ReMark Posted September 26, 2013 Share Posted September 26, 2013 I can't recall. How does one extract block attributes in LT and bring them into Excel? Wasn't it via the -ATTEXT command and a template file? Is there also another way (using LT 2013)? Jog my rusted cranium please! Thanks. Quote Link to comment Share on other sites More sharing options...
Tuns Posted September 26, 2013 Share Posted September 26, 2013 Maybe a data link? Quote Link to comment Share on other sites More sharing options...
steven-g Posted September 26, 2013 Share Posted September 26, 2013 Attext is the one, pen and paper is the other Quote Link to comment Share on other sites More sharing options...
ReMark Posted September 26, 2013 Author Share Posted September 26, 2013 Is pencil OK? LoL Any 3rd-party options that you know of? ATTEXT seems so ancient. Quote Link to comment Share on other sites More sharing options...
steven-g Posted September 26, 2013 Share Posted September 26, 2013 I don't know of one ! I have a macro set up that does the whole thing automatically, and drops the output text file into a standard file location, obviously it only works for one type of block, but it's only one click (and it uses the whole drawing) Quote Link to comment Share on other sites More sharing options...
Tuns Posted September 26, 2013 Share Posted September 26, 2013 Copy and paste. I'm guessing data link doesn't work? I don't know too much about linking an excel file to an attribute. Quote Link to comment Share on other sites More sharing options...
ReMark Posted September 26, 2013 Author Share Posted September 26, 2013 As far as I can determine a DATALINK is more apt to be used to bring an already populated spreadsheet into AutoCAD. My engineer has yet to extract the data (attributes) from his blocks. Quote Link to comment Share on other sites More sharing options...
steven-g Posted September 26, 2013 Share Posted September 26, 2013 A data link is used for tables, which can have fields that read attributes that can read other attributes or table entries using fields, but I would sooner use a blunt piece chalk and the sidewalk Quote Link to comment Share on other sites More sharing options...
Mike_Taylor Posted September 26, 2013 Share Posted September 26, 2013 There is an attribute extraction command. You essentially write a template file as a txt file. From there you can enter the command, follow the on screen instruction and export a comma delimited file. From here it is quite simple to import into excel. We use this all the time for extracting attributes for equipment requirements given to us by the architects and linking that to a master excel sheet with all equipment for the specific chain we are working on. Quote Link to comment Share on other sites More sharing options...
ReMark Posted September 26, 2013 Author Share Posted September 26, 2013 Yes, that's the -ATTEXT command mentioned previously. Guess I'll be showing the engineer how to create a template file. My thanks goes out to steven-g, Tuns and Mike_Taylor. Quote Link to comment Share on other sites More sharing options...
steven-g Posted September 26, 2013 Share Posted September 26, 2013 Just ran a quick test, if you want to use it on multiple blocks, you can add all the tag names into one template, any blocks that don't contain that tag are read, but it gives it a zero value, and if you are putting it into excel then it would be simple to get excel to work out which info you want to use. Quote Link to comment Share on other sites More sharing options...
ReMark Posted September 26, 2013 Author Share Posted September 26, 2013 I was planning on setting up the template for the engineer in exactly that way. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.