Data Extract question

I have two questions regarding the dataextract command.

1. Is it possible to make it work in reverse, updating drawings accorind to changes made in the extracted table via Excell

2. Has anyone tried to make to automate it to extract and update an excell table in order to have an up to date automatic drawing list.

Thanks for the assistance

I have managed to extract data with the normal data extraction and read it from a cvs file and put it back in the drawing template.

Program is from lee mac my modification can be found here :

http://www.cadtutor.net/forum/showthread.php?41439-Lisp-routine-use-csv-to-update-title-block-attributes-on-ctab/page8

Automation still goes true script pro.

Update drawing how? Change a table?

owh I guessed that he meant the drawing template.

Soory about not answering I'm somewhat busy so processing all the data on the thread you linkd is taking a while...

Yes I seem to have been unclear as to drawing updating.

I meant to update the drawing frame title block. The title block contains attributes which can be extracted via dataextract, and it would be nice if I could make changes to the extracted *.csv and have the changes reflected in the title block.

It seemes plausible since datextract creates a tidy array with attribute tags horrizontaly and drawing numbers vertically.

Like I said in that thread data extract adds .dwg to the file name and the cvs update title block doesn't look at the .dwg so remove .dwg in the filename.

Could be an easy fix but i am lazy

It also updates all the same attributes.

Drwo,

What is the format of the CSV file? i.e. the order of the headings?

I'm guessing something like:

DWGFile TAG1 TAG2 ... TAGN

If the Drawing filename is indeed listed, does it have the .dwg extension as CADKitt suggests?

Hopefully this will help.

Hopefully I will have enough time to go through the suggested solutions.

Thanks for the Help, I'll probably be back with questions

Lee Mac

Hopefully

this

will help.

And it did, it works perfectly, especially when combined with ScriptPro.

Now I have to work out how to create a connection between existing drawing lists and the extracted csv list and crossreferencing all of this, and make it simple enough that someone will actually want to use it

(If I find a definite solution I will post it)

Thanks for the help.

[/indent]

And it did, it works perfectly, especially when combined with ScriptPro.

Good to hear!

[/indent]

And it did, it works perfectly, especially when combined with ScriptPro.

 

Now I have to work out how to create a connection between existing drawing lists and the extracted csv list and crossreferencing all of this, and make it simple enough that someone will actually want to use it

(If I find a definite solution I will post it)

 

 

Thanks for the help.

Here's a tip from Lynn Allen's blog that explains how to do it. There's even a video

http://lynn.blogs.com/lynn_allens_blog/2010/07/an-autocad-video-tip-on-linking-excel-with-autocad-tables.html

I was thinking more along the line of writing a *.bat file that would do the followning

1. Run ACAD

- perform dataextract (one template must be premade per folder/project)

2. Crossreference received CSV and precreated Drawing list (this needs investigating)

- take author and dates from csv and import to dwg list

- take dwg name, proj name, etc.. and import into csv

3. Update each drawing in the folder using csv and the above mentioned lisp (this without ScriptPro, rather using a "FOR" loop in MS DOS

This is the basic idea, I'm quite certain that I wont have time to work on this.

Thanks for the help again.

PS

Here's a tip from Lynn Allen's blog that explains how to do it. There's even a video

http://lynn.blogs.com/lynn_allens_bl...ad-tables.html

 

Not what I was aiming for, but thanks anyway