AutoCAD Map 3D :: VBA - Changing Column Definition Of Object Data
Jan 23, 2006
I have used the example of Map Object-data. I try to change the Object-data definition from a character to integer to do other querys.
How Do I have to Change the Column definition of the object-data? Where I have to add the definition "as integer" or "as long"?
Set amap =
ThisDrawing.Application.GetInterfaceObject("AutoCADMap.Application")
'Create OD Table Definition
Set ODfdfs = amap.Projects(ThisDrawing).MapUtil.NewODFieldDefs
' Add Column Headings and Defaults
I continue to suffer project downtime and setbacks due to a variety of defects in the software. Here formula columns are not working. I created a Formula Column for simply computing ItemQTY *Item Cost in a Data Extraction table for a current project.
QTO is defective, and now Data Extraction is not working. What does the product leadership expect us to do for quantity analysis?How can Quality Control of this software significantly improve?
I would like to link an Excel table to a SHP file via a column in commun. My SHP file and Excel Spreadsheet share one same column filled with numbers. So it's neither simply import Excel table, nor import with points.
But I don't know if I should use "Data Link" or "Add ODBC connection" or "FDO import", or some other fonctions...
I'm trying to change the value in the description column through the formattedtext but the final result is not what is supposed to be, this is a part of my code.
Sub HoleTab()Set oDrwDoc = ThisApplication.ActiveDocumentDim oSheet As SheetDim i As IntegerSet oSheet = oDrwDoc.ActiveSheetDim oHoleTables As HoleTablesSet oHoleTables = oSheet.HoleTablesDim oTable As HoleTableDim oTableRow As HoleTableRowDim oTableRows
I tried to use the command "Remove Material" from the rippon, and I get no rsponse, and deleted the material from the palette and yet the material there, How can I get rid of the materials I attached to the walls?
I am using beam/column calculator in the frame generator in inventor 2010 suite.I have a beam being used for a flight of stairs it is positioned 40 deg above the 'floor' or my xy plane in my assembly.I want to place a distributed load acting as if there were several people stading on the stairs at one time so in the direction of the z axis of my assembly. The problem I am having is I try to change the angle of the distributed load but it only allows me to change the x and y components of the load.
a) change the angle of the laod in the Z directions
or
b) change the cordinates in beam itself so the x axis is along the length of the beam instead of the z axis.
I have tried adding a UCS to the beam part but it still wants to choose the length of the beam as the z axis.
I am trying to create a property definition that will display the elevation of a space object. I looked through the automatic properties and did not find anything that looked like the elevation.
I have tried the following but was unable to achieve any success.
RESULT="--" On Error Resume Next Set AcadApp = GetObject(, "AutoCAD.Application") Set Obj = AcadApp.Activedocument.Objectidtoobject("[ObjectID]") RESULT = Obj.elevation
That formula does work if i swap elevation with say height, width,length or any of the properties found in the automatic property list that are a single word. I know the elevation is there I just don't know how to access it.
I've been having this issue happen repeatedly, but not consistently. In a new file, I adjust the width of an mtext box so that the text wraps into multiple lines. When I next open the file, all mtext boxes are back at a wider width so that the text is all on one line. The start of the text is also usually in a different location. This was happening on 2011/XP and now on 2012/Windows7.
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.
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.
In most cases this works well. However I found a case that it not work as well. When I try to change the definition from a new block that I have created in my test DWG, it disappears from the model.
In Bill of material i have custom PartQty column and is beside QTY column. I need all informations from QTY column to PartQty column to copy. Possible with iLogic? I'm selecting now manualy copy and paste but it would be nice to have automatic.
I'm not sure what I did to make this happen or how to change it back, but for some reason when I change the size of an object/line it changes the stroke weight as well. (For example, if I drew an ellipse with stroke weight 2 pt, and then increased the size the stroke weight would be 2.856 pt or some such number instead of 2 pt.) How to change this back?
After I import different files in my working file, it's getting hard to work- RAM(16GB) is getting completely full and its almost unworkable! I checked out Object Manager and found stack with "SVG data" and "Locked SVG data" object there under some basic shapes.
Stack is about from 10000 to 100000... Some times even more, but its not possible to select all them because Corel just stops. What is that- "SVG data" and "Locked SVG data" object and why they are so many there?
I am trying to publish to the CC a guide rail. The vendor of the rail gives me the option of entering the desired length of the rail. After that he gives me the option to choose between the length that I entered and a shorter and longer standard length witch can be delivered faster.
I want to do the same thing with my published part, but I cannot make a key parameter to change depending on the entered custom parameter. I want the user to make the next steps when inserting from the CC: 1- select the size of the rail; 2-select the type of the rail; 3- enter the desired length of the rail; 4- choose between the desired length and the 2 recommended lengths (I need these 3 lengths to be shown)
I have created a table style in ACAD 2012 with all of the cells formatted to what I need. The trouble begins when I bring in a BIAS excel data link to populate the table. I have tried every option in the insert table steps and have even tried all the different options under the modify excel link options. I have toggled the use excel formatting on and off, which does change the table size a small bit, but does not allow the table style to take affect.
I have attached a screen shot of the "good" and "bad" tables. The bad table is what the good table comes in as and it is also what happens everytime the table link updates. It always reverts back to the bad style and then I have to change the table back to the good one by hand - changing each column individually.
Is there a way to attach a data link to a table with the table style holding its shape and formatting?
This happens on all of my drawings and using all kinds of different excel links.
I have 45 PCs running Autodesk Inventor 2011 in a student PC lab. We have since set up Vault Server and I need to change the location that these point at.The files that I need to edit can be got to by:
1. Open Autodesk Inventor 2. Click “Pro” 3. Click “Options” 4. Click the “File” tab 5. I need to edit the following: Default templates, Design Data (Styles, etc) and Default Content Centre files. 6. The above three will be pointed to a server that has vault setup on it (\vault emplates, etc).
Now to clarify, Inventor works, I do not need assistance activating it, and I do not need assistance with group policy to set up the install..I need to be able to modify the above with group policy through either the registry (if possible) or some other method.
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.
I have an object with an Object Data Table attached filled in with information. Is it possible to copy the table and information from that object to another object? Tried the obvious, Match Properties, and it did nothing.
