AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Active Member
korinagomez
Posts: 9
Registered: ‎04-24-2012
Message 1 of 16 (313 Views)

Autocad Map 3d annotation

313 Views, 15 Replies
04-24-2012 10:40 PM

I have a set of data in excel. how can i annotate my map with this data, such that the map recognizes the name for example of a point and then directs this data to this point.

 

For example given points A and B in the map. then i have for example 3 columns of data in excel for points A and B.

 

Thank you.

*Expert Elite*
antoniovinci
Posts: 1,702
Registered: ‎06-03-2011
Message 2 of 16 (311 Views)

Re: Autocad Map 3d annotation

04-25-2012 01:18 AM in reply to: korinagomez

First you load the .XLS file with _MAPATTACHDB then you link the number of Autocad point to the same field in Excel, by means of the _MAPDEFINELT command.

Active Member
korinagomez
Posts: 9
Registered: ‎04-24-2012
Message 3 of 16 (294 Views)

Re: Autocad Map 3d annotation

04-25-2012 05:31 PM in reply to: korinagomez

thank you for replying. when i did what you said, (mapdefinelt), there appears a define link template dialog box, i clicked some of the options for the key selection, but the values do not appear in the map..

sorry, i am really new to this.

*Expert Elite*
antoniovinci
Posts: 1,702
Registered: ‎06-03-2011
Message 4 of 16 (284 Views)

Re: Autocad Map 3d annotation

04-25-2012 10:50 PM in reply to: korinagomez

 

After the _MAPATTACHDB command and loading your .XLS file, right click on the connection, then choose Properties: 

 

 

 

Now you should setup the ODBC driver like this: when everything is ok, you can issue _MAPDEFINELT (I recommend you to learn these powerful commands in the F1 help)...

Active Member
korinagomez
Posts: 9
Registered: ‎04-24-2012
Message 5 of 16 (268 Views)

Re: Autocad Map 3d annotation

04-26-2012 06:22 PM in reply to: antoniovinci

wow. thank you for replying..

a table same as my excel file appears,

here is a link of the task i was assigned. am i on the right track or is this possible with autocad map 3d. i was thinking of  making the excel my data source, and an everyday change in values will be visible through changes in the color in my map.. just like a weather map.

 

http://earthobservatory.nasa.gov/GlobalMaps/view.php?d1=MYD28M

 

i really appreciate your help. i've been working on this for three weeks now. again thank you :smileyhappy:

Active Member
korinagomez
Posts: 9
Registered: ‎04-24-2012
Message 6 of 16 (261 Views)

Re: Autocad Map 3d annotation

04-26-2012 08:14 PM in reply to: antoniovinci

or based on the data, how will i annotate the map with color, such that when assigned a value, it will automatically change color.. as for the link i attached, i will be animating the drawings so as to appear like that.. but coloring now is my only problem.

 

 thank you :smileyhappy:

*Expert Elite*
antoniovinci
Posts: 1,702
Registered: ‎06-03-2011
Message 7 of 16 (255 Views)

Re: Autocad Map 3d annotation

04-26-2012 11:00 PM in reply to: korinagomez

I'm afraid you can't get that.

Software GIS like Map involves links to external databases as text attributes, not as dynamic source to stylize your map in realtime.

By the way, in your spreadsheet I don't see the values A-21, A-22, C-21: how did you join Autocad objects with Excel records..?

Active Member
korinagomez
Posts: 9
Registered: ‎04-24-2012
Message 8 of 16 (252 Views)

Re: Autocad Map 3d annotation

04-26-2012 11:33 PM in reply to: antoniovinci

do you mean linking the object to the excel data?? watch this video,after doing this, double click the object, properties ribbon will appear, scroll it down, then you'll see your excel data there..

http://www.youtube.com/watch?v=7D_Y2-89ySA

 

:smileyhappy:

*Expert Elite*
antoniovinci
Posts: 1,702
Registered: ‎06-03-2011
Message 9 of 16 (248 Views)

Re: Autocad Map 3d annotation

04-27-2012 12:23 AM in reply to: korinagomez

Dear Korina,

I link Autocad stuff to databases since '90 of the past century, so my question was about how YOU did that... 

Active Member
korinagomez
Posts: 9
Registered: ‎04-24-2012
Message 10 of 16 (247 Views)

Re: Autocad Map 3d annotation

04-27-2012 12:24 AM in reply to: antoniovinci

with regards to my question, i saw a video that is a probable solution, however whenever we click style editor from the analyze tab, it says "to edit style, you need to have a map layer".

 

does it need to be GIS, or map imported from sql or arcsde?? the map we have was previously made in corel draw and converted to dwg.. sorry for troubling you.

 

here's the link by the way http://www.youtube.com/watch?v=6ITZnrGfec0

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.