Skip to Content
Dette spørgsmål er blevet anmeldt
res.partnerodoo12
3 Besvarelser
5269 Visninger
Avatar
AnonymousUser1293123

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?



  



Avatar
Kassér
Sehrish

This will helps you in future: https://www.scoop.it/t/learn-openerp

Avatar
Chris TRINGHAM
Bedste svar

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.​

Avatar
Kassér
Avatar
Krutarth Buch
Bedste svar

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,


Avatar
Kassér
Related Posts Besvarelser Visninger Aktivitet
customer field removed on res.partner when upgrading from odoo 12 to 14 Løst
res.partner odoo12 v14
Avatar
Avatar
1
apr. 23
2501
Contacts module python code odoo12 Løst
contacts res.partner odoo12
Avatar
Avatar
1
mar. 20
4374
Odoo Mail Sending Limit Løst
odoo12
Avatar
Avatar
Avatar
2
dec. 23
14680
(Document type: Invoice, Operation: write) - (Records: [], User: 2)
odoo12
Avatar
0
okt. 23
33
Error while importing data in Odoo12: An unknown issue occurred during import (possibly lost connection, data limit exceeded or memory limits exceeded)
odoo12
Avatar
Avatar
Avatar
Avatar
3
okt. 23
788