Loading Product categories in several languages

[former_member252154]

Hi Gurus

We are implementing CLM 10

A newb question

We have thousands of categories to load in two different languages.

In the Enterprise book I see no field with language value for int_categories tab .

How can I load the second language?

Thanks in advance

[Former Member · Accepted solution]

Where are these categories coming from ?. If ECC then if you use the XML extractor you should be able to specify the languages. If you are using the enterprise book there is no possibility to specify both languages at the same time. you need to create 2 separate files each representing a different language.

Please check if the XML format will work in your favor.

Prasad

[former_member252154 · Accepted solution]

Hi Prasad

Thanks for this.

We are not integrated. I can only upload with Excel.

I am ready to load twice but how will the system determine the language as there is no field for language in the worksheet.

Regards

[former_member252154 · Accepted solution]

No idea ?

[former_member190023 · Accepted solution]

Hi,

As far as I can figure out, this is how the system is designed to work:

Step1. You import ProdCategs. When you do this you are only setting the 'DisplayName' of the ProdCat (no language values)

Step2. Create a separate template import file of type MultiString (class id 594) - using this template you specify the object (in your case ProdCat), and the language-specific values. You can get the template either from RefGuide or from the import wizard.

Wild guess:

You could try adding in two extra columns to the standard ProdCat template: NAME.LANGUAGE and NAME.VALUE and set corresponding values (language code and value), but I can't guarantee it will work

Bogdan

[former_member252154 · Accepted solution]

Excellent stuff! We need more resources like you on this forum

I successfully translated one Product category.

Last issue : In French we use accents in many words like "café". Those accents are destroyed during the import of the csv file.

Any idea what setting I could change in Excel or CLM to save those?

Thanks in advance

[former_member190023 · Accepted solution]

Hmm, that needs to be tested on my side.

Can you tell me:

- what option did you use to import? template file for MultiString class?

- what do you mean by destroyed? é is converted to e, or fully removed? you can use a word like français (special char in the middle) to see what happens to it exactly.

Bogdan

[former_member252154 · Accepted solution]

Ok. That is all sorted. Just needed to convert he csv file in UNICODE.

Again thanks a ton. Full points

[former_member190023 · Accepted solution]

Perfecto, you are welcome. So did you use MultiString or extra columns in ProdCat file?

Bogdan

[former_member252154 · Accepted solution]

Hi

I am not able to directly create with the multi csv.

I first need to create the Prod cat with the Enterprise worksheet then I translate witht he multi csv.

I then need to load a second multi csv to translate the description.