Skip to Content
This question has been flagged
import
1 Respondre
5632 Vistes
Avatar
Dale

Good day

I have managed to import contacts into OpenERP from a previous CRM system quite successfully. However I did all the preparation in advance and brought in single csv files. Now I need to import an additional address from the same system into the existing contacts in OpenERP. I have the external_id available and I can match on that field however I cannot import with an empty NAME field. As stated I just need to import an address and since the original import the "name" field may have been updated in OpenERP and cannot be overwritten now. How could I get around this?

Thanks

Avatar
Descartar
Avatar
Vincent Van Dyck
Best Answer

Just reimport the name too. As long as you have the correct id, records are updated, not added.

Sorry, too fast, I do edit :

You have to export (id - by default) and (updated) names from OpenERP in a CSV or XLS file. Then you can add the updated names in your addresses file (the Libreoffice/Excel command VLOOKUP should do the trick) with the id as index.

Avatar
Descartar
Landis Arnold

You can also try the "Mass Editing" Module which I am just now testing. It is functional if you want to update a number of records to the SAME value. Ideally you could display your data in a spread and just update like a Spreadsheet but that is not available that I know of. This technique should work. Good to know about :)

Related Posts Respostes Vistes Activitat
Import Contact Notes (Help! Which is the correct Odoo Field?) Solved
import
Avatar
Avatar
Avatar
2
de des. 25
227
Importacion de Atributos y Valores
import
Avatar
Avatar
Avatar
Avatar
3
de des. 25
2554
Issue with import and comma in Excel File (odoo 19)
import
Avatar
0
de set. 25
235
Import from Winbooks Solved
import
Avatar
Avatar
Avatar
Avatar
Avatar
4
de maig 25
7161
can i import journal entries from Excel
import
Avatar
Avatar
1
d’ag. 24
3721