How to force to use same IDs when import?

Question

Hi,
I export my contacts and import them in a different odoo system. I exported both ID and External ID columns. Former column is interger and latter one is text.
When I import, the ID column can't be accepted, and I can't find the correct ID column in the drop down list.

If I don't import the ID column, some mapping relationship will be messed up.

cabrejua · Accepted Answer

You cannot import record IDS due to ids are generated dynamically by Odoo

Ray Carnes (ray) · Answer

As @Julio reported, you cannot import the database id field, as this is managed by Odoo.
You do not need to import this field.
The *External ID* field is what references the record, and this is what determines if Odoo creates a new record or updates an existing record.
See also:
https://www.odoo.com/documentation/user/14.0/general/base_import/import_faq.html#what-s-the-difference-between-database-id-and-external-id [1]
https://www.odoo.com/forum/help-1/what-is-an-external-id-and-what-is-its-uses

Related Posts	Odgovori	Prikazi
Contact import page show blank page after selected the sheet import contact	2 mar. 24	30
Error on line 0: "'Contacts require a name' Solved import contact	1 nov. 23	3360
How to remove an added state in address field import contact	1 mar. 17	4546
Import transfers mistake : "The values for the fields 'company_id, name' already exist" import id transfers mistake	1 okt. 23	2883
Agregar tipo de identificación / add type identification contact	1 okt. 25	2668

This question has been flagged

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