Automatic BOM export

[Anonymous]

I want use iLogic to export my BOM. There is the build-in command:

ThisBOM.Export("Parts Only", "fileName", kMicrosoftExcelFormat  

But the problem is, every time I run that, it shuffles the columns into alphabetical order but I want it to be in the order that it set up as. When you go to Manage > Bill of Materials > Export, it exports it the way I want, but it doesn't do it properly when I run iLogic. I'm just looking for a way to automate this.

Thanks

Nick

[k14348]

u need BOM from idw file or iam file?

-karthikeyan

[frederic.vandenplas]

Hi,

I could reproduce the issue, with the API you can do more then with the basic ilogic function.

I just put a BomView.Sort on your item and then exported the bom

Dim oDoc As AssemblyDocument
oDoc = ThisApplication.ActiveDocument
'  a reference to the BOM
Dim oBOM As BOM = oDoc.ComponentDefinition.BOM
'  the structured view to 'all levels'
' Make sure that the parts only view is enabled.
oBOM.PartsOnlyViewEnabled = True
'  a reference to the "Parts Only" BOMView
Dim oPartsOnlyBOMView As BOMView = oBOM.BOMViews.Item("Parts Only")
' Sort the bom
oPartsOnlyBOMView.sort("Item",True) 'ColumnName','Ascending=True/Descending=False'
' Export the BOM view to an Excel file
oPartsOnlyBOMView.Export ("C:\temp\test.xls", kMicrosoftExcelFormat)

[Anonymous]

Preferably from the .iam

[Anonymous]

This will sort the rows, but how can I sort the columns? Thanks for this bit though!

[frederic.vandenplas]

Doh, i was looking at the export and found that the rows where not sorted neither.

Apparently the API call and the Export BOM built in function differ entirely and are not synchronised (google search)

So i would report this as a bug or as an improvement idea

As an alternative you can use excel COM to arrange the columns there.

[Anonymous]

The weird part about that is that if you go through the BOM interface, you can export according to your current layout just fine. Is it possible to use an xml template of the BOM to export the current BOM through. Basically use the code you provided to apply the template.