AutoCad :: Object Data To Attribute Data To Perfection?
Oct 15, 2010
I'm working in AutoCAD Map 3D 2008 and Autocad Civil 3D 2009.
The General Task:I want to convert the object data to attribute data so that I can export it to an Excel file, add another column of data, and then import that new data as attribute data.
The Specific Task:I have thousands of campus water meter locations (a block with a small icon, attribute data, and object data) that belong to two different systems, domestic water and lake water. Each of these blocks has object data item (a barcode tag) that I want to show as a label next to the block.
However, before I do that, I want to export that barcode data to an excel file so I add a column (eventually a new piece of attribute data) that says whether or not that specific water meter is radio read or manually read. I want to then import that radio read/manual read excel file back into autocad and have an X appear on the block icon if it is radio read. I also want the barcode information to show up as a label.
My problem:I can't get the barcode object data to export with the locations in one easy excel sheet that I can simply import after I have made my changes.
Find some person on here who knows how to convert object data to attribute data.
I have imported a shp to dwg. it has the object data attributes.
Suppose I have a point for cities shp imported to dwg. The attribute has name of the city. How can I display the name of the city to each point on the layer of dwg file.
how to import point data that has Map Object Data also attached to it? "import it by attaching to a data source".
Example: I have a bunch of manholes. Each MH has X,Y,Z, but also Type, Invert Elevs., Pipe Sizes, Pipe Materials, Pipe Directions, Structure Type/Material, etc. etc. etc. I may have point data representing MH's, airport runway ends, trees, anything you can imagine, with all kinds of data imaginable.
I want to import this data directly into Autocad/Civil 3D as either Autocad points, lines, or closed polylines (I also have utility lines, parking lots, etc.- all with data associated with it), all with the data attached as object data. I know that anything more complex than points might be hard to explain here, so I am hoping at least for a solution on how to import points - I have 99,999 MH's and obviously I don't want to have to type all that data in one by one.
I basically suck at using sql server. I can get around using the Map workspace and the different tabs. I have never used FDO, and I am not even sure what it is.
I fooled it today by creating 99,999 Autocad points at the correct XYZ, attaching the correct object data to them, then exporting as a shp file. I went into the shp_name.dbf file and edited it to add the data I wanted by cutting & pasting from Excel. then I re-imported the shp file. but, this is a workaround at best.
Surely Map can import objects and their associated data fields, all populated with valid data! all I need is to know how to do it. I mean, if this is not something I can do directly using Map commands should I take the money I earned by surveying 99,999 MH's with my GIS data collector that allows me to assign 101data fields to each object I survey, and buy something better?
C3D 2012 on 64bit Win 7 all up to date Dell Precision 7core 8GB RAM NVIDIA Quadro FX 1800M LDT/C3D user since release 12
I have a drawing with Objects that have both Object Data and Linked data in an Access database. I need to get information from the linked table to a new linked table for each object.
I have thought that if I get the necessary information from the Linked table record to the object data for each object, I could then convert the Object data to a new link and am looking for a way to copy the data from a field in the Linked Table to the object data. There is at least one field common to both the OD and Linked Table record.
In my company, they have just upgraded the old version of Autocad LT 2004 to the new 2013 and we have created menu to make our job easy. I have try to transfer the menu file .mnc to 2013 but it's not working or I don't do it the right way.
Possible to send attribute data that is in our title block to a schedule that is populated with property set definitions? We are not using the Project Navigator at this time.
I need to create a small table to ID the User, Computer name, Door Key, etc for a floor plan drawing of our office. I'd like to get this done in Excel and link it all so the bldg manager can make changes to the drawing without me. I have created the excel file and created a "name set" in excel for each room. In Autocad 2013 I have inserted a table from a data link and pointed that link to the named range of the room (the named range in excel is an 8 cel block with al the info I need repeated and uniquely named for each room.
This works great...so my next step is to create a block out of the table and make the DATA LINK a variable attribute...that's where I'm stuck. i cannot figure out how to do this. I would love to be able to INSERT BLOCK and have one attribute question...ROOM NUMBER?. That should look to the excel NAMED SET the corresponds and populate the table.
we have a block that we use to identify rooms. that block has 3 attributes: rooms name, rooms number and surface area.
A former colleague once showed me how to do this but I can't reach him... How can I inquire the data from an area and tag-it right to the surface area attribute of my block? I don't mean pick a pline, list and edit the block... it's something like pick the closed pline and the "area" data is displayed in the right tag of my block?
I wanted to get a few opinions regarding exporting data.
We are working with AutoCAD 2013 Vanilla.
We have dynamic blocks with attributes that contain the block Name, Size, Color, material etc...
What is the best way to export the information?
Schedule and linked to a spreadsheet?
(I have experience with schedules but not so much with linking to spreadsheets)
DbConnect? (I know very little on this)
Another way to ask the question;
What is the best way to export the data that I can successfully train 20 designers on how to do it correctly.
So part one is determining the best method,
part two is training a group of designers to use it correctly.
I worked on getting a schedule out and linking to a spreadsheet but even after talking to my reseller support I feel that is too cumbersome. I would like a more streamlined process, you know the one, click here and presto!
Is there a way to edit the an attribute data if it is defined as number to add a value of .3 to the number being displayed in this attribute box. The feature is a point and i'm looing to add the .3 value to elevation attribute value that weren't pulled from a surface or created using object data.
How to choose the attribute or field data from a list?
When using the “title block”, attributes and fields to better control the information that belongs to the drawing, then it worth to have a feature that allows selecting this information from a LIST.
For example, if we need to specify “location” of the project, then it is better to have sort of list from which we can select the location of the project the same we do it in the Excel (as shown in the screenshot below).
Is there such feature in the AutoCAD? To choose the information from a list?
This was my first go-around attempting to create a custom tool palette for our office. Everything was fine, the palette worked well. All of the block libraries and associated files were initially saved on my local drive. I then moved the files and folders out on the network, repathed all the items on the palette to the new area but for whatever reason when I insert blocks that have attribute data attached It is not recognizing it anymore. I am just trying to get this piece straightened out before I export the palette itself out to the network to share.
I am currently trying to make my AutoCad more powerful as a tool of Engineer but not Draftmen (My boss never thing about it, I could only get a standard AutoCAD, not AutoCAD-EMP).
I want to make it a tool for myself to analysis the building system, with excel (and VBA)
The first tool I wanted to create is an underground drainage capacity analysis tool. But I meet the first difficulty, how can I automatically transfer the information inside CAD drawing to the excel?
Say, There is a drainage system with 2 manhole and 1 pipe, the Manhole have 3 attribute : Name, Model, Level, (and the X-Y coordination), I Create a Block with attribute "Name ; Model ; Level". and then I insert the Blocks and place it in correct location inside the Layout Plan.
How can I create some script to "Scan" all Block inside the drawing and make an excel file with data like:
I am trying to find a way to programmatically move our AutoCAD room tag attribute data to new AEC space property sets. I work in a hospital that has approx. 1 million s.f. and over 3000 rooms. Obviously a daunting task to do room by room.
I have a drawing template (block) where the drawing number is displayed in two locations (attributes). The same value has to be entered in both attributes.
Is there any way of "echoing" the data from one attribute to other attributes (or text objects)?
I have attribute data that is entered as a format of 25-6. I need to make these into feet and inches, 25'-6". Is there a way to update these attributes globally or even at least by choosing the block itself? The only thing I can think of is find and replace and I just feel there has to be a better way.
Seems like Multi-View Blocks are like that hot red-head in high school that you really want to get to know until you get to know them.
I made a bunch of blocks for my electrical plans. Annotative symbols for plan view, 3D blocks for model view, and elevation blocks for elevations. I then started creating the MVBs.
Upon insertion the annotative blocks appear super small and the model view blocks scale way up. The model view blocks are not annotative and are not supposed to scale at all. It seems MVBs see any block inside that is annotative as an indication that the entire MVB shall be annotative. Fustrated, I finally found a work-around that is a bit half-arsed:
I made another block as a sort of holder for the annotative symbols that was set to not be annotative and inserted that into the MVB. VOILA! the MVB itself doesn't scale, but the annotative symbol inside the non-annotative block does. This works fine except for one caveat: I can't edit attributes that are in blocks inside of blocks. If I made another block to use in the MVB for the attributes, it would work, so long as I don't make it annotative, which isn't what I want.
So, A) is there a better work-around than the block-in-a-block-in-a-multi-view-block method, or B) Is there a way to access and edit attribute data of sub-blocks inside a MVB?
Maybe my next thread will be about red-headed Multi-View Blocks with carpets that match the drapes.
I have a master shape file that contains parcel ID, owner, tax info., etc. I have another file ( access 2003 -open to better file format suggestions-) which contains parcel ID and a "yes" or " no" entry for whether or not the parcel needs a new water meter. All I want to do is add the water meter information into the other shape file. This would create one shape file with one table with all the information that I need.
Ultimately I will use the information to do a map query and find out spatially where i need new water meters.
Right now i have the master shape file connected though the “Connect to Data” feature. I also have the new data added to the drawing though the Data sources------>attach under the “Map Explorer” Task pane. I attached access file (ver. 2003 .mdb) which has two columns “Parcel ID” and “Meter”.
I right click on the shape file under the display manager and select”Create a Join;” however my water meter table is not listed as an option. Will this not work?
Plan B - I tried to Create and connect to the access file as an ODBC connection. Followed this guy’s directions to a T [URL]. But when i populate my table under the fdo connection the column headings exist ( “parcel ID” and “Meter”) but the actual data is missing. Am I missing something important?
Note: I am running c3d 2012 on a Win 7 64 Bit machine. I also removed office 32 bit apps and installed 64 bit apps to see if that would solve the problem. No go.
say you make some parcels in your project with custom data fields like: id_no, permit_no, acres_served etc. you attach an agency provided shape file via an fdo connection that has many fields of information like above.
when you right click on your parcel and do parcel properties you get a tab that lets you input the custom parcel data.
lets say you print an fdo map label showing, say, the id_no, provided in the shape file. Then in your custom parcel properties for id_no you type that in.
is there a way to make an expression to put in the other custom parcel properties that will read, say, the permit_no(id_no) from the fdo like and put that information in the custom parcel property field?
I'm having problems getting super elevation data to transfer to different drawings by means of an alignment data shortcut. I know alignments hold the super elevation data so I've gone into my alignments data shortcut, input my super elevation data, saved and closed. Now when I open my finished grade drawing, reference in my alignment and profiles, then create a corridor from that information, my super elevation didn't transfer with the reference.
I pulled cross sections and it appears is has no clue there is any super elevation data. Also, I tried bringing it directly into the drawing I'm doing my corridors in and it erred saying I must be in the parent alignment drawing. Data shortcuts are pretty much useless to me if super elevation data doesn't transfer.
64 bit Windows 7 Intel Xeon (R) @2.8GHz 6.00GB Ram Civil 3D 2012 Civil 3D 2012 Intel(R) Xeon W3530 @ 2.80GHz 6.00GB Ram Windows 7 Professional
I am trying to link my extracted data from blocks with attributes to an extenal source so that the table I create and place into the drawing already has the formulas I need to due the required calculations. But every time I create and place the table the formulas are not in the table. I include the columes that contain the data but it doesn't seem to be working.
i have created a data band in profile view that should show a created profiles elevation, but some of the the data fields are missing irregulary. Also in the data band that shoud show the diferenece betven the tow profiles - EG and the new profile the data is missing. The EG profiles data and the surface are ok all is shown.
I've just installed Civil3D, 64-bit on windows 7(running on bootcamp) and am trying to insert a georeferenced raster image but have encountered some issues.
1. "Home tab>>Data panel>>>insert An Image" - The data panel is missing and it's also not found in "customize palettes"
2. Trying the data connect route does not work either: Display manager>>>Data>>>Connect To Data - There is no 'Data' option and I cannot connect to Data.
Is it possible to embedd data in a table so that a user can select from a group of data within one cell?
I use this technique quite often in Excel. One cell in a table can have various values: A, B, C, or D. While another cell can have a different set of values to choose from: BLUE, RED, ORANGE, or PURPLE. The user can pull down an arrow (similar to a dynamic block) and choose from a set list of values.
I know that the xmls are very important in the design data folder and we shouldn't mess with them.What about the rest of the folders. I have around 11 folders. GOST, AEC Exchange, AIT, Cable & Harness, Bend Tables, DWG-DXF etc...
I need to know if any of these folders can be deleted? We don't use AEC Exchange, Cable Harness, BIm Exchange, Design Accelerator, Tube & Pipe.
What about the Optimisation, DXF-DWG. I am not sure if I am using them unknowingly.Does this could be deleted? Is there a procedure to get rid of them.
I found a lisp to get block attribute data to a other block. See attachment. I can only apply it to one block. I like to apply it to selected blocks or blocks in a group. Is this possible?
Is it possible to add data to a feature data table? Example: The shape file data downloaded from NRCS only has the Soil number for the State. As I check out features I would like to add data for the soil name, soil group, etc. as additional columns in the data table and have it available in the future by checking the feature back in to my local information.
I have object data attached to some linework and I want to copy that data to some new entities.Is it possible to copy object data from one entity to another with out having to fill in the table again.
We need to take polylines from AutoCAD Map 3D to 3ds Max and rename each polyline to have a name of something like "Building Number-Room Number", both of which are defined in our properties for each polyline. Because none of this data is kept on import to Max, we need to do this all in Map 3D, which we are not experienced with. Is there a way to do this, and if so what? We are importing the .dwg files in Max with polylines as splines.
