Point elevation issue, CSV File

Point elevation issue, CSV File

rainmanoliver1
Advocate Advocate
1,844 Views
9 Replies
Message 1 of 10

Point elevation issue, CSV File

rainmanoliver1
Advocate
Advocate

Hi All, 

Having an issue with points. When I insert points from a CSV file into C3D 2019 the point elevation displayed in the point label and listed in properties does not match the elevation in the CSV file. 

 

The points came in at the correct location and with the correct numbering so I know I did not screw up the file format selection (PNEZD) 

 

Any ideas?

TIA

rC

0 Likes
1,845 Views
9 Replies
Replies (9)
Message 2 of 10

Anonymous
Not applicable

Can you Attach the CSV. file.

IF you change it to txt  . is the issue solve?

0 Likes
Message 3 of 10

ChicagoLooper
Mentor
Mentor

If you are using PNEZD format (Point Number, Easting, Northing, Elevation, Description) and your file has .csv extension, then the Preview Window will show the appropriate values in their respective columns (see image below). If the elevation is not consistent with your csv file, then the Preview Window will also display an error.

 

If your csv file is formatted as PNEZD, then the Z-value will be displayed.If your csv file is formatted as PNEZD, then the Z-value will be displayed.

If you are still getting errors, then open a new drawing using the template named '_AutoCAD Civil 3D (Imperial/Metric) NCS.dwt' and try again.

Chicagolooper

EESignature

0 Likes
Message 4 of 10

rainmanoliver1
Advocate
Advocate

Thanks for the reply. 

What if the point elevations show up correct in the "Import Points" box, but once inserted the elevations are incorrect?

0 Likes
Message 5 of 10

Anonymous
Not applicable

May be you have modification in your settings  ,, so Try another template.

 

0 Likes
Message 6 of 10

Pointdump
Consultant
Consultant

Rene,
"...the point elevation displayed in the point label and listed in properties does not match the elevation in the CSV file."
Please elaborate on what does not match. A screen shot of your point's label and the Properties Window would be helpful.
Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2025
0 Likes
Message 7 of 10

ChicagoLooper
Mentor
Mentor

Unfortunately you are not providing enough information and the little information you are revealing is too vague. 

 

For a test, I have put together a PNEZD csv file  for import. I have deliberately tried to ‘screw it up’ in an effort to get inaccurate elevations. Given the ‘Import Points’ dialog window and the csv file format, I can’t replicate your situation that shows incorrect elevations. 

 

Your bad elevations could be many things: your template, your point file settings, your csv file or something else altogether. 

 

Please upload your csv (or about 6 lines of it) for further analysis. 

Chicagolooper

EESignature

0 Likes
Message 8 of 10

skater_sandoval
Community Visitor
Community Visitor

So, i found a solution to your issue, in Toolspace palette, go to Settings tab, then on your drawing's name, right click and select "edit drawing settings", a window will appear, in the Units and Zone tab, check the drawing units (meters) or (feet), depending what measure system you are using, select the correct unit and click apply and ok, wait to the drawing to refresh or do it manually with de "regen" command. Now check your elevation point. I used (meter) as my drawing unit and it worked.

Message 9 of 10

Nestorpalma.ues
Explorer
Explorer
That is what i'm seeing also. The Preview windows was the Northing, Easting and Elevation correct. I have a new drawing with no CRS defined. Then my points are imported with totally different cooridnates and elevations. In the import window I have unchecked the boxes under 'Advanced options'
0 Likes
Message 10 of 10

Nestorpalma.ues
Explorer
Explorer
Thank you! That was the answer.. I had opened a drawing survey saved by an architect then forwarded to me. The COGO points were part of a survey database. I could not include the points in the drawing. The COGO points lacked the DATA field to belong to a group. I had to be explode the COGO points, then from blocks exploded to mtext, then extracted the data (ENZ) in a csv format from the mtext. However I did not change the units on the drawing importing the points from inches to feet. Once that happened I was able to see them come in with their proper ENZ numbers. Thanks skater_sandoval
0 Likes