Bentley Communities
Site
Search
User
Site
Search
User
Product Communities
ProStructures
ProStructures Wiki
Part list sorting options
Sign In
+
ProStructures
-
ProSteel
+
ProSteel CONNECT Edition
-
ProSteel V8i
+
General - ProSteel V8i
+
Setup, Customization & Navigation - ProSteel V8i
+
ProSteel Options - ProSteel V8i
+
Steel Shapes/Objects - ProSteel V8i
+
Steel Connections - ProSteel V8i
+
Structural Objects - ProSteel V8i
+
Manipulation Tools - ProSteel V8i
+
ProSteelTools - ProSteel V8i
+
Part Databases - ProSteel V8i
+
Macros - ProSteel V8i
+
Import/Export - ProSteel V8i
+
Detail Center & Drawing Creation - ProSteel V8i
-
Reports - ProSteel V8i
How to position one by one
Numbering of Plates
Plates with Position Number in model
Position Flag Styles in drawing missing
Positioning with specification
Bolt Nuts Not In Partlist
Total Number Of Parts/Groups Wrong
Drawing Partlist with unwanted Groupprefixes
Drawingpartlist Templates
Filter samples
first page
Gross weight and Net weight for the part lists
group single part list by weight ranges
How To Add A Column For Width In Partlists
How To Add Info To Part List Header
How To Change Sort Order In Part Lists
How to export ProSteel Lists to Excel
How To Group Plates By Thickness In Partlists
Layout - frame table content
Paint Area With Or Without Inner Contour
parts missing
Plates surface
Plates: In Partlists and naming thickness should be placed first
Prosteel Crashing When Using Partlist Creation Command
Prostructure 2d partlist in drawing
Part list sorting options
How to Create Microstation cell and Tag to Use with Prostructure Frame
Sorting in the Partlist
Variables for Partlist Outputpath
Get partlist data having less weight coming less than 1 Kg
Header block only on first page
+
ProSteel CONNECT for AutoCAD
+
ProSteel V8i for AutoCAD
+
ProConcrete
+
Learning Content for ProStructures
+
ProStructures Licensing
+
ProStructures Customer Examples / Projects
Questions about this article, topic, or product? Click here.
Part list sorting options
Document objectives
Grouping a part list using more than one criterion requires sorting the list of elements in the correct order. Starting with Select Series 4, ProStructures provides the opportunity to sort the bill of material using two or three criteria. This document explains how to set up this sorting option and shows two samples.
Name of columns required
For this sorting option one needs to know the name of the columns that shall be used for sorting a list.
You can either open the part list MDB file with Microsoft Access or you can use a table feature built into the part list functionality.
Open the dialog box settings via menu settings/default part list assignment and tolerances and tick the box edit part list data in a table.
Back in the main dialog you can reach the table by double clicking any entry.
Every name of a column can be used for the sorting. Name, position number and material are some common choices.
Creating the variable for the sorting
Open a part list definition file via the menu settings/edit part list definition.
The sorting option will be defined as a user variable.
The new user variable must be named as MYSORTORDER.
By double clicking the new variable can be edited.
The actual definition is the name of the columns divided by a plus sign and as a text definition.
Sample one is a single part list for only plates. The list has a group header for thickness and material.
Only sorting the list by position number would result in a very unorganized list and the grouping would not work as supposed to.
Using MYSORTORDER with the definition "HIGH+MATERIAL+POS_NUMBER" creates a neat list and the grouping is working properly.
Sample two is an ordered list for shapes.
MYSORTORDER is defined as "NAME+MATERIAL+POS_NUMBER". The result is a list which is grouped in blocks with all shapes with the same name and material and each block is shown in the right order of position numbers.
Share
History
More
Cancel
Created by
Gernot Jeromin
When:
Tue, Jun 21 2011 5:19 PM
Last revision by
Vyanktesh Nama
When:
Fri, Apr 2 2021 1:52 PM
Revisions:
4
Comments:
0
Recommended
Related