Change External id parameter to another column while importing

Question

Hi,

I have a local system and I have around 5000 clients on it. When I export the clients from my local system on excel file and then I import it to odoo, odoo creates an external id for them.
Lets' say later on I have updated the clients phone number and created a new 500 client on my local system so the total are 5500 and I exported them on excel file then I impor ted the new excel file on odoo. It will create a new external id for all contacts since the excel file which generated from the lo

Waleed Ali Mohsen · Answer

You have to have a
unique identifier from the original application like ID field (it should be unique) So let's suppose you have the below in your local system
ID  Name
1   Cleint1
2  Client2
3 Client3

So you can use the ID and add a prefix to it in excel (Use
CONCATENATE  function to add prefix) before upload it Odoo:
ID                       Name
partner_1          Client1
partner_2         Client2
partner_3        Client3
By doing this you will using the unique ID from your local app.
See mo

This question has been flagged

Enjoying the discussion? Don't just read, join in!