AutoCAD 2010/2011/2012

AutoCAD 2010/2011/2012

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

Update Block Attributes in Drawing from an Excel Spreadsheet

2606 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...."

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 -

*Expert Elite*
Alfred.NESWADBA
Posts: 9,216
Registered: ‎06-29-2007
Message 2 of 4 (2,597 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,601
Registered: ‎08-16-2007
Message 3 of 4 (2,585 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,581 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...."
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.