ACCEPTED SOLUTION
Accepted Solutions
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,,
EndMPMWorkCenterCreate 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
we have below file with csv pattern
the conversion to xml is done by csv2xml tool https://www.ptc.com/en/support/article/CS358782
The csv2xml tool will generate the XML for you from csv file.
here is the row with names with separator
user,name,number,category,description,standardProcessPlan,defaultUnit,folder,lifecycle,view,teamTemplate,lifecyclestate,typedef,parentContainerPath,version,iteration,organizationName,organizationID,createTimestamp,modifyTimestamp
Not all input have to be filled in but you can check DTD definition what is required.
...\Windchill\codebase\registry\ixb\dtds\standard12_1.dtd\csvmapfile.dtd
elements with question mark in the end of string attribute name are not required.
here is example with MPM WorkCenters with IBA definition
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
csvmapfile.txt contains this definition
BeginMPMWorkCenter~create~com.ptc.windchill.mpml.resource.LoadResource.beginWorkCenter~user~name~number~source~defaultUnit~category~usage~folder~lifecycle~view~teamTemplate~lifecyclestate~typedef~parentContainerPath~version~iteration~organizationName~organizationID~createTimestamp~modifyTimestamp~erpValidationCode~external~description
PetrH
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,,
EndMPMWorkCenterCreate 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
@HelesicPetr Thanks for sharing,
If i create individual means it's working, but how i can add the attachment individually in primary and secondary content. Refer the below attachments.
I already upload few data through creo, it's shown other format can we do this format in loader.
Regards,
Aj
The objects loaded throw creo is not WTDocument so you can not use this method load from file to load EPMDocuments.
PetrH
What is not clear in the article CS38296
PS> the order is very important.
BeginWTDocument
EndWTDocument
ContentFile
BeginWTDocument
EndWTDocument
ContentFile
....
PetrH
zip is a primary content and the attachment is also zip file in the article example
What is confusing?
You need to define each file individually
BeginWTDocument - defines the object in the Windchill
EndWTDocument - defines the primary content file
ContentFile - defines the attachment file. You can use more ContentFile rows for more attachments but it has to be before next BeginWTDocument definition
the definition order is super important
PetrH
What all documents in dump are you talking about?
The source files has to be individually placed in a folder not in a one zip file.
PetrH
I think this will help us to understand what i asked.
I create multi-document that name are T1 | T2 | T3| T4
Each document have a some attachments okay, Example T1 have 2 Attachments one for T1.txt (Primary) and other one is 888505.xlsx (Secondary)
Question: How we can go similar for T2 Document. (Attachments is different)
Question: T3 i can use T4.txt & 888508.xlsx, how we can map it.
Regards,
Aj
It is not so big deal if you can define all definitions in one row.
T1 number, name, primary file location1, 1attachement file1, 1attachement file2, 1attachement file3
T2 number, name, primary file location2, 2attachement file1, 2attachement file2, 2attachement file3
TX number, name, primary file locationX, Xattachement file1, Xattachement file2, Xattachement file3
then you can write a code in excel that creates the structure definition as you need based on the csvmapfile.txt
then you just save the result to the csv file.
I did it many times.
Also you can write own utility that can build the Windchill correct structure from you specific input.
For someone who can not create any automatization by code it is challenge.
PetrH
