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
Solved! Go to Solution.
Solved by braudpat. Go to Solution.
Solved by braudpat. Go to Solution.
Solved by braudpat. Go to Solution.
Solved by antoniovinci. Go to Solution.
Solved by antoniovinci. Go to Solution.
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.
thanks because I didn't understand a word you just said 🙂
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.
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?
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 ...
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.
wow, thanks so much! this is exactly what I need ... and the "how to" would be great, thanks!
In Autocad Map:
In Qgis:
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 !
Patrice BRAUD
Hello Antonio
At your order !
This beautiful VLisp "EXPORT-TEXT" routine is from (gile) ! ... Thks Gilles !!
Patrice BRAUD
Merci beaucoup, mais... it doesn't work in my old Map2006 😞
Cambronne !!
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
Patrice BRAUD
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..!
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 !!
Patrice BRAUD
Sorry for this most rudimentary question but how do I load and then run this program in AutoCad Map 3D 2015?
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 ...
Patrice BRAUD
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?