Export Points with DTM attribute

[Anonymous]

I've imported data that contains attributes and the dtm toggle into civil 3d. I've done some corrections and rotated this data set and was looking to re export the points. When I go to export these points (using the proper point file format that contains the DTM-CDF attribute) the DTM Yes/No toggle does not show up in my csv file. Looking at the individual points in civil it has the yes/no toggle attribute for the DTM-CDF so it was also imported correctly.

Anyone has any experience with this and have found a solution? I'm using Civil3D 2017.

Thanks

[Mike.M.Carlson]

Hello,

Are you referring to cogo points or ACAD points created from a .shp file via the MAPIMPORT command with Object Data created?  If they're cogo points, I assume you created a User Defined Property Classification (UDP) for the additional columns containing the attribute data?

[Anonymous]

Yes they are cogo points. Yes a UDP was created to import the attributes and it works as intended. Cogo points show up with the DTM attribute and any other additional information from the time of survey. It's just when you go you reexport these points into a csv file that it strips away the DTM-CDF attribute. The other attributes show up though.

[Mike.M.Carlson]

Ok thanks for the clarification.  If you send to me (I can try with C3D18 or 19) to see if it is a version issue?    

The other option to consider is to export your dwg with the cogo points/UDPs to SDF and reimport the .sdf into a fresh dwg via MAP3DCONNECT....Hopefully the UDP attributes will go along with .sdf so you can create Object data with the UDP attributes upon import.  Then you can just open the attribute table and copy records to excel.  

**Edit.  You have to calculate three new fields in the Table though to show the point X Y Z data in the attribute table before copying to excel, but that's easy.

[Anonymous]

What files are you specifically looking for? Just the original csv file? All the file UDPs are baked into the template we use and the points are all sitting in a survey database.

[Mike.M.Carlson]

just send the dwg with the points and I will try to export with the point file format you used for import (that has the UDPs).

[Anonymous]

Here's a copy of the base drawing i'm using. Let me know if this works for you or if i need to zip up the survey database folders as well.

[Mike.M.Carlson]

Thanks, which Point Group are you interested in?  Or All?

[Mike.M.Carlson]

I just exported from the "All Points" Point Group and it worked for me in C3D18.  Looks like you set up your UDP and point file formats correctly...must be a bug in your version.  I hope the attached file helps.

[Anonymous]

It exported the other attributes but not the DTM-CDF Y/N toggle. I've attached the original file that was imported and it has the DTM toggle.

I know i can always just copy and paste this column into my exported file but that's a workaround a problem not a solution.

[Mike.M.Carlson]

Try to change the "DTM-CDF" UDP from String to Boolean as shown in pic below:

[Anonymous]

I've found the user-defined property classsification with the different Attributes 1-5 and the DTM-CDF but it does not allow me to edit the format to boolean.

[Mike.M.Carlson]

This is because you used Survey Database to insert the drawings with UDP.  Not a big deal, but it limits you (by design).  

Do a quick test first in a new dwg with a new UDP group as you had before, but with Boolean type specified for that one you're having trouble with.  Then update your point file format in that dwg to point to the revised UDPs.  Then import that .csv you used to import into your Survey database.  Verify that the UDP attributes come in and try to export some points (using correct point file format) to see if all UDP attributes goes over. 

If it works, then you will have to create a new UDP group like above in the current dwg you have, but with boolean type for the problem one and update the custom point file formats to the specify the updated UDPs.  Then I would remove all points from the drawing via Survey Database.  Then Reimport the Survey event points into the Survey database via the external point csv file again (using the new point file format now in drawing).  Insert points into drawing, verify Survey Database UDPs are there and try to export.    

[GTVic]

We also have a UPD called DTM-CDF, not sure of the origin of that name?

I created another UDP called DTM-CDF2 as boolean and another called GTT, also boolean. Columns DTM-CDF and DTM-CDF2 will not export but ATT1, ATT2, GTT, etc. will export.

My opinion is that it simply won't export when the UDP name has a dash in it.