FrontAccounting forum — Reset full system (Delete all entries)?

Re: Reset full system (Delete all entries)?

null@example.com (apmuthu) — Mon, 04 Feb 2013 00:57:00 +0000

Mere deletion of data records is insufficient.
The auto_increment counter has to be reset as well if used.
Hence a TRUNCATE command is better suited for purges.

Also, some of the data should not be purges as they may pertain to
permissions,
logical inter-relationships used in code,
drop-down list and other form element choices,
sys_prefs choices.

The recomended way: After FA is setup and tweaked (extensions, languages, roles, prefs) the way you want it. take a backup and use it to restore for purges later on. Remember the passwords as well for the restored state.

Re: Reset full system (Delete all entries)?

null@example.com (chrison) — Sun, 03 Feb 2013 16:51:48 +0000

That might have been part of why my attempt at wiping the database clean didn't work. What happened was not all of the data was erased, and some of the indexes got mangled. When I tried to then restore the real data from a backup, stuff got jumbled up.... GL accounts weren't balancing, reports were wrong, etc.

Re: Reset full system (Delete all entries)?

null@example.com (apmuthu) — Sun, 03 Feb 2013 14:03:14 +0000

Beware: Some new tables and data get created / modified when some extensions get installed.

Re: Reset full system (Delete all entries)?

null@example.com (chrison) — Sun, 03 Feb 2013 08:19:17 +0000

I found an SQL script somewhere in the forum for an earlier version of FA (can't remember which one but I think it was 2.2.x) that supposedly wipes the data clean. I tried to modify it to work with 2.3.13 but when I ran it it made a terrible mess of things so I ended up having to start from a clean install.

My recommendation is to NOT try and wipe the sample data and reset the database. There are just too many interrelated tables and if something goes wrong you're totally screwed. In the end, it is probably much easier to just start fresh with a clean install. However, if you wish to give it a try I do wish you the best of luck.

Regards,

Chris

Re: Reset full system (Delete all entries)?

null@example.com (tekillah) — Sat, 02 Feb 2013 20:08:56 +0000

I am not sure this is possible in FA. The best practice with any installation is to backup a clean copy once the setup is all done. You of course can do this at the DB level, but please make sure you understand the ERD of FA tables.

Re: Reset full system (Delete all entries)?

null@example.com (bluebird) — Tue, 27 Nov 2012 12:12:26 +0000

Is there any option to delete all the entries from within the system itself? (To delete as batch or by selecting multiple entries at a time)

Re: Reset full system (Delete all entries)?

null@example.com (joe) — Tue, 27 Nov 2012 10:32:28 +0000

No, but you can restore the company from the same script as you started with.

/Joe

Reset full system (Delete all entries)?

null@example.com (bluebird) — Tue, 27 Nov 2012 07:21:43 +0000

My installation have many sample data which I created while looking around the system.
Is there are way that I can reset complete system so that it becomes fresh installation?