Problem:
When importing TermSet using CSV file in SharePoint 2010, you get error:
An error was encountered while attempting to import the term set at line [LINENUMBER] of the submitted file and some data may not have been cleaned up. Please ensure that this file is a valid csv file and adheres to the correct format as in the sample file ImportTermSet.csv.
Where [LINENUMBER] is the number of the last line in your CSV file.
You have verified that CSV file is indeed valid, and there is definitely nothing wrong with the last line. Also, when removing the last line, the error persists, but contains LINENUMBER-1.
Solution:
Make sure capitalization in the terms imported in your CSV is same for all parent items. You cannot have parent items with different capitalization.
You will get the error if any parent level term capitalization doesn’t match, e.g.,
,,,"True",,"First level term","First second level term",,,,,
,,,"True",,"first level term","Second second level term","Third level term",,,,
will give you the error, while
,,,"True",,"First level term","First second level term",,,,,
,,,"True",,"First level term","Second second level term","Third level term",,,,
works fine.
Had this problem today, thanks muchly for the heads up!
ReplyDeleteGreat!! thanks for your post. saved me lot of time.
ReplyDeleteI found my issue was commas in the term comments. I had lots of them for 100+ terms
ReplyDeleteAny problem with open csv file https://wikiext.com/csv for me can be solved simply,
ReplyDeleteI use the program for the automatic opening of several files extensions.
As soon as I started using the universal file viewer, I stopped receiving any error notifications. Maybe this was your problem?