Help

欢迎!

该社区面向专业人士和我们产品和服务的爱好者。
分享和讨论最好的内容和新的营销理念,建立您的专业形象,一起成为更好的营销人员。


0

What is an external id, and what is its uses?

Avatar
odoo
1 Comment
Avatar
Discard
Avatar
odoo
-

I would say that it is one of the first thing ton manage and learn well in Odoo.

1 Answer
0
Avatar
odoo
Best Answer

An External ID (also called XML ID) is a string identifier that uniquely identifies a particular record in Odoo.  

They become important when you plan to import data into Odoo.

When you import data, if you supply an External ID, Odoo checks if this record already exists.  If it does not, that line of your import file becomes an INSERT.  If it does exist, that line of your import file becomes an UPDATE.  If you don't supply an External ID (you leave it blank, or just don't supply the field at all), Odoo creates one automatically for you.

They are stored in the ir.model.data model and are not given to records that are created via the Odoo user interface - only for records that are imported (External ID is created or read on import) or exported (External ID is created on export if it doesn't exist already).

You can see the External ID for a record in Developer Mode using the View Metadata option in the Debug Menu.


When you export data, Odoo will ensure External ID's are present for every record in the export file, so you can update the file and import it back into Odoo (using the rules above).


 

4 Comments
Avatar
Discard
Avatar
odoo
-

Clear Ray, and what is the maximum value of the external ID field, like what is the maximum range Odoo allows??

Avatar
odoo
-

The field is a char field composed two smaller char fields separated by a period character. The first part is normally the name of the module creating the record, or some other prefix. Both char fields can have up to 10,485,760 alpha-numeric characters in total, except the period character. You will run into usability issues before your run into storage issues. After 66 characters in total, the ID won't display properly on the screen and you will have to scroll your browser to see it.

Avatar
odoo
-

Hello, As we don't have a xml id for records that are added by user interface then if anyone wants to update records that added by user interface, Is there any way?

Avatar
odoo
-

If you export the records, Odoo will automatically assign them an ID so that if they are re-imported, they will update instead of the import creating new records. Be sure to choose "I want to update data (import-compatible export)" during the export.