copying translation into english language

Asked by Kamil

Hi!
I met problems with language version of OpenERp and decided to switch into english version.

I have small database it is why i could have done on my own this simple step with 'description' field and my little knowledge of sql:

UPDATE product_template
SET description=(SELECT ir_translation.value
          FROM ir_translation
          WHERE product_template.id=ir_translation.res_id AND
                ir_translation.name='product.template,description' AND
                ir_translation.state='to_translate')
WHERE EXISTS (SELECT ir_translation.res_id
              FROM ir_translation
              WHERE product_template.id=ir_translation.res_id);

But my ask is (i am sure you all have done it already)
could you give me sql query which can copy translation strings (translated and to_translate)\into proper fields of proper tables using [ir_translation.name] filed?
Not as i did: ir_translation.name='product.template,description'
It was good for simple, one-time action.
This query is somewhat difficult for me (as i am not sql programmer) and you have it done, i suppose

Point is that i would like to have translated UI but the rest have working in 'english'.

Question information

Language:
English Edit question
Status:
Answered
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Numérigraphe (numerigraphe) said :
#1

You can't do it in SQL, because the name of the table you have to update is stored in a column of ir_translation.
SQL isn't meant to process tables inside columns.

As I told you already, check out the module base_translation_copy.

Lionel.

Can you help with this problem?

Provide an answer of your own, or ask Kamil for more information if necessary.

To post a message you must log in.