ProSteel Partlist Database Details
The reporting tool reads ProSteel object information from an Access database rather than directly from the design file. Supporting Item Types in a ProSteel report extended the ProSteel database structure.
A field is added to a partlist table for every Item Type that is
attached to an object in the table (as marked in red in the above image).
A table is added to the database for each ItemType field that was added
to the Partlist table. Each record in the table is a unique Item (set of
property values).
- The table name matches the Partlist field name.
- The first field-named ItemTypeKey-is used to join the Item (set of property values) to one or more objects in the Partlist table.
- The remaining fields are named for the Item Type properties. The field values are the individual property values as strings. The fields can hold up to 255 characters.
The List & Label field names are based on the Access table and field names. The Access naming restrictions cause the special character substitutions and truncations described in the Name Details section.