Skip to Content
Меню
Вам необхідно зареєструватися, щоб взаємодіяти зі спільнотою.
Це запитання позначене
7 Відповіді
49797 Переглядів

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.

Аватар
Відмінити
Найкраща відповідь

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.

Найкраща відповідь

@avarcas.com Thanks for your answer helped me allot

Аватар
Відмінити
Найкраща відповідь

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

➜ ~ 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. 

Аватар
Відмінити
Related Posts Відповіді Переглядів Дія
1
черв. 25
709
creation of company Вирішено
1
жовт. 24
12333
0
жовт. 22
2066
2
бер. 22
12355
2
січ. 18
8477