Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
2 Odpowiedzi
5511 Widoki

I have created a database for inventory, and while doing that I have made a lot of sample products and inovices and sales order and purchase order , now that i dont want all these data, i wanted to remove that and i know that these datas cannot be deleted once done

 I have taken the backup of the same and want to restore it without any sample datas.. 

Can anyone tell me how to restore the same database without any sample datas...

Awatar
Odrzuć
Najlepsza odpowiedź

Hi,

There are few modules available in the Odoo app store for cleaning the database(removing data), you can try those modules to remove the existing data in the database.

1. Database Cleanup: https://apps.odoo.com/apps/modules/12.0/database_cleanup/

2. Odoo Customize: https://apps.odoo.com/apps/modules/13.0/app_odoo_customize/

3. Data Clear: https://apps.odoo.com/apps/modules/12.0/clear_data/


All are free modules and different versions are available. Also, have a look at this video: How to Clean the Database in Odoo After testing without lose of configuration

Thanks

Awatar
Odrzuć
Najlepsza odpowiedź

Hi Suhaib,

There is an oca module named clear data where you can select models and delete the entire data.

Otherwise you can connect to your database in pstgresql and use this sql query


TRUNCATE public.relation_name CASCADE;

Hope it helps
Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
2
sie 24
20626
2
lip 24
42165
2
lip 24
1107
2
mar 20
10306
2
mar 18
3290