Export object data to excel

[sthompson1021]

I have received a drawing with a block in it that has data attached to it. I can see the data in properties but cannot figure out how to export to excel. I'm new to Map 3D so any help would be appreciated. I've attached a drawing with one of the blocks in it.

[ChicagoLooper · Accepted solution]

Hi @sthompson1021 

Thank you for uploading your block.

BTW, it would be helpful if you could explain WHY you need to export it to excel. I'm guessing you merely need to VIEW the data (you can easily see the data on your monitor) not necessarily see the data sitting in a spreadsheet. As always, the REAL value is gained when you feed data into Map3D, analyze it, then create points, lines and/or polygons to present the data in graphic form such as maps.

If you must create a spreadsheet, create a shapefile first. Unlike plain vanilla entities, a shapefile can, and will, STORE data inside the objects. You can access this STORED data and save it in organized tabular form.

First, use the MAPEXPORT command to create a shapefile. Name the shapefile OD_Block and save if in your project folder. <<FYI, when executing MapExport, all blocks are considered to be POINT objects, no exceptions.>> Next, do this:

1.  On the Selection tab, do this. <<Your drawing only had one block or one building. If you have more than one, you must select ALL the buildings.>>
2. On the Data tab=>Select attributes=>Expand Object Data=>Check the box named Address Points=>OK <<Your Object Data will be captured and displayed in the columns named Source Field and Output Field.>>
3. On Options tab, click OK. <<You didn't have a projection so your shapefile will NOT have geospatial accuracy.>>
4. Go to your project folder=>CLICK-and-DRAG the newly created shapefile named OD_Block from its Windows folder and DROP it directly onto a 'Blank' area of modelspace. Zoom extents to see the point(s) of the new shapefile.
5. Open the Map Task Pane if it's not already open. <<To open it, use MAPWSPACE=>type in 'ON' on the command line.>> On the Display Manager tab of the Task Pane=>highlight OD_Block so it's blue=>Click Table to display Table View=>Highlight ALL rows in the Table=>Options dropdown=>Export to CSV format. <<Name and save this new csv in your project folder. You may now open the csv in Excel and save to xlsx extension.>>

Step-1

Step-2

Step-3

Step-4

Step-5

[braudpat]

Hello @sthompson1021 

1) Thanks for the beautiful answer of Mr @ChicagoLooper 

2) When I want to export ACAD Properties or export OD (Object Data) to CSV Files,

I used a beautiful routine from CADaSchtroumpf / Bruno / Bonuscad - Routine "OD&PROP2CSV"

3) THANKS to @CADaSchtroumpf 

The Health, Bye, Patrice (The Old French EE Froggy)

PS: New US version v1.03A which corrects a bug related to the minimum US/English translation !

.

[sthompson1021]

First off, your directions were perfect. Very easy to follow and worked great. Thank you!

The reason I need to export to excel is that I have to provide address lists for area's we are working in including Lat and Long info. Everything I need is in the object data for the blocks. With this process I can get the lists fairly easily.

Again, thanks for taking the time for walking me thru it.

[sthompson1021]

Hi Pat,

I tried the lisp you attached but I kept getting an error message. I was able to do it with ChicagoLooper's instructions 

so all worked out. Thanks for the reply thou. I have tucked away some of the other lisp routines that you have posted

and they work great.

[BriamR]

@braudpat Thanks for sharing this lisp, I have the OD&PROP2CSV__v100.lsp which works in French but the update you share in US v103 gives me this error,

Select objects:
Selection filtering, choice [Single/All/Manual]<Manual>: A
Add an other filtered selection [Yes/No]? <No>: N
Error: quit / exit abort

is there any more update? thanks again

[braudpat]

Hello @BriamR 

1) We have to say THANKS to @CADaSchtroumpf who is the writer of THIS beautiful french routine

AND MANY others routines on OD for MAP / CIVIL !

2) YES the French routine is OK and the US/English version has a minimum US/English translation !

3) I join again the 2 version : FRench v1.03 = OK and the new US/English v1.03A = OK

Nice WE, The Health, Bye, Pat

[BriamR]

Thanks very much @braudpat 

[braudpat]

Hello @BriamR @sthompson1021 @ChicagoLooper @CADaSchtroumpf 

Into my previous message, you will find a New US version v1.03A which corrects a bug related to my "bad" old minimum US/English translation !

Please let me know if NOW this beautiful routine from CADaSchtroumpf / Bruno / Bonuscad, is OK for you !?

Nice WE, Bye, Pat

[CADaSchtroumpf]

@braudpat 

Bonjour,
Les erreurs de traduction viennent d'(INITGET).

Dans la version Française, on a:
(initget "Unique Tout Manuel _Single All Manual")
Si l'utilisateur tape "unique" ou simplement "u", la clé retourné sera "Single" et non "Unique".
Si tu veux que l'utilisation se fasse uniquement en Anglais, il faut simplement mettre:
(initget "Single All Manual")

Pour une autre langue, par exemple Italien, il faudrait mettre ceci:
(initget "Unico Tutto Manuale _Single All Manual")

De cette façon, aucune modification n'est nécessaire dans le code hormis la traduction des messages.

Translation errors come from (INITGET).

In the French version, we have:
(initget "Unique Tout Manuel _Single All Manual")
If the user hits "unique" or simply "u", the key returned will be "Single" and not "Unique".
If you want the use to be done only in English, you just have to put:
(initget "Single All Manual")

For another language, for example Italian, it would be necessary to put this:
(initget "Unico Tutto Manuale _Single All Manual")

In this way, no modification is necessary in the code except the translation of messages.

I attach the version (I did not test)

[braudpat]

Hello @CADaSchtroumpf 

THANKS

Happy WE, Bye, Pat 

[BriamR]

@braudpat Thanks, works for me!

[BriamR]

works perfect, thanks @CADaSchtroumpf