topic Re: BOM Sort not working Properly in Inventor Programming Forum

BOM Sort not working Properly

Anonymous — Sat, 22 Sep 2012 16:21:00 GMT

Dim oDrawDoc As DrawingDocument

Set oDrawDoc = ThisApplication.ActiveDocument

Dim oSheet As Sheet

Set oSheet = oDrawDoc.ActiveSheet

Dim oDrawingView As DrawingView

Set oDrawingView = oSheet.DrawingViews(1)

Dim oAssydoc As AssemblyDocument

Set oAssydoc = oDrawingView.ReferencedDocumentDescriptor.ReferencedDocument

Dim oBOM As BOM

Set oBOM = oAssydoc.ComponentDefinition.BOM

oBOM.StructuredViewEnabled = True

oBOM.StructuredViewFirstLevelOnly = False

Dim oBOMView As BOMView

Set oBOMView = oBOM.BOMViews.Item("Structured")

Call oBOMView.Sort("BOM Structure", True, "Part Number", True, , True)

The above line not working properly, It sorts only the first a criteria i.e. BOM Structure. And if change the first one to Part Number the only the part number will work. At any point of time only the first sorting criteria is working.

Re: BOM Sort not working Properly

Anonymous — Mon, 24 Sep 2012 15:22:24 GMT

Is this a bug or something wrong in the above code?

Re: BOM Sort not working Properly

xiaodong_liang — Thu, 27 Sep 2012 03:43:30 GMT

Hi,

firstly, there is a typo in the last line. The TertiaryColumnTitle is not set, while the TertiaryColumnAscending is set to true.

But this is not a problem. Even though I use Call oBOMView.Sort("BOM Structure", True, "Part Number", True), the issue can reproduce. The second column is not sorted.

I logged this issue with the engineer team.

Re: BOM Sort not working Properly

Anonymous — Thu, 27 Sep 2012 10:36:52 GMT

Thanks, Please Let me know if this is solved in upcomming updates.

Re: BOM Sort not working Properly

Anonymous — Wed, 01 May 2013 18:41:53 GMT

The problem exists in Inventor 2014 also.

Re: BOM Sort not working Properly

jdkriek — Thu, 02 May 2013 20:16:00 GMT

Good catch.

Re: BOM Sort not working Properly

mrattray — Fri, 20 Feb 2015 14:56:23 GMT

Still an "issue" in Inventor 2015.

Re: BOM Sort not working Properly

MechMachineMan — Tue, 19 Jan 2016 18:27:53 GMT

STILL an issue in 2016, 4 years later.

ie; Trying to sort BOM with a custom iProp column (Work Order #) sorted first, and mass sorted second.

Will sort mass just fine, but I can't set the option for what order to sort the custom iProp; it always sorts ascending even though it is completely numerical..

Re: BOM Sort not working Properly

Anonymous — Wed, 18 Oct 2017 21:06:38 GMT

Still an issue in Inventor Pro 2017.... Can someone please fix this?!

Re: BOM Sort not working Properly

Anonymous — Mon, 08 Apr 2019 13:42:09 GMT

There is a way to sort BOM by more then one column:

Instead of trying to do it this way:

oBOMView.Sort("BOM Structure", True, "Part Number", True)

Do it this way: first sort by the second column and then by the first.

oBOMView.Sort("Part Number", True)

oBOMView.Sort("BOM Structure", True)

Re: BOM Sort not working Properly

Anonymous — Mon, 08 Apr 2019 13:43:41 GMT

There is a way to sort BOM by more then one column:

Instead of trying to do it this way:

oBOMView.Sort("BOM Structure", True, "Part Number", True)

Do it this way: first sort by the second column and then by the first.

oBOMView.Sort("Part Number", True)

oBOMView.Sort("BOM Structure", True)

Re: BOM Sort not working Properly

rhasell — Mon, 08 Apr 2019 23:36:43 GMT

Actually, this never works properly. You might get lucky, but don't bank on it. I guess it depends on your environment, but I had some strict sorting rules, and they never really worked consistently.

I have found that sorting in the drawing environment to be the most stable.

Create a dummy drawing and place all the Parts Lists in there. Using iLogic, you can sort multiple parts lists with a few mouse clicks.

These can then write back to the assemblies, and give a consistent BOM sort. (I wrote some code the other day to sort the BOM by item number, you cant go wrong with that one, LOL)