How to delete all test accounts / sales orders / journal entries at once without wiping the whole database
I'm sure there has got to be a way to do this - In setting a new server (OpenERP 7), in the process of configuring everything just right and making sure it's right, I have created nearly 100 test accounts and countless transactions.
When everything is perfect and it's time to deploy, how do I wipe out all these accounts and journal entries and get a clean slate - without wiping the database and losing all of the customization I've done? I don't see any obvious way
See this similar question: Erase or clear all accounting data from openerp. In short, there's no silver bullet. There's the dangerous route of manually truncating tables in postgresql, or the safer method of exporting your core data and re-importing to a clean database.
Any customizations should really be done in new modules, which can be installed on any database quickly and easily. It also makes maintenance in production much simpler, and allows for easy setup of test environments (which you should have!).
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/17/15, 8:38 AM|
|Seen: 764 times|
|Last updated: 4/17/15, 8:45 AM|