topic Re: Exporting points points to a CSV file error in Civil 3D Forum

Exporting points points to a CSV file error

D_Bynum — Tue, 12 Nov 2019 14:57:49 GMT

When exporting points to a CSV file, the attributes in column (F) are over-writing existing attributes in column (K). This just recently started and not sure what is causing this to happen. Any suggestions?

Re: Exporting points points to a CSV file error

Pointdump — Tue, 12 Nov 2019 15:21:18 GMT

More information please.

Dave

Re: Exporting points points to a CSV file error

D_Bynum — Thu, 21 Nov 2019 20:24:40 GMT

More info like what?

Don't know what else to say other than after inserting a CSV file into a DWG and then exporting the points out to a new CSV file, the attributes in column "F" are duplicating themselves (some cases, over-writing existing data) in column "K".

Re: Exporting points points to a CSV file error

Pointdump — Thu, 21 Nov 2019 21:31:18 GMT

Dan,
Please post your drawing and the original CSV file. Another set of eyes on your UDP and Point File Format might catch something you missed.
Dave

Re: Exporting points points to a CSV file error

ChicagoLooper — Fri, 22 Nov 2019 17:34:44 GMT

@D_Bynum wrote:
When exporting points to a CSV file.............

If you want a csv file you can simply copy the point info. Right click All Points and select Edit Points. (Image-1)

1-Right click All Points.

The PANORAMA will appear. Highlight all rows so they're blue, right click then select Copy to Clipboard. (Image-2)

2-Highlight all rows, right click, then copy to clipboard.

Open a blank spreadsheet, highlight cell A1, right click and select PASTE. The clipboard contents will appear in THEIR respective rows and columns. Perform a SAVE AS in csv format.

Re: Exporting points points to a CSV file error

AllenJessup — Fri, 22 Nov 2019 18:48:50 GMT

There are many formats of CSV files. The most common is PNEZD and the longest OOTB. You mention column F and K

PNEZD

ABCDEFGHIJK

You must have a lot of user data or other fields. Anyone trying to help will have to see what kind of data you have and how you've set up the CSV file format for export.

Re: Exporting points points to a CSV file error

cwr-pae — Fri, 22 Nov 2019 20:23:54 GMT

What @AllenJessup , @ChicagoLooper and @Pointdump say. Plus, I see reference to this issue when people add new classifications to the "unclassified" set instead of creating their own new set.

Re: Exporting points points to a CSV file error

lynn_zhang — Thu, 28 Nov 2019 02:17:45 GMT

Hello @D_Bynum ,

Just checking to see if your problem has been solved. Did the response from our experts above help answer your question? If yes, please click on the "Accept as Solution" button in their reply so this helps other users in the community find the solution too. Thanks!

Re: Exporting points points to a CSV file error

D_Bynum — Fri, 06 Dec 2019 13:42:37 GMT

importing points

'insert' ribbon tab / 'points from file'

'importpoints' command line

exporting points

'output' ribbon tab / 'export points'

'exportpoints' command line

compare:

imported point file

exported point file

has you can see, column "F" info is overwriting column "K"

csv files and dwg attached.

Re: Exporting points points to a CSV file error

Pointdump — Fri, 06 Dec 2019 15:15:41 GMT

Dan,
Thanks for posting your drawing and data.
Here's what I see. In your "As Built-ACMP" Point File Format I didn't see any of your "CHKM" User-Defined Property Classifications. When I added them to a "As Built-ACMP_2" Point File Format, all the classifications seem to slot themselves in correctly. Please check the attached drawing and CSV files.

Dave

Re: Exporting points points to a CSV file error

D_Bynum — Fri, 06 Dec 2019 15:29:59 GMT

can not open your attached DWG - newer version. I am using Civil 2017.

Re: Exporting points points to a CSV file error

Pointdump — Fri, 06 Dec 2019 15:40:44 GMT

Dan,
Sorry about that. Unfortunately, I don't have 2017. Please check this attached "EXPORTED_2" CSV file to see if the Export worked from my drawing. And please post a Screen Shot of your "As Built-ACMP" Point File Format. I'm wondering if there are version-specific problems with Point File Formats.
Dave

Re: Exporting points points to a CSV file error

D_Bynum — Fri, 06 Dec 2019 15:49:10 GMT

the file looked ok, except for missing columns 'L,M & N'.

point file format

Re: Exporting points points to a CSV file error

Pointdump — Fri, 06 Dec 2019 16:20:50 GMT

Dan,
I didn't notice those missing columns. OK, so to get L,M, and N you would need to add "ATT7","ATT8", and "ATT9" to your CHKM User-Defined Property Classifications and then add all of those ATT1-9 UDP's to your Point File Format.(Replace those <unused> columns.)

Dave

Re: Exporting points points to a CSV file error

lynn_zhang — Wed, 11 Dec 2019 02:03:10 GMT

Hello @D_Bynum

Just checking to see if you're still having the problem. Did the response from @Pointdump help solve your problem? If yes, please click on the "Accept as Solution" button in his reply so this helps other users in the community find the solution too. Thanks!