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: 4124

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    9119×  
Prices - CAD eShop:
applies to: Inventor ·

See also:
Tip 13337:How to select blocks by attribute values? (SelByAttr)
Tip 13234:How to place a GeoTIFF image automatically into the correct position?
Tip 13227:Reference Explorer - quick analysis of your project or assembly (file size, xref errors).
Tip 13040:iLogic - display information about complexity of an Inventor part.
Tip 12671:Import Excel table by snapping a photo of it.


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