Skip to Content
This question has been flagged
1 Reply
3097 Views
Avatar
Mandresy Randriatavy

Hey,

I got an ERP deployed directly with Odoo, but inside I mixed test and real datas..

I'd like to get ride of the tests made and keep the real ones. If I delete one by one, It's won't delete all related records so that could be really exhausting.


Questions:

- If I delete them one by one, will my datas still in the database (but invisible in the server) ?

- Next time to prevent this circonstances, How can I create a demo version and merge the demos update to the production version ?

- How to access to the database itself to clear all datas needed ?

- If I can't clear it, is it possible to duplicate the database, clear it from my side, and replace the current database ?


Thanks,


Avatar
Discard
Mandresy Randriatavy
Author

Thabk youbsir, iubnfortunately I can't select your comlent as solved because of thisbtupud idea of karma in forum made for help 

Avatar
Mehjabin Farsana
Best Answer

Hi,

First of all we should take at most care when do we record some data in the production database, which cannot reverted back. Like in the inventory application, if you create a picking/transfer and mark it is done, easily you cannot revert it back or delete it from the db. Here the only way is to record an opposite entry or use third party apps to delete it. 

So this is just a case, coming to your questions,

1. If you somehow delete the test data's, it will be deleted from the database. If you just to need to control visibility, if the archive option is available, you can use it.


2.For demo/test, if you are using Odoo SH, you can use the staging/development branches.  If it is not odoo sh, you can create a separate odoo instance in same machine or different machine for the test purpose.


3. Yes, from the database manager page, ie, ip:port/web/database/manager , you can duplicate the db, try different things to clean up the data and if everything goes fine, you can continue with this db as live db.


Thanks

Avatar
Discard