Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
Professional CAD/CAM tools built on Inventor and AutoCAD
Any referenced datasets can be downloaded from "Module downloads" in the module overview.
Transcript
00:00
Hello, and welcome to importing and exporting
00:02
data inside Dynamo.
00:04
My name is Stacey Morgan design technology manager
00:08
in this session, we will talk about importing data
00:11
into Dynamo for Seville 3D using an external source like a CSV
00:15
file data lives everywhere.
00:17
And comes in many different formats.
00:19
So it's important to understand how
00:21
data can be imported into Dynamo and ultimately
00:24
your designs in the most efficient and effective way.
00:28
We are now at the first step in the workflow
00:30
importing a CSV file.
00:32
Let's get started by switching over to the applications
00:39
to access Dynamo from the Civil 3D environment.
00:42
I want to go to the Manage tab visual programming panel
00:46
and click on the Dynamo icon.
00:50
Once the Dynamo splash screen opens.
00:52
I'm going to click on New to start a new Dynamo
00:54
graph before I get started by importing data.
00:58
I want to first take a look at the CSV file
01:00
that I'll be importing in this example,
01:03
we are using a point file to demonstrate
01:05
how data is easily imported into Dynamo from an external source.
01:10
Keep in mind, you can use any type of information.
01:12
It does not have to be a point file.
01:15
We can also use information from pipe networks
01:17
personal information.
01:19
Really any type of data you want to import
01:21
from an external source.
01:24
In my CSV file, I have the point numbers
01:26
in the first column, the North things
01:28
the e dings the elevations and then also the descriptions.
01:33
Let's go back to Dynamo and import
01:35
this CSV file to find the node specific to import and export
01:39
data.
01:40
We will be working in the import and export
01:42
category in the Dynamo library.
01:45
We will click to expand this category.
01:48
And in the data subcategory, we will
01:51
expand that to find import CSO.
01:55
We also have the option here to important an Excel file,
01:59
which provides a few more input notes
02:01
than we need at this time.
02:03
So we will stick with the import CSV.
02:05
We're going to left click to add that to our workspace.
02:09
This note is looking for two specific inputs.
02:11
File path as a string and transpose
02:15
set to a Boolean value of true or false.
02:20
We're going to bring in a file path node
02:22
and use that to browse to the CSV file, we have saved.
02:26
There are several ways we can find this node if we right
02:29
click in the workspace.
02:32
The search bar populates we can type and file path
02:35
here and click to enter that node into our workspace.
02:40
We can also search the Dynamo library
02:42
at the very top and type in the same file path.
02:46
We get the same results by hovering over
02:49
this node in the Dynamo library.
02:51
It will show us the input value of none.
02:54
And the output is a string will left.
02:57
Pick to add the file path to our workspace.
03:00
Next, we will click Browse and browse to the CSV file
03:04
that we want to import.
03:08
Once that path is located.
03:10
We can then connect the file path output to the file path
03:14
input on the data import CSV.
03:17
Since the transpose input is looking for a Boolean value,
03:21
we will add the Boolean node to our workspace for now,
03:27
we will set this to false.
03:29
And connect to the transpose input.
03:32
Dial transpose provides the first glimpse
03:36
of how to work with data.
03:37
We just imported.
03:39
Working with lists is fundamental to understanding
03:41
how Dynamo works and transpose is widely
03:43
used to organize data and apply functions to that data.
03:49
Let's add a watch node to the graph.
03:50
So we can see what happens to the data
03:52
when we switch our Boolean value from false to true we'll
03:56
connect the data import CSV to the watch node
03:59
and run our graph with the transpose value set to false.
04:04
Dynamo organizes the data according
04:06
to the columns in the CSV file a total of five less.
04:15
The first list is all of the point numbers.
04:19
The second list is all of the North things, then
04:23
these things the elevations.
04:26
And then lastly, the descriptions
04:31
by setting the transpose value to true.
04:34
And rerunning our graph.
04:36
Notice how our list is now organized
04:38
by the rows in the CSV file.
04:40
Each list contains the point number
04:43
nor thing he's doing elevation and description
04:47
since the intent of our graph is to create
04:49
cogo points from this data.
04:51
We set the transpose value back to false.
04:55
In the next session, we will pass these five lists in order
04:58
to apply the Create cogo points function to this data.
Video transcript
00:00
Hello, and welcome to importing and exporting
00:02
data inside Dynamo.
00:04
My name is Stacey Morgan design technology manager
00:08
in this session, we will talk about importing data
00:11
into Dynamo for Seville 3D using an external source like a CSV
00:15
file data lives everywhere.
00:17
And comes in many different formats.
00:19
So it's important to understand how
00:21
data can be imported into Dynamo and ultimately
00:24
your designs in the most efficient and effective way.
00:28
We are now at the first step in the workflow
00:30
importing a CSV file.
00:32
Let's get started by switching over to the applications
00:39
to access Dynamo from the Civil 3D environment.
00:42
I want to go to the Manage tab visual programming panel
00:46
and click on the Dynamo icon.
00:50
Once the Dynamo splash screen opens.
00:52
I'm going to click on New to start a new Dynamo
00:54
graph before I get started by importing data.
00:58
I want to first take a look at the CSV file
01:00
that I'll be importing in this example,
01:03
we are using a point file to demonstrate
01:05
how data is easily imported into Dynamo from an external source.
01:10
Keep in mind, you can use any type of information.
01:12
It does not have to be a point file.
01:15
We can also use information from pipe networks
01:17
personal information.
01:19
Really any type of data you want to import
01:21
from an external source.
01:24
In my CSV file, I have the point numbers
01:26
in the first column, the North things
01:28
the e dings the elevations and then also the descriptions.
01:33
Let's go back to Dynamo and import
01:35
this CSV file to find the node specific to import and export
01:39
data.
01:40
We will be working in the import and export
01:42
category in the Dynamo library.
01:45
We will click to expand this category.
01:48
And in the data subcategory, we will
01:51
expand that to find import CSO.
01:55
We also have the option here to important an Excel file,
01:59
which provides a few more input notes
02:01
than we need at this time.
02:03
So we will stick with the import CSV.
02:05
We're going to left click to add that to our workspace.
02:09
This note is looking for two specific inputs.
02:11
File path as a string and transpose
02:15
set to a Boolean value of true or false.
02:20
We're going to bring in a file path node
02:22
and use that to browse to the CSV file, we have saved.
02:26
There are several ways we can find this node if we right
02:29
click in the workspace.
02:32
The search bar populates we can type and file path
02:35
here and click to enter that node into our workspace.
02:40
We can also search the Dynamo library
02:42
at the very top and type in the same file path.
02:46
We get the same results by hovering over
02:49
this node in the Dynamo library.
02:51
It will show us the input value of none.
02:54
And the output is a string will left.
02:57
Pick to add the file path to our workspace.
03:00
Next, we will click Browse and browse to the CSV file
03:04
that we want to import.
03:08
Once that path is located.
03:10
We can then connect the file path output to the file path
03:14
input on the data import CSV.
03:17
Since the transpose input is looking for a Boolean value,
03:21
we will add the Boolean node to our workspace for now,
03:27
we will set this to false.
03:29
And connect to the transpose input.
03:32
Dial transpose provides the first glimpse
03:36
of how to work with data.
03:37
We just imported.
03:39
Working with lists is fundamental to understanding
03:41
how Dynamo works and transpose is widely
03:43
used to organize data and apply functions to that data.
03:49
Let's add a watch node to the graph.
03:50
So we can see what happens to the data
03:52
when we switch our Boolean value from false to true we'll
03:56
connect the data import CSV to the watch node
03:59
and run our graph with the transpose value set to false.
04:04
Dynamo organizes the data according
04:06
to the columns in the CSV file a total of five less.
04:15
The first list is all of the point numbers.
04:19
The second list is all of the North things, then
04:23
these things the elevations.
04:26
And then lastly, the descriptions
04:31
by setting the transpose value to true.
04:34
And rerunning our graph.
04:36
Notice how our list is now organized
04:38
by the rows in the CSV file.
04:40
Each list contains the point number
04:43
nor thing he's doing elevation and description
04:47
since the intent of our graph is to create
04:49
cogo points from this data.
04:51
We set the transpose value back to false.
04:55
In the next session, we will pass these five lists in order
04:58
to apply the Create cogo points function to this data.
Try it: Import Data CSV
How to buy
Privacy | Do not sell or share my personal information | Cookie preferences | Report noncompliance | Terms of use | Legal | © 2025 Autodesk Inc. All rights reserved
Sign in to start learning
Sign in for unlimited free access to all learning content.Save your progress
Take assessments
Receive personalized recommendations
May we collect and use your data?
Learn more about the Third Party Services we use and our Privacy Statement. May we collect and use your data to tailor your experience?
Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.