topic Re: BOM EXPORT-VISUAL STUIDO in Inventor Programming Forum

BOM EXPORT-VISUAL STUIDO

Anonymous — Tue, 11 Dec 2018 12:30:37 GMT

Hi Everyone

I'm being asked more and more to export BOM's from inventor from Non inventor users. ie users without an inventor installation.

I figured I could do something in Visual Studio, the program would have to acquire a network license. and then allow the user to search our network drive for a number and then just export an indented BOM basically.

Has anyone done anything similar already or any pointers at all on the way to acquiring a license from VS?

Any help/nudge in the right direction would be appreciated.

Thanks all

Re: BOM EXPORT-VISUAL STUIDO

HermJan.Otterman — Tue, 11 Dec 2018 15:28:09 GMT

Hi, I think you need to look at Vault Professional, that would solve your question.

but if you don't want to pay than maybe you could do things with Apprentice:

http://aucache.autodesk.com/au2011/sessions/5606/class_presentations/v1_CP5606-Apprentice.pdf

Re: BOM EXPORT-VISUAL STUIDO

HermJan.Otterman — Tue, 11 Dec 2018 15:30:19 GMT

this is from the API help in Inventor:

Exporting the assembly BOM

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
  
    ' Make sure that the parts only view is enabled.
    oBOM.PartsOnlyViewEnabled = True

    ' Set a reference to the "Parts Only" BOMView
    Dim oPartsOnlyBOMView As BOMView
    Set oPartsOnlyBOMView = oBOM.BOMViews.Item("Parts Only")

    ' Export the BOM view to an Excel file
    oPartsOnlyBOMView.Export "C:\temp\BOM-PartsOnly.xls", kMicrosoftExcelFormat
End Sub

Re: BOM EXPORT-VISUAL STUIDO

Anonymous — Tue, 11 Dec 2018 15:32:39 GMT

thx for the apprentice doc, that looks like the route I may go down.