topic Re: Map 3d Export to .csv in AutoCAD Map 3D Forum

Map 3d Export to .csv

townest — Wed, 17 Oct 2018 18:13:32 GMT

Greetings,

I have been using the Data Table > Select All > Export (to .csv) for data exports. The column names* are noticeable absent using this technique. Is there a better method?

Thank you,

Tyler T.

*some people/software refer to columns names as fields or headers.

Re: Map 3d Export to .csv

kajar — Thu, 25 Oct 2018 18:24:09 GMT

Export from Data table removes headers.

There are no good alternative ways to do it.

One workaround for point features.

When you have point data, then you can use Mapimport and import point features as blocks, feature datafields will be imported as block attributes, when you use predefined block(attribute name must be same name like point feature attributes).

Then next step you can use DATAEXTRACT which export data to excel(with headers).

Kajar

Re: Map 3d Export to .csv

ChicagoLooper — Fri, 26 Oct 2018 00:04:37 GMT

Who says you can't do this? Of course you can

If you are trying to cut-and-paste using the shapefile's table view then only the cells will be copied, while the column headers won't be. Try as you might, you it's not possible from M3D/C3D. The way to do it is through Excel. From Excel, go to FILE=>Open=>Then browse to the shapefiles's dbf, not the shp, the dbf, double click to open. Be sure to change show 'All Files (*.*)' beforehand or you may not see the dbf when you're browsing.

From Excel, browse to and open the dbf. Change 'Files of Type, to All Files (*.*)

Once it's you have it open in Excel, perform a Save As and save it using the format (file extension) of your choice. The headers will now be part of the xlsx file. All of this done even without copying and pasting.

Re: Map 3d Export to .csv

parkr4st — Sat, 27 Oct 2018 12:41:20 GMT

and if it is .sdf data?

Re: Map 3d Export to .csv

АлексЮстасу — Sat, 27 Oct 2018 13:05:46 GMT

If you export from dwg+OD, you can export to csv with the ODEDIT_EXPL command from the new version of ODEDIT.
The names of the columns are created from the OD fields names.

Re: Map 3d Export to .csv

ChicagoLooper — Sat, 27 Oct 2018 15:30:55 GMT

@parkr4st wrote:
and if it is .sdf data?

The spreadsheet can be generated form either an sdf or shapefile.

Obviously the dbf file only exists for the shapefile, not for an sdf. You can easily pull out an Excel file that mimics a shapefile's dbf but can you pull one out from an sdf? The Reader's Digest answer is no because the sdf doesn't have a dbf file, however, that doesn't necessarily mean the sdf doesn't have easily extractable data, it just means the data has to be accessed in another way, from a different angle. This is the angle I came up with (I'm sure someone else can come up with an alternative).

Use MAPIMPORT to import the sdf as AutoCAD entities. Make sure to bring in the object data during this process.

Then use MAPDWGTOSDF command to export the drawing entities. At the beginning of that command, change Files of Type to ESRI Shapefile (*.shp). Unlike exporting to an sdf file where you can export any combination of points, lines and polygons, exporting to a shapefile is limited to only one type. You could conceivably run export-to-shapefile three times by running the procedure separately for points, lines and polygons. Once you've exported to shapefile you'll have a dbf that can be opened from Excel.

On a side note, I'd like to know why the OP needs, or wants, to pull out a csv with headers. Whatever the reason, there's probably a better way to do whatever he's trying to accomplish without jumping through all these hoops. The OP seems to be focusing on his workflow when his workflow may not be considered best practice.

Re: Map 3d Export to .csv

townest — Fri, 02 Nov 2018 19:01:00 GMT

Bottom line is AutoDesk thought of exporting snapshots (with Export button on the Data Table) SDF data, if necessary for any reason, but clearly missed the headers.