Not able to import my CSV file in civil 3d

[ce21b020APBPZ]

I saved my data in .csv format from excel. It looks like it's formatted correctly but, when I Import Points from the file into Civil 3D, it keeps telling me "No point file format match found". It should be a standard PNEZD Comma Delimited format. I have checked the csv file in excel and notepad looking for errors, but it looks fine. I'm uploading the csv file here if anyone can find what`s wrong.

[Pointdump · Accepted solution]

Hi Kalyan,
You have 7 columns of data. After creating 2 User Defined Properties you'll need to create a custom point file format, maybe something like Name,Northing,Easting,Elevation,UDP Start Depth,UDP End Depth,Description. And at the first of line 1 of your CSV add "#" so that line will be ignored on import.
Drawing and CSV attached so you can see how to set up User Defined Properties and the custom Point File Format.
Dave

[ce21b020APBPZ]

Thank you so much for the reply and solution sir. And thankyou for sending the corrected files.

[ce21b020APBPZ]

Sir I tried as you said. But, again it's not working. Can you check that?

I'm sending the image.

[Pointdump · Accepted solution]

Hi Kalyan,
Did you add "#" to the beginning of the first line of your CSV? That comment tag tells Civil 3D to ignore the first line. You can also just delete the first line, but I like to keep it, as it describes your data.
Use the Load and Parse buttons to check the Point File Format. Send another screen shot if that doesn't work.
Dave

[ce21b020APBPZ]

Sir, I used # and I also used the file that you have sent. I also used load and parse too. After clicking Ok, it's there in the filters but it's not accepting the csv file.

[Pointdump]

Kalyan,
Screen shot please of where things go wrong. A video would help.
Dave

[ce21b020APBPZ]

Sorry sir for late reply. I have some college submissions. Maybe the way I import is wrong. If you don't mind, can you send me a video of importing properly?
Thanking you.

[ce21b020APBPZ]

Sorry sir, for late reply. Once check this video.

Thank you.

[Pointdump]

Kalyan,

Thanks for the video.
You did everything right creating the User Defined Properties and the custom Point File Format. Try saving the drawing, closing, then re-opening.

Edit: Post your latest drawing and I can check it.
Dave

[ce21b020APBPZ]

I tried again sir. Now it's working.

Thank you so much sir.

[ce21b020APBPZ]

Sir, can you help me with creating and visualizing the strata surfaces with the borehole data in Civil 3D?

[Pointdump · Accepted solution]

Kalyan,
Good to hear it's working now for you.
For the borehole strata, you'll want to post a separate question on that. I haven't much used the Geotechnical Module, but several people on this forum have.
Dave

[ce21b020APBPZ]

Thank you so much for the help sir.