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

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!