FrontAccounting forum — Removing the database entries from backend (phpMyAdmin)

Re: Removing the database entries from backend (phpMyAdmin)

null@example.com (mayankjani) — Thu, 22 Mar 2012 08:04:09 +0000

Thanks thanks thanks a lot, Joe.

You great... Proud...

Mayank Jani

Re: Removing the database entries from backend (phpMyAdmin)

null@example.com (joe) — Thu, 22 Mar 2012 07:52:17 +0000

COA = Chart of Accounts. This is a name for the scripts, f.i. en_US-new.sql that is included in FA. Look in the /sql folder.
The en_US-new.sql script is a COA for a new US company with only the needed data inside it. Use this COA as a model when creating your own from a backup.

/Joe

Re: Removing the database entries from backend (phpMyAdmin)

null@example.com (mayankjani) — Thu, 22 Mar 2012 07:35:36 +0000

And where I can find "en_US-new.sql" file?

Is it by default table with data?

Mayank Jani

Re: Removing the database entries from backend (phpMyAdmin)

null@example.com (mayankjani) — Thu, 22 Mar 2012 07:27:18 +0000

Thanks for your response.

But what is COA?

Can you guide me on this?

Mayank Jani

Re: Removing the database entries from backend (phpMyAdmin)

null@example.com (joe) — Thu, 22 Mar 2012 06:48:57 +0000

This is very dangerous. You should use an empty COA from the beginning or make a backup of an existing one and remove all the data that you do not need (look into en_US-new.sql to see which table contents to preserve) and create a new client from this new COA.

/Joe

Removing the database entries from backend (phpMyAdmin)

null@example.com (mayankjani) — Thu, 22 Mar 2012 05:49:40 +0000

Hello!

Can I remove all the entries of table from back-end (phpMyAdmin)?

Can it will effect to any functionality of FA?

Can anybody guide me on this?

Which tables' entries must be remain if I am going to empty data of tables?

Thanks In Advance.

Mayank Jani