Create drainage pipe network from excel data

Packages
1

Hi, was wondering if Dynamo can create a pipe network from excel data (attached). The data looks like this:
<table width=“754”>
<tbody>
<tr>
<td width=“64”>XCoord</td>
<td width=“64”>YCoord</td>
<td width=“64”>ZCoord</td>
<td width=“64”>StrNumber</td>
<td width=“76”>Type</td>
<td width=“64”>Owner</td>
<td width=“71”>Description</td>
<td width=“98”>Diameter_Width</td>
<td width=“42”>Height</td>
<td width=“83”>z Justification</td>
<td width=“64”>Thickness</td>
</tr>
<tr>
<td>4087.198</td>
<td>2459.792</td>
<td>5.393</td>
<td>1</td>
<td>Drainage UG</td>
<td>MCC</td>
<td>Box Culvert</td>
<td>2.2</td>
<td>1.3</td>
<td>Bottom</td>
<td>0.1</td>
</tr>
<tr>
<td>4099.064</td>
<td>2499.548</td>
<td>5.79</td>
<td>1</td>
<td>Drainage UG</td>
<td>MCC</td>
<td>Box Culvert</td>
<td>2.2</td>
<td>1.3</td>
<td>Bottom</td>
<td>0.1</td>
</tr>
<tr>
<td>4099.064</td>
<td>2499.548</td>
<td>5.79</td>
<td>1</td>
<td>Drainage UG</td>
<td>MCC</td>
<td>Box Culvert</td>
<td>2.2</td>
<td>1.3</td>
<td>Bottom</td>
<td>0.1</td>
</tr>
<tr>
<td>3999.22</td>
<td>2757.101</td>
<td>8.435</td>
<td>1</td>
<td>Drainage UG</td>
<td>MCC</td>
<td>Box Culvert</td>
<td>2.2</td>
<td>1.3</td>
<td>Bottom</td>
<td>0.1</td>
</tr>
<tr>
<td>321035.3</td>
<td>5812591</td>
<td>5.2</td>
<td>2</td>
<td>Drainage UG</td>
<td>MCC</td>
<td>Pipe</td>
<td>1.2</td>
<td> -</td>
<td>Bottom</td>
<td>0.1</td>
</tr>
<tr>
<td>320996.9</td>
<td>5812691</td>
<td>5.3</td>
<td>2</td>
<td>Drainage UG</td>
<td>MCC</td>
<td>Pipe</td>
<td>1.2</td>
<td> -</td>
<td>Bottom</td>
<td>0.1</td>
</tr>
</tbody>
</table>
I would very much appreciate your help.

DRAINAGE_OP1_Revit

Regards,

Chris

2

And I cant edit my post (delete the table) for some reason.

3

Hi Chris,

could you elaborate? Are the points in the file connected to each other? Or is it more element based, like a Box culvert component with centerpoint at X,Y,Z?

4

Thanks Jostein,

The xyz represent the centreline of a box culvert. z represents the bottom of it. The StrNumber represents the culvert. ie in this case there are 2 culverts, 1 is defined by 4 centreline points, 2 is represented by 2 centreline points.

5

I know this is an old post, but I’m having a similar problem trying to create a pipe network.
I’ve made an adaptive component family for my pipe but when I try and run it in my Dynamo script, I get errors trying to set parameters for my pipe size which is being read from my excel sheet. See Pipe2.png. It creates the network with correct coordinates which is a start.
If I change the node from adaptiveComponent.bypoints to familyinstance.bypoint the pipe sizes change to the spreadsheet but the pipes don’t use the coordinates, they just lie on top of one another. See Pipe1.png.
Any help would be appreciated as this is my first script I’m trying to write from scratch.
Ade

image
image1663×848 95.4 KB

image
image1842×931 117 KB

6

Hi, could you expand the data coming from your List.Clean node. I think that would help alot.

7

HI jostein_olsen, sorry for the late reply as been busy working on other problems, so I had put this on the back burner as they say.
However, I just tried my script today and it works :slight_smile: I know have varying pipe sizes being read from Excel.

PipesVary
PipesVary1069×412 7.13 KB