Results 1 to 8 of 8

Thread: Extract Title Block Attribute Data to Excel

  1. #1
    Member
    Join Date
    2003-03
    Posts
    17
    Login to Give a bone
    0

    Default Extract Title Block Attribute Data to Excel

    I am in the process of indexing a group of approx 60,000 AutoCAD drawings with AutoCAD 2005. To my advantage, all of these drawings use a consistent attributed title block with the drawing number, description and such. There are approx 30 drawings per folder. I can't come up with an efficient method of getting the attribute data to my excel spread sheet. Currently I am Copy-Paste from AutoCAD to Excel. I have created a template to export the attribute data to a text file, but I cannot seem to append the data, it wants to overwrite the output file. I have tried the attribute export tool, but it gives me too much information.

    Currently I use a directory printer that gives me the filename and path witch will be used to provide a hyper link once the data is imported into my access database. All I really need is to get the drawing description from the attributed title block into Excel or Access.

    Any Ideas?

    Thanks,

    Patrick Scott
    Lansing, Mi

  2. #2
    All AUGI, all the time Mlabell's Avatar
    Join Date
    2004-12
    Location
    Toledo, OH
    Posts
    513
    Login to Give a bone
    0

    Default Re: Extract Title Block Attribute Data to Excel

    If tables are available in acad 2005 (I believe this is when this feature became available), you can use the "eattext" command to extract the attribute values of a certain block in .csv format. This file can then be opened in excel. My suggestion is create a table template and you can extract like a madman...

  3. #3
    All AUGI, all the time zoomharis's Avatar
    Join Date
    2005-02
    Location
    Abu Dhabi (Native-India)
    Posts
    506
    Login to Give a bone
    0

    Default Re: Extract Title Block Attribute Data to Excel

    Use and combination of Script file and LISP/VBA routine. I used to create drawing list directly from the final drawings using a VBA macro and AutoCAD Script file. It's so efficient that you can cut down several weeks works in to a few hours. Especially in your case as you have 60,000 drawings ( I can never imagine doing it manually..!!!). If you post a sample drawing, I shall try to adjust my macro to be compatible with your drawing.

  4. #4
    100 Club
    Join Date
    2006-10
    Location
    Chicagoland
    Posts
    154
    Login to Give a bone
    0

    Default Re: Extract Title Block Attribute Data to Excel

    Just an FYI, eattext has been around awhile, not just when tables started.

  5. #5
    All AUGI, all the time Avatart's Avatar
    Join Date
    2004-06
    Location
    Upsidedown in dreamtown
    Posts
    928
    Login to Give a bone
    0

    Default Re: Extract Title Block Attribute Data to Excel

    I think your best bet would be to write a script using "-ATTEXT" and then reading the resulting data into a CDF file, you can then open that in Excel and format it all nice. It would be a great if you have a batch processor to do this for you, sit back with a nice cuppa and watch the PC take the strain!

  6. #6
    Member
    Join Date
    2008-11
    Posts
    12
    Login to Give a bone
    0

    Cool Re: Extract Title Block Attribute Data to Excel

    Guys,
    I know this is not what you are discussing though, does any of you know how to go the other way? Excel to title sheet?

  7. #7
    All AUGI, all the time Avatart's Avatar
    Join Date
    2004-06
    Location
    Upsidedown in dreamtown
    Posts
    928
    Login to Give a bone
    0

    Default Re: Extract Title Block Attribute Data to Excel

    Quote Originally Posted by scoff View Post
    Guys,
    I know this is not what you are discussing though, does any of you know how to go the other way? Excel to title sheet?
    You can do this using a VBA application to link AutoCad and Excel together, or you can save your Excel data as a CSV file and read it through AutoLisp, like you would a text file.

  8. #8
    Woo! Hoo! my 1st post
    Join Date
    2011-12
    Posts
    1
    Login to Give a bone
    0

    Default Re: Extract Title Block Attribute Data to Excel

    Dear,

    Thanks for the idea

Similar Threads

  1. Please, help me extract data Dynamic Blocks and Attribute blocks to Excel
    By minhphuong.humg453254 in forum Dynamic Blocks - Technical
    Replies: 1
    Last Post: 2014-04-17, 08:12 PM
  2. 2010: Extract attribute data in files without opening
    By luislhss in forum AutoCAD General
    Replies: 1
    Last Post: 2013-05-22, 10:57 PM
  3. HOW TO POPULATE BLOCK ATTRIBUTE (TEXT) FROM TITLE SHEET DATA
    By tony.millhouse505221 in forum AutoCAD Sheet Set Manager
    Replies: 3
    Last Post: 2011-04-29, 07:07 PM
  4. Extract Attribute Data into a Table
    By KansasCAD in forum AutoCAD Tables
    Replies: 1
    Last Post: 2006-04-21, 02:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •