FrontAccounting forum — How to can I empty pre-data in my tables on installation

Re: How to can I empty pre-data in my tables on installation

null@example.com (joe) — Sun, 26 Apr 2009 14:40:55 +0000

No, there must be at least one admin user, one company and some other base information. Very much like the en_US-new.sql. Of course some of the info here can be deleted as well.

/Joe

Re: How to can I empty pre-data in my tables on installation

null@example.com (Leo) — Sun, 26 Apr 2009 14:16:47 +0000

but if i remove the all insert , i can't run frontaccount. is it right?

Re: How to can I empty pre-data in my tables on installation

null@example.com (joe) — Sat, 25 Apr 2009 12:42:30 +0000

No, you can replace. It is just that you will need some data here to create new customers/suppliers/items etc..
You can change to whatever suits you.

/Joe

Re: How to can I empty pre-data in my tables on installation

null@example.com (Leo) — Sat, 25 Apr 2009 11:31:36 +0000

in the en_us_new.sql, the values thoese are inserted default must be inserted? which are essential？

Re: How to can I empty pre-data in my tables on installation

null@example.com (joe) — Sat, 18 Apr 2009 07:18:02 +0000

If you are using en_US, there is a minimalistic chart of accounts in the SQL folder, en_US-new.sql file to use when creating new companies. If you think it would be better with an even more minimalistic one, you are welcome to create one and contribute it to the community.

/Joe

Re: How to can I empty pre-data in my tables on installation

null@example.com (tom) — Fri, 17 Apr 2009 21:53:08 +0000

It would really be great if there was a choice at install time.

Since the superuser is only part of the First company created, it would be nice if there was a Create Tables option that did not include any demo data.

Or should I say no transactions.

A number of things can not be deleted once there are some transactions, that makes it hard to start a new company.

tom

Re: How to can I empty pre-data in my tables on installation

null@example.com (emman) — Thu, 26 Mar 2009 07:54:05 +0000

itronics wrote:

FA is complex system using a lot of defaults, so it is difficult i not impossible to start from completely empty database. To be on safe side choose chart of accounts from download page mostly suitable for your needs and try removing all not needed accounts.
Janusz

Thanks, I just modify it in the database.

Re: How to can I empty pre-data in my tables on installation

null@example.com (itronics) — Thu, 26 Mar 2009 07:49:06 +0000

FA is complex system using a lot of defaults, so it is difficult i not impossible to start from completely empty database. To be on safe side choose chart of accounts from download page mostly suitable for your needs and try removing all not needed accounts.
Janusz

How to can I empty pre-data in my tables on installation

null@example.com (emman) — Thu, 26 Mar 2009 06:00:20 +0000

Hi, FA is really doing great!

I just want to ask if there's a way to set my tables empty upon installation.

Cheers!
-emman