Skip to Content
This question has been flagged
importcontactid
2 Respostes
5819 Vistes
Avatar
Ying Shi

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.

Avatar
Descartar
Avatar
cabrejua
Best Answer

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

Avatar
Descartar
Avatar
Ray Carnes (ray)
Best 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

https://www.odoo.com/forum/help-1/what-is-an-external-id-and-what-is-its-uses-95070

Avatar
Descartar
Ying Shi
Autor

OK, thanks, I get this now. But how do I export and import messages attached to all project tasks? In Settings->Technical->Messages, I can export them, but they only associate with project task with document ID, which is database ID, not external ID.

Ray Carnes (ray)

Since you are not using the ID field to create/update - just to reference - you can use the field as you would expect.

Related Posts Respostes Vistes Activitat
Contact import page show blank page after selected the sheet
import contact
Avatar
2
de març 24
30
Error on line 0: "'Contacts require a name' Solved
import contact
Avatar
1
de nov. 23
3364
How to remove an added state in address field
import contact
Avatar
Avatar
1
de març 17
4555
Import transfers mistake : "The values for the fields 'company_id, name' already exist"
import id transfers mistake
Avatar
Avatar
1
d’oct. 23
2893
Agregar tipo de identificación / add type identification
contact
Avatar
Avatar
1
d’oct. 25
2677