How to convert CSV file to XML to import a classification structure in windchill 12

Hello @RS_10128209 

There is a windchill shell tool to convert csv to xml (wt.load.util.CSV2XML)

first you should prepare CSV file based on a csvmapfile.txt (WT_HOME\loadFiles\csvmapfile.txt)

there are method you need. 

save csv to D:\IMPORTCSV

then use windchill shell command 

windchill wt.load.util.CSV2XML -root D:\IMPORTCSV

 XML file will be generated and this file you can load to Windchill by 

windchill wt.load.LoadFromFile -u AdminUser -p AdminPassword -d D:\IMPORTCSV/sourceFile.xml -CONT_PATH \"/ORG_NAME/wt.pdmlink.PDMLinkProduct=PRODUCTNAME\"

 Hope this can help

PetrH

Curious if you got this working?  In my searches I'm seeing mixed information on if CSV2XML works for Classification structures.

It’s all in the help.

The process is very simple.

Did you not read the manual?