AutoCad :: Importing Point Data From Excel To Civil 3D?

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


ADVERTISEMENT

AutoCad :: Importing Excel Data

Apr 6, 2010

I am having a problem with my table that I insert from excel into ACAD 2010. The Data in excel is on automatic color and arial text, once imported into ACAD as ACAD entities the data in my table does not want to change to being bylayer as the cell type is set to but instead stays on white. The only way I can change the color is by entering the cell and changing it manually to bylayer.

View 9 Replies View Related

AutoCad 2D :: Importing Excel Data To Define Dynamic Blocks Properties

Dec 4, 2012

I work for a company that makes sheet metal cabinets. Each cabinet we construct has 17 parts that all different different blank sizes and notching. I have a template for each part right now that I have to shrink or stretch to the appropriate size every time we get a custom size order.

What I've created so far is an excel spreadsheet that determines the sizes of all the parts based on the overall height width and depth of the custom cabinet that was ordered. Any way to define a parts properties with a dynamic block and get the width depth or height imported in from the excel spreadsheet to automatically adjust the size.

[URL]

View 6 Replies View Related

AutoCAD Civil 3D :: Import Point Data For Each Point Includes Hyperlink

Jan 17, 2013

I have a database of points I am trying to import, and the point data for each point includes a hyperlink.  I've created a set of custom User-Defined Property Classifications for all the data types in the point database, and I've created a point file format to use to import the points. 

It's a database of existing curb ramps, the data includes things like widths, slopes, some text, and a hyperlink to the Google Streetview at each ramp.  I've created a custom point label that will show the data I need to see at each ramp.

All goes great except that the import fails because of the hyperlinks.  I've tested it by removing the hyperlinks from a small test portion of the data set, and the test points are then successfully imported.  I suppose I can delete the hyperlinks from the entire database, but if there is a way to include the hyperlinks in the point import I would prefer that.

Win 7E 64-bit, Intel i7, 12 GB
C3D 2012

View 6 Replies View Related

AutoCAD Civil 3D :: Importing Layers From Excel

Jan 24, 2013

I 'm looking for a method to import the layers that I have exported from Civil 3D 2013 and have edited in Excel. 

View 2 Replies View Related

AutoCAD Civil 3D :: Importing Points From Excel Sheet

Jun 14, 2013

When i import points (csv) from my excel sheet into Civil 3D, i can't see the actual points on the display frame, but i can see that the points have been imported by looking at the prospector tab > Points.

View 2 Replies View Related

Lightroom :: Importing LR4 Catalog Into LR5 Freezes At (preparing New Searchable Data Point)

Dec 24, 2013

I have just downloaded and installed LR5. I have been using LR4/3/2 and have always successfully imported catalogs in the past. This time LR5 appears to do most of the work as a file almost the same size as the original LR4 catalog is created, but the "catalog upgrade in progress" message just freezes.Should I reinstall LR5?

View 6 Replies View Related

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 View Related

AutoCAD Civil 3D :: How To Import Excel Data For Hydrograph Into SSA

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

AutoCAD Civil 3D :: Data Linked Excel Table

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

AutoCAD Civil 3D :: Import Excel Data In Templates

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

AutoCAD Civil 3D :: How To Copy Point Table From Excel

Oct 22, 2013

This seems like it should be the most stupidly easy thing...but AutoCAD doesn't seem to have a way to do this. I made a point table from a point group. Quick and sweet.

But now I want to change it a little bit, and it's not something I can just do from the table style. So I want to copy it into Excel...and when I try to, hitting paste in Excel ends up just giving me this block image version of the table in Excel. I tried doing TABLE EXPORT but that's only for regular tables.

View 3 Replies View Related

AutoCAD Civil 3D :: Get Data To Excel / Get Tables Of Can't Tabular Editor

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

AutoCAD Civil 3D :: Remove Excel Data Links From Reference Manager?

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

AutoCAD Civil 3D :: Importing GIS Data

Feb 10, 2011

I'm working in C3D 2009 and I have received some GIS data files that I would like to import. I don't work with GIS files in my daily work so I am not familiar with them. Although I have an idea of what kind of information can be stored in the GIS files. I've managed to get the data into my drawing using mapimport, but how do I know that I have successfully inserted all of the information that was sent to me?

I was given shx, shp, dbf, idx, prj, sbn, sbx, and xml files. All I have in my drawing are polylines that have a little bit of extra information when the properties box is displayed.  It just seems like a lot of files to be sent to only receive a polyline. Although all of the files except the shp files have only 1kb file sizes, and the shp file is 400 kb. So perhaps I was just sent extra files?

View 8 Replies View Related

AutoCAD Civil 3D :: Importing GIS Data For Inlets

Jan 7, 2013

I see you can import junctions from GIS shapefiles, but can you import inlets? I have hundreds of inlets (mostly grate inlets) and I need to import the inlet type and inlet opening dimensions. I have a shap file with the inlet data, but I'm unable to import it into SSA with all the information I need.

I know you can import shapefiles as junctions and convert them to inlets, but then you would have to manually input the dimensions of the inlet. Is it possible for SSA to automate this processs?

View 1 Replies View Related

AutoCAD Civil 3D :: Importing Data From Two Sources

Feb 18, 2013

I am having problem importing data from two different source. The first one is hypso data and is supposed to be in lat / long from the CSRS. When I import the shape file in C3D using these specification, the white arrow appears in the center of the drawing, and everything seems fine.

Now then, I have those data point from land survey with a GPS I wish to had to my surface. When I import my text file ( which is in P - X - Y - Z format ), the point appears way offside of the hypso drawing.

So I was wondering, how can I know the system in which those point were recorded. Once I know this, how can I specify to C3D that the hypso is in a certain system, and the GPS point in another one, so that they will come together ?

View 9 Replies View Related

AutoCAD Civil 3D :: Importing Survey Data

Oct 21, 2012

I am bringing in the points by importing survey data because I don't want anyone to be able to edit the point data.

Vive noticed that they can be erased and that you can explode them.

View 4 Replies View Related

AutoCAD Civil 3D :: Importing (Not Data Referencing) Profile

Jun 15, 2012

I want to create a live instance of an existing FG-Profile that I somebody else did into our master profile drawing.  Is there an easy way to do this? I don't want to data reference it in.

I tried exporting the FG-Profile information into a .txt file and then use the "create a profile from file", but for whatever reason C3D didn't like my profile info was giving me an error message.

View 4 Replies View Related

AutoCAD Civil 3D :: Creating Excel Table For Populating Point Loc And Label Multiple Files

Jan 18, 2013

I have some data in the form of

point#    |    X    |    Y   |    Desc_1   |   Desc_2  |   Desc_3  |....... ect

I would like to make an excel table that i can create multiple points from and make that table dynamic, ie if i edit the table the points will change.I would be labeling the points according to the different desc_# in multiple drawings

Is there any way to do this? I have messed with creating a user defined property classification and creating a new point file format, but i want that point file I imported to be dynamic, and if I change values the values will change in all my drawings.

View 4 Replies View Related

AutoCAD Civil 3D :: Importing Point From Text File

Jan 18, 2013

I am using autodesk autocad civil 3D (Metric).When I am importing point from text file it comes with different scale which is not to 1:1.Actual scale is 1: 3.280 which is exactly equal to 1m :1 ft ratio.

So, my guess is, X,Y,Z coordinates are importing to autocad civil 3D is in feets and measured distance points in meters. 

View 3 Replies View Related

AutoCAD Civil 3D :: Export Offset / Elevation Data From Cross Sections To Text File / Excel

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

AutoCAD Civil 3D :: Importing SHP Data Always Creates A Pipe Network

Oct 16, 2013

I want to import a number of SHP files into Civil 3D for design - road centrelines, boundaries, creek centrelines, etc.  however when I import them into Civil 3D (_AeccImportGISData) it only allows me to create a Pipe network.  the dialog that opens automatically assumes I want to import a pipe network.

Is there another way to import this information without assigning parts.

View 1 Replies View Related

AutoCAD Civil 3D :: Survey Database Point Data

Apr 16, 2012

Is there a way to "data shortcut" information imported from a data file into multiple drawings?  If so, is there a way to lock the data points "in place" and not be able to adjust the point location/elevation, but allow the movement the text information around within the drawing.

The goal is to have multiple drawings with these data points and be able to move the text information from the style, but not (in a million years) be able to move the data point itself.  There may be multiple drawings with these points located within them.

View 4 Replies View Related

AutoCAD Civil 3D :: Display Point Data From SHP File

Jan 2, 2013

how to show point labels on the points I imported from a .shp file. I used MAPIMPORT and brought in the associated object data but I don't know how to get it to display in my drawing.

View 7 Replies View Related

AutoCAD Civil 3D :: Survey Point Extended Data

Jul 5, 2012

I am wondering if it's possible to have a point code automatically add data to a user-defined field either in the survey database or in a drawing.  For instance, our surveyors currently will code a catch basin as CB INV2.2 if it has an invert depth of 2.2'.  I have a survey point user-defined property called InvertDepth.  Is it possible to get the survey database to automatically add 2.2 to that user-defined property or does that have to be manually input?  I have an expression and a label style that will take the elevation shot and subtract the depth number to give me the invert elevation on a lable, but I'd like to see if this can be done automatically without having to manually type in the depth on every point that is a catch basin or other inlet.

I've looked into the description key-set's parameters, but they seem to be mostly for display purposes and writing a full description.

View 6 Replies View Related

AutoCAD Civil 3D :: Contour Surface And Data Point

Feb 11, 2013

I'm working on a topo survey and the contours are crossing each others (See attached pic) and what I did was edit the surface by adding points. I know that these points are fake, but how does this affect the terrain surface for design point of view? I did try swapping edge and deleting lines but makes it worse. Also as you can see in the pic, I don't see the added points like it did back C3D 2008.

View 5 Replies View Related

AutoCAD Civil 3D :: Point Group When Importing Survey Points?

May 23, 2013

Sometimes when i import points Civil 3d creates a Point group in the drawing with the name of the point file, sometime it does not. I prefer when it does create this point group. It always seems to create a Survey Point Group. How do i control wether or not a point group is created in the import?

Civil 3D 2013
HP Z400 Workstation
6GB of RAM
296GB HDD
ATI FirePro V5700(FireGL)
Win 7 Home Professional

View 5 Replies View Related

AutoCAD Civil 3D :: Create Point From Coordinate And Elevation Data

Jul 28, 2012

Is there anyway to create a point from the coordinate and elevation data listed in a section inquiry panel (see attached)?

View 3 Replies View Related

AutoCAD Civil 3D :: Point Cloud Data - Processing Error

Jul 10, 2012

2012 SP2. I get this very descriptive message while trying to create a point cloud: The following error occurred processing the point cloud data: An error ocurred in data processing.

I've previously created point clouds from the same data (ENZ comma delimited) without a problem. I believe this was done before applying SP2. Any problems creating point clouds since SP2?

View 1 Replies View Related

AutoCAD Civil 3D :: Parcel Point Export To Data Collector?

Nov 19, 2012

I am trying to speak 'surveyor' without the background in the data collectors.  We have a new surveyor who uses Terramodel.  I have an LDD parcel database that the surveyor is requesting to be translated to points for stakeout.

I can export the parcels to xml and Terramodel will import them, but it seems to import them as lines.  The Surveyor wants points to be able to do a map check in Terra Model and program the data collector.  I am not seeing a create points from parcel function anywhere from 2004 to 2012.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved