AutoCAD 2010/2011/2012

AutoCAD 2010/2011/2012

Reply
Member
tinribs
Posts: 5
Registered: ‎09-24-2008
Message 1 of 4 (2,272 Views)
Accepted Solution

Update Block Attributes in Drawing from an Excel Spreadsheet

2272 Views, 3 Replies
10-15-2012 02:00 PM

I have a basic floor plan in AutoCAD 2012 that has blocks in specific locations which contain personel data....name, phone, computer tag, desk key numbers, etc.  I extracted the data to an Excel spreadsheet and I thought set up a "data link".  But I don't know how to make the data update.

 

My problem...moves of staff, phone, computers are often made, but no one lets me know about it until they want a new floor plan printed and the computer and key tags get so messed up from the moves that it can take me hours to fix.

 

My goal is to be able to have our secretarial staff update the spreadsheet and in turn update the blocks in my AutoCAD drawing when it is opened and/or "updated".

 

Is this possible?  Am I missing something?  I have tried to wade through the posts and tutorials, but can't quite get a good grasp on this issue.  Any help would be greatly appreciated!  Thanks.

"not all who wander are lost...."
*Expert Elite*
Alfred.NESWADBA
Posts: 8,962
Registered: ‎06-29-2007
Message 2 of 4 (2,263 Views)

Re: Update Block Attributes in Drawing from an Excel Spreadsheet

10-15-2012 05:01 PM in reply to: tinribs

Hi,

 

>> I thought set up a "data link".  But I don't know how to make the data update

You can make datalinks, but you can't update then any block-attributes from the datasource (imho).

 

What you can try are the commands ATTIN and ATTOUT. Therefor you need the ExpressTools to be installed and running, then you can export existing attribute-data to aa txt file (that can be opend with Excel then), modify the data in Excel and then import the new data back into the attribtues.

 

HTH, - alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
*Expert Elite*
dbroad
Posts: 1,546
Registered: ‎08-16-2007
Message 3 of 4 (2,251 Views)

Re: Update Block Attributes in Drawing from an Excel Spreadsheet

10-16-2012 08:06 AM in reply to: tinribs

I don't think the system was designed to have Excel drive the drawing.  If you make changes to the drawing, you can refresh the excel links to create the report.

 

You can break the link to the spreadsheet and edit it manually. But such edits won't change the drawing and the drawing and spreadsheet will no longer be linked.

 

A third party solution might be developed or available.

Member
tinribs
Posts: 5
Registered: ‎09-24-2008
Message 4 of 4 (2,247 Views)

Re: Update Block Attributes in Drawing from an Excel Spreadsheet

10-16-2012 08:21 AM in reply to: Alfred.NESWADBA

Thanks Alfred!  This worked great.  I can make edits to the text file and using the ATTIN command, it will update the blocks in place.  I can see too that arranging the attributes in a different order will make this easier for staff to update the text file.  :smileyhappy:

"not all who wander are lost...."
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

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