CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]
CZ | EN | DE
Login or
registration
  Visitors: 4636

CAD tip CAD tip # 11732:

   
Question CAD 
 %  platform  category 
Q - question

How to sort BOM or parts list by part number in Inventor? (iLogic)

A - answer You can change sort order of your parts list in an Inventor drawing using the following simple iLogic rule - it re-sorts the partlist so that its individual items (rows) are listed in ascending order their part number.

The re-sorted parts list can be then renumbered starting by 1.

On Error Resume Next
Dim oDwgDoc As DrawingDocument
oDwgDoc = ThisApplication.ActiveDocument

Dim oPartsList1 As PartsList
oPartsList1 = oDwgDoc.ActiveSheet.PartsLists.Item(1)
If oPartsList1 Is Nothing Then
	MsgBox ("No parts list!")
Else
	oPartsList1.Sort("PART NUMBER") ' Needs to be localized: e.g. BAUTEILNUMMER (de), ČÍSLO SOUČÁSTI (cz)
	oPartsList1.Renumber
End If 


If you need to change sort order of your assembly BOM in a similar way, use the following iLogic rule:

'Get active assembly
Dim activeAssembly As AssemblyDocument = ThisApplication.ActiveDocument
'Get structured bom view
Dim bomView As BOMView = activeAssembly.ComponentDefinition.BOM.BOMViews(2)
'Sort by Part Number
Call bomView.Sort("Part Number", True)
'Renumber rows
Call bomView.Renumber(1, 1)
Inventor
100% *  CAD 
14.12.2017    10636×  
Prices - CAD eShop:
applies to: Inventor ·

See also:
Tip 13611:BOM with multi-line items in Inventor.
Tip 13557:How to create an image with transparent background in Fusion 360?
Tip 13539:Revit 2023.1 shows "Twinmotion is not installed"
Tip 13522:LookupXLS - populating DWG texts from Excel spreadsheets.
Tip 13505:How to find which version of Inventor has saved a file?


Back   All CAD Tips



Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link: CAD Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   



Featuring:
Use Google Earth images in your AutoCAD projects with the Plex.Earth Tools More info


Please use these tips at your own risk.
Arkance Systems is not responsible for possible problems that may occur as a result of using any of these tips.
TOPlist