[note] Workflow of SAP2000 to Revit via Dynamo

Before DynamoSAP from CORE Studio update to 1.0,
you can try this workflow to import structural design data from SAP2000.

In SAP2000
1. Display → Show Tables.

2. choose Joint Coordinates, Object Connectivity in Connectivity Data, and Frame Item Assignments in Frame Assignments, then click OK.

3. File → Export All Tables → To Excel to export those 3 tables to Excel spreadsheets.

In Excel
the only step in Excel, is to manage those 3 spreadsheets
to the following data to fit the format of Tekla Report:
[0] Section Type Name  [1] Frame Number
[2,3,4] Start Point_X, Y, Z  [5,6,7] End Point_X, Y, Z
[8, 9] Height, Width  [10] Design Profile Section  [11] GUID

though you can manage these data either in Excel or in Dynamo,

in this post, the design data will all be managed via Dynamo Studio.

In Dynamo

1. Excel.ReadFromFIle to read spreadsheet data of SAP2000
List.RemoveItemAtIndex to remove Title and Header row
List.Transpose to exchange row and column data for Dynamo List use
List.GetItemAtIndex to take necessary data list

2. List.GetItemAtIndex to sort Name(temporary), Number, Design Section, GUID data from the first and the second list we just managed before

3. List.GetItemAtIndex to take Joints' Number data from the first managed list and take the Points' Coordinates data from the third managed list 
String.ToNumber to convert SAP2000’s string data to numbers
List.GetItemAtIndex again to get Start_X, Y, Z and End_X, Y, Z data

4. List.GetItemAtIndex to take Design Section data
from the Second managed list
String.Replace / String Split to remove the string “W”,  
and split Width and Height data by the string "X".
List.Transpose to exchange row and column data
String.ToNumber to convert SAP2000’s string data to numbers
List.GetItemAtIndex again to get Height and Width data

4-1. if the Name Data were not been separated to Column and Beam,
use this nodes to filter and create a new Name list
Formula if (start_X=end_X && start_Y = end_Y, true, false);
List.FilterByBoolMask to filter  Name List from step 2
then add suffix “_C” for Column or “_B” for Beam to Element's Name

5. List.Create to link all collected data together from step. 2 ~ 4
List.Transpose to exchange row and column data back to Excel format
List.AddItemToFront to add Header row back for Excel recognize 

6. Excel.WriteToFile to export new Excel file for further use

Now you get the managed structural design data just as the one made from Tekla Report, you can then use the same workflow of the TeklaList Custom Nodes in the previous post to create Structural Elements in Revit.

Workflow of Tekla 2016 to Revit using Dynamo


Dynamo sample file download link:
Dropbox share