Using Dynamo to create surface from CSV point file

[Anonymous]

I was wondering if anyone knows how to create a dynamo script that will create a point group and surface from CSV point file (PNEZD)? It would be great to have a script that would let you pick which CSV file you wanted, pick a name for the point group, and pick a name for the surface.

[Jeew-m]

Hi,

This VIDEO shows how to develop the script. Hope you can do it yourself by looking at it.

Thanks

[samir_rezk · Accepted solution]

Hi @bfieber 

Attached is a Dynamo script you may use to Import a PNEZD Excel Spreadsheet formatted and columenated the same as the below Excel screen capture (note no column headings) I have prepared a short demo screencast for use with Dynamo Player. (note: Dynamo is not able to add Surface Breaklines and Borders at this time!)

 

I encourage you to learn Dynamo, it is a powerful new addition to Civil 3D that greatly simplifies programming for the non programmer. For further learning, be sure to visit the DynamoPrimer as well as many AU Classes available. I presented an AU 2019 Class for Getting started with Dynamo. Also visit the designated Dynamo for Civil 3D Forum to find more Dynamo related help.

Hope this help,

[Anonymous]

Thanks Jeew-m, that routine works.  The only problem is I can't figure out how to choose any csv file to make the surface .  If I name the files exactly like the author of the video, then everything works.  But as soon as I try to select a different csv file, the routine gives me errors and doesn't import the points or create the surface.

[Joe-Bouza]

Hello @Anonymous , @samir_rezk & @Jeew-m  

This looks great and I am sure Dynamo will move into my work flow at some point.  But how is this any more efficient than right clicking the surface tab and adding the point file? 

Pardon the question. I may have missed something.

[itK9Z2E]

thank you 

if i have different description for a lot points in excel file that i want do more point group in same time

how can i do that please?

[nkiakas]

Hi @Joe-Bouza 

It could be more efficient if you have several point files (xls or csv).

For example, if you have 10 files, either you import points 10 times or create one file of points by pasting the other 9 files to the first file.

In Dynamo you consume the same time for one or ten files.

Dynamo is recommended for "heavy" labor repeated tasks.

Regards