AutoCAD Civil 3D :: Create Figure Prefix Form Excel Spreadsheet / Access
Apr 19, 2012
Is there a faster way to create figure prefix i.e form excel spreadsheet or access.
I have one tip also. When you modify the figure database "C:ProgramDataAutodeskC3D 2013enuSurvey" by using notepad and you add "*" after each figure it will connect during linework codes that much the prefix code and will exclude the integer, EPN1 and EPN2 will be treated as EPN
I am using AutoCAD Civil 3D 2011. I am wondering if there is a way to assign an mline to a figure style in the Figure Prefix Database. Ultimately I am trying to create storm drains that have a width automatically (ex. 12" SD would come in at 12"). Right now I have a single center line that comes in and I manually offset the line to create a width or I place an mline over the center line.
I am trying to work on my figure database and have run into an issue I don't understand. Curious as to weather or not it's something I am doing, or just a bug.
I wanted to look at every possible line that could be imported so I created a dummy point file using the Figure prefix data base and imported it into one of my blank templates and ran into to curious issues.
CP is connecting to AA
OC only connects if the point has an identifier behind the OC, for example OC01.
Here is a copy of the figure database and point file I am using. I understand you will not have my layers, but the connectivity should be the same. Let me know if you need anything else.
I am running Autocad Civil 3D 2012. I created a figure prefix database that our surveyors were familiar when coding in the field. It is a numeric code list. I received a survey last week that had 6 break lines coded in the point file. Only one of the 6 acts as a break line.
All break lines start and stop with the right line work commands but they fail to break crossing triangle legs. I've checked everything I can think of and the setup looks correct . The only difference between the one break line that works and the others is that break line has sequential point numbers while the other break line codes are scattered throughout the point file.
I have Figure prefix of GPNT for painted gas line and GP desciption key for Guy Pole. Imported survey text file, linework for GPNT came in correctly but at each shot the symbol for GP (Guy Pole) came in. Is there a way to fix that without creating a description key for GPNT. Have others with the same situation. Wanted to avoid adding description keys for items that were displayed all the same.
Civil3D 2013 Windows 7, 64 bit Intel i7 2600 @ 3.40Ghz 16 GB RAM Nvidia Quadro 600
Recently I upgraded to 2013 and I been having some issues with my survey DB, first of all I created a base data shortcuts project template folder with all my folders and a default Survey DB.
once I create my project, and import points to the default DB, I have no access to the Figure Properties. Is this feature, that worked in 11 & 12 now broken in 13? I have gone into the setting and copied a new files to the folder several times, to no avail, and there are no other versions of C3D on this machine.
So now that I have my points in the drawing, I go to translate them to my survey, generally I will utilize line in the drawing between field data, and platted data to translate and rotate to the platted lot or lots and the work from there on any calcs or changes. However, when my OSNAP toolbar is docked and locked and I go to select a point line the midpoint, I have no access to the OSNAPS. This also, worked in 11 & 12, but seems broken in 13.
I am looking for a way to use the .dwg file properties of a drawing to generate an updateable drawing list/register. One that will update automatically as the file properties are updated. I have already created a title block that uses text fields to display custom properties of the file on my title block, such as the job no., drawing no. etc.
I have searched the web for answers, came across this site, joined and searched through it... There are a number of threads that 'sorta' deal with my needs but alway tend to digress more towards the "poster's" needs and away from mine. I noticed that they all talk about Lisp Routines and I have no knowledge of using them. Is that the only way to go or can I use another route? Another one was the Sheet Set Manager but I don't think that this is exactly what I am looking for...
Trying to figure out the best method to insert an IDW into an Excel spreadsheet without sacrificing quality. I have tried several methods to go straight from Inventor(2012) to Excel(2010) using print PDF at press quality, export JPEG, and even the snipping tool as a last ditch effort all of which inevitably loose all line quality when inserted to Excel.
I have only had success bringing a PDF from Inventor into Adobe InDesign where I am able to mimic the design of my Excel spreadsheet and create an additional PDF to include with the Excel document. It seems like there would be an easier way for Inventor and Excel to work together without sacrificing quality or adding additional steps.
Got a new computer, put AutoCAD LT 2010 on the machine, justlike the rest of the office, but also installed excel 2010, when the rest ofthe office has 2007. when insertinglinked spreadsheets from the new computer, and we update the links on our oldcomputers, Acad fatal errors out. Thisis because of the difference in the excel versions correct?
I am trying to export some data from my BOM. I require the part names, quantities and lengths. I have followed a previous topic in these discussions which is now closed. it seems simple to follow but requires me to click on the export BOM icon in the top left of the browser. In my instance this is greyed out. D
Using AutoCAD 2010, and I'm having problems printing with one dwg, that I've had to copy an Excel Spreadsheet into. The spreadsheet was created with Excel 2007, and has quite a bit of text in it, and I'm trying to print it on an E size sheet, to an HP Designjet 4000. AutoCAD hangs up each time I try to print this, and my computer gets a message indicating that I'm low on disk space, even tho I do have plenty of space. It's like Autocad is taking more resources than it normally should. How I can insert this spreadsheet into AutoCAD and be able to print it? I've inserted the spreadsheet in model space, and the titleblock/border is in paperspace. I've tried printing to pdf and exporting to other formats to see if that will work, but AutoCAD keeps hanging up. Any other AutoCAD dwg works fine to print to the printer. It's just this one file with a spreadsheet inserted into it.
Im struggeling with creating a code that opens a certain Excel spreadsheet and retrieves / inserts info.
the spreadsheet is a list containing part numbers for purchased components, therefore the list must be filled with information from iproperty. But it has to be where the next available number is. i had this working in iLogic, but have to move it to VBA for better use. the code that worked in iLogic is this one.:
If possible it would be nice if the code at the same time retrieves the new partnumber and saves the active part as this part numeber...
I am working on a gearbox design that requires multiple iterations on the shaft dimensins and other parts, so linking the dimiensinos to a spreadsheet would make this easier. However, I'm using the design accelerator for the shaft and other components and I cannot find any information on how to connect the dimensions I enter in that design accelerator to a speadsheet.
I know how to link to a spreadsheet for a regular component, but haven't used that much.
I need to find a way to export my BOM data to an Excel spreadhseet. Some of my BOM's are in tables, most are not. I found a lisp routine that will export this data to a csv file, but it's clunky at best. I don't want to use the "ole" method, I don't feel like fighting that battle.
So outside of plotting to a "png", and pasting that into Excel, are there any other options that are feasible?
I've previously used Autocad 2008 Electrical. I've just started a new job and I have been asked to update some electrical drawings from a recent project. My current employer use Autocad 2010 as opposed to Autocad Electrical which I have previously used.
The problem I have is that I have a drawing with a table linked to an Excel spreadsheet that displays an I/O table.
Since the drawings have changed the amount I/O has increased.
I have a new excel sheet with the new I/O list which is larger than the old I/O list.
When I "point" the Table to look at the new spreadsheet in the "Modify Excel Link" Dialogue and alter the "Link to Range" Tab to my new desired excel sheet and apply the changes the table. The new excel sheet populates the table correctly until the end of the old table used to stop then the format goes all to hell and the new part of the table is way out of scale and at 90 degrees out to the original table.
I think I am possibly missing a step somehwere when updating the Data Table Links!?!?....Do I need to alter the table properties somewhere too?.
I created a spreadsheet of about 40 rows to be used to create different parts. I then created a part "we'll call it Board_A". I linked to the spreadsheet and used 3 of the fields for my dimensions. Lets say I named the length (which was the extrusion number) as "Len_1". I saved it and all is well!! I then created other parts and used the spreadsheet for the dims. I then went back and opened "Board_A" and saved a copy as "Board_B". I closed Board_A and opened Board_B. I then rt clicked on "Extrusion" so I could change the length from "Len_1" to "Len_1_A" which is another row (field) on that same spreadsheet which is still linked. When I tried I received a message that said I couldn't do that (I forgot the actual message!) I clicked the Parameter icon and the only fields showing on the popup spreadsheet box were the ones I had previously used for those parts that I made from scratch. I thought I figured this out once but if I did I forgot. I deleted the spreadsheet link and then re-added it but nothing I have tried has worked. Is there a way to get these fields to be usable with a Copy of an existing part or do I just have to start from scratch and make the similar part?
I have a map in AutoCAD and I would like to fill certain sections of it. The colour that I require the fill to be changes according to varying data in an excel spreadsheet. Is there a way of linking the two?
I would like to create surface from contours and extract points (with value) from on it. I had contours in my drawing; each major and minor contours are single polyline with elevation (Z value).
If I create surface form CONTOUR, some polylines (major or minor) are not included in to surface. After the creation of surface, I tried to erase the existing contour lines (Polyline) from drawing but the surface will be disappearing.
If I create the surface from ''DRAWING OBJECTS'', I'm not able to select the polylines (attachment 01) .