AutoCAD Civil 3D :: Export Alignment To Excel As XYZ Data?
Jun 19, 2012
I was trying to export my alignment, at certain intervals, to excel (or text) as xyz data. I tried searching and found... Alignment to xyz
But it didn't really work. I can export the XY but not the Z in the report manager.
So my questions are.... How can I create a new report to incorporate the Z? Or is there another way to do it?
I should add I also tried the "Incremental Stationing Reporting" from the Profiles Report... However it doesn't recognize the profiles I've created? I get the "No FG profiles in....." even though there are?
View 7 Replies
ADVERTISEMENT
May 31, 2012
I need to export to an Excel Spread Sheet (along a 15,000 foot alignment) the Station and Norhing-Easting at every 100' station tic. The only solution I can think of is to place a point at every 100' tic and export the points to a file. I can then put in Excel and edit the point number to reflect the correct station.
View 8 Replies
View Related
Feb 5, 2008
Is there a way to export the band data for an alignment with two profiles? I have an existing ground and a proposed profile. Can I export the station and elevation data from the band for both profiles?
View 9 Replies
View Related
Jun 9, 2010
I am using Civil3D 2010. I am trying to export the offset/elevation data from my cross sections to a text file or excel file so i can paste the info into another program. so far i've been labeling the offset/elevation info on the section and typing it into excel by hand.
View 9 Replies
View Related
May 3, 2012
I using a data reference/shortcut to properly label an alignment in paperspace. However when I reference the alignment in and apply the labels the aren't the same as the original alignment that I am referencing. Is there a setting where I am supposed to apply a new beginning station.
Also it seems as though the stationing(distance) isn't even matching up 1:1 with the original drawing. For example in the original base drawing my alignment starts at 10+00 with the next PI at 14+76.98, but the stationing on the reference alignment starts at 0+83.33 with the very same PI being labeled as 1+23.08. So the very same distance is 476.98' in the real design and the drawing it's being referenced in, but the stationing of the referenced alignment shows it as 39.75 Units.
I've attached a screen of the beginning of the alignment.
Civil 3D 2012
Windows 7 Service Pack 1
Intel Core i7-2600 CPU
16GB RAM
View 5 Replies
View Related
Sep 15, 2011
I have been asked to write a module that will export layer data from AutoCAD and put it in an Excel spreadsheet. The user wants to have this done through a macro. I am assuming that I need to create a dll that is called from inside AutoCAD but I am not sure.
They want to start with AutoCAD 2008 and once we get it working there we will convert it to 2011 or 2012.
First of all, I can not find the 2008 API and second of all I'm not sure where to start. I am very experienced at programming. We are going to use VB.NET.
View 9 Replies
View Related
Oct 13, 2011
Can I export the text from autocad 2012 LT to excel file.
View 1 Replies
View Related
Oct 9, 2012
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?
°°AutoCAD Rel 1 - 2014°°
View 6 Replies
View Related
Feb 28, 2012
I have a object data table attached to many polygon. In this table i have 2 line of data. I want to export in a tabloid like microsoft excel. I know autocad have a command to do this...
View 7 Replies
View Related
Sep 4, 2012
I have Export data from dwg to notepad lisp programe. But i need lisp programe for Export data (Easting,Northing and Level) from dwg to excel.
View 2 Replies
View Related
Sep 4, 2012
I have Export data from dwg to notepad lisp programe. But i need lisp programe for Export data (Easting,Northing and Level) from dwg to excel.
View 2 Replies
View Related
Dec 5, 2013
i need to export Geometry Data (in properties) X,Y,Z coordinates/points from a Sold 3D object into Excel (csv.file) I have tried data extraction (EATTEXT) but it doesn’t pick the points up unless I add points manually.
View 5 Replies
View Related
Jan 25, 2011
For some reason when I try to "Create Reference" to bring in my Alignment, Finished Ground and Existing Ground I get three different alignment data shortcuts instead of them grouping into one. I am trying to find out where in my workflow this all went wrong.
I have a .dwg that just has my alignment files in it. Then I make a new drawing and data shortcut in those alignments and Surface. I make my profiles and then create the data shortcuts for those. I start a New drawing and try to reference the alignment and profile and I get duplicated that aren't grouped. If you take a look at the two .bmp's you can see what happens.
The Purple highlighted area is how I want it to show up and that one worked just fine. Same work flow. The yellow is what is giving me a hard time.
View 9 Replies
View Related
Mar 20, 2013
How can i create an Alignment from points (imported) easily without drawing a polyline point to point using a polyline to define a route?
View 1 Replies
View Related
Mar 6, 2013
Is there currently any workaround to bring in alignment descriptions when data short cutting? I have hundreds of lines that are in my drawing that need callouts and this is easily done by making a label with reference text to the alignment description.
View 1 Replies
View Related
May 20, 2013
How can I import excel data for a hydrograph into SSA for a sub basin? I have 10 subbasins each with their own hydrograph.
View 1 Replies
View Related
Mar 15, 2012
How to insert a linked excel table into my drawing, however I have not figured out how to add rows to the table, the option is greyed out. I can insert rows above and below the (inserted) table but not anywhere in the middle.
I've tried everything I can think of, even removing all the formatting in the .xls spreadsheet to no avail. The cells are unlocked, I can manipulate the data, but not being able to insert rows is really hindering the efficiency of using a data linked table.
View 9 Replies
View Related
Jul 4, 2013
I have an excel sheet containing alignment coordinates i.e
Station Number
Northings
Eastings and
Tangential Direction
I wanted to export these into Civil 3d so that I can work with the info. What format would I save my excel document? is it 'text (tab delimited)' or 'csv (comma delimited) or formatted text (space delimited)?
I've tried all the above but I keep getting an error message from AutoCAD that point files not in right format
NB: Am using MS Office 2010
View 1 Replies
View Related
Nov 19, 2013
I am creating a template for my company with associated description keysets. The codes and attributes have already been created in an excel spreadsheet. Currently I am typing these all individually by hand but would like to import the excel data if possible.
View 2 Replies
View Related
Aug 4, 2011
is it possible to lock an alignment to a pipe network, so that if you move a structure, the alignment moves with it?
along those same lines, when you create an alignment from a pipe network, is it possible to auto assign the reference alignment to the pipe parts, so that labels come out correctly?
View 4 Replies
View Related
Apr 27, 2012
Is there a way to have a block (called test, for arguments sake) within this block we have text (attribute / fiield or whatever).
Now I have an alignment that has stations set every 10 units and on those stations I have inserted the block "test" as part of the alignment label style.
I can get the block inserting correctly, rotation the direction I require etc but what I need is for this block to report the station number.. ie 10, for the first 20 for the second and so on.
Is this possible?
View 1 Replies
View Related
Oct 29, 2013
I have an alignment I need to edit that has a reverse curve. The first curve was made with the "Floating Curve (from entity, radius, through point)" and the second with "Free Curve Fillet (between two entities, radius)"
When I delete one or both curves i lose all the superelevation data beyond the editing location due to the temporary spit in the alignment. The superelevation data is all manual. This is a trail and the super is based on drainage not curves.
how to edit the alignment with a temporary split and not lose the superelevation data? I have not found a way yet to remove the reverse curves and not have a temporary gap.
View 3 Replies
View Related
Jul 2, 2012
In LDT listing curve data was as easy as selecting an alignment, clicking edit and printing out a spreadsheet with all the required info. how to do this in C3D. Inifo I need:
Delta
DOC
Tan
Length
Radius
PC
PT
PI
View 3 Replies
View Related
Feb 22, 2013
For a roadway project I am creating alignment detail sheets. For the first project, only a portion of the final road is being constructed. I have the proposed alignment brought in with data shortcuts and will use various styles for the labeling. But I only need a few different sections of this alignment to be shown. Is there a way I can set clip boundaries or mask out the sections I don't want to show?
View 1 Replies
View Related
Mar 19, 2013
I want to export data from AC3D to Excel; I've tried to do it with copying directly the tables I made, but it isn't text or number format.For example, I want to get the data from this table:
I know that with previous versions of autocad it could be done.In addition, I also want to get value table of the calculated cant of the "Cant Tabular Editor":How can I get a table of this data? I need it because I have a lot of curves and I want to do some verifications of the standars of my country.
View 4 Replies
View Related
Dec 2, 2013
I need to produce a better standard table for our company, but need to know how it would be possible to display only either the START STAKE VALUE/ STATION or END STAKE VALUE/STATION in the appropriate column. If I can achieve this i would not need to details for straight segments as indicated in the details column.
View 5 Replies
View Related
Aug 28, 2013
I am working on roadway project where I am using Pipe Networks to layout the drainage infrastructure. I have set my working dwg up so that I am data referencing the existing surface and proposed alignment. I have set my pipe network up so that it is also referencing this surface and alignment. Everything was working fine. Labels were pulling the correct information from my surface elevations, and stations were being referenced as well, until I got a message that recommended that I recover my drawing.
I ran recover and my surface and alignment data shortcut disappeared. My pipe network now shows questions marks where there were once stationing and it appears that the surface and alignment have completely disassociated themselves from my drawing, however they appear in the prospector, but cannot be refreshed. Again the data shortcut symbol is no longer next to my surface and alignment, but there is a symbol telling me that those objects are being referenced by another object in my drawing (my pipe network). I have tried refreshing, resetting the working folder, all to no avail.
View 1 Replies
View Related
Jun 1, 2010
I have been provided with Surveyed Utility Locates along an Existing Roadway. These are provided to show conflicts between the New Storm Sewer System and Existing Utilities such as Water, Sewer, Gas, Elec, etc. The survey however is incomplete as it was prepared a few years ago and the Storm Sewer has just been designed. Yes, I can create points and provide them to the County Surveying department. However, before this is done, I must provide an easily-understood format of the new survey locations to the County Project Management.
To provide a Point Table which references the Surveyed Points' location in reference to the roadway stationing (Alignment). I have attached what the point table is to look like.
I am unable to find the desired data reference in the currently provided data field selection. Am I just missing it or is this a "Wish List" item?
View 9 Replies
View Related
Oct 25, 2012
is it possible to get the alignment name which the corridor surface is built from when the surface is being data referenced. in other word no corridor as the middleman.
the way i see it is when corridor suface is referenced, it becomes a regular surface and loses some properties such as parent alignment.
i am still using COM. maybe .net can do it? either way works.
Civil 3D 2012
Work: Xeon W3503, 12GB, Quadro 2000, Dell P2211H x 2
Home: 3930k, 12GB, GTX 590, U3011, QX2710
View 1 Replies
View Related
Jun 26, 2013
I am using Rel 2013 C3D
How do I remove excel data links from my Reference Manager (see attached image). What I have been doing is AutoCad erasing the graphics from my drawing but the link still remains in the xref manager window.
View 5 Replies
View Related
Oct 18, 2012
Using C3d 2013.
Where do I find the PI data of an alignment object to plug into a mtext Field?
Field Category and Field Name and any other steps to locating it would be useful.
View 9 Replies
View Related
