Automating Parts list export
Automating Parts list export
(OP)
We are trying to automate the export process of our parts lists, and would like the ability to pre-set some of the options available.
Each time we export a parts list we need to do 4 things:
*set the output location => FILE
*set the format => Commas between columns
*set the filename => <DB_PART_NO><DB_PART_REV>
*set the location => U:\NX\BOM
Does anyone know of, or have any VB code they use to do this? Any help would be greatly appreciated
Each time we export a parts list we need to do 4 things:
*set the output location => FILE
*set the format => Commas between columns
*set the filename => <DB_PART_NO><DB_PART_REV>
*set the location => U:\NX\BOM
Does anyone know of, or have any VB code they use to do this? Any help would be greatly appreciated
Ross
NX6.0.1.5 WinXP SP2
TC V10.0.2.4
SolidWorks 2007





RE: Automating Parts list export
My approach in the past has been to create a small number of master assemblies for the various products and export each to Excel to create the lists of files required. Having said that I don't know what you're intended reuse of the information is so I can't better advise than that.
For example why do you need it if you have teamcentre? Or in other words what is it that you require than teamcenter can't already give you?
Cheers
Hudson
RE: Automating Parts list export
RE: Automating Parts list export
John R. Baker, P.E.
Product 'Evangelist'
NX Design
Siemens PLM Software Inc.
Cypress, CA
http://www.siemens.com/plm
http://www.plmworld.org/museum/
To an Engineer, the glass is twice as big as it needs to be.
RE: Automating Parts list export
Note though that roles don't record this customisation and nor is it coded in any of the defaults files. It is not usually so onerous a task that one would bother to avoid the brief manual interaction required to set it up since it will be saved and remain thus until the next version upgrade.
Cheers
Hudson
RE: Automating Parts list export
For instance, if we choose to "Pack all" parts with multiple instances to show just one instance of it in the assembly navigator, the part number column shows "PARTNUMBER X 2" to show the qty of that item. On the other hand, if we choose to leave them unpacked, we see multiple instances of the same part, each with a qty of 1.
We also have some assemblies that are driven by a reference part containing only sketches and planes, which we never want to appear in any parts list. We can add the PLIST_IGNORE_MEMBER attribute to them to exclude them from a parts list, however they still appear in the Assembly navigator.
Hence the reason we thought exporting a parts list may more beneficial. I am certainly open to any other suggestions though
Ross
NX6.0.1.5 WinXP SP2
TC V10.0.2.4
SolidWorks 2007
RE: Automating Parts list export
You could suppress the components that are only for reference in the ANT and that may be of use to you I guess, but apart from that I still really don't know your end goal so if you choose to share that maybe we can comment further.
Cheers
Hudson
RE: Automating Parts list export
Ross
NX6.0.1.5 WinXP SP2
TC V10.0.2.4
SolidWorks 2007