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

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

Translate the entire conversation x

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

RS_10128209
12-Amethyst

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
HelesicPetr
22-Sapphire II
(To:RS_10128209)

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.

Announcements


Top Tags