topic Re: create surface from points in Civil 3D Forum

create surface from points

alexandru.murariu1989 — Mon, 04 Oct 2021 06:35:42 GMT

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 !

Re: create surface from points

Pointdump — Mon, 04 Oct 2021 06:49:37 GMT

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

Re: create surface from points

alexandru.murariu1989 — Mon, 04 Oct 2021 07:05:27 GMT

ty sir!

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

Re: create surface from points

Pointdump — Mon, 04 Oct 2021 07:11:28 GMT

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

Re: create surface from points

Udo_Huebner — Mon, 04 Oct 2021 07:37:18 GMT

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.

Re: create surface from points

Pointdump — Mon, 04 Oct 2021 07:22:01 GMT

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

Re: create surface from points

alexandru.murariu1989 — Mon, 04 Oct 2021 07:28:28 GMT

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

Re: create surface from points

Pointdump — Mon, 04 Oct 2021 07:35:26 GMT

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

Re: create surface from points

Udo_Huebner — Mon, 04 Oct 2021 07:53:35 GMT

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.

Re: create surface from points

alexandru.murariu1989 — Mon, 04 Oct 2021 07:52:47 GMT

with replace from note pad. exactly as udo_huebner said above

Re: create surface from points

alexandru.murariu1989 — Mon, 04 Oct 2021 07:55:54 GMT

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.

Re: create surface from points

Udo_Huebner — Mon, 04 Oct 2021 08:05:05 GMT

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".