Import Data CSV

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.