Shapes/Grades/Sizes ASCII Export Column Layout
The Shapes/Grades/Sizes ASCII export is a powerful tool for extracting shape dimension data into a simple .txt file. This functionality is ideal for migrating data, performing bulk updates, or integrating with external software.
Because the exported file does not contain a header row, this guide provides a complete definition for each column. It also explains how to add a custom header row that the system will recognize as a comment, ensuring your data remains easy to read and manage.
The table below details the specific order and purpose of each data column found in the exported .txt file.
| Position | Column Name | Description |
|---|---|---|
| 1 | shape | The shape profile name (e.g., W12X26). |
| 2 | dimensionString | The primary dimension string for the shape. |
| 3 | dimensionStringAlternate | The alternate dimension string, typically the metric equivalent. |
| 4 | baseWeight | A weight value used for specific dimension formats; otherwise ignored. |
| 5 | unitWeight | The weight per unit of length (e.g., lbs/ft). |
| 6 | xSectionalArea | The cross-sectional area of the shape. |
| 7 | depth | The overall depth of the shape. |
| 8 | flangeWidth | The width of the flange. |
| 9 | flangeThickness | The thickness of the flange. |
| 10 | webThickness | The thickness of the web. |
| 11 | kDistance | A stored property with no functional effect in the system. |
| 12 | adjustedK | A stored property with no functional effect in the system. |
| 13 | usualGage | The standard gauge distance for bolt holes. |
| 14 | secondaryGage | The secondary gauge distance, if applicable. |
| 15 | axisXXS | The plastic section modulus about the X-X axis. |
| 16 | insideDiameter | The inside diameter for hollow sections. |
| 17 | outsideDiameter | The outside diameter for hollow sections. |
| 18 | wallThickness | The wall thickness for hollow sections. |
| 19 | calcRevaluation | The calculation setting for revaluation. |
| 20 | revaluationLength1 | The first length threshold for price revaluation. |
| 21 | revaluationLength2 | The second length threshold for price revaluation. |
| 22 | revaluationLength3 | The third length threshold for price revaluation. |
| 23 | revaluationPrice1 | The price associated with the first revaluation length. |
| 24 | revaluationPrice2 | The price associated with the second revaluation length. |
| 25 | revaluationPrice3 | The price associated with the third revaluation length. |
| 26 | chargeLength | The length used for charging purposes. |
| 27 | calcScrap | The calculation setting for scrap. |
| 28 | scrapLength | The length of scrap produced. |
| 29 | scrapPrice | The price of scrap. |
| 30 | kerf | The width of material removed by a cutting process. |
| 31 | kerfRipCut | The kerf value for rip cuts. |
| 32 | kerfCrossCut | The kerf value for cross cuts. |
| 33 | kerfInternalCut | The kerf value for internal cuts. |
| 34 | trimLeadingWidth | The trim allowance for the leading edge (width). |
| 35 | trimLeadingLength | The trim allowance for the leading edge (length). |
| 36 | trimTrailingWidth | The trim allowance for the trailing edge (width). |
| 37 | trimTrailingLength | The trim allowance for the trailing edge (length). |
| 38 | clampAllowanceFromPart | The clamping allowance measured from the part. |
| 39 | validCombiningScrapPercentage | The valid scrap percentage used for combining. |
| 40 | metric | A boolean flag (0 or 1) to indicate if dimensions are metric. |
| 41 | firstCutCost | The cost of the first cut. |
| 42 | firstCutCharge | The charge for the first cut. |
| 43 | additionalCutCost | The cost for each additional cut. |
| 44 | additionalCutCharge | The charge for each additional cut. |
Dimension Examples
The following diagrams illustrate how key dimensional properties from the table correspond to different Material Groups or Shape Types.
Structural Angles
This example displays the properties for a Structural Angle 4" x 4" x 1/4" style shape.
For these shapes, important properties include Depth, Width, Thickness, and Unit Weight.
Structural Section Shapes (e.g., C, W, S)
This example shows the properties for a Channel 3 x 3.5 style shape.
This example shows the properties for a Wide Flange 16 x 26 style shape.
For these shapes, important properties include Depth, Flange Width, Flange Thickness, Web Thickness, and Unit Weight.
Hollow Structural Section (HSS)
This diagram illustrates the properties for a Hollow Structural Section 4" x 4" x 1/4".
For HSS, key dimensions include Depth, X-Sectional Area, and Wall Thickness.
Plate (PL)
This diagram shows the properties for a Plate 0.500" (or 8/16").
Round Bar (ROD)
This diagram illustrates the properties for a Round Bar 13/16"
Pipe (PIPE)
This diagram illustrates the properties for a Pipe 6" Schedule 40.
For Pipe, key dimensions include Inside & Outside Diameter, Wall Thickness, and Unit Weight
Shapes / Grades / Sizes Global Edit
Editing a group of dimensions simultaneously is often more efficient than modifying them individually. The diagram below illustrates an example of a Global Edit for Wide Flange. Because the Global Edit function can affect a wide variety of materials at once, please proceed with caution and carefully review any alterations.
See also
Find shapes, grades, dimensions, or shape abbreviationsManage shapesManage gradesModify dimension propertiesModify the properties of multiple dimensions
How to Add a Commented Header Row
To make your exported ASCII file easier to read, you can manually insert a header row at the top. The system is designed to ignore this line during import, provided it starts with a specific prefix.
To add a header, open the .txt file and insert a new line at the very beginning. Start this line with ten asterisks followed by a space (********* ). Any text after this prefix will be treated as a header comment.
Header Row Template
You can copy and paste the line below directly into your file. It includes all the column names in the correct order for your reference.
********** shape dimensionString dimensionStringAlternate baseWeight unitWeight xSectionalArea depth flangeWidth flangeThickness webThickness kDistance adjustedK usualGage secondaryGage axisXXS insideDiameter outsideDiameter wallThickness calcRevaluation revaluationLength1 revaluationLength2 revaluationLength3 revaluationPrice1 revaluationPrice2 revaluationPrice3 chargeLength calcScrap scrapLength scrapPrice kerf kerfRipCut kerfCrossCut kerfInternalCut trimLeadingWidth trimLeadingLength trimTrailingWidth trimTrailingLength clampAllowanceFromPart validCombiningScrapPercentage metric firstCutCost firstCutCharge additionalCutCost additionalCutCharge