pegonzalezs / odoo-tools Goto Github PK

Context

On translatable fields there is no possibility in the usual Export / Import mechanism to update the translations easily

As example next field is translatable

These are the values

The way that Odoo works is exporting the records, choosing the translatable field, BUT the value exported will be the value in the language of the user who is exporting. So there is no way of exporting ALL the translations values, then the user changes in the excel the value of each translation, then import that value in Odoo adapting all the translations of the product

Work to be done

Lets try to allow the user to modify the translations of a field via odoo-script

Parameters of the script (user ID of the users with different languages)
Model_id (model of the field we want to update)
field_id (id of the field)
mode( export: when translations are downloaded from Odoo / import: when translations are uploaded to Odoo)

Export Mode:
Script logins with user of language X as preferences

user reads the value of the model field

the values of all the records of the model,field are saved in Excel
model.field_EN | model.field_DE | model.field_FR
record_id(1), value EN | value DE | value FR
record_id(2), value EN | value DE | value FR

• HERE IS WHERE THE USER MODIFIES THE VALUES IN THE EXCEL*

Import Mode:
read each line of the excel, get the model, field (from the header column) and the id of the record from the value of the columnX
Log in Odoo with user with language X and write the records with the values from the excel
Log in Odoo with user with language Y and write the records with the values from the excel