Windchill loadfrom file templates for creating part substitutes and alternates

1 reply
649 views
Translate All

Hi All,

Recently I have worked on creating the part substitutes and alternates using windchill load from file utility in windchill 12.0.2.18. Since the REST end points were not present in my windchill version need to go with load from file utility. I hope it will be useful for some one looking for a solution to automate these tasks.

Following is the xml template for the same:

Load Alternates:

<?xml version="1.0" ?><!DOCTYPE NmLoader SYSTEM "standard12_0.dtd">
<NmLoader>
<csvBeginCreateUpdateAlternateLink handler="wt.replacement.LoadReplacement.beginCreateUpdateAlternateLink" >
<csvalternatePartNumber>AI-00003</csvalternatePartNumber>
<csvalternatePartName>component2</csvalternatePartName>
<csvalternatePartOrganizationName>DemoOrg</csvalternatePartOrganizationName>
<csvalternatePartOrganizationID></csvalternatePartOrganizationID>
<csvalternateForPartNumber>AI-00002</csvalternateForPartNumber>
<csvalternateForPartName>component1</csvalternateForPartName>
<csvalternateForPartOrganizationName>DemoOrg</csvalternateForPartOrganizationName>
<csvalternateForPartOrganizationID></csvalternateForPartOrganizationID>
<csvtwoWayStatus></csvtwoWayStatus>
<csvreplacementType></csvreplacementType>
</csvBeginCreateUpdateAlternateLink>

</NmLoader>

LoadCommand:

windchill wt.load.LoadFromFile -d <Path of the xml load file> -u <UserName> -p <Password> -CONT_PATH \"/wt.inf.container.OrgContainer=DemoOrg/wt.pdmlink.PDMLinkProduct=<Your Product Name>\"

XML Template for the creating substitutes:

<?xml version="1.0" ?><!DOCTYPE NmLoader SYSTEM "standard12_0.dtd">
<NmLoader>
<csvBeginCreateUpdateAssemblySubstitute handler="wt.replacement.LoadReplacement.beginCreateUpdateAssemblySubstitute" >
<csvpartNumber>AI-00001</csvpartNumber>
<csvpartName>TopLevelPart</csvpartName>
<csvorganizationName>DemoOrg</csvorganizationName>
<csvorganizationID></csvorganizationID>
<csvversion>A</csvversion>
<csvview>Design</csvview>
</csvBeginCreateUpdateAssemblySubstitute>

<csvBeginCreateUpdateSubstituteLink handler="wt.replacement.LoadReplacement.beginCreateUpdateSubstituteLink" >
<csvsubstituteForPartNumber>AI-00004</csvsubstituteForPartNumber>
<csvsubstituteForPartName>component3</csvsubstituteForPartName>
<csvsubstituteForPartOrganizationName>DemoOrg</csvsubstituteForPartOrganizationName>
<csvsubstituteForPartOrganizationID></csvsubstituteForPartOrganizationID>
<csvsubstituteForLineNumber></csvsubstituteForLineNumber>
<csvsubstitutePartNumber>AI-00005</csvsubstitutePartNumber>
<csvsubstitutePartName>component4</csvsubstitutePartName>
<csvsubstitutePartOrganizationName>DemoOrg</csvsubstitutePartOrganizationName>
<csvsubstitutePartOrganizationID></csvsubstitutePartOrganizationID>
<csvreplacementType></csvreplacementType>
<csvsubstitutePartReferenceDesignator></csvsubstitutePartReferenceDesignator>
<csvsubstitutePartUnit></csvsubstitutePartUnit>
<csvsubstitutePartAmount></csvsubstitutePartAmount>
</csvBeginCreateUpdateSubstituteLink>

</NmLoader>

LoadCommand:

windchill wt.load.LoadFromFile -d <Path of the xml load file> -u <UserName> -p <Password> -CONT_PATH \"/wt.inf.container.OrgContainer=DemoOrg/wt.pdmlink.PDMLinkProduct=<Your Product Name>\"