How to update pipe start invert & pipe end invert elevation on pipe network from excel

Civil 3D
, , , ,
1

Hi,
How to update pipe network (Pipe start invert & Pipe end invert elevation) from excel when i have reference pipe name match in excel and civil 3d ?
Hope anyone test this by python or dynamo

Attached example civil file (3 pipes) and excel with updated invert start and invert end

Drawing1.dwg (989.8 KB

Worksheet.xlsx (8.6 KB)

image
image1362Ă—544 26.3 KB

2

You can change the pipe elevations using Pipe.SetStartInvert and Pipe.SetEndInvert nodes.

C3D_SetPipeInvertFromExcel
C3D_SetPipeInvertFromExcel2986Ă—782 244 KB

C3D_SetPipeInvertFromExcel.dyn (31.2 KB)

3

Thank you ISECnico, It has been successfully working
another question, i added also pipe diameter on excel if it can be done please update the .dyn

Worksheet-01.xlsx (8.6 KB)

4

@mabdelwahedHMVM8, you are welcome! :smiley:

On this forum, we try to encourage a DIY (do it yourself) attitude to problem solving. I think you should look for the Pipe.Resize node and see if you can improve the graph yourself. Good luck and feel free to post again if you have issues. :four_leaf_clover:

5

You could try to utilise “Pipe.Resize” node that may be able to help but do watch out that it may choose the incorrect part type(eg concrete instead of PVC)

Or a better one is to use “Pipe.Swap” and input the right part size and family name into it

6

image
image1014Ă—605 103 KB

7

i downloaded this workspace and a lot of the nodes are dummy nodes. why is that?

8

You’re likely missing a package or in the wrong context (i.e.Dynamo for Revit instead of Dynamo for Civil 3D)