Skip to main content
A
Amirtharaj_K17-Peridot
17-Peridot
November 25, 2023
Question

Load from File- New WT

  • November 25, 2023
  • 3 replies
  • 1955 views

Hi Guys,

I am looking for WT Parts that will be created and loaded from Excel.

 

This is one I tested individually, and it works.

[ If i add this it's not work: <csvlifecycle>vtc</csvlifecycle> <!-- Added: Life Cycle Template --> | <csvcontext>Testing Purpose</csvcontext> <!-- Added: Context --> | <csvlocation>/Testing Purpose/2. WT Parts</csvlocation> <!-- Added: Location -->]

 

 

<?xml version="1.0" ?><!DOCTYPE NmLoader SYSTEM "standardX20.dtd">
<NmLoader>

<csvBeginCreateOrUpdateWTPart handler="wt.part.LoadPart.beginCreateOrUpdateWTPart" >
<csvpartName>Demo_load_part</csvpartName>
<csvpartNumber>0000000101</csvpartNumber>
<csvtype>separable</csvtype>
<csvgenericType></csvgenericType>
<csvcollapsible></csvcollapsible>
<csvlogicbasePath></csvlogicbasePath>
<csvsource>make</csvsource>
<csvfolder>/Default</csvfolder>
<csvlifecycle>vtc</csvlifecycle> <!-- Added: Life Cycle Template -->
<csvview></csvview>
<csvvariation1></csvvariation1>
<csvvariation2></csvvariation2>
<csvteamTemplate></csvteamTemplate>
<csvlifecyclestate></csvlifecyclestate>
<csvtypedef></csvtypedef>
<csvclassToUpdate></csvclassToUpdate>
<csvorganizationName></csvorganizationName>
<csvorganizationID></csvorganizationID>
<csvsecurityLabels></csvsecurityLabels>
<csvcontext>Testing Purpose</csvcontext> <!-- Added: Context -->
<csvlocation>/Testing Purpose/2. WT Parts</csvlocation> <!-- Added: Location -->
</csvBeginCreateOrUpdateWTPart>

<csvEndCreateOrUpdateWTPart handler="wt.part.LoadPart.endCreateOrUpdateWTPart" >
<csvparentContainerPath></csvparentContainerPath>
</csvEndCreateOrUpdateWTPart>

</NmLoader>

 

I want bulk load from excel sheet, i want know, how we can create this in excel too.

 

Regards,

Amir

3 replies

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
November 26, 2023

If you are just loading parts from a spreadsheet, you are better off using this method:

https://support.ptc.com/help/wnc/r12.0.2.0/en/#page/Windchill_Help_Center%2FImExImportAbout.html%23

Much easier. This is done via the normal UI.

J
jvonzastrow115-Moonstone
15-Moonstone
November 27, 2023

Hi @Amirtharaj_K 

 

A simple way to get the correct excel format is to export one part from Windchill GUI. From Part Detail page select Action - Export importable spreadsheet

Then you can modify the file to fit with your new parts. You import spreadsheet from Products Details page - Action - Import importable spreadsheet.

 

If you like to use loadFRomFile from Windchill shell you can find samples of file 

[Windchill_Home]/loadFiles
[Windchill_Home]/loadXMLFiles

see detail : Article - CS138169 - [Knowledge Hub] Windchill PLM - LoadFromFile Utility (ptc.com) 

 

Regards

Johannes

    Fadel
    Fadel23-Emerald I
    23-Emerald I
    November 27, 2023

    @Amirtharaj_K  , glad to hear from you again , take any part in your windchill , and export it as excel spreadsheet, use the exported file as template .

    The export action is  on the info page of part , the import is on folder table view  

    (view in My Videos)

    Buiꓘa
    A
    Amirtharaj_K17-PeridotAuthor
    17-Peridot
    December 18, 2023

    Thanks for the reply guys and apologize for the delay in response.

     

    How we can use the loader to do this, and how we can add the attribute's name and value here?

    Article - CS172839
    What is the CSV file format for converting to XML and loading WTPart in Windchill PDMLink

     

    Regards,

    Aj

    Fadel
    Fadel23-Emerald I
    23-Emerald I
    December 19, 2023

    @Amirtharaj_K  chcek https://www.ptc.com/en/support/article/CS195189 for loader to update iba value .

    for the csv , check your windchill installation folder for a file called csvmap.txt , it has csv syntax for all OOTB loader 

    Buiꓘa
    Terms & ConditionsAccessibility statement