How to import Multi-language Multi-facetted term set in SharePoint

Question

How to import Multi-language Multi-facetted term set in SharePoint

Maarten Van Elsen 41

Hi,

I have created a taxonomy in Excel consisting of about 1000 terms in 3 languages. It is multi-facetted & some terms have synonyms.
SharePoint can handle all of this. Rather than uploading 3000+ terms manually, I would like to import once.
Unfortunately, the examples available on-line only describe the syntax for single language & single facet taxonomies.

My main concern are the languages: I estimate that to be 95% of the work.
If I could already import a single facetted term set with terms in 3 languages, that would be fantastic.

A solution using a CSV file for import would have my preference.

Any suggestions on how to approach?

Kind regards
Maarten

CaseyYang-MSFT 10,461 Reputation points

2021-11-22T03:22:11.043+00:00

Thank you for your question. We will give you an update as soon as possible. Thank you for your understanding and support.

Accepted answer

0 additional answers

Your answer

CaseyYang-MSFT 10,461 Reputation points

2021-11-22T03:22:11.043+00:00

Thank you for your question. We will give you an update as soon as possible. Thank you for your understanding and support.

Answer 1

CaseyYang-MSFT 10,461

Hi @Maarten Van Elsen ,

1.Open the Term Store management tool
Site settings > Site Administration > Term store management > Return to classis

2.Click "View a sample import file" to download a copy of the import file.
Term Store Management Tool > GENERAL > Sample Import > View a sample import file

3.Open the sample CSV file, populate the file as per your requirement. Then import the file into the desired group to create a new term set.
Right click Group > Import Term Set > Choose file > select your CSV file

For Reference: Import term sets

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Maarten Van Elsen 41 Reputation points

2021-11-23T07:25:25.1+00:00

Thank you @CaseyYang-MSFT

This was the procedure I followed prior to submitting my question.
I created a test term set (see attachment 151675-importtermset-test-04.txt - I changed the extension for csv to txt to be able to upload):
* Term 19 is an example of a multi-facet. It is correctly uploaded, although I seem not able to set the characteristics (pinned or re-used- from the CSV file
* It has 2 languages - I used the LCID code for dutch & English. My SP is in Dutch. Unfortunately, all terms are loaded in the Dutch version. It seems as if the LCID code is not used during the import. I also discovered that the "merge" function is more a "replace" function. What I mean is that a true merge would add the 'old' term to the synonyms.

My biggest problem is the language support which seems not to work for me and the sample file does not show how to do so. Any help would be appreciated.

Kind regards
Maarten
CaseyYang-MSFT 10,461 Reputation points

2021-11-26T08:02:33.467+00:00

Hi @Maarten Van Elsen ,

Per my research, i didn't find any articles about how to import multi-language term sets. Here is a blog about Custom multilingual text in SharePoint Online using Taxonomy and JSOM for reference.
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.
Yi Lu_MSFT 17,616 Reputation points

2021-11-29T08:27:54.997+00:00

Hi @Maarten Van Elsen
Would you please provide some update of this issue? Please feel free to reply.
Maarten Van Elsen 41 Reputation points

2021-11-29T15:00:44.587+00:00

Thank you for your reply.

I believe the conclusin is that multilanguage is not possible using CSV.
To get such job done requires some more advanced approach, like the one described in the link.

Thanks for the information.

Maarten
CaseyYang-MSFT 10,461 Reputation points

2021-12-02T08:28:17.653+00:00

Hi @Maarten Van Elsen ,

You are welcome and thanks for your reply. If you think this answer helpful to you, please remember to accept them. It will help others who meet the similar question in this forum. Thank you for your understanding.

Share via

How to import Multi-language Multi-facetted term set in SharePoint

0 additional answers

Your answer