Updating between excel sheet and autocad dwg.

[Jach]

now, i have uploaded. the file i take the DATA Extraction from and
the file i want it to link to.

first i start DATAEXTRACTION, pick what blocks i want to extract. after what attributes i want.

the i go make the DATALINK make it as on picture on post #14 even tried with ReMark´s change to it.

Then i check if alle the collums are in right ordre.
after that i press NEXT

and i get OUTPUT OPTIONS

and make a cross in both INSERT DATA EXTRACTION TABLE INTO DRAWING and OUTPUT DATA TO EXTERNAL FILE (.xls .csb .mdb .txt)

then i choice the placement of my sheet aaaaand NEXT

now i am at table style and choice STANDARD
for formatting the table i use MANUALLY SETUP TABLE
under that i select TITLE - HEADER - DATA
and i set a cross in USE PROPERTY NAMES AS ADDITIONAL COLUMN HEADERS.

then i press NEXT and after that FINNISH

after that i place the table in the drawing and it pops up with a DATA LINK HAS CHANGED sign in the bottem.

I press it and this happens:

Command: _DATALINKUPDATE
Select an option [Update data link/Write data link] <Update data link>: _U
Select objects or [Data link/all data linKs]: _D
Enter data link name or [?]: Data Extraction - Fluid Bed Drier.dxe
2 object(s) found.
2 object(s) updated successfully.

if i go on the sheet i looks good, but if i change it and saved it and closes it. i should say in AutoCAD there is an update ready?
NOTE: at that point i have had close the drawing i have made it from in case that might can give an issue

its here it begins to get fuggy, what i am doing wrong id think also i see there a way to get it to copy my excel with the extra fane too? when i extract? i am totally lost on what to do now lol.

any ideas, what there might be wrong are very welcome

[ReMark]

I see the saga still continues. I must have missed it in a previous post but it appears you used the DATAEXTRACTION command to create this table. That may be at the root of the problem you are having.

[Jach]

okay? have any solutions to it? or is it a AutoCAD error? hehe

[ReMark]

AutoCAD error? I wouldn't say that exactly. AutoCAD only does what the user instructs it to do which would make this an OIE (Operator Induced Error).

Solution? Not at the moment. I would have to try and replicate the steps you followed to see what could be salvaged or go about the process in a different manner.

Why don't you fly over here to the U.S. and we'll go over this together at my computer.

[Jach]

hehe i would not mind a vacation.

but autocad could have got an (Operator Induced error) from the programmer, that program help making that part but then again, they should have tested it.

and totally agree, it could be myself doing something wrong, first time working with Data Extraction.
But thanks alot if you wanna check it, you are a

[ReMark]

I would hold off handing out any gold stars for the moment if I were you. The problem remains unsolved.

As far as the program goes, the programmers at AutoDesk, as good as they are, cannot fully anticipate all the different ways someone will attempt to use various commands to solve a problem. Remember too that data extraction was an AutoCAD feature prior to the introduction of Tables and Data Links. Maybe it was assumed the user would use one method or the other and not try to combine the two. See what I mean?

[Jach]

so what you are saying is, i cant make my attributes from an dynamic block update from an excel sheet there are linked to this drawing in some way?

[ReMark]

I do not have enough knowledge to definitively answer that question at the moment. I would not jump to any conclusions if I were you.

I'm kind of surprised that you did not test this method, but on a much smaller scale, before this or did you?

[pmxcad]

Use attout and attin (express tools)
Select all blocks or make a selection (qselect), command Attout.,it saves it as a txt file. open it with Excel, edit wat you want to edit, Save it as a txt file....done. Go back to Autocad, command, ATTIN, select the txt file..........done

Pmxcad

[ReMark]

Although ATTOUT and ATTIN will work it does take more effort to update both the drawing and Excel especially if changes are frequent in nature.