Skip to main content
H
hschulze1-Visitor
1-Visitor
May 3, 2017
Question

How to use Windchill's Spreadsheet Upload to attach Describe_By and Referenced_By Document numbers to a Part

  • May 3, 2017
  • 2 replies
  • 5138 views

I have datasheets and request emails to attach to parts, hundreds at a time.

I don't want to use the commandline (NMLoader) method, although i have in the past, one reason is that it leaves no traces (iterations).

Is there a way to use ImportSheetType=Document, can I see an example please?

I have been creating parts using Import From Spreadsheet, that works well most of the time.

Hans Schulze

I am surprised that online help doesn't mention this function much.  Was there a manual or guide written for it?

2 replies

J
JeffZemsky17-Peridot
17-Peridot
May 4, 2017

Hans Schulze‌ - today only loading Part, BOM, AVL/AML and Replacements are supported in the Excel Import/Export framework.

There is a partner Wincom Consulting that does have an Excel based loader for Documents.

H
hschulze1-VisitorAuthor
1-Visitor
May 4, 2017

Can I put a document in a BOM format upload?

J
JeffZemsky17-Peridot
17-Peridot
May 4, 2017

The Excel Import/Export will only operate on WTPart objects today.  This would not work

H
hschulze1-VisitorAuthor
1-Visitor
June 2, 2017

I have created a tool to generate an NMLoader XML file from VBA.

ftp://ftp.sonic.net/pub/users/bubblecdn/Create_Document_Upload_XML.xlsm

This spreadsheet assumes that you have 0 or 1 Describe-By document, and 0-2 Reference-By documents to upload.  If you need a different configuration, you need to put on your VBA hat, and edit the code.  Note that cell labels are used extensively.

    T
    tgudobba14-Alexandrite
    14-Alexandrite
    June 9, 2017

    Hans,

    Pretty slick spreadsheet, this streamlines the process quite a bit. Thanks for sharing.

    Terms & ConditionsAccessibility statement