Introduction

00:01

Welcome to Importing and Exporting Data

00:02

Inside Dynamo for Civil 3D.

00:04

My name is Stacy Morykin, Design Technology Manager.

00:08

Importing and exporting data saves time

00:10

and eliminates manual uploads, by allowing users

00:13

to seamlessly integrate data from third-party data sources,

00:17

and also extract that data from Dynamo for use

00:20

by other systems.

00:22

Course overview-- this course covers four objectives,

00:25

starting with importing data from an external source,

00:29

like a CSV file.

00:31

Data lives everywhere and comes in many different formats.

00:34

This lesson showcases importing a CSV file

00:37

containing Coggle point information,

00:40

and provides the first glimpse at how

00:42

organizing data upon import can impact functions

00:45

applied throughout the graph.

00:48

We will then parse the information imported,

00:50

using two different methods--

00:52

available nodes in the Dynamo library and a customized code

00:56

block.

00:57

The pros and cons of each method are also discussed.

01:01

In the third lesson, list nodes to organize data is reviewed.

01:05

We will separate data into individual lists,

01:08

combine several lists into one, and transpose

01:12

in preparation for exporting.

01:16

Lastly, we will export the organized data to an Excel

01:19

spreadsheet, using the node.

01:21

Each input port of this node is discussed at length,

01:24

with tips and tricks discovered during the process.

01:28

The final product in Excel format

01:30

can then be utilized by other systems.

01:34

The individual lessons in this workflow are as follows.

01:37

We will first import a CSV file containing point data.

01:41

We'll parse that imported data to apply functions.

01:45

We'll organize data in preparation

01:47

for exporting, and finally exporting

01:50

that data to an Excel document.

01:53

Follow along with me, as we begin this course

01:55

on importing and exporting data inside Dynamo for Civil 3D.

Video transcript

00:01

Welcome to Importing and Exporting Data

00:02

Inside Dynamo for Civil 3D.

00:04

My name is Stacy Morykin, Design Technology Manager.

00:08

Importing and exporting data saves time

00:10

and eliminates manual uploads, by allowing users

00:13

to seamlessly integrate data from third-party data sources,

00:17

and also extract that data from Dynamo for use

00:20

by other systems.

00:22

Course overview-- this course covers four objectives,

00:25

starting with importing data from an external source,

00:29

like a CSV file.

00:31

Data lives everywhere and comes in many different formats.

00:34

This lesson showcases importing a CSV file

00:37

containing Coggle point information,

00:40

and provides the first glimpse at how

00:42

organizing data upon import can impact functions

00:45

applied throughout the graph.

00:48

We will then parse the information imported,

00:50

using two different methods--

00:52

available nodes in the Dynamo library and a customized code

00:56

block.

00:57

The pros and cons of each method are also discussed.

01:01

In the third lesson, list nodes to organize data is reviewed.

01:05

We will separate data into individual lists,

01:08

combine several lists into one, and transpose

01:12

in preparation for exporting.

01:16

Lastly, we will export the organized data to an Excel

01:19

spreadsheet, using the node.

01:21

Each input port of this node is discussed at length,

01:24

with tips and tricks discovered during the process.

01:28

The final product in Excel format

01:30

can then be utilized by other systems.

01:34

The individual lessons in this workflow are as follows.

01:37

We will first import a CSV file containing point data.

01:41

We'll parse that imported data to apply functions.

01:45

We'll organize data in preparation

01:47

for exporting, and finally exporting

01:50

that data to an Excel document.

01:53

Follow along with me, as we begin this course

01:55

on importing and exporting data inside Dynamo for Civil 3D.

Was this information helpful?