Map 3d Export to .csv

[townest]

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.

[kajar]

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

[ChicagoLooper]

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.

[parkr4st]

and if it is .sdf data?

[АлексЮстасу]

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.

[ChicagoLooper]

---

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

[townest]

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.