Skip to main content
17-Peridot
March 4, 2024
Solved

Load File from Local

  • March 4, 2024
  • 1 reply
  • 14493 views

Hi Guys,

 

I am looking for existing local files that, how we can upload into Windchill through the LOAD FILES option.

 

Point 1: How we can create this excel sheet.csv?

Point 2: How we can convert into XML.

 

Regards,

Aj

 

 

Best answer by HelesicPetr

Hi @Amirtharaj_K 

This is a live example

BeginMPMWorkCenter,,PA0001,WorkA001,make,,WorkStation,,/Default/Centers,Basic,Manufacturing,,INWORK,com.ptc.windchill.mpml.resource.MPMWorkCenter,,A,,,,,,
IBAValue,Parametr1,AAA,,
IBAValue,Parametr3,CCC,,
IBAValue,Parametr5,CDA,,
EndMPMWorkCenter

Create TXT csv file,

Use csvToxml tool from Windchill Shell CMD 

check the XML output, 

load this XML to windchill

 

how to use csvToXml tool https://www.ptc.com/en/support/article/CS358782 

how to use load from file utility https://www.ptc.com/en/support/article/CS138169

 

All you can find on knowledge base

example with WTParts https://www.ptc.com/en/support/article/CS17492

example with wtDocument and primary file https://www.ptc.com/en/support/article/CS38296

 

PS> you can use load from file utility for all objects that are mentioned in the csvmapfile.txt 

PetrH

1 reply

Fadel
23-Emerald I
March 4, 2024

we have below file with csv pattern 

Fadel_0-1709557446205.png

 

the conversion to xml is done by csv2xml tool https://www.ptc.com/en/support/article/CS358782 

Buiꓘa
17-Peridot
March 7, 2024

Thanks for the reply, @Fadel. I apologize for the delayed response.

Do you have any sample XML and Excel files for me to understand?

 

Regards,

Aj

 

Fadel
23-Emerald I
March 7, 2024

Salam Amir,

 

would you let me know about the data you want to load , can later make a practical example  

 

BR,

Fadel

Buiꓘa