Extract Attributes From Multiple Drawing Tabs

[junkie_ball]

Hi

 

I am trying to improve workflow for our drafters in the office. One of the most time consuming problem is creating the drawing register. I have been looking into stream lining this process. All the information we require to include on our drawing register is held in attribute fields in standard title block all our drawings use. I can export the attribute information using the attribute extraction tool within cad and then open up the resulting file in Excel to use the data extracted.

 

My problem comes when our drawing file contains numerous drawing tabs (pretty much every project we do). I have to run the attribute extraction tool for each drawing tab to extract the required data. Is there any way of running a script or batch file that would automate this process? I have some VB knowledge if basic coding is required although I have never looked at lisp if they are required. We are running AutoCad 2012lt so not sure if a lisp would run anyway.

[Pablo Ferral]

You should be able to extract data from multiple title blocks.

 

Check out this tutorial. Let me know if it helps:

http://www.cad-notes.com/creating-schedule-from-your-autocad-drawing/

 

Don't forget that the sheet set manager has this functionality built in.

[junkie_ball]

Thanks for the reply will have a play with this over the next few days and let you know how i get on.

[BIGAL]

If you have 2012 LT then may not be possible to write macro, try writing down each step with attribute extraction then do a line by line script or a macro with each bit seperated by a single space, re lisp not a problem to go to each layout tab and pull out info, happy to provide examples.

[steven-g]

If I use ATTEXT for extracting data (LT) then using 'all' to select objects instead of other selection methods, will also extract any block attributes in all the paperspace layouts of the drawing, without having to go to each layout individually.

[junkie_ball]

If I ATTEXT for extracting data (LT) then using 'all' to select objects instead of other selection methods, will also extract any block attributes in all the paperspace layouts of the drawing, without having to go to each layout individually.

 

Thanks this works a treat. Didnt realise the all command select the blocks on all tabs. Thought it only selected all blocks on the current paperspace or model space. Only thing I need to sort now is to write a small macro to remove the single quotation marks that surrounds all the individual attribrutes when brought into excel. This is going to save hours of tine.

[steven-g]

That should be a setting in the import text wizard in excel, second or third screen gives you the option to remove single or double quotes.