Extracting data from a title block to automate a drawing list

[gv6823otG42ZL]

When creating a drawing list for a company i work for, I have to pull up each drawing and record the revision number and sheet number of the drawing in an excel spreadsheet for a drawing list. The issue is, sometimes we have drawing packages with over 300 drawings. is there a way to automate this as follows? the attached standard spreadsheet shows the standard drawing numbers and what groups are supposed to receive a copy of that drawing. the program would extract the revision number and sheet number from each drawing and place it in its respected cell within that spreadsheet? I don't know if there is something already out there like that, or how hard it would be to make something but I am curious if there is a way to automate this?

[cadffm · Accepted solution]

Hi,

you using blocks with attributs, sure it works.

The raw data export: Command: DATAEXTRACTION

[Sea-Haven]

Using Accoreconsole is the fastest way to do this task with a script, it would have the file names etc. You can get the block details and write to a Excel the values. One of the things when using Excel is you Getapplication if Excel is already open the lisp will use that Excel for the output so that gets around the one Excel file problem. I don't know if Accoreconsole supports Getapplication I will have to test. At worst unfortunately you would open each dwg write the details then close the dwg. 

I moved your title block to the layouts and changed some values, so I could see what was going on. This is the way I would expect a dwg to be laid out.

Your sample dwg should reflect each layout as having different information. Can you also fill in details with true dummy values having just XXX makes it hard to work out what is going on in the Excel. Lots of unknowns.