link between WTPart and WTDoc for 15.000 files as "described by" relation out of a spreadsheet

Forum|Forum|5 years ago
December 8, 2020
1 reply
7163 views

Hello everybody,

we have ~15.000 files (.pdf/.zip) which we like to import into our Windchill 11.0 M030 system. The upload and the manually setting of the correct version we already can do by our own. The missing last step is the link between the existing WTParts and the new added WTDocs as "described by" documents (version depending). Is there a way to use a spreadsheet which connects the filename with the WTPart Number (materialnummer), maybe with interim step adding the document numbers to it?

I read the Windchill help, but I miss the right keyword to get to a solution. Would be great if you can give me a solution note.

Best Regards,

Johannes

Best answer by MikeLockwood

This exact process is addressed in this document, page 72.

https://support.ptc.com/WCMS/files/169024/en/WCDataLoadGuide.pdf

Make sure for each document whether to use <csvPartDocReference> tag or <csvPartDocDescribes> tag as applies for the object type or sub type.

This procedure takes as a given that both WTPart and WTDocument exist in the system; different process to create and associate in one step.

I can provide an example if needed.

M

MikeLockwood

Answer

22-Sapphire I

This exact process is addressed in this document, page 72.

https://support.ptc.com/WCMS/files/169024/en/WCDataLoadGuide.pdf

Make sure for each document whether to use <csvPartDocReference> tag or <csvPartDocDescribes> tag as applies for the object type or sub type.

This procedure takes as a given that both WTPart and WTDocument exist in the system; different process to create and associate in one step.

I can provide an example if needed.

J

JV_8742917

Author

1-Visitor

Thank you for your precise and fast support.

I am so far that I know I have to define a XML file with the informations for all Documents and load it by Windchill Shell in this style (concret example):

<?xml version="1.0"?>

<!DOCTYPE NmLoader SYSTEM "standardX20.dtd">

<NmLoader>

<csvPartDocDescribes handler="wt.part.LoadPart.createPartDoc

Describes">

<csvdocNumber>0000001598</csvdocNumber>

<csvdocVersion>A</csvdocVersion>

<csvpartNumber>ME6994</csvpartNumber>

</csvPartDocDescribes>

</NmLoader>

Since you offered it, can you help me with the XML file? At the moment I am not familiar with the creation process. In the meantime I test it as you can see in the attachment, but I don't the result in the Windchill system. What's wrong? It seems that the xml is not right, the soure is in the .zip and was converted succesful?!

3_test_ME6994.xml

4_test_ME6994.zip