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?
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.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 11/25/13, 5:25 AM|
|Seen: 791 times|
|Last updated: 3/16/15, 8:10 AM|