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?
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:
External ID are very sensitive parts of OpenERP. In order to get things getting better you have to rework as the server does in its porcess while updating modules. First Identify the view you want to be updated through an XML Id. Consider its name and its ID in the URL. Then go to Configuration > sequences & Ids > External Ids and filter on the object ir.ui.view and the ID you kept before. Check if you have an XML id defind here for you view. If it is not the case, that means that you won't be able to update your view by updating a module. Two possibilities for you : - recreate in OpenERP via web a new external id with the same name and same module as the one you have in your module and set the res_id to the ID already identified - You already have one but with a weird xml_id. So consider my first item and try to find why there was such a weird xml_id associÃ©ted to your view. Then consider to break the weird association or maybe consider duplicating the view as well as xml_id
Hope it could help
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/22/14, 1:53 PM|
|Seen: 7647 times|
|Last updated: 3/16/15, 8:10 AM|