cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Newbie

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

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?

7 REPLIES 7

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

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.

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

Can I put a document in a BOM format upload?

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

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

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

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.

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

Hans,

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

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

I found a bug when updating some parts, that I had to include the MfrName despite that the part numbers were unique to each Mfr.  Just provide the Mfr name or leave it blank.

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

Re: How to use Windchill's Spreadsheet Upload to attach Describe_By and Referenced_By Document numbe

Very nice tool.

Thank you very much for making it available.

Much Appreciated

Scott

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________ Check out the Windchill Tips Board! We're talking about Whirlpool's use of digital twin, augmented reality, and data-driven design!

The NAVIGATE WORKING GROUP is here! Come innovate with PTC!

Sign up for a Working Group