BOM EXPORT-VISUAL STUIDO

BOM EXPORT-VISUAL STUIDO

Anonymous
Not applicable
589 Views
3 Replies
Message 1 of 4

BOM EXPORT-VISUAL STUIDO

Anonymous
Not applicable

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

0 Likes
Accepted solutions (1)
590 Views
3 Replies
Replies (3)
Message 2 of 4

HermJan.Otterman
Advisor
Advisor
Accepted solution

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

 

If this answers your question then please select "Accept as Solution"
Kudo's are also appreciated Smiley Wink

Succes on your project, and have a nice day

Herm Jan


0 Likes
Message 3 of 4

HermJan.Otterman
Advisor
Advisor

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
If this answers your question then please select "Accept as Solution"
Kudo's are also appreciated Smiley Wink

Succes on your project, and have a nice day

Herm Jan


0 Likes
Message 4 of 4

Anonymous
Not applicable

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

 

0 Likes