Point insert elevation error

[a.szwyd]

Hi I'm having issues transferring points from one drawing to another, I've exported the points csv format, when I import them on the new drawing, the format is correct and the true elevation is correct in the preview screen, eg the elevation is 35.000 but then the point inserted is showing 0.035 I'm guessing it's a scale or unit issue, any ideas? 

Many thanks 

[Pointdump]

Hi @a.szwyd,
"...the point inserted is showing 0.035..."
The Point Label is showing that? What does it show in Properties? And what are your Drawing Units?
Dave

[ChicagoLooper]

Your best bet would be to look at the exported csv file. The EXPORTED z-value, or elevation, controls what the elevation is upon IMPORT to the new drawing.

Would it be possible to upload the csv? Or an image of that csv that was created when you performed the export?

You may also want to investigate the units in the NEW drawing. Are the units in the new the same as the units in the source drawing?

[a.szwyd]

Hi CSV file attached, and screen shots of the issue elevation at 35.490 on the properties menu, but when i create a feature line or create a point its providing the levels as shown

[Pointdump]

@a.szwyd,
Thanks for posting your CSV. I can't reproduce the problem. Can you post your drawing with the Feature Line?
Dave

[a.szwyd]

Many Thanks drawing attached

[Pointdump]

@a.szwyd,
Here's the problem. In Civil 3D drawing Units should always be either Feet or Meters. Anything else causes trouble.
Dave

[a.szwyd]

Dave,

See attached its throwing out the point elevation & properties once the change is updated.

[ChicagoLooper]

Hi @a.szwyd 

Thank you for the screenshots you uploaded in Post 4. Screenshot 2 shows your elevations in column 2 (second from left). Your elevation data shows a range from a low of 0.035m to a high of 0.052m. Believe it or not, these are the elevations you are 'exporting' so if you 'import' the same elevations into a new drawing, you'll get those values. Be aware, those imported values are less than 1 meter!  

To fix this you can right-click your Point Group (or All Points if you don't have point groups) in Toolspace=>Select Edit Points=>The Panorama will open=>Highlight your points in the Panorama=>right-click and Copy to clipboard=>Paste the contents of the clipboard to Excel then perform Save As in xlsx format.

Adjust your your new xlsx file to PNEZD or PENZD format (you can rearrange columns and delete unnecessary columns while in Excel). Adjust your Z-values by a factor of 1000 (you can use a formula). Save this adjusted file using csv format. Import your points from the new csv. 

[Pointdump]

@a.szwyd,
I can't think of any one-click fix for your drawing's mixed units. If you scale for Z you'll also scale the Northings and Eastings. I'd start over.
Dave

[Wojtek_Garczewski · Accepted solution]

Hi @a.szwyd 

Thank you all for your assistance @Pointdump, @ChicagoLooper. 
Based on the thread (and your data) it looks that experts are correct. The issue is present due to mixed units. 

Drawing is set to millimeters, but it looks that the objects in the drawing were drawn in meters (e.g. width of the road ~5.5mm? I guess it should be 5.5m).

Then when importing CVS with values in meters, all Z values are incorrect. 

I suggest starting over with the correct units set up in dwg.

Thanks,
Wojtek
______________________________________________________________

If any of the above posts answer your question, please click the "Accept as Solution" button. This helps everyone find answers more quickly!