Skip to Content
This question has been flagged
1 Reply
2132 Views
Avatar
Ali

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 imported the new excel file on odoo. It will create a new external id for all contacts since the excel file which generated from the local system didn't have the external id from odoo. 


What should I do ?  Is there a way that I can change the main parameter on uploading from external id to email or Misc reference or anything that could be static on my local system for example ? So I can avoid any duplicating that could happen ?


BTW, I need to work on the both systems the local system and odoo for some reasons. 

Thank you. 



Avatar
Discard
Avatar
Waleed Ali Mohsen
Best 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 more in Odoo Import/Export 

Avatar
Discard
Ali
Author

Hi Waleed,

Hope you are doing well.

Thank you for your reply.

Unfortunately, I'm still having an issue with this. Is there a way to contact you to help me on this issue and it will be paid.

Thank you.

Best Regards,
Al

Ali
Author

This is my email

kau.stud1@gmail.com