AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Active Member
todor.latev
Posts: 7
Registered: ‎01-22-2010
Message 1 of 5 (1,206 Views)
Accepted Solution

Export SDF to ASCII /or XLS/

1206 Views, 4 Replies
01-02-2013 10:57 AM

Using Civil 3D 2012 x64

 

I have an SDF file which contains point objects with associated data table records

I'm trying to extract the data to xls file /or text file/

Once imported in Map there's the option to view data table, then one can go select all and copy/paste everyhing in excel

This would have been perfect if coordinates were exported too. Alas I end up with a rather useless table

 

Is there a way to convert an SDF file to xls file and preserve all the data records along with the geometry /xyz/ in the process?

 

for something SO BASIC there HAS to be a basic solution

 

Thanks in advance!

----------------------------------------------------------------------
C3D 2015 x64, SP1, Win7 x64, 16Gb RAM

Hi,

 

>> for something SO BASIC there HAS to be a basic solution

If you have not "imported" the SDF, but connected to the SDF, then you can create calculated fields as additional columns to the datatable. Then you can export again (or use copy&paste) to get a XLS including the coordinate-values.

(hope this video is a help, even it's German, if not, let me know)

MapFDO_PointCoord_CalcFields_AN01.gif

- alfred -

*Expert Elite*
Alfred.NESWADBA
Posts: 9,610
Registered: ‎06-29-2007
Message 2 of 5 (1,204 Views)

Re: Export SDF to ASCII /or XLS/

01-02-2013 11:10 AM in reply to: todor.latev

Hi,

 

>> for something SO BASIC there HAS to be a basic solution

If you have not "imported" the SDF, but connected to the SDF, then you can create calculated fields as additional columns to the datatable. Then you can export again (or use copy&paste) to get a XLS including the coordinate-values.

(hope this video is a help, even it's German, if not, let me know)

MapFDO_PointCoord_CalcFields_AN01.gif

- alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Active Member
todor.latev
Posts: 7
Registered: ‎01-22-2010
Message 3 of 5 (1,199 Views)

Re: Export SDF to ASCII /or XLS/

01-02-2013 11:31 AM in reply to: Alfred.NESWADBA

Thanks Alfred, this worked!

Never seizes to amaze me though how simple things like this have to be researched and worked around to accomplish...

BTW - is there a way to use excel as an SDF viewer/editor?

Cheers,
Todor

----------------------------------------------------------------------
C3D 2015 x64, SP1, Win7 x64, 16Gb RAM
*Expert Elite*
Alfred.NESWADBA
Posts: 9,610
Registered: ‎06-29-2007
Message 4 of 5 (1,196 Views)

Re: Export SDF to ASCII /or XLS/

01-02-2013 11:41 AM in reply to: todor.latev

Hi,

 

>> BTW - is there a way to use excel as an SDF viewer/editor?

As Excel is no GIS-tool/has no GIS-functionality, I don't think so.

 

- alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Mentor
olivier.eckmann
Posts: 189
Registered: ‎02-14-2009
Message 5 of 5 (1,185 Views)

Re: Export SDF to ASCII /or XLS/

01-03-2013 12:45 AM in reply to: Alfred.NESWADBA

Hello,

 

you can import SDF with MAPIMPORT command and convert attributes data to OD.

Then you can export to SHP file with MAPEXPORT command. You can export OD AND AutoCAD properties like geometry (X,Y,Z,length, area, rotation...), layer, color... to attributes data

In SHP format, attribute data are stored in DBF file which can be opened and viewed by Excel. But don't modifiy and save back the DBF, because you can damage structure of data.

 

Olivier

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.