I need to remove Your company and other demo data from an existing application without affecting the useful records. The other company data should remain intact only demo data should be removed.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
7
Replies
44778
Views
Hi Sohail,
You should create new database without demo data instead removing demo data from existing database.
I just suggested you an option. There is not any module available to remove demo data. You need to delete it manually. It may happen that in some cases you can't delete demo data record because it is depend on some other record which is necessary.
@keyur I am having the same problem I want to remove demo data but in my database I have created some new fileds and done some customization everything will be lost Is there any other option for me ??
@umer the only way I can see, is you can export data from your existing database and import them in new database which has no demo data installed.
You can use the following:
Enter your VPS (if remote) or open terminal if in local:
ssh -l root 99.99.99.99
Use the postgres user:
➜ ~ su postgres
Select database
Select database
➜ ~ psql abc_db_name
And fire this operations in terminal:
delete from stock_pack_operation;
delete from stock_picking;
delete from stock_move;
delete from account_invoice;
delete from account_partial_reconcile;
delete from account_move;
delete from sale_order;
delete from account_payment;
I agree with Keyur.
You never use demo database for business !!!
Deleting demo data through postgres is Not a proper way.
Demo data will be restored if you install/upgrade a module.
Find the installed apps in existing database, create new one and install those.
Export all data in CSV/Xls and restore in new database.
@avarcas.com Thanks for your answer helped me allot
