无法从 SharePoint 2010 中的 CSV 导入术语集

Question

我无法在 SharePoint 2010 中使用 CSV 导入术语集。我收到以下错误：尝试导入所提交文件的第 [最后一行] 处的术语集时遇到错误，并且某些数据可能尚未清理。请确保此文件是有效的 csv 文件，并遵循示例文件 ImportTermSet 中的正确格式.csv

我尝试重用示例文件本身来创建我的术语集，在记事本中创建术语集（+确保它是 UTF-8 CSV），但一切都徒劳无功:(有人可以在这里帮我吗？

Answer 1

http://blog.jussipalo.com/2011/04/sharepoint-importing-term-set-gives.html

Answer 2

为了记录：所有重复的术语实例必须具有完全相同的大小写。

例

,,,TRUE,,Continent,Political Entity,,,,,
,,,TRUE,,continent,Political Entity,Country,,,,
,,,TRUE,,Continent,Political Entity,Country,Province or State,,,

上述内容将失败，因为 1 级术语"大陆"在第二行上有小写的"c"。

Answer 3

注意嵌套级别的声明方式。

这是一个正确的CSV文件的示例（注意嵌套级别的顺序）

"Term Set Name","Term Set Description","LCID","Available for Tagging","Term Description","Level 1 Term","Level 2 Term","Level 3 Term","Level 4 Term","Level 5 Term","Level 6 Term","Level 7 Term"
"My Term Set","Description of My Term Set",,"True",,,,,,,,
,,,"True",,"Italy",,,,,,
,,,"True",,"Italy","Venice",,,,,
,,,"True",,"France",,,,,,
,,,"True",,"France","Paris",,,,,
,,,"True",,"Germany","Berlin",,,,, 

这是不正确的 CSV 文件的示例：

"Term Set Name","Term Set Description","LCID","Available for Tagging","Term Description","Level 1 Term","Level 2 Term","Level 3 Term","Level 4 Term","Level 5 Term","Level 6 Term","Level 7 Term"
"My Term Set","Description of My Term Set",,"True",,,,,,,,
,,,"True",,"Italy",,,,,,
,,,"True",,"Italy","Rome",,,,,
,,,"True",,"France","Paris",,,,,
,,,"True",,"France",,,,,, 

最后一行将给出导入错误，因为"法国"已经存在