topic Re: Object data extraction of Polyline and line to excel(csv,xls,text) in AutoCAD Map 3D Forum

Object data extraction of Polyline and line to excel(csv,xls,text)

Anonymous — Fri, 17 Jan 2020 11:32:22 GMT

Hi all,

Currently I'm facing a challenge that I need to extract OD from p-line and lines which have Object data.

Can you please post your ideas to extract quickly and can we write any LISP for OD extraction.

Please post your suggestions on this.

Many thanks,

Ramesh Ch.

Re: Object data extraction of Polyline and line to excel(csv,xls,text)

Pointdump — Fri, 17 Jan 2020 12:58:40 GMT

Ramesh,
You can use MAPEXPORT to quickly extract OD.

Dave

Re: Object data extraction of Polyline and line to excel(csv,xls,text)

АлексЮстасу — Fri, 17 Jan 2020 13:48:53 GMT

In my opinion, if MAPEXPORT in mif/mid, txt-csv files are immediately obtained.
The mid file contains values from OD, and is actually csv separated by comma.
There is still a way to unload into csv via ODEDIT_EXPL - at once with some common counts.

Re: Object data extraction of Polyline and line to excel(csv,xls,text)

Pointdump — Fri, 17 Jan 2020 14:45:19 GMT

Alexander,
"...MAPEXPORT in mif/mid, txt-csv files are immediately obtained."
Thank you! I learned something new. I had never heard of "mif/mid", so I looked at the file formats in MAPEXPORT. Never noticed those before. Definitely faster than opening a DBF file in Excel.
Dave

Re: Object data extraction of Polyline and line to excel(csv,xls,text)

АлексЮстасу — Fri, 17 Jan 2020 15:13:21 GMT

It's cool!

Through mif/mid is the easiest and fastest way to get csv. And MAPIMPORT capability after changing data in csv (in mid or in mif/mid).

Here almost everyone treats mif/mid without interest, because Mapinfo seems morally obsolete. Therefore, I am already afraid that Autodesk can exclude mif/mid from MAPEXPORT. 🙂

Re: Object data extraction of Polyline and line to excel(csv,xls,text)

Anonymous — Mon, 20 Jan 2020 13:13:24 GMT

Thanks for suggestion,

It worked pretty well and fast as well(mif/mid).

Re: Object data extraction of Polyline and line to excel(csv,xls,text)

Anonymous — Mon, 20 Jan 2020 13:19:59 GMT

Alexander,

I have been using MAPEXPORT often, now i'm using 'mid' file extract which contains values from OD.

It's fast and efficient. Thank you for your update and looking forward to hear from you more like this type of updates.

Re: Object data extraction of Polyline and line to excel(csv,xls,text)

Anonymous — Sun, 31 May 2020 13:07:04 GMT

Hi there,

I have the same issue here. I have some polylines with Object data and I want to extract the info( In reality I have some shape files and I want to bring them in Autocad in a specific block, everything ok for the points but I can manage to do the same way for polylines.)

I have used this mapexport to mid/mif but how do I get this files into excel without an online convertor ?

Thanks a mil

Re: Object data extraction of Polyline and line to excel(csv,xls,text)

АлексЮстасу — Sun, 31 May 2020 13:36:54 GMT

@Anonymous wrote:
... but how do I get this files into excel without an online convertor ?

I'm not sure I understood about "without an online Converter"...

Two Lisp - https://forums.autodesk.com/t5/autocad-map-3d-forum/applications-for-object-data/m-p/9388127#M56631:
1. All_OD2CSV.lsp - export OD to csv,
2. CSV2OD.lsp - imports data from csv into the OD.

And two commands from https://forums.autodesk.com/t5/autocad-map-3d-forum/applications-for-object-data/m-p/9498449#M56959:
1. MAPODOUT,
2. MAPODIN.

And ODEDIT_EXPL from my ODEDIT.

Re: Object data extraction of Polyline and line to excel(csv,xls,text)

ChicagoLooper — Sun, 31 May 2020 19:01:27 GMT

If your source is a shapefile, then do this:

Open Excel.
Go to File=>Open=>Browse=>Select the .'dbf' file of your shapefile (.dbf=database file)=>Open. <<Be sure All Files (*.*) is displayed in the dropdown that's located above open button before you click OPEN.>>
Your Object Data will open in a spreadsheet. Perform Excel editing functions if needed. Save this spreadsheet.