Results 1 to 7 of 7

Thread: EXCEL Drawing register using Autocad Title Block Attributes

  1. #1
    Member
    Join Date
    2010-05
    Posts
    9
    Login to Give a bone
    0

    Default EXCEL Drawing register using Autocad Title Block Attributes

    Hi,

    I have recently taken on the task of doing some major house-keeping and tiding up of our drawing database and associated project folders.

    I was wondering if there was any way at all of creating a Drawing Register for each Project using Excel and populating this spreadsheet with the information from the attributes in the Title Block i.e.: Drawing No., Drawing Title, Date Drawn, Revision No., Revision Description.

    If this is at all possible, would the information in the spreadsheet be automatically updated when the drawing attributes are updated?

    I am using AutoCAD Electrical 2010.

    Any Assistance Would Be Greatly Appreciated

    Many Thanks

    Regards

    Simon

  2. #2
    The Silent Type RobertB's Avatar
    Join Date
    2000-01
    Location
    Seattle WA USA
    Posts
    5,859
    Login to Give a bone
    0

    Default Re: EXCEL Drawing register using Autocad Title Block Attributes

    Have you looked at the Sheet Set Manager? This allows you to create a sheet index as an AutoCAD table which you could then export to Excel, although if you are using SSM, Excel is just wasted time and effort.
    R. Robert Bell
    Design Technology Manager
    Stantec
    Opinions expressed are mine alone and do not reflect the views of Stantec.

  3. #3
    Member
    Join Date
    2009-03
    Location
    Auburn, Washington
    Posts
    8
    Login to Give a bone
    0

    Default Re: EXCEL Drawing register using Autocad Title Block Attributes

    Hello Simon-

    The only command I can think of is "DATAEXTRACTION". I think you can batch the process to run through a list of files, possibly folders also. Once the process completes, I think the information can be linked, between the excel and cad files. However, I worry that the consistency of the information may leave you with a bunch of **** in Excel. An alternative, time consuming as it is, to change your title block attributes from text to fields linked to an outside database (excel file). You could go a step further, populating custom file properties on the dwg file, with this same information (would require an add-in or programming) then you could use windows desktop or google desktop search, to read the values of those custom properties---extra "feature".

    Jamie Hill

  4. #4
    Certifiable AUGI Addict
    Join Date
    2015-11
    Location
    Jo'burg SA
    Posts
    4,512
    Login to Give a bone
    0

    Default Re: EXCEL Drawing register using Autocad Title Block Attributes

    The DataExtract doesn't "automatically" update the excel file. You'll need to run the extract again, however you don't need to set it up again as the settings are saved in a DXE file.

    But, , it "automatically" updates a table inside a DWG file ... which you can export to excel if you wish. If you open the DWG containing the table a pop-up note is displayed if there was a change in one (or more) of the source DWG's, allowing you to click the update (similar to what happens with xrefs being updated by someone else).

    Both the SSM and DWGProps idea would be a lot of work since each of your existing DWG's need to be fielded to these (maybe even redefining your TB's). It might be possible to script it using some advanced lisp, but that's probably not the simplest thing to do. If you do decide to go this route, I'd suggest SSM instead as it's a lot more flexible & comprehensive than DWG Props, not to mention SSM works on multiple DWG's at once - DWGProps only work on one DWG at a time. Also there's an automatic drawing list feature in SSM, not so in DWGProps.

    In any event, I'd highly recommend going the SSM route from now on. Simply so your new projects don't give you the same headaches.

  5. #5
    Member
    Join Date
    2009-03
    Location
    Auburn, Washington
    Posts
    8
    Login to Give a bone
    0

    Lightbulb Re: EXCEL Drawing register using Autocad Title Block Attributes

    Hello again-

    I just read a new blogpost made by Jimmy at JTBWorld. The concept, isn't exactly as you'd like, but I think close enough, that it is wort reading.

    http://blog.jtbworld.com/2010/05/pro...roperties.html

    Jamie Hill

  6. #6
    Member
    Join Date
    2010-05
    Posts
    9
    Login to Give a bone
    0

    Default Re: EXCEL Drawing register using Autocad Title Block Attributes

    Hi All,

    Many Thanks for all the replys, i really appreciate all your feedback.

    One other question, Is it at all possible to of turning the CAT attribute of multiple Blocks to invisible across multiple drawings within a project without opening each Block Symbol individually?

    I am using AutoCAD Electrical 2010.

    Any Assistance Would Be Greatly Appreciated

    Many Thanks

    Regards

    Simon

  7. #7
    Certifiable AUGI Addict
    Join Date
    2015-11
    Location
    Jo'burg SA
    Posts
    4,512
    Login to Give a bone
    0

    Default Re: EXCEL Drawing register using Autocad Title Block Attributes

    Not without scripting. In which case you should modify the block in one DWG, then WBlock it out to a new DWG. Then insert & redefine from that through the script. Then run the AttSync command to update each instance of the block in the drawing (even if there's only one). Then you should have this script run on all the DWGs. If you're not on 64bit, you could use ScriptPro from ADesk to run the SCR file ... otherwise there's some non-free script runners (do a google) or somewhere here there's a thread pointing to something called BatchLisp which might be used as well.

    You could "redefine" the block as well as modify each instance in multiple drawings using AutoLisp with ObjectDBX. Unfortunately you can't send commands using ObjectDBX though, so the AttSync can't be used.

Similar Threads

  1. 2013: Batch extraction of title block attributes to excel
    By robechandler167079 in forum AutoCAD General
    Replies: 1
    Last Post: 2015-04-28, 07:29 PM
  2. How To Create Dynamic Block With Attributes - Drawing Title
    By omorah in forum Dynamic Blocks - Technical
    Replies: 1
    Last Post: 2012-08-09, 02:36 AM
  3. title block and attributes in autocad 2004
    By mescamilla in forum AutoCAD General
    Replies: 2
    Last Post: 2010-09-16, 02:25 PM
  4. Excel Drawing Register
    By donalcommane in forum Software
    Replies: 0
    Last Post: 2009-05-13, 09:18 AM
  5. Drawing Register / Issue Sheet in Excel
    By de-co1 in forum Software
    Replies: 9
    Last Post: 2006-12-06, 09:25 AM

Posting Permissions

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