spur Posted November 1, 2009 Share Posted November 1, 2009 Hi, I have been trying to extract data from blocks containing attributes to an external Excel file source. I can update a table within AutoCAD and then get the update to an external source file which contains non attribute data but if I extract attribute data to another table I can not get the external file to update when changes are made. I have been through the data extraction wizard and set up a table within the drawing I then go through the following. · Select object. Change attribute value description. Select table. Right click and select Update Table Data Links. The table updates to show the change in the appropriate column. (This will also works if the Data Link icon on the status bar is selected and then right click Update Data Links…). The following message appears within the command line 1 object(s) found. 1 object(s) updated successfully. Then with the table selected Right click and select Write Data Links to External Source. Following message appears within command line. 1 data link(s) do not allow their data to be written out. 0 data link(s) written out successfully. The external source file does not update. External source file will update if the following is undertaken: Column is selected then right click and Data Extraction is selected and then Edit Data Extraction Settings… After selecting this and clicking Next through each of the dialog boxes to Finish the external file will update to match the table within the drawing. Can anyone confirm why this does not update without going through the Edit Data Extraction Settings… From reading the help section within AutoCAD this should update the external source file. Is this the case or am I missing something. I have even tried dbconnect but still get difficulties. Quote Link to comment Share on other sites More sharing options...
KIO Posted February 23, 2011 Share Posted February 23, 2011 Hello, Spur. Have you found an answer or any alternative solution ? I've got the same problem: "data link(s) do not allow their data to be written out" And it seems to last from 2008, posted on Autodesk Discussion Board link. Quote Link to comment Share on other sites More sharing options...
spur Posted February 26, 2011 Author Share Posted February 26, 2011 Hi Kio, I'm afraid I have not found a solution this problem and still undertake the same process above. Regards Spur Quote Link to comment Share on other sites More sharing options...
jadoidge Posted February 26, 2011 Share Posted February 26, 2011 I have used the export data command in express tools, this save the block attributes in a tab separated txt file that can then be imported to excel. Regards Quote Link to comment Share on other sites More sharing options...
KIO Posted March 1, 2011 Share Posted March 1, 2011 @Spur It's a pity. Btw, have noticed - single cell update works fine (right click-> data link-> upload user changes to source file). Thnx for reply. Quote Link to comment Share on other sites More sharing options...
KIO Posted March 1, 2011 Share Posted March 1, 2011 I have used the export data command in express tools, this save the block attributes in a tab separated txt file that can then be imported to excel. Regards That's right. Also you can insert exported table via data link and update it from excel. As well it should work in reverse, from drawing to excel, but it doesn't. And that's the question :] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.