Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Importing product translation not possible with OpenERP?

By
Maxime Deuse
on 10/21/14, 11:19 AM 1,025 views

Hi,

I need to import products into OpenERP 7. Each product has 2 different name translations, one in French and one in Dutch. An example of a product could be:

  • default_code (reference) : EXP-0111-21
  • name Fr : Diable à patins
  • name Nl : Steekwagen met trapglijders
  • list_price : 235€

I want to insert both translations into the ERP for my list of products. I don't see any option to import name translations into the ERP while importing my list. Do I need to directly insert my data into the database or is there another way to import my translations?

Thank you

1
René
On 10/23/14, 10:19 AM

Hi

I also worried a lot about this problem and finally found the following comfortable solution.

1) import your products with english or whatever language descriptions you like first

2) create individual csv-files for every language with the following structure:

module,type,name,res_id,src,value
"your_modulname","model","product.template,description","your_modulname.your_template_id","source-value Text","translated-value text"

3) start the following command to import the language-files in the console when server is stopped:

/path_to_your_openerp-server_file/openerp-server -c /path_to_your_openerp-server_config_file/openerp-server.conf --i18n-overwrite --i18n-import=/path to your translated csv file/de_DE.csv -l CORRECT_OPENERP_LANGUAGE_CODE -d $NAME_OF_YOUR_DATABASE

Thanks for your answer! I will definitely try this out!

Maxime Deuse
on 10/24/14, 6:25 AM
0
Maxime Deuse
On 10/22/14, 3:22 AM

I found a solution; it's not perfect at all but it will do the trick until I find something better.

  1. First I connect to my admin account and I set my admin language to French.
  2. I import all my products with the French names into OpenERP.
  3. Once this is done I export all my products with their French name from OpenERP to a csv. In doing this I get a product's "id" coupled with the item "name" (in French).
  4. In my csv I change the French item "name" with the Dutch one.
  5. I connect myself as the admin on OpenERP and change the Admin language to Dutch.
  6. I import my newly created csv file (with "id", "Dutch name").
  7. It works, my products have a translation now.

I know it's a real pain to do all this to insert my products with two translations but I have not found an easier way to do it. It could probably be done by inserting data directly into the database but this is something I would rather not do (I am afraid I would break the database).

Your Answer

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

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 10/21/14, 11:19 AM
Seen: 1025 times
Last updated: 3/16/15, 8:10 AM