topic Re: Export Assembly BOM with Parent Part numbers in Inventor Programming Forum

Export Assembly BOM with Parent Part numbers

Anonymous — Wed, 27 Dec 2017 20:36:39 GMT

Hello,

I have a need to use my BOM in another program that has the ability to import complex assemblies in one import.

It uses a "parent part number" field to identify the assemblies.

Anyone have any ideas? I manually added a field and populated it to give you an idea of what I'm looking for.

I left in the "Item" column for a clear picture of the hierarchy, but that isn't necessary for my import.

Part Number, Parent Part Number, Quantity, Unit Quantity

are my minimum fields.

Re: Export Assembly BOM with Parent Part numbers

bradeneuropeArthur — Wed, 27 Dec 2017 20:52:12 GMT

Hi,

What is the file format you are needing for the export.

Question:

What are you trying to do with this exported BOM.

Maybe there are less complex methods to achieve the same as you are needing!

Re: Export Assembly BOM with Parent Part numbers

Anonymous — Wed, 27 Dec 2017 20:58:15 GMT

The preferred format is .csv

I am importing into an ERP system that creates routers and work orders. It requires a specific import template as I listed.

I can import each assembly one by one - but if I can figure this out (with the parent part numbers) then I can do it in one import.

Re: Export Assembly BOM with Parent Part numbers

bradeneuropeArthur — Wed, 27 Dec 2017 20:59:08 GMT

What if the Childfile is used in more than one parent?

Re: Export Assembly BOM with Parent Part numbers

Anonymous — Wed, 27 Dec 2017 21:08:47 GMT

I am using a "Structured" list with expanded assemblies to give me the following - notice the item numbers that Inventor populated (4.1 is a child of 4): parts are repeated if they are in multiple assemblies.

Re: Export Assembly BOM with Parent Part numbers

chandra.shekar.g — Tue, 02 Jan 2018 07:06:48 GMT

Hi @Anonymous,

Try the following suggestion to customize BOM.

https://www.cadlinecommunity.co.uk/hc/en-us/articles/203364071-Inventor-2017-Quick-Tip-BoM-Customisation-

To import customized BOM, try the following VBA code to import.

Sub BOM_ColumnCustomizasion_Export ()
Dim oAsmDoc As AssemblyDocument
Set oAsmDoc = ThisApplication.ActiveDocument
Dim oAsmDef As AssemblyComponentDefinition
Set oAsmDef = oAsmDoc.ComponentDefinition
Dim oBOM As BOM
Set oBOM = oAsmDef.BOM
Dim filename As String
filename = "c:\temp\BOM_Columns.xml"
Call oBOM.ExportBOMCustomization(filename)
Beep
End Sub
Sub BOM_ColumnCustomizasion_Import ()
Dim oAsmDoc As AssemblyDocument
Set oAsmDoc = ThisApplication.ActiveDocument
Dim oAsmDef As AssemblyComponentDefinition
Set oAsmDef = oAsmDoc.ComponentDefinition
Dim oBOM As BOM
Set oBOM = oAsmDef.BOM
Dim filename As String 'assume the file exists
filename = "c:\temp\BOM_Columns.xml"
Call oBOM.ImportBOMCustomization(filename)
Beep
End Sub

After importing BOM, try to export BOM using following VBA code.

Public Sub BOMExport()
    ' Set a reference to the assembly document.
    ' This assumes an assembly document is active.
    Dim oDoc As AssemblyDocument
    Set oDoc = ThisApplication.ActiveDocument

    ' Set a reference to the BOM
    Dim oBOM As BOM
    Set oBOM = oDoc.ComponentDefinition.BOM
    
    ' Set the structured view to 'all levels'
    oBOM.StructuredViewFirstLevelOnly = False

    ' Make sure that the structured view is enabled.
    oBOM.StructuredViewEnabled = True

    ' Set a reference to the "Structured" BOMView
    Dim oStructuredBOMView As BOMView
    Set oStructuredBOMView = oBOM.BOMViews.Item("Structured")
    
    ' Export the BOM view to an Excel file
    oStructuredBOMView.Export "C:\temp\BOM-StructuredAllLevels.xls", kMicrosoftExcelFormat

End Sub

Hope, this would help you to import assembly with Parent Part Number.

Thanks and regards,

Re: Export Assembly BOM with Parent Part numbers

Anonymous — Tue, 02 Jan 2018 13:08:42 GMT

Thanks Chandra, this looks very promising. I will dig into it and see what I come up with.

Re: Export Assembly BOM with Parent Part numbers

chandra.shekar.g — Wed, 03 Jan 2018 04:21:21 GMT

@Anonymous - let me know if any assistance required.

Thanks and regards,

Re: Export Assembly BOM with Parent Part numbers

Brett.G — Thu, 25 Apr 2019 14:09:13 GMT

Nick, were you ever able to figure out a solution? This functionality is something I'd be interested in as well. Thanks!