cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

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

RS_10128209
10-Marble

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

To create a classification structure by importing a csv template.

2 REPLIES 2

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

Im enable to convert CSV to XML file its showing me the error related to header.

Top Tags