create surface from points

[alexandru.murariu1989]

Hell sir,

i have the following table saved as cvs file. i can't import the points to make the surface, because it doesn't recognize the format. where am i wrong?

Ty !

[Pointdump]

Hi Alexandru,
Your CSV file has some formatting problems:
#Name;#x;#y;#z
673;574.990.385;711.629.265;119.71
691;575.025.266;711.634.457;121.10
703;575.043.269;711.651.261;122.41
728;575.080.530;711.657.077;123.18
743;575.122.189;711.684.350;124.90
You'll need to change those to:
673,574990.385,711629.265,119.71
Dave

[alexandru.murariu1989]

ty sir!

can they change automatically? or does everything have to be done manually?

[Pointdump]

Alexandru,
I don't think there's a way to change the lines easily, either in a word processor or Excel. That's a lot of lines to change manually. Where did you get this file from originally?
Dave

[Udo_Huebner]

You have to remove the additional dot as thousands separator.

This can be done easily with Search & Replace using Notepad.exe or another texteditor.

Replace ";575." with ";575" ";711." with ";711" and so on for 7 times, than your CSV file is prepared for import.

[Pointdump]

Hi Udo,
There are 4800 lines in Alexandru's CSV file. I don't think there's any easy way to Search and Replace.
Dave

[alexandru.murariu1989]

I managed to replace it. I mean I hope I succeeded. I attach the file, is it ok? I still can't import the points

[Pointdump]

Alexandru,
Your new CSV file will work. You just need to change the Semicolon to a Comma or define the Semicolon as a Separator in your Point File Format.
673;574990.385;711629.265;119.71
691;575025.266;711634.457;121.10
703;575043.269;711651.261;122.41
728;575080.530;711657.077;123.18
I've got to know. How did you change it so quickly?
Dave

[Udo_Huebner · Accepted solution]

Depending on your Civil version you have to save your UTF encoded Textfile as ANSI first.

Anyway, if you import my CSV file uploaded above, you will get the following DWG import.

I used point names instead of point numbers for the import, because your text has some point names with letters in the first column. And some point names are used multiple times, I then had Civil replace those names with an automatic name.

[alexandru.murariu1989]

with replace from note pad. exactly as udo_huebner said above

[alexandru.murariu1989]

I didn't understand how you did it. but thank you. maybe you could please make a video to understand if it's not too much trouble.

[Udo_Huebner]

The  Civil Command _IMPORTPOINTS still cannot handle UTF-8 encoded texfiles in recent versions.

To avoid problems, open CSV in Notepad and Save As with Encoding: ANSI  (selectable in SaveAs file dialog)

Finally use  _IMPORTPONTS in Civil 3D.

You will first need to create a suitable point import format for your separator and point names with characters. I have done this in the attached drawing. I have named the point format "NRHZ (comma separated) UH".