topic Re: Importing CSV into Civil 3D in Civil 3D Forum

Importing CSV into Civil 3D

nordfasointernational — Sat, 07 Dec 2024 10:02:11 GMT

Hello,

I have converted my into CSV format but I cannot see them into C3D while importing.

I have been trying agin and again.

Can you help me with that? It is a school project (site grading).

Many thanks

Re: Importing CSV into Civil 3D

chriscowgill7373 — Sat, 07 Dec 2024 13:44:42 GMT

Have a look at this article:
https://www.autodesk.com/support/technical/article/caas/sfdcarticles/sfdcarticles/How-to-import-points-from-Excel-into-Civil-3D.html

From the looks of your formatting, I dont believe that there is a point file format within Civil 3D by default that can read you rpoint file, so you will need to create one. This article provides that information as well.

Re: Importing CSV into Civil 3D

Pointdump — Sat, 07 Dec 2024 19:41:17 GMT

Hi Alif,
Welcome to the Autodesk Forums, and thanks for posting your CSV files. I'm assuming they both contain the same 2174 points.
As @chriscowgill7373 said, there's not an out-of-the-box point file format that will accept your data.(His link is a good one) You'll need to do a little work with Notepad++ or Excel.
Open "Classeur1 CONC2.csv" in NotePad++. Replace all the quote marks with nothing. Re-save.

Because these are Latitudes and Longitudes, you'll need to assign a coordinate system to your drawing. You can use command MAPCSASSIGN to assign UTM84-30N to your drawing.

In Civil 3D, under the Settings Tab >> Point File Formats, right-click and choose "New..." >> User Point File.

Create a Custom Point File Format and import your points.
If you just want to create a surface, you can add the points directly to your surface instead of creating COGO points first.
Dave

Re: Importing CSV into Civil 3D

nordfasointernational — Sun, 08 Dec 2024 01:00:51 GMT

Hi Sir,

Thank you so much for your support.

I still need your help with the grading of the site.

How can I proceed to get the best study?

Regards,

Alif

Re: Importing CSV into Civil 3D

nordfasointernational — Sun, 08 Dec 2024 01:36:22 GMT

I am stucking in here.

Re: Importing CSV into Civil 3D

ChicagoLooper — Sun, 08 Dec 2024 03:42:13 GMT

Hi @nordfasointernational

Ouagadougou, correct?

Your point file named Classeur1 CONC2 .csv is in Lat/Long format, commonly referred to as NEZ (Northing-Easting-Elevation).

You can create a surface in 3-steps:

STEP 1:

Using Excel, edit your point format so you can separate the Northing, Easting, and Elevation to get three (3) columns. Once separated, save this CSV and add '_NEZ' to the end of the file name. There are several csv formats when you save it. Be sure to select the correct csv format like the one shown below.

<Important: Be sure to CLOSE after saving. You can't insert from a CSV file if it remains open.>>

Image-1Image-2Image-3

STEP 2:

Back in Civil3D, enter MAPCSASSIGN on command line. In search box, enter UTM84-30 then select UTM84-30N=>click Assign button.

Image-4

Next, enter MAPIMPORT on command line=>browse to and select the new CSV file. Point file format=NEZ=>Z(Elevation)-Meters. Since the point coordinates in the CSV are Lat/Longs and projected to WGS84, enter the 'Code" LL84.

<<Civil3D will insert your Lat/Long points accurately even though modelspace has an assigned coordinate system of UTM84-30N.>>

Click OK and your points will be displayed in modelspace. Use Zoom command=>Extents to see the points.

Image-5

The points will be inserted as blocks and they'll be spatially accurate. Unfortunately, the blocks will be scaled too big, way waaay too big. You'll need to reduce the scale to X=20, Y=20, and Z=20.

<<FYI, the blocks were inserted using the 3 columns in your CSV file. Initially, those points had northing and easting (Lat and Longs) with units of degrees. The MAPIMPORT command that you used earlier has converted them to units with meters. If you select a single block, you can see Position X, Position Y, and Position Z in the Properties Palette.>>

Image-6

After the scale has been reduced, you can turn ON Bing Hybrid and use the aerial imagery as a basemap.

<<Note: be sure to perform Step-1 correctly. If you don't, you won't be able to turn on Bing imagery.>>

Image-7

STEP 3:

Using Toolspace, right-click 'Surfaces" and create a NEW surface. For the surface definition, use the new Blocks that you just inserted.

Image-8

Re: Importing CSV into Civil 3D

fcernst — Sun, 08 Dec 2024 03:41:57 GMT

No.. use a Civil 3D Point Import workflow as mentioned above.. to leverage Civil 3D..

Re: Importing CSV into Civil 3D

Pointdump — Sun, 08 Dec 2024 08:12:26 GMT

Alif,
Set up your neuveau Point File Format like this, and test it by clicking "Load" and "Parse". And don't forget to put a semicolon in the "Delimited by" box.
Dave

Re: Importing CSV into Civil 3D

Pointdump — Sun, 08 Dec 2024 08:38:22 GMT

Alif,
"grading of the site"
Once you've got your new Point File Format, you can add those points to your surface definition.
Dave

Re: Importing CSV into Civil 3D

ChicagoLooper — Thu, 12 Dec 2024 04:44:21 GMT

@fcernst wrote

OK, if you are offended by the workflow that accurately inserts blocks using Lat/Longs, then you can using this method which continues the previously outlined procedure.

<<Although creating a Lat/long decimal degree formatted CSV is easy for certain users in this Forum, this method offers an alternate way to insert those Lat/Long formatted points. This method accomplishes the end goal of acquiring COGO points without having to create a new point Style.>>

After the blocks have been accurately inserted, convert those offending point blocks to Softdesk points.
Once they're converted to Softdesk format, use the function known as Repalce Softdesk Point Blocks and you'll end up with COGO points.

(view in My Videos)

Re: Importing CSV into Civil 3D

nordfasointernational — Tue, 10 Dec 2024 00:29:50 GMT

My problem remain unsolved. I have tried all the way you show but still.

On my softwre (student version) I don't see the NEZ. See picture.

Ihave even save the file on XYZ But still not working. See attachment

Can you explain how this can be fixed?

Regards

Re: Importing CSV into Civil 3D

nordfasointernational — Tue, 10 Dec 2024 00:31:43 GMT

This is how it showed up since 8h00 AM, I have been wotking on it to find a way. It is 1230 AM

Re: Importing CSV into Civil 3D

ChicagoLooper — Tue, 10 Dec 2024 01:20:01 GMT

Hi @nordfasointernational

If you don’t see NEZ try using YXZ.

Make sure you give your YXZ the projection named LL84 when using it as your input file.

Re: Importing CSV into Civil 3D

Pointdump — Tue, 10 Dec 2024 05:48:35 GMT

Hi Alif,
CSV(Comma Separated Values)
I think the problem you're having is the semicolon delimiter. Change all the semicolons to commas and try again.
Attached.
Dave

Re: Importing CSV into Civil 3D

ChicagoLooper — Tue, 10 Dec 2024 15:20:09 GMT

Hi @nordfasointernational

Don't NOT use PYXZD!

That for format needs 5 columns of data, you only have 3; Lat, Long, and Elevation.

1. Open your CSV using Excel. Highlight Column A. Then do this:

2. Next, do this.

3. You have just created a Comma Delimited CSV file using Excel.

4. Save the new file using CSV (comma delimited) (*csv) format.

Re: Importing CSV into Civil 3D

nordfasointernational — Tue, 10 Dec 2024 21:56:26 GMT

Works perfectly.
Thx

Re: Importing CSV into Civil 3D

nordfasointernational — Tue, 10 Dec 2024 21:57:00 GMT

Works perfectly.
Thx

Re: Importing CSV into Civil 3D

nordfasointernational — Tue, 10 Dec 2024 22:58:22 GMT

I got it.

You are the best Masters ever

Re: Importing CSV into Civil 3D

ChicagoLooper — Thu, 12 Dec 2024 04:46:58 GMT

Hi @nordfasointernational

The reason you can't see the map is due to the coordinate system you've assigned to modelspace.

Open a brand new, clean metric template and MAPCSASSIGN the coordinate system named UTM84-30N (Do not assign LL84!)
Add the CSV point file using MAPIMPORT (FYI, the native coordsys given to the CSV by the original author is LL84.)
Complete the rest of the steps outlined in the previous post.

NOTE:

It's perfectly OK to add points that have LL84 projection when your modelspace has UTM84-30N.

<<The modelspace coordsys doesn't have to be the SAME as the CSV file. The point file and modelspace can have different coordsys because Map3D/Civl3D will transform from one to the other.>>

Re: Importing CSV into Civil 3D

nordfasointernational — Sat, 14 Dec 2024 10:13:27 GMT

Hello,

I am sharing what I have done so far with my site grading project that includes two buildings pad.

Can you see and say what need to be correct?

Regards