How to import csv with business terms to glossary

Question

How to import csv with business terms to glossary

Markova, Monika 20

I am trying to import csv with a simple term using system default template. When I browse the csv, i have no alert so I continue with OK button. Then error message occurs, see image. The error is about missing attributes qualifiedName, name & glossary name. But such attributes are not part of System default templates. User's image

Unfortunately there is no possibility to insert csv file here. So I'm adding at least an image of csv (open with excel, but it is stored as csv with UTF8 comma delimited). User's image

Moreover downloaded csv file provided as an example is not working anyway. So please, could you send me csv which really works for my pretty easy example?

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2024-02-28T21:42:24.56+00:00

Hello Markova, Monika,

from your issue, it seems like the CSV file you are trying to import does not contain the required attributes for the system default template. If your CSV file does not contain the attributes, you may need to modify the file or create a custom template that matches the attributes in your file.

and please Make sure that the CSV file is saved in UTF-8 format and that the first row contains the column headers.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Markova, Monika 20 Reputation points

2024-02-29T07:59:05.4566667+00:00

Hi, how can be missing attributes which does not exist in the template? Here is my system template definition. Do you really see attributes Glossary name and QualifiedName within this templates? Or you just want me to say that i need to add also attributes which are not in template definition and need to somehow guessed it based on the error because i do not have any other option where to find complete list of required attributes for template? And as you can see in my previously provided screen attribute Name is filled. Also I have confirmed that csv is stored in UTF-8 because I know this is required.
Markova, Monika 20 Reputation points

2024-02-29T10:00:28.82+00:00

I've added attribute Glossary Name and qualified Name to csv as you adviced. When I open issue in detail - column is not part of the template.

But when I go further - click on button OK - it still says attributes are missing. So at first purview says attribute is no allowed and then purview says attribute is missing. Inconsistence between errors is really confusing.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2024-03-06T22:51:12.0033333+00:00

Markova, Monika, This issue needs further troubleshooting. If you have a support plan, please submit a support request. in case, if you don't have a support plan, please let me know so that I can enable a one-time free support request to work on this case. I am looking forward to hearing from you.
Markova, Monika 20 Reputation points

2024-03-18T12:45:59.9533333+00:00

Hi, I've solved the issue. The problem was not missing attributes. When i modify the csv (with UTF-8) with notepad it is fine, but if i open it with excel is not working properly.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2024-03-18T21:42:39.2033333+00:00

Hello Markova, Monika,

The error message you are receiving is misleading. I will share this with the Product group.

I'm glad you were able to resolve the issue, and thank you for sharing the resolution.

Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution as it helps the community look for answer to this issue.

1 answer

Your answer

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2024-02-28T21:42:24.56+00:00

Hello Markova, Monika,

from your issue, it seems like the CSV file you are trying to import does not contain the required attributes for the system default template. If your CSV file does not contain the attributes, you may need to modify the file or create a custom template that matches the attributes in your file.

and please Make sure that the CSV file is saved in UTF-8 format and that the first row contains the column headers.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Markova, Monika 20 Reputation points

2024-02-29T07:59:05.4566667+00:00

Hi, how can be missing attributes which does not exist in the template? Here is my system template definition. Do you really see attributes Glossary name and QualifiedName within this templates? Or you just want me to say that i need to add also attributes which are not in template definition and need to somehow guessed it based on the error because i do not have any other option where to find complete list of required attributes for template? And as you can see in my previously provided screen attribute Name is filled. Also I have confirmed that csv is stored in UTF-8 because I know this is required.
Markova, Monika 20 Reputation points

2024-02-29T10:00:28.82+00:00

I've added attribute Glossary Name and qualified Name to csv as you adviced. When I open issue in detail - column is not part of the template.

But when I go further - click on button OK - it still says attributes are missing. So at first purview says attribute is no allowed and then purview says attribute is missing. Inconsistence between errors is really confusing.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2024-03-06T22:51:12.0033333+00:00

Markova, Monika, This issue needs further troubleshooting. If you have a support plan, please submit a support request. in case, if you don't have a support plan, please let me know so that I can enable a one-time free support request to work on this case. I am looking forward to hearing from you.
Markova, Monika 20 Reputation points

2024-03-18T12:45:59.9533333+00:00

Hi, I've solved the issue. The problem was not missing attributes. When i modify the csv (with UTF-8) with notepad it is fine, but if i open it with excel is not working properly.
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2024-03-18T21:42:39.2033333+00:00

Hello Markova, Monika,

The error message you are receiving is misleading. I will share this with the Product group.

I'm glad you were able to resolve the issue, and thank you for sharing the resolution.

Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution as it helps the community look for answer to this issue.

Answer 1

Hello ,

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer .

Issue:

Unable to import csv with business terms to glossary using system default template

Error Message:

Request failed with status code 400 Requestid: XXX Attributes qualifiedName, name & glossary name are missing. Failed to derive a unique name for Glossary term

User's image

Solution:

The error message is misleading. The issue was not with missing attributes. The error occurred when modifying the CSV with Excel using UTF-8 encoding. It works fine when using Notepad.

If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

I hope this helps to other community members looking for answer to this issue.

Share via

How to import csv with business terms to glossary

1 answer

Your answer