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

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! 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.

4 REPLIES 4
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.

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?

Announcements
Top Tags