AutoCAD Map 3D :: Merging Data From One Data Set To Another
Dec 14, 2011
I have a table setup in Autocad map and am entering attribute data for the objects (Polygons). I have received a new dataset which I imported as points into the drawings which sit inside in the polygons. The points imported include one attribute data field that I want to get into my table.
In practical terms I am entering data re building heights, received a lidar file with point data relating to the building height.
I do have a scene with CAD data in it, some of it is collapsed to poly some of it is left as mesh. Now i want to import this data to a scene with a different scale. When doing so, some parts of the object become very large while others shrink to minimum. Only a few parts stay at the correct position. These follwing steps I tried to correct the problem:
- Linking everything to a Helper = FAIL - Attaching everything to one Object = NOT AN OPTION - Collapsing everything to Poly or Mesh = Fail - Grouping = FAIL
Is there anything else i could try to get this dam file merged? Like a Pivot Point Reset to World? Match Scale Pivot Reset...
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.
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
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 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.
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 am working on parsing the psd file and saving the data as per doc of photoshop 6. I need to make an image from the layer data alone with different combinations of layers selected, visible etc... and not using the merged data section in the file.
Without using scripts, is there any way to have rectangles or textboxes act on values coming from a data file? For examplle if the value in a textbox was greater than 10 coming from a data record, could the textbox change color, or any other attribute to make it change from record to recortd as it is being viewed or printed?
I'm creating a catalog, using data merge in InDesign CS5.5 for the first time. I'm using dummy data to start, naming the products with a naming convention Product 1, Product 2, etc.
Everything seemed to be working, but then I noticed that the merge is all jumbled, such as:
Page 1 has Product 15 repeated, with the product description, price and other information from product 6. This repeats five times down the first page.Page 2 starts with Product name, price and number for Product 7, but the description for product 6. Continuing on page 2, everything seems one off. Product names mixed with data from the next product. Page 3-15 are the same as page 1, all Product 15 with the description for Product 6.
In short, this is very weird. I am saving the data in a CSV comma deliminated (also tried text with tab delineations.) I don't think there are any text breaks in the data, nor blanks. The odd thing is also that the preview looks perfect before I merge the document.
Here's Page 1:
Here's page 2:
By the way, all numbers (except pupil price) relay the product number. For example, Product 1 has a price of $1.00, an item number of H1, and the description "This is product 1".
I have some cad lines/blocks that have a data table attached to them. I try to publish to a dwf with object property data (included). When I open the dwf I can not find the object data. All the object data is checked to be included under output dwf options.
What are the steps to get a dwf with object data attached to it?
Ive setup some blocks which have attributes and have been successfully using a template to extract the data for a while. I just created a new block and tried extracting the data. All works fine except for BL:NAME returns '*U' instead of the block name. The block is called 'SM'. Is '*U' a code for something?
We have this public server in Indiana that I am trying to figure out if Map 3D will connect to. The directions on how to connect are here: [URL] ........
If Map 3D 2012 is able to connect to this data? I cannot get it to work, but I am not a Map / GIS expert by any means.
I've got a routine that gets the surface, I can rename the surface, get the min and max elevations,... But when i want to add a ContourData there is a problem.
I set up a SurfaceAnalysisContourdata (see code below), when I try to add the maximum elevation to the array I get the error "Object reference not set to an instance of an object"
Dim cdata(0) As SurfaceAnalysisContourData cdata.Initialize() With cdata(0) .MaximumElevation = TextBox1.Text 'Maximum surface
I have a problem with autocad WS on Autocad 2012, I've used a workstation of a colleague of mine, and I access to some personal drawings thru the "online" tab, unfortunately, when I press the "online drawings" and a popup windows appear to ask my Autocad WS data, I forgot to uncheck the "Remember my data" and now every time I click on "online drawings" it connect to my Autocad WS account.
Is it possible to remove my data from Autocad ? I tried to click on Logout on Autocad WS but it doesn't work.I have several personal drawings on it and I don't won't that my colleagues open or modify them.
Is that possible to read the Autocad Table data , without opening the Autocad from VB.NET. I tried with opening one autocad then loading the source dll. it was working perfectly.
But i need to without opening a application its possible or not?
I am a new c sharp developer. I want to create a program in C sharp, which can communicate with autocad, when I do click in some area of the drawing, I can call to the c sharp program with the information of the object selected, for example I want to know the four utm coordinates of a rectangle,with those coordinates I want to search in a sql server database, which contains information of the object selected, for example if I select a rectangle, the database must contain the name of the owner, location and display to the user the information.
Otherwise, I want to open the program in c sharp, doing a searching via name of the owner and I want to open the dwg file that contains the utm coordinates of the name provided.
I am having issues trying to print a file from LT2014 in which I have overlaid my drawing on map data. The satellite image is scaled and located correctly.
The problem I am having is when I go to print the file, the satellite image shows in my viewport but when I print the file it is only my original drawing that prints without the map data.
Is it possible to print map data or am I just overlooking something?
I'm trying to connect to a mysql database and I get this warning : "There was a problem accessing the connection's schema information. Item AREA is already in this named collection."
I've created the attached table (used as legend in drawing, to point out revisions).
Cells in second column from the left are set as data dd/MM/yyyy, so when I change revision I write current data and it give correct format.
The problem is that every time I change layout and come back (or every time I open the drawing), data in empty cells were set to 01/01/1970...but I want them empty.