Skip to Content
This question has been flagged
import
1 Odpoveď
4898 Zobrazenia
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
Zrušiť
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
Zrušiť
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 Replies Zobrazenia Aktivita
Import from Winbooks Solved
import
Avatar
Avatar
Avatar
Avatar
Avatar
4
máj 25
3477
Importing products from Odoo 12 to Odoo 18
import
Avatar
Avatar
Avatar
2
apr 25
422
can i import journal entries from Excel
import
Avatar
Avatar
1
aug 24
1247
Odoo 17 Studio
import
Avatar
Avatar
1
feb 24
2128
Importing records--is there an option to create a related record if it does not exist yet?
import
Avatar
Avatar
Avatar
Avatar
3
okt 23
10148