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.
I am surprised that online help doesn't mention this function much. Was there a manual or guide written for it?
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.
Can I put a document in a BOM format upload?
The Excel Import/Export will only operate on WTPart objects today. This would not work
I have created a tool to generate an NMLoader XML file from VBA.
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.
Pretty slick spreadsheet, this streamlines the process quite a bit. Thanks for sharing.
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.
Very nice tool.
Thank you very much for making it available.
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!
The NAVIGATE WORKING GROUP is here! Come innovate with PTC!Sign up for a Working Group