I have tried this question before but it is now becomming a little more urgent. I would like to extract data I can see in a viewport then add it to the data it finds in the paperspace of the sheet. I don't want the entire drawing (modelspace) just what is seen in the viewport. Then do this process again and so on. 1 excel sheet per 1 sheet.
View 1 RepliesI work in a manufacturing facility and we are trying to come up with a way to extract data from an AutoCAD file in to a .KML or .CSV file which gives coordinate points, etc.
This will be used in a mapping-type software to display/highlight areas of the plant with zooming capabilities and information shown on the left-side. We are trying to make it look something like Google Maps, so it can used to determine areas of the plant undergoing work, lighting zones, etc.
In a nutshell, I want to be able to extract coordinate data from our layout(s) which can used to pinpoint locations on the map and highlight regions, etc. Perhaps it could export data in to Excel with attributes assigned to the coordinates which give Area, Bay Location, etc. The initial thought was to somehow export this to a .KML file and use that as a starting point.
is there any way to use data extraction and get the dimensions of the solid. Using dynamic blocks on 3d solid is not an option as far as i know. I tried using block with attributes and field which refer to a dimension line but it's too complicated and takes far more time than just check them by hand.
View 0 Replies View RelatedI enter data into an Excel job setup worksheet. I then want to be able to extract data from given cells in the Excel worksheet, and have this become fields in AutoCAD. I do not want to use a table in AutoCAD - I want (ideally) to have the Excel data come in to AutoCAD as a field. I can see that Data Links tends to come in only to a table in AutoCAD.
View 1 Replies View RelatedSeeing this error
Error on Line 10 : 'SealString_1' is not declared. It may be inaccessible due to its protection level.
Dim SealString_1 As String Dim SealString_2 As String Dim SealString_3 As String Dim SealString_4 As String Dim SealString_5 As String Dim SealString_6 As String Dim SealString_7 As String For Each S As String In SealString_1.Split(",") If i = 0 Then name = S If i = 1 Then name = OD If i = 2 Then name = ID If i = 3 Then name = DE If i = 4 Then name = LI i = i + 1 Next S
I need to extract data from AutoCad Drawing using C# or VB.Net.
I have a Title Block which is not inserted using attributes. It has some horizontal & vertical lines drawn to look like a table and text added between them. See the attchment.
I need to extract data from that and display in Ms-Excel or in a datagridview.
I am trying to write a lisp file that extracts the LAYER, Z, X, Y, TEXT HEIGHT, POINT NUMBER, from the attached DXF file. Ultimately I will have the lisp insert a "POINT" at the X,Y,Z, cords, and then a "TEXT" entity at the same coordinates with the text height value and the point number string. Both entities need to be on the layer ending in "-PN". The layer name will change depending on the date. I have a third party program that creates the DXF file.
The point of the lisp file is to insert the point numbers and points into my drawing at their correct locations. For the life of me I can not make this work. I have attached the little bit of lisp I have, which unfortunately does not work properly because of it searching for the "TEXT" entry in the DXF file of which there are three per point number. I only need one. I have also attached the DXF file I have. maybe just an overall procedure that I can then code myself? I'm just not good at getting lisp to read a file and extract what I want from it.
Is there a method of extracting XYZ data to use for CNC tube bending from components developed in frame generator ? I know that in routed systems you can export that data, but can the same thing be done with frame generator or any individual bent tube or pipe part?
View 4 Replies View RelatedI would like a lisp routine that can extract and export the x, y, z coordinates of all the points in a drawing into a text file so I can use the same in excel.
View 9 Replies View RelatedI have an excel document with a document header reserving rows 1-12. When i use "extract data" in autocad, i don't want the excel header to disappear. Can i set another cell than A1 to be the starting cell in Excel? Or how do i keep the header in the document?
View 5 Replies View RelatedI am trying to take a jpg file of an image, and write each RGB pixel color's value into a 3 component integer vector corresponding to the RGB components of the color for that pixel. For each pixel in the jpg, I wish to write the corresponding 3 by 1 integer vector into a matrix after which I plan to do a SVD decomposition of the newly constructed matrix to do an image analysis.
Any plug-in that allows one to efficiently iterate through each pixel in a jpg, and convert the pixel data to a RGB integer vector, and say write to a file?
Specific Details: I am using gimp 2.6 as my image editor, and wish to collect all the RGB 3 by 1 integer vectors (where each 3 by 1 integer vector corresponds to RGB color of exactly one pixel in the jpg image) into a matrix of integer so that I can do a reduced SVD decomposition of that matrix to analyse the pixel data: I wish to compare two similar images by using the SVD decomposition of integer matrices corresponding to the two images saved as jpg files pic1.jpg and pic2.jpg.
Can you extract the data from tracking/story editor outside of InDesign? I do a large catalogue and want a way to identify which product sets had changes made to them or not, but not just within story editor, but download the data to say a txt file or excel, etc.
View 4 Replies View RelatedI have been through all of the system variable field sources but cannot find one that stores the scale of a viewport. I want to add a field to my drawings that prints the viewport scale and updates it automatically if and when I change the scale.
View 3 Replies View RelatedWhen I copy a viewport in a layout it does not create another viewport, only a poly line.....
View 6 Replies View RelatedHow do I change a polygonal viewport to a rectangular viewport?
View 5 Replies View RelatedProblem: When I create a new viewport, another viewport's paperspace blanks out or disappears. When I copy a viewport over, the new VP doesn't show anything and you can't maximize/"enter" its paperspace; it's like a simple rectangle, but the properties box says it is indeed a viewport.
Ex. Viewport 1 shows the top view of an object, Viewport 2 shows the right side view... as soon as I add Viewport 3, the top view in VP 1 blacks out. I attempt to ReDraw, Regenerate, etc, but it doesn't re-appear. I've run Plot Preview to see if maybe it's just a fluke with the graphics card on my screen, but alas, even in plot preview the viewport is blanked out.
It almost seems like there is a limited number of viewports I can use.
Solution: Run the MaxActVP command and set the value to a number greater than the number of VPs you actually need. This particular file had that value set at 2; hence, why a new, third VP blanked out the first one.
I have a drawing with a viewport that fits to the page. And I created another smaller viewport over top that just shows the legend. Now when I try to double click inside the smaller viewport it always goes into the larger one. I have tried bringing the smaller one to the front but that didn't work. I know that I can clip the larger viewport around the smaller one or bring the legend right into paperspace or slid the smaller one off to the side work in it and slide it back. This is more out of curiosity of how to get into the smaller viewport.
View 2 Replies View RelatedI am wanting to insert a second viewport over an existing viewport and have the information in the existing viewport behind the second viewport and not seen. I want the second viewport boundary to be the "trimming" edge of the existing viewport. How do I do this?
View 3 Replies View RelatedI did a test drawing with 4 viewports in paperspace.I frozen a layer in each viewport (as a viewport override, not global), and wrote code to gather info on layer overrides in viewports.The function takes in a database, and is generally used on drawings only open in memory:
public static bool GetLayerInfoFromDB2(Database db) { //do viewports on layoutstry {using (Transaction tr = db. Transaction Manager. Start Transaction()) { ObjectId ldid = db.LayoutDictionaryId;DBDictionary ld = (DBDictionary)tr.GetObject(ldid,
[code]....
the odd thing is it never finds the frozen viewports on the first viewport. It catches the others fine.I cannot see anything odd either, the counts of viewports and layers are all correct, and the drawing has no problems.Is there something that must be done to initialize the mechanism that reads viewport overrides?
how do you create a viewport within an existing viewport ?
View 9 Replies View RelatedI 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.
View 2 Replies View Relatedi 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.
View 4 Replies View RelatedI'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.
View 2 Replies View RelatedI 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.
Is there any automated way to transfer this data?