How can I update the external_id? I've made a mistake during an import and I have some record with the wrong external_id in the form "res_partner_XXX" where XXX is the record id. How can I update those records with a csv file? I tried to import the csv in the external identifiers section, but with no luck: a new record is created instead of updating the old one (V 7.0) Is there a way to do it?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
3
Replies
40224
Views
Please be careful when doing this!
Every OpenERP module uses External ID's to "add" and/or "locate and update" information in the system. Changing or Deleting External ID records can cause serious limitations to the ability to install or upgrade modules in the future.
Make sure you understand what you are doing and change only External ID's related to data YOU have imported into OpenERP.
To access the record that contains the External ID for a particular database record, visit Settings --> Technical --> Sequences and Identifiers --> External Identifiers
Each External ID maps to a Database Record ID. You will see that an External ID is constructed by a concatenation of the Module and External Identifier field.
ID and Export before change:
ID and Export after change:
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
5
Apr 18
|
7990 | ||
|
2
Mar 15
|
12381 | ||
|
2
May 24
|
6103 | ||
|
3
Jul 20
|
3605 | ||
|
odoo module update error
Solved
|
|
1
Jan 20
|
5802 |
