Adding pipe property values from excel_ lisp or dynamo

[QuinnL]

For our plans, we need to show the 5 year and 100 year hgl (hydraulic grade line). Currently, we draft in the storm pipe in Civil 3d and then export it to stormCAD. StormCAD then gives us the HGL values in a excel sheet. We then hard type these values into civil 3d. (Right click pipe, properties, scroll down, and then hard type the HGL values in.) This takes hours if you are designing multiple storm pipes.  Is there anyway (command, lisp, or dynamo) to auto transfer pipe property values from an excel and pasting them into a pipe network in Civil 3d. 

 

Thanks!

-Q

[BIGAL]

Look at Civil Site Design its drainage module does HGL on long sections. Runs with CIV3D or Bricscad.

[Steven P]

if you can save the excel sheet as a comma separated sheet (CSV) this can be read directly as a text file vis a LISP - which is quicker than say the getexcel LISP for reading from an excel file. From there you can use the data as you need to.

 

If you can use something that exists - like BigAl suggests this is probably the best way, if it has been produced, tested and used in the real world then likely that a lot of bugs will be fixed.

 

if that is not viable then we'd need a bit more information i think such as a sample of the excel file, what you need to copy from this and a sample pipe network

[SLW210]

There are also some methods to send it to AutoCAD from Excel with a Macro in Excel not sure if there are any examples sending to a Civil 3D Pipe Network, maybe.

 

From AutoCAD (I don't have Civil 3D should be the same) you can copy the information you want in Excel and Paste Special (there are some options depending on what you want).

 

Like stated, what exactly do you need to transfer into (in other words, what exactly is the information in the pipe network).

 

Lots of info on using Dynamo in Civil 3D for these type tasks.

 

Dynamo Basics for Civil 3D - YouTube

 

Dynamo For Civil 3D: Pipe Network Details from Excel - YouTube

[hosneyalaa]

On 4/6/2023 at 12:16 AM, QuinnL said:

Currently, we draft in the storm pipe in Civil 3d and then export it to stormCAD. StormCAD then gives us the HGL values in a excel sheet

@QuinnL hi

Which version Civil 3d used

Can you attached example drawing and

Example Excel 

It certainly can be done

[QuinnL]

I ended up using dynamo. I pulled some blocks together from different premade dynamo scripts. I will attach my script. 

Pipe_HGLFromExcel.dyn