topic Re: Convert Civil 3D pipe network data to Property Set Data in Civil 3D Forum

Convert Civil 3D pipe network data to Property Set Data

Anonymous — Thu, 12 Nov 2020 08:18:42 GMT

I need help,

am using civil 3D 2020 version

I create a property set Data for my project to show the Pipe type & Pipe Zone & Pipe Code

First Question: I need to convert these sets to Pipe network Table?

Second Question: I need to export to Excel file?

so, any ideas?

Re: Convert Civil 3D pipe network data to Property Set Data

drazen.galic — Thu, 12 Nov 2020 10:59:44 GMT

Hi @Anonymous

To include PSD in pipe table you have to know some tricks (I found that on www.excitech.co.uk).

So, in my drawing I have some PSD tables as shown on below picture:

For example I have Pipe_data table and I will focus to Status value (in my drawing I have values Good and Bad).

When you create C3D table you have to create new column which will refer to Property set data. The problem is that property set data are not exposed, so you cannot simply insert them from pull-down menu. But, you can in definition part of column content type the next text:

<[PS:Pipe_data:Status]>

In above string PS refers to Property set, Pipe_data to name of table and Status to specific data. When you define your table you have to have something like:

If you do it correctly, you will have the next table:

Best regards,

Drazen Galic

If that post is solution to your problem please press "Accept as solution" button

Re: Convert Civil 3D pipe network data to Property Set Data

Anonymous — Thu, 12 Nov 2020 11:48:25 GMT

OMG, Thank you, Drazen this is exactly what I was looking for

Thank you So much 🤗

Re: Convert Civil 3D pipe network data to Property Set Data

KieronC — Thu, 12 Nov 2020 21:08:18 GMT

Hello,

Regarding your second question..I am not sure if it has been answered. I use the following tool from the Autodesk App Store:

Civil Table Export

https://apps.autodesk.com/CIV3D/en/Detail/Index?id=7594632698699596084&appLang=en&os=Win64

This app allows you to export C3D tables to Excel (.CSV) file forrmat. One tip is to ensure you are using a WCS rather than a UCS at the time of export. Otherwise you can end up with rubbish data in the CSV file.

Another tip....do not have a "split" table. Ensure it is one continuous table when you export

Regards

Kieron

Re: Convert Civil 3D pipe network data to Property Set Data

Anonymous — Sun, 15 Nov 2020 04:59:16 GMT

Thanks Kieron

its work and it is very simple 🤗