Finance | Project Operations, Human Resources, ...

Import and translate product names D365FO

(0) Share

Report

Posted on by RadekM

172

Hello,

can anyone guide me how to export translation for products in D65FO ?

I need to create a new translation for RU. But I can't find where I can find this.

I have the same question (0)

All responses (15)

Answers (0)

Suggested answer

Christoph Thaler 5,442 on at

Like (0)

Report

Hi RadekM,

Please check out the "Product translations" entity.

Was this reply helpful? Yes No
RadekM 172 on at

Like (0)

Report

Can you expand it a bit ? How can I get there ? It's first time I need to do anything like that

Was this reply helpful? Yes No
Suggested answer

Christoph Thaler 5,442 on at

Like (0)

Report

Hi RadekM,

Just switch over to the "Data management" workspace and create a new export project. Give it a name and use "add entity". Within the form choose "Product Translations" and data format "Excel".

As soon as you use the "Export" button all product translations will be exported and you can download them as Zip File.

After you have modified the product descriptions in the excel file just add the new file into the ZIP and create a import project. In the import project use add file and select the zip file. As soon as you run "Import" and it is finished the items / products will have additional translations

Was this reply helpful? Yes No
RadekM 172 on at

Like (0)

Report

No zip file. So I got exported it and there are over 500.000 records in one language.

Now there can be more than one language id ? Or I must recreate all this records with other langid ?

If I can put more than one id how to separate them ? At the end I need 3 languaes of products

Was this reply helpful? Yes No
Suggested answer

Christoph Thaler 5,442 on at

Like (0)

Report

The relation between product and translation is 1:N. It seems right now you have just one language per product. If you need 3 translations per product you have to multiply the records, modify the "LanguageID" and fill the "Description" and "ProductName".

Here an example from Contoso USMF

Was this reply helpful? Yes No
RadekM 172 on at

Like (0)

Report

Can I add it in different excel file or sheet ? Looks like one sheet can contain only 1mln records

Was this reply helpful? Yes No
Suggested answer

Christoph Thaler 5,442 on at

Like (0)

Report

Yes you can import different excel files as well, just split it up as needed.

Was this reply helpful? Yes No
RadekM 172 on at

Like (0)

Report

Great you're really helpfull.

Sadly somwehere is a problem importing this file I need to investigate a bit more.

Error processing data project 'ru-en-gb' using job 'ru-en-gb-2020-04-09T16:00:13-81C7A87E652141368D917E4535B6C32C'.

Was this reply helpful? Yes No
Suggested answer

Christoph Thaler 5,442 on at

Like (0)

Report

In the "Job History" of "Data Management" you should find your import project. Click "Execution Details" and check "View execution log" to find more details.

Was this reply helpful? Yes No
RadekM 172 on at

Like (0)

Report

File contains duplicate rows, cannot insert data into staging due to unique key violation.-

'0' 'Product translations' record(s) inserted in staging

Ok so one more question. I must have the same product name in every language. So do I need to edit a bit every record like prod-en, prod-ru so it's not duplicated ? Or the problem is because I try to import everything with the data I exported ? I can't import again the data that is not modified ?

Was this reply helpful? Yes No