AutoCad :: Attout And Attin For Updating Block Attributes From A Spread Sheet
Jul 4, 2011
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..
View 3 Replies
ADVERTISEMENT
Jun 29, 2012
I'm working on a program that cycles through each paperspace layout in a drawing and updates the sheet number and total quantity of sheets in the titleblock attributes. I've updated the block attributes in paperspace before, and it worked fine. Now that I'm trying to cycle through each layout, I cannot get it to work. I have attached my code. I beleive it starts to cycle through the layouts, but it fails when I try to grab the attribute collection.
Public Sub UpdateSheetNumbers() Dim doc As Document = Application.DocumentManager.MdiActiveDocument Dim db As Database = doc.Database Dim ed As Editor = doc.Editor Dim layoutCount As Integer =
[Code].....
View 7 Replies
View Related
Oct 30, 2013
I'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?
View 9 Replies
View Related
Feb 1, 2012
When you extract information from attribute blocks to form a spreadsheet can you specify that the spreadsheet also lists the co-ordinates x,y, z for that block? For example, you have an attribute block with information regarding, station number, chine number. When I extract the information I would like to list the x, y co-ordinate point of the circle block .
View 2 Replies
View Related
Dec 14, 2012
I 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.
View 7 Replies
View Related
Nov 18, 2012
If you review the attached screen shot of a PDF you will see that my Excel spreadsheet object prints very light. This is added to a Paper Space layer that is same layer as the Title Block, which is printing fine. The colorful solid objects are each in their own viewports.
I have set the OLE property "Plot Quality" to "Monochrome", also I have set the "Plot Style Table" to "monochrome.ctb".
To place the spreadsheet table I have Excel open, I select the columns/rows that I want and then Ctrl-C, I flip over to ACAD and Ctrl-V to place the object, I then resize it by dragging its handles. On screen, in ACAD, it looks fine.
I am creating the PDF using "Cute PDF Writer", which does an excellent job creating PDFs from many applications. I don't think it's related to my problem. I have tried ACAD's "DWG To PDF.pc3", but had a similar problem, but worse in other aspects.
View 2 Replies
View Related
Jul 16, 2013
I am trying to link a Excel spread sheet to an Inventor 2009 part. It worked great on Friday now it is not working. The only thing that changed was that there was a windos update. When it does work I am unable to update any of the parametes that are linked to Excel file as the update button has disappear.
View 2 Replies
View Related
Jan 23, 2012
From the attached image you can see what I'm talking about.
(left=original, middle=ROTATE, right=PROPERTIES)
When I rotate blocks using ROTATE command everything is fine, but when I rotate blocks using PROPERTIES my attributes get messed.
I need to rotate several blocks at once with PROPERTIES, because I don't have time to rotate each one separately.
The same thing happens when scaling blocks, but this was resolved using the command BSCALE in the command line.
View 5 Replies
View Related
Sep 24, 2013
I have a job to photograph 300 items and use lightroom to number each one with its own product code.
Then I need to add the barcodes to the images so the client can scan them
They have a spread sheet with all the data on but can a sript be written to do this action ???
View 2 Replies
View Related
Aug 16, 2012
I have a spreadsheet in Excel that is split into columns. The first is the frame number, and the subsequent columns are the rotations about the X, Y and Z axis. There is also a column that has the location in the Z axis from the origin (0). These values are currently being input manually and keyed. The object being animated is a locator node which will form the parent of an object.
Is there a way to have these values read in automatically and for each frame to then be keyed to that value?
As I've never touched MEL or Python I wouldn't have a clue where to start trying to write some sort of script to do this.
View 1 Replies
View Related
Aug 1, 2013
I am trying to update blocks from a selection set and based on two specific attributes. I get and error eLock Violation
Not sure where it comes from since this is a dll.
Dim doc As Document = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument Dim db As Database = doc.Database Dim ed As Editor = doc.Editor Dim x As Integer = 0 Dim tr As Transaction = db.TransactionManager.StartTransaction() MsgBox("Going into attribute write", MsgBoxStyle.OkOnly) Try Dim idArray As ObjectId() = selSet.GetObjectIds() For Each blkId As ObjectId In idArray Dim blkRef As BlockReference =
[Code]........
View 3 Replies
View Related
Nov 7, 2011
The only stipulation is my company uses AutoCAD 2012 LT. I am not familiar with Lisp/VBA programming codes but I have done an "appload" before, but that does not work with LT versions.
Question:
How do I update multiple template blocks based off of the first template? Currently we have been using one primary drawing sheet and are now going to be implementing a detail sheet.
View 8 Replies
View Related
Sep 4, 2012
We use a number of blocks with block tables for data extraction here, and whenever one of the blocks is modified and updated, all of the block tables reset to the default value. This happens for any block reference change, not just changes to the block table (which makes sense that it would reset).
How can we update these blocks without having to manually change all of the block tables afterwards?
View 2 Replies
View Related
Dec 8, 2011
I was curious to see if there's a way to set up Autocad (2010) to recognize when MTEXT objects are edited, and have it adjust their defined width automatically (both single- and multi-line)--versus having to click on the arrow every time to snap the text box "margin" to the actual text. I'd like to do this to keep my background masks the exact width of the text; I just hate it when the mask doesn't cover enough of the text, or when it covers more and the background is unnecessarily obscured. I'm careful about keeping things neat, but my coworkers aren't .
View 1 Replies
View Related
Feb 14, 2013
Is there a way to create a block with attributtes that automatically complete x, y, z, lat, long for the insertion point of the block?
I am trying to complete text in paperspace that will automatically fill in the lat long of a point in model space without using a table. I have tried field insertion with reference to a cogo point, but it doesn't give options for position on a cogo point. If I pick a block with attributes, it will let me pick any attributes, and x,y position for the block.
Cogo points show all the information I need to propagate in the properties....but how do I get that to translate into the text using fields or some other method?
Dell Precision T3600 - Windows 7 64-bit
NVIDIA Quadro 600
Intel(R) Xenon(R) CPU E5-1607 0 @ 3.00GHz 3.00GHz
8 GB ram - Two 1TB raid
View 9 Replies
View Related
Oct 26, 2012
When the block is in a drawing and I click it, it takes me to block editor.
However if I go to it in block editor and test block it allows me to change the attributes.
Why does clicking the block go to block editor and not allow me to change its attributes as it does when I test block.
View 9 Replies
View Related
Oct 31, 2013
I would like to change sub block from a visibility after setting it. Here an example of code to get the right visibility, I don't really know how to update a sub block by name or by handle(seems to change inside dynamic block).
Dim Block As AcadBlock
Dim BlockRef As AcadBlockReference
Dim DynEntBlock As AcadEntity
Dim DynObjRefH As IAcadBlockReference
[Code]........
View 9 Replies
View Related
Apr 8, 2013
I can insert a block with block attributes using the Inter op very easily:
Dim theBlock AsAcadBlockReference
Dim pickScreenVBA = myDoc.Utility.GetPoint(, "insert the hydrant")
theBlock = myDoc.ModelSpace.InsertBlock(pickScreenVBA, "Hydrant", 1.0#, 1.0#, 1.0#, 0)
Dim varAttributes AsObject
varAttributes = theBlock.GetAttributes
varAttributes(0).TextString ="3 Ports"
varAttributes(1).TextString ="Salt water"
Works great, but when I try using the non-inter op, all the example insert new Attributes and not add block with existing attribute (so I end up with duplicate attributes for each block - i.e "Salt water" attribute is added to the block each time I run the code),
Are they any examples that does the same as above using the non-interop code?
View 2 Replies
View Related
Dec 12, 2013
I'm trying to add some attributes to an existing block using the block editor, but after I save and close it I cannot see any 'placeholders' despite adding a default value and the attributes work fine when I double click the block.
I've tried using the ATTSYNC and BATTMAN commands but nothing works and there are no invisibility states applied to either the attribute or block and all layers are switched on.
I just tried making a quick block from scratch and it seems to have the same affect, except the default value will show, but no 'placeholder' shown if left blank.
I swear with previous version I could see the tag when a value hadn't been applied, so is it that the version I now use (2012) does not have this feature or it's disabled?
View 9 Replies
View Related
Feb 14, 2012
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.
View 9 Replies
View Related
Sep 19, 2011
I'm trying to chnage the text of the sheet number and total sheet number attributes for each layout in my drawing. I have code that adds and deletes the specified pages, now I need to edit the attributes to reflect the correct page and correct total amount of pages. Here is my code, based on my old VBA version.
I know there is a problem with the line:
For Each item In myBTR.ObjectId
I've used a number of websites and books, but I would really like to find something that teaches about block tables, block table references, block table IDs so I can get a better understanding of breaking stuff down to get the info I need.
Public Sub updatePageNumbers()
Dim myDWG As Autodesk.AutoCAD.ApplicationServices.Document
Dim myDB As Autodesk.AutoCAD.DatabaseServices.Database
Dim myTransManForPageNumbers As Autodesk.AutoCAD.DatabaseServices.TransactionManager
Dim myTransForPageNumbers As Transaction
[Code]....
View 6 Replies
View Related
Jun 4, 2013
Currently we have about 30 sheets where we xref the same construction note and legend. The client is asking us to remove notes that don't apply to each sheet. For example, sheet 1 will not need note 2, 6, 10, 11. Sheet 2 will not need 3, 5, 10, and 11, etc.
Same goes for the legend- they don't want to see something if it does not apply to the sheet.
Other than bringing in those notes and legend into each sheet and modifiying it, I can't think of another way to do this. Previously, if I needed to change the wording of note 4, I change it once and I'm done. If I need to change anything now, I will need to open up 20 sheets.
Also, they want to remove the note completely, and not just cover up the note with "Not used this sheet."
View 9 Replies
View Related
Dec 2, 2013
I have a set of drawings with a large number of sheets. I need to do a mass edit of the properties for each sheet (for example update the revision number, date, checked/design/approved/drafting initials, description). The updated properties are largely similiar.
Is it necessary to update each sheet's custom properties individually, or is there an easier method?
View 2 Replies
View Related
Nov 21, 2011
In fact, some of the things I've found online refer that you cannot automatically replace entire Titleblock Templates for existing Sheets in the Sheet Set Manager. So, here's my question:
Can you replace all existing Sheets in a Sheet Set with an entirely new Template file automatically, without opening each Sheet and re-inserting the Title block?
Example:
Let's say I have a Sheet Set. Inside the Sheet Set, I already have 20 sheets created. I then realize that my Template file is missing our company logo. I then have to open the Template file and insert my company logo. Well, this works for all newly created sheets from that point forward, but how can I get this change to automatically populate in the existing 20 Sheets that are already in the Sheet Set?
View 9 Replies
View Related
May 27, 2011
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 Replies
View Related
Feb 22, 2013
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.
View 3 Replies
View Related
Dec 13, 2012
using AutoCAD 2009 (vanilla)
I got too smart for myself today in bringing an old drawing up to current standards...Everyone seems to want their block attributes to be zero - I have blocks where the attributes are best when they match the rotations of each blocks.
I have an old drawing that was rotated (as it should be) at approx 2deg.
I used a lisp routine to global edit all the blocks that needed to be at zero. BUT for some reason (and after hundreds of blocks were corrected), I noticed I now have two blocks that should NOT have been in the set have had their attributes rotated to zero....and the attributes should be at the same rotation as their block's rotation.
Because those two blocks have a fixed tic mark, I can click on the mark to see what the block rotation is, then rotate its attribute to that rotation, but I have hundreds of blocks! One-at-a-time sucks....
Any chance there is a GLOBAL way to edit an attribute rotation to match its own block's rotation?
View 2 Replies
View Related
Feb 6, 2013
I have created an annotative block. This block is displayed in a few different viewports at different scales. After I create the block I go and check the viewports and it is displaying well. The linework (polylines and a circle) is annotative as is the text in the block.
However, if I then change the scale/annotative scale of a viewport, the block doesn't seem to update properly. The text within the block updates to the new size although the linework within the block doesn't seem to scale and resets back to the model space size.
I've tried regenning etc with no luck. Is there a command I need to use after changing a viewport scale to force annotative blocks to update?
View 9 Replies
View Related
Jul 20, 2012
I have a drawing that has about 450 identical instances of a block. The block has visibility options to show different things. I don't want to edit the block as there isn't anything wrong with it.
What i need to is update the blocks all together to change visibilities.
View 3 Replies
View Related
Jan 9, 2014
I have a block that has to be update in a bunch of drawings -more than 20-. I updated in only one drawing, apply coy paste to the following but the block does not update in the drawing that I am pasting my new block. How is possible to update this block in the following 19 drawings?
View 4 Replies
View Related
Sep 6, 2012
I've made a block with fields linked to attributes (so when I change the value of the "master" attribute, the field values will change).
*NOTE* the fields are contained within a piece of MTEXT and NOT within another attribute.
The fields will not read the "value" of the attributes they are connected to, unless I explode the block (and change the DEFAULT value), or use regular text instead of attributes.
FIELDEVAL - set to 31
UPDATEFIELD - returns: "2 fields found, 2 fields updated" but it doesn't actually update them.
Regen/Regenall/Save - does nothing
BATTMAN - SYNC - does nothing
Lastly, I noticed that if I use "loose" text outside the block, but still link the fields (that are inside the block) to that text, they will update when I change the text contents after regen. AutoCAD is just having trouble using fields+attributes.
View 9 Replies
View Related
