Exporting Text by layer to an Excel File

[Anonymous]

HI,

I read the post for when this question was previously asked and do not understand it.  I simply need to export all text BY LAYER in my drawing, preferably to a format that I can import into Excel.  What is the easiest way to do this please?  Thanks

[antoniovinci]

Command: _MAPEXPORT

adding the property "LAYER" as Object Data.

Let's suppose you have N layers: if you open the resulting shapefile in a Gis editor (e.g. Qgis) you can automatically split it into N indipendent sub-shapes, by layer, yielding N files .DBF loadable in Excel.

Feel free to upload here a small drawing of yours: I can demonstrate the above technique quickly, sir.

[Anonymous]

thanks because I didn't understand a word you just said 🙂

[antoniovinci]

---

wings1080 wrote:

thanks because I didn't understand a word you just said

---

You're right, man, I apologize for my wretched english 😞

In the attachment, you got the promised N=7 files .DBF, loadable in Excel.

[Anonymous]

THANKS but hmm, I have 61 layers in my drawing, I was hoping you could show me HOW you did this so I can do it in the future, why were there only 7 files that you sent?

[Anonymous]

I guess what I was hoping for was, for example, a list of all the p101, p123, p479 values etc...  in the 2005_probing_completed layer for all layers ...

[antoniovinci · Accepted solution]

Well, your drawing contains pure text in only 7 layers.

The other ones look like text, but they're block attributes.

If you _BURST them, you can get the following attachment: check it out, and if it's good for you, I'll describe how-to.

[Anonymous]

wow, thanks so much!  this is exactly what I need ... and the "how to" would be great, thanks!

[antoniovinci · Accepted solution]

In Autocad Map:

1. command _BURST (in order to explode the embedded block attributes into Dtext objects)
2. command _MAPEXPORT => choose TEXT type => in the Data tab, select LAYER as Properties => save as SHP file

In Qgis:

1. open up the brand new shapefile
2. menu VECTOR => DATA MANAGEMENT TOOLS => SPLIT VECTOR LAYER => UNIQUE ID FIELD => choose LAYER

[Anonymous]

obviously lol 😉  thanks again!

[braudpat · Accepted solution]

Hello from France

An other method with a Lisp/VLisp program that will generate an CSV/XLS file !

So after it's easy to sort by layer, by entities, by value, by anything ...

I use it often because DataExtraction is not always the fastest method to extract Text, MText, Attribute !?

Antonio is the King of MAP + QGIS !

[antoniovinci]

Not bad, Monsieur: would you please share with us your Vlisp..?

[braudpat]

Hello Antonio

At your order !

This beautiful VLisp "EXPORT-TEXT" routine is from (gile) ! ... Thks Gilles !!

[antoniovinci]

Merci beaucoup, mais... it doesn't work in my old Map2006 😞

Cambronne !!

[braudpat]

Hello Antonio

It works on my MAP 2015, 2014, 2013, 2012, 2011, 2010 !

Do you reach the dialog box to specify the output filename ?

If YES, into the filename please write something like :  ANT.TXT

[antoniovinci]

---

braudpat wrote:
If YES, into the filename please write something like :  ANT.TXT 

---

Well done, it works if I manually add the TXT/CSV extension..!

[braudpat]

Hello

YES you MUST write .TXT or .CSV with the filename into the dialog box ...

It's a very small default of this beautiful routine from (gile) !

EXPORT-TEXT works on Texts, MTexts, Attributes . I like it !!

[Anonymous]

Sorry for this most rudimentary question but how do I load and then run this program in AutoCad Map 3D 2015?

[braudpat]

Hello

1) With your keyboard :  APPLOAD  <Enter>

Browse your PC, Select the file "EXPORT-TEXT.lsp" then Load then OK/Close 

2) With your keyboard :  EXPORT-TEXT  <Enter>  

And play ... 

[Anonymous]

thank you, I did as you directed and selected "ALL" and it said 1681 objects selected, I exported the csv file and opened it and this was the result, what did I do wrong?