I am extracting attributes from an AutoCAD 2011 drawing into an Excel sheet using EATTEXT. I am then manually adding columns to the Excel sheet. How can I update the Excel sheet with new attributes values later on without overwriting the modified sheet and losing the added columns?
View 2 RepliesI have a basic floor plan in AutoCAD 2012 that has blocks in specific locations which contain personel data....name, phone, computer tag, desk key numbers, etc. I extracted the data to an Excel spreadsheet and I thought set up a "data link". But I don't know how to make the data update.
My problem...moves of staff, phone, computers are often made, but no one lets me know about it until they want a new floor plan printed and the computer and key tags get so messed up from the moves that it can take me hours to fix.
My goal is to be able to have our secretarial staff update the spreadsheet and in turn update the blocks in my AutoCAD drawing when it is opened and/or "updated".
I have a set of sheet metal parts modeled in inventor that are produced in a wide range of sizes and several different sheet metal types.
The dimensions (length, width, flange size, etc) are driven from a spreadsheet. I would like to be able to have the user update the K Factor from the same spreadsheet by selecting a sheet metal type.
The sheet metal type and K factor are not listed in the parameters list with the other model dimensional data, so I'm not sure how to proceed.
I have AutoCAD 2013 and often "paste special" excel files that automatically update when the excel file changes.The problem I'm running into is I work with a person who has uses an older version of CAD 2004, so I always save to the older format for him.
When I etransmit, I be sure to add the excel file, but when he opens the dwg, only the outline of the excel appears in his dwg, no content.
I have a program that I used years ago to extract attributes from AutoCAD into excel. The VBA program is in excel. It is Attribute extraction Utility for AutoCAD Release 14. I want to use it again for 2014 but when I run it I get a compile error can't find project or library and it highlights the the following code "set doc = ACAD.ActiveDocument". Below is the entire VBA sub routine.
' THIS EXTRACTS THE ATTRIBUTE VALUES FROM AUTOCAD TO EXCEL
Sub Extract()
Dim sheet As Object
Dim shapes As Object
Dim elem As Object
Dim Excel As Object
Dim Max As Integer
[Code]...
I work for a company who's trying to automate the production of their mechanical and electrical cad drawings. We eventually want to integrate this into our website, so that a customer can select a few options, and a detailed drawing is generated based on what they pick.
To begin with, I'm trying to integrate AutoCAD with MS Excel. I've managed to automate in excel the options a customer can choose from. Now, the tricky part is, how can I transmit information to AutoCAD to perhaps pick blocks and strategically place them in specific locations of the drawing.
For example, if I have the option of Cats, Dogs, Elephants and Monkeys, and I have the option of quantities... 1, 2, 3, 4, 5, and I pick 3 Monkeys and 2 Cats, I want CAD to be able to place 3 monkeys and 2 cats side by side in a row.
I'm trying to figure out a way to do the following:
I have several drawing files in DWG. Each DWG has a block placed in a drawing sheet. The block contains attributes which would like to link to an Excel file.
Then if I update the attribute in the drawings this would change the linked attribute in the Excel file, and vice versa.
Note that there are several drawings which I would like to handle in a single Excel file.
I have some soil boring data captured, in the field, to an Excel spreadsheet; basically, a bore site ID and coordinates.
I'd like to be able to have the coordinate attributes of blocks inserted into my bore site plans populate automatically, perhaps based off of the value of a bore site ID attribute which is manually entered for each bore site.
Alternatively, if there were a way to insert the bore site blocks based off the actual Excel records, populating all attributes and locating the block by the actual X,Y,Z coordinate, that might be even better.
way I can link my AutoCAD title block attributes to excel and make changes in either excel or AutoCAD and then be able to run an update? The attributes would be “REV” “DWG_NO” “TITLE” “LOCATION” “DRAWING_SIZE” and “FILE NAME”.
View 4 Replies View RelatedEvery time I try to update blocks with attributes of a given layout, this only updates the last active layout. example:
I have three layouts: Layout1, Layout2 and Layout3
layout of the three blocks I would need to update the reference but I can Layout1 default that always takes the last active layout. In the following paper space specific code, but as it would to tell a particular layout.
Private Sub UpdateAttributesInDatabase(ByVal db As Database, ByVal blockName As String, ByVal attbName As String, ByVal attbValue As String) Dim psId As ObjectId Dim tr As Transaction = db.TransactionManager.StartTransaction() Using tr Dim bt As BlockTable = DirectCast(tr.GetObject(db.BlockTableId, OpenMode.ForRead), BlockTable) psId = bt(BlockTableRecord.PaperSpace) tr.Commit() End Using UpdateAttributesInBlock(db, psId, blockName, attbName, attbValue) End Sub
I received a title block update from the architect and it has a block attribute that has the delta revisions of the project. So the new file had a text addition for delta 2. When I replaced the old title block with the new one and then opened one of my sheets, the title block is not showing delta 2, the field is empty.
Do attributes not update automatically? do I need to detach and reattach the title block in all my sheets ?
I have a couple of attributes suing fields within a block. But they don't update on opening. I need to do a manual field update to get them updated to the latest values.Tried various combinations of "fieldeval", but this was no good.
View 5 Replies View RelatedI've got a block with multiple attributes. This is not a problem to redefine the blocks attributes.
Some of the attributes contains dynamic fields (blockplace holder x y z parameters) When i insert a block with such atributes that includes the blockplaceholder dynamic fields i get
X: InsertionPoint => It is recognized as an Dynamic field but displays InsertionPoint. and does not update the value.
How can i update the fielddata from vb.net?
Part of the code I use (where i think the problem is)
For Each attid As ObjectId In refbtr attent = tr.GetObject(attid, OpenMode.ForRead) If TypeOf attent Is AttributeDefinition Then Dim attdef As AttributeDefinition = attent Dim attref As New AttributeReference() attref.SetAttributeFromBlock(attdef, myBlockRef.BlockTransform) Dim attrefid As ObjectId = myBlockRef.AttributeCollection.AppendAttribute(attref) tr.AddNewlyCreatedDBObject(attref, True) End IfNext
I am trying, to make a data extraction with Link External data with linking to a excel sheet. Everything works fine, with the data extraction.
Then I try using upload to source/download to source update, but end up with this msg. every time:
1 object(s) found.
1 data link(s) do not allow their data to be written out.
0 data link(s) written out successfully.
I have tried when it said, successful all the way, but nothing have happen in the excel sheet at that time.
What I am trying to do, is make it automatic or manual update in the attributes in the drawing. If I change something in my excel sheet and ofc. the other way around to if possible.
I've to put some data as like table beside the figure. I've these data in a excel sheet. Can i import that sheet in CAD? or I need use table and re-type all data?
View 4 Replies View RelatedCurrently i am trying to get an Excel sheet incorporated into my AutoCAD layout. I get it in and it seems way to small. I re-scale the excel insert and get it right then update the sheet to get the new info and it shrinks back down. Now i thought at first it was the excel insert that was the problem, but now looking my layout seems to be extremely large and that's why the excel sheet is off. How can i take my existing layout and change it to fit 11x17. I really don't want to have to redraw the whole layout to make it fit 11x17.
View 9 Replies View RelatedI'm trying to create a new titleblock for a company I just started with that wants to make the move to AutoCAD. I have a couple of years drafting exp but I'm still learning the finer points of setting up a virgin system. So, I've drafted a titleblock which I'm trying to add attributes to, and I think I'm very close to having it all sorted out but I'm stuck at the moment. See below:
A breakdown of what I've done: Created title block and added attributes for all values we'll be taking from sheet sets (i.e. client name, revision numbers, revision dates}. This titleblock is saved as its own drawing and the attributes are in that drawing. The attributes have tags only- no default data or prompts Created a "Dummy" sheet set with all custom properties needed for future sheet sets/projects (i.e. client name, revision numbers, revision dates. Created a New Drawing using the sheet set manager, with our company's current drawing template.Purged all old title blocks from the new drawing Inserted the new title block (Bullet point 1) with attributes into layout 1.When prompted, I inserted the field for each corresponding attribute.
At first everything looked fine. Sheet number was correct, sheet title was correct, even a couple of the custom properties were alright and displaying properly in the layout. BUT THEN I noticed that a few attributes weren't showing up at all in the layout. When I would edit the title block itself, all of the attributes would be there but when I would try to insert a field into their 'default' parameters, the 'custom sheet set' properties wouldn't exist (like this sheet was not associated with this sheet set). But some of the attributes in the block WOULD be able to reference the custom sheet set properties, so that's not the issue.
My issues are inconsistent. Some attributes work, some don't, some update according to sheet set properties in the layout, others change in the block editor.
Is all of this weirdness being caused by the fact that my attributes are within a block? And does that mean that I have to define attributes in the Drawing template instead?
If you look at the attached drawing you will see my drawing sheets. The problem I have is regarding the attributes used for the 'Checked By' section of my sheet.
Yesterday I added a 'Size' tag to my sheet so this shows whats size paper the sheet is to be printed at. To make this fit I needed to move all the existing attributes over to the right.
Everyone except the 'Checked by' tag moved. I cannot now get this tag to move over even if I open the block up and move it.
I've attached an image to show you what I mean.
I'm using a blocklibrary, where I stored all my blocks, most of them have attributes.
Now I'd like to simplify my workflow and want to update the blocks that I inserted in a drawing trough LISP.
Is there a way to update all inserted blocks and attributes of the whole drawing a once? The idea is, that the LISP checks the whole blocklibrary and updates the inserted blocks that to not match with the once from the library.
What is the best way to Insert an Excel sheet into autocad?
View 4 Replies View RelatedI've made a big calculation in a Pipe Stress Analysis program and the program has auto created 10 autocad drawings that is used to find points in the system.The problem is that the program has random numbered (with no intelligence) and now I have a big report which for example points at a number some where in the 10 drawings, which is hopeless to find.
Can I somehow:
1. Find all numbers in this drawing.
2. Put them into Excel.
3. Sort them after size.
4. Add an extra column which tells which drawing I can find the number.
5. Last put all the numbers from all the drawing into one Excel sheet and sort them after size, now I have a number index, so I can find which number is in which drawing.
Can Autocad find all numbers in a drawing and let me copy them to Excel for editing?
I want to link an excel sheet with a drawing, so changing the excel changes the drawing.
I used this awesome site to learn about going to Edit->Paste Special->Paste Link->AutoCAD Entities...but I don't have that choice. Just the one that makes the OLE image. While that will work, that is less than ideal. It appears in just normal paste, but not under paste link.
AutoCAD 2007, A.54; Excel 2003 SP3; Windows XP SP3.
I have a drawing with an embedded Excel sheet. I want to read the contents of the excel sheet. Maybe in combination with Microsoft.Office.Interop.Excel?
View 9 Replies View RelatedI am trying to create a new sheet in an existing excel file and can not figure out how to do it.
I am trying to export parts lists from multiple drawings to an exisitng excel spreadsheet and I'd like have each on their own sheet. I can do everything but create a sheet. How to do this in iLogic?
Inventor Pro 2013 (PDS Ultimate)
Vault Pro 2013
Windows 7 64
Xeon 2.4 Ghz 12GB
I´m having a couple of problems with getting data correctly from an Excel Sheet. I´m using the Excel Sheet to get Data for the Stock Number based on geometry.
First time the Excel File get´s opened it always cannot find the first sheet. I´m using a german Version and Sheet1 is Tabelle1 in german.
It always searches for sheet1 the first time the script runs on a new derived assembly. The second time (on second part) it correctly finds Tabelle1 and reads the correct value.Here is the code I´m using:
[code]
myXLS = "K:IdentNr.xls"
GoExcel.Open(myXLS)
i = GoExcel.FindRow(myXLS, "Tabelle1", "Stärke", "=", Stärke, "Material", "=", iProperties.Material)
IdentNr = GoExcel.CurrentRowValue("IdentNr")
iProperties.Value("Custom", "IdentNr") = IdentNr
[code]
And there is another issue which I have solved already but still gives me a bit of a headache. When the userdefined property IdentNr gets written into the part it always defaults to a numerical value, which means that I always get a comma at the end of the Stock Number.
Only when I define IdentNr like this:
Dim IdentNr As String
the format is correctly set to Text.I expected that when you read a value from an Excel Cell that the Format of the Cell gives the format of the user defined property. Is that not correct?
When i import points (csv) from my excel sheet into Civil 3D, i can't see the actual points on the display frame, but i can see that the points have been imported by looking at the prospector tab > Points.
View 2 Replies View RelatedI have made a data link to an excel file. Then I bring it in as a table. I then adjust the text height and remove all formatting from the table. Unfortunately, after closing and re-opening the file, the table changes. I lose formating/cell alignment/text height. It isn't even consistent across the table. The lost formatting is only on the 2nd split of the table, the first side retains the corrected formatting. I have selected the option to not update excel formatting. I don't even get a notification the table is updating. There haven't been any changes to the excel sheet either....
View 6 Replies View RelatedI am very new to autocad and i am using 2013 student..
1) I have drawn a curved line for a Directional Drill Shot and need to create a points on it every 2 metres to give a Cord position,
2)I need to be able to transfer these points into a excel spread sheet.
I want a ilogic rule syntax for following process:
I have one excel sheet it consists around 5 sheets for Plate, Flats, Rounds, etc. When i am run the rule then it will ask and do the following:
Ask the thickness value.It will search thickness value in “D:LINUS KOTTEstock numbers.xlsx” in sheet 1If thickness value found then fill the stock number in iproperty(project tab-stock number)
Here i am using different rules for plate, flat, round, etc.,
So I am Loving the use of Attout and Attin for updating block attributes from a spread sheet...Currently I am producing drawings with names on desks. I have created a block with the attributes of Name and desk.
I am currently updating the drawings blocks so that I can input an excel spreadsheet with over 1500 names into the drawing using Attin (changed the .xls to .txt and roberts your mothers brother)
Unfortunately the spreadsheets I have been given have the name as one field. i.e name: Joe Bloggs, Ideally I would have the information as First Name: Joe last name: Bloggs and create two associated attributes which would enable a nicely displayed block..
is there any way that I can format the block so that the attribute displays as a multi line..e.g.
Joe
Bloggs
not
Joe Bloggs.
I know I can go into each attribute (although trying to remember that command "A something Edit" I think) and edit it like a piece of txt. I would rather not have to go and do that if there is another work around..
A local search of my HD and a search on the subject here returned with zero results...
Where does one find the Inventor Sheet Metal Rules excel table for 2012 on a Windows 7 system?
All the documentation says it's located in the Documents and Settings directory, but Windows Vista eliminated that folder and thus it is not in Win7 either.
I can find the SheetMetalRules.xml file, but I need the excel table for modification.