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

[Anonymous]

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.

[Pointdump · Accepted solution]

Ramesh,
You can use MAPEXPORT to quickly extract OD.

Dave

[АлексЮстасу · Accepted solution]

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.

[Pointdump]

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

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

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

[Anonymous]

Thanks for suggestion,

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

[Anonymous]

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.

[Anonymous]

 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

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

---

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

[ChicagoLooper]

If your source is a shapefile, then do this:

1.  Open Excel.
2. 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.>>
3. Your Object Data will open in a spreadsheet. Perform Excel editing functions if needed. Save this spreadsheet.