Skip to Content
Menu
This question has been flagged
2 Replies
3588 Views

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
Discard
Best Answer

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

Avatar
Discard
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
Discard
Author

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.

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 Replies Views Activity
2
Mar 24
30
1
Nov 23
1244
1
Mar 17
3210
1
Oct 23
1401
1
Sep 24
180