Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I made a mistake when importing a list of 1000 contacts using the import contacts tool. Unfortunately, I forgot to backup my database before importing the contacts.
All entries have the tag "casa" and the value "CASA" for a custom column "x_imi_data_import_identifier".
Is it safe for me to execute the SQL query "DELETE FROM res_partner WHERE x_imi_data_import_identifier=`casa`;"?
If not, what other queries can I execute? Or is there a way to delete contacts based on tags?
In the List View use the standard filter to display all the records with "CASA" in your field "x_imi_data_import_identifier".
Check this is what you want, then select all the records, and the "Delete" option from the Action menu.
Hello,
Rathar than deleting the contacts, can't you update the value in that field?
"UPDATE res_partner set x_imi_data_import_identifier=`CASA` where x_imi_data_import_identifier=`casa`;"
Thanks,
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
1
kwi 23
|
2445 | ||
|
Contacts module python code odoo12
Rozwiązane
|
|
1
mar 20
|
4323 | |
|
Odoo Mail Sending Limit
Rozwiązane
|
|
2
gru 23
|
14609 | |
|
0
paź 23
|
33 | ||
|
3
paź 23
|
788 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
This will helps you in future: https://www.scoop.it/t/learn-openerp