跳至内容
菜单
此问题已终结
2 回复
9134 查看

A product has been created in openerp, when exported, its external ID is 

product.product_product_48

Any chance this external ID could be updated to other value?  We have a list of products from another database, we want to make products's external ID  in openerp the same as in the other database.

 

 

 

形象
丢弃
编写者

apparently, product.product_product_48 could be update to "product.product_product_" from openerp interface, Technical->External Identifiers, (where is the id of that product from another database.

最佳答案

Sure.. external_ids are stored in ir_model_data table

external ids are in form : module_name.external_id
so to get all exported ids for product you an run:
select module, name from ir_module_data where module='product';

Acourdingly, you can prepare and modify those records with sql update statement.. 

 

hope it helps...

形象
丢弃
最佳答案

No, not by default at least. It is also a bad idea, because OpenERP uses this idea in all sort of refences (in the many2one fields for example). Since the number is generated for you it is generally a bad practice to want to change it and/or base any business logic around it, other than using the api/orm.

For comparing products between 2 databases it is ofter better to compare another column, such as a required/readonly field.

形象
丢弃
相关帖文 回复 查看 活动
2
5月 25
765
2
3月 24
3262
1
2月 22
2145
5
11月 21
12596
1
3月 17
3076