delete all customers at once

Question

Hi
I have run a big import that loaded thousands of records into my database but I need to run the import again from scratch. I have a large number of users defined fields that will take a very long time to recreate. Can I either:
Delete all customer records at once? OR
Copy my user defined fields from my existing database to a new database?
Thanks

Dale · Answer

Thanks for your answers. I found a backup with just the custom fields in it and restored that. Would still like to know of a way to dump just the data though

Laurens · Answer

I suppose uninstalling/reinstalling the CRM module would delete your contacts, but also any custom changes you made in your views. If you didn't make new modules for your changes, this is not recomended.

Bonnet Denis · Answer

Did you try to select all your customers in list view and delete them?

Gustavo · Answer

Now that I think about it... how about marking the customers as Invalid? You only need to set the Active field to False

COR · Answer

Well the delete function is not a recommended one because of the moves dependent on either Customers\Suppliers\Accounts\ etc.
It's better to de-activate the customers and create new ones.
to do so, you can Use ODBC and MS Access to edit the table of res.partner, or do it one by one through openerp UI

Powiązane posty	Odpowiedzi	Widoki
how do you delete a database? database delete	1 mar 15	14249
Deleting product and product variation database - creating a clean workspace without losing visual modifications database delete wipe	1 mar 24	3406
How deleting data ? (invoices, manufacturing orders, stock) database delete odoo16features	2 sty 24	3529
How do I access the Database Management page when --no-database-list option is used? server management database	6 kwi 15	12935
Which script do you use to delete oldest databases dump/backup? Rozwiązane database script delete	2 mar 15	8596

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!