Export BOM, All Levels, Assemblies Only

[bbeilke]

I'm apologize if this topic has been covered somewhere and I missed it.

Is there a way to export all levels of a BOM to Excel, but only export the assemblies?  I'm assuming that this would have to be done through programming as there are no such options in the built-in export utility.  For my purposes, being able to filter the export list by the type of file (assembly vs. part) and include only assembly files would work.  As an alternative, it would also work if I could only include items in the export that started with a specific string of characters.  The text string filtering might work even better for my needs because it would also exclude purchased/vendor assemblies.

Before I get to far down a rabbit hole, I was hoping that somebody more familiar with the API would be able to tell me if this level of granularity was even possible.

Thanks for your help.

[dalton98]

This is possible but it requires some customization to build a unique Bill of Materials.

If you are just wanting to use the default 'Export BOM' , but only want assemblies to show up an easy work around would be to...

Add using 'Choose Columns' ----> Filename

Select 'Export all Levels'

Then accessing the Excel file, whether vba or manually, filter that row by ".iam" and delete the other rows

If you are wanting something more custom here is a good video

https://www.youtube.com/watch?v=RKzsH4orQR0