Transcript U.S. User Case

Tekla Structures User Meeting 2008
Templates
By: Glen Hutchinson
Templates Agenda
• .CSV
• What is .CSV
• Why .CSV
• User Defined Attributes
• Create a .CSV
• Sales Takeoff Example
• Tips and Tricks
What is .CSV?
• Comma-Seperated Values
• CSV is a delimited data format that has
fields/columns separated by the comma
character and records/rows separated
by newlines.
Why .CSV
• Importing Data to Other Systems
• Microsoft Access
• Excel Spreadsheets
• Importing Data to Tekla Structures
• Dates
• Shipping
• Pouring
• Status
• Poured
• Shipped
• Erected
User Defined Attributes
1.
2.
3.
4.
Identify Attributes
Confirm, Default or Custom
Modify Objects.inp
Map New Variables
1.
2.
3.
4.
Identify Attributes
Confirm, Default or Custom
Modify Objects.inp
Map New Variables
Identify Attributes
1.
2.
3.
4.
Identify Attributes
Confirm, Default or Custom
Modify Objects.inp
Map New Variables
Confirm UDA’s
•
•
•
•
•
2Scheduled
ways
• Objects.inp
Cut
Tekla Structures
In• Assembly
UDA’S
Galvanizer
Painted
1.
2.
3.
4.
Identify Attributes
Confirm, Default or Custom
Modify Objects.inp
Map New Variables
Confirm UDA’s
• Look what is already there
1.
2.
3.
4.
Identify Attributes
Confirm, Default or Custom
Modify Objects.inp
Map New Variables
Modify Objects.inp
1.
2.
3.
4.
Identify Attributes
Confirm, Default or Custom
Modify Objects.inp
Map New Variables
• Objects.inp
• C:\TeklaStructures\14.0\environments\
usimp\inp
Modify Objects.inp
attribute or unique_attribute
attribute name
prompt
value types
format
affects numbering
check switch
max value, min value
label and default value
1.
2.
3.
4.
Identify Attributes
Confirm, Default or Custom
Modify Objects.inp
Map New Variables
• Value
Field Format
types
• %s
= String
Float
= Numbers
• %D
= Number
String
= Text
• Option = Lists
• Date = Small Calender
Create Objects.inp
1.
2.
3.
4.
Identify Attributes
Confirm, Default or Custom
Modify Objects.inp
Map New Variables
• Part User Defined Attribute Setup
Program
• Extranet
• Downloads>Extended Applications
Modify Objects.inp
1.
2.
3.
4.
Identify Attributes
Confirm, Default or Custom
Modify Objects.inp
Map New Variables
• When creating these new Attributes
• Great for UDA’s for all Part Types
• Create a different objects.inp for different
Part Types
Map New Variables
1.
2.
3.
4.
Identify Attributes
Confirm, Default or Custom
Modify Objects.inp
Map New Variables
• Import_macro_data_types.dat
• Used in importing attributes
• C:\TeklaStructures\14.0\environments\usimp\system
Creating a .CSV
• Commas to create columns
• Rows are automatically created
Creating a .CSV
• Example
• _Precast_Product_List.rpt
Create a .CSV
Demo
Recap Creating a .CSV
• _Precast_Product_List
• Insert “Commas”
Recap Creating a .CSV
• Save as “.csv.rpt”
Recap Creating a .CSV
• Select report
• Notice .CSV
• Show Report
with associated
viewer
Recap Creating a .CSV
• Save in new location
• Opens Excel automatically
Sales Take Off Process
• Fill in Attributes in Model
Sales Take Off Process
• Produce .CSV Report
• Format if needed
Sales Take Off Process
• Import .csv to existing estimating
products
• Use other .xls templates to get data and
produce an estimate
• Import .csv into Microsoft Access
Template Tips and Tricks
• HTML can be produced out of Tekla.
• Easier approach
• .csv
• Run a Format Macro
• Saveas HTML
Templates Tips and Tricks
• Sort Order, Tree View
• Drag the Attribute
Templates Tips and Tricks
• Summary Rows
• When you want to sum field values on a
summary line rather than output individual
field values each on their own line, you can
easily turn a value field into a summary field.
Templates Tips and Tricks
• Set default text color for new Texts
• Same for steps for Value Fields
Templates Tips and Tricks
• Right Click > Crop
Templates Tips and Tricks
• Use Characters to create lines
•
•
•
•
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
___________________________________
---------------------------------------------------------=================================
Templates Tips and Tricks
• Use the Preview Pane
Templates Tips and Tricks
• Hide Fields in Content Browser
Tips and Tricks
• Show grid location of Cast Units
• CAST_UNIT_POSITION_CODE
Thank You