Passar para o conteúdo principal

Shapes/Grades/Sizes ASCII Export Column Layout

Tekla PowerFab - Not version-specific Maintenance export export data
Not version-specific
Tekla PowerFab Tekla PowerFab GO
Attachments

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.

PositionColumn NameDescription
1shapeThe shape profile name (e.g., W12X26).
2dimensionStringThe primary dimension string for the shape.
3dimensionStringAlternateThe alternate dimension string, typically the metric equivalent.
4baseWeightA weight value used for specific dimension formats; otherwise ignored.
5unitWeightThe weight per unit of length (e.g., lbs/ft).
6xSectionalAreaThe cross-sectional area of the shape.
7depthThe overall depth of the shape.
8flangeWidthThe width of the flange.
9flangeThicknessThe thickness of the flange.
10webThicknessThe thickness of the web.
11kDistanceA stored property with no functional effect in the system.
12adjustedKA stored property with no functional effect in the system.
13usualGageThe standard gauge distance for bolt holes.
14secondaryGageThe secondary gauge distance, if applicable.
15axisXXSThe plastic section modulus about the X-X axis.
16insideDiameterThe inside diameter for hollow sections.
17outsideDiameterThe outside diameter for hollow sections.
18wallThicknessThe wall thickness for hollow sections.
19calcRevaluationThe calculation setting for revaluation.
20revaluationLength1The first length threshold for price revaluation.
21revaluationLength2The second length threshold for price revaluation.
22revaluationLength3The third length threshold for price revaluation.
23revaluationPrice1The price associated with the first revaluation length.
24revaluationPrice2The price associated with the second revaluation length.
25revaluationPrice3The price associated with the third revaluation length.
26chargeLengthThe length used for charging purposes.
27calcScrapThe calculation setting for scrap.
28scrapLengthThe length of scrap produced.
29scrapPriceThe price of scrap.
30kerfThe width of material removed by a cutting process.
31kerfRipCutThe kerf value for rip cuts.
32kerfCrossCutThe kerf value for cross cuts.
33kerfInternalCutThe kerf value for internal cuts.
34trimLeadingWidthThe trim allowance for the leading edge (width).
35trimLeadingLengthThe trim allowance for the leading edge (length).
36trimTrailingWidthThe trim allowance for the trailing edge (width).
37trimTrailingLengthThe trim allowance for the trailing edge (length).
38clampAllowanceFromPartThe clamping allowance measured from the part.
39validCombiningScrapPercentageThe valid scrap percentage used for combining.
40metricA boolean flag (0 or 1) to indicate if dimensions are metric.
41firstCutCostThe cost of the first cut.
42firstCutChargeThe charge for the first cut.
43additionalCutCostThe cost for each additional cut.
44additionalCutChargeThe 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.

Image
S-G-S-L-4 x 4 x 0.25"

 

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.

Image
S-G-S Dimensions - C - 3x3.5

 

This example shows the properties for a Wide Flange 16 x 26 style shape.

Image
S-G-S Dimensions - W - 16x26 - Numbered

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".

Image
S-G-S Dimensions - HSS - 4x4x0.25 - Numbered - R1

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").

Image
S-G-S Dimensions - PL - 0.500 - Numbered

Round Bar (ROD)

This diagram illustrates the properties for a Round Bar 13/16"

 

Image
S-G-S-RD-0.75

Pipe (PIPE)

This diagram illustrates the properties for a Pipe 6" Schedule 40.

Image
S-G-S Dimensions - PIPE - 6 STD - Numbered

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.

Image
S-G-S Dimensions - W - Global Edit - Numbered

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
Enviar

Table of Contents