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.
When I use the import excel points function in the 2D sketch menu of Inventor 2013, nothing happens when I open the excel file. No points are drawn in the sketch... I don't even get an error message... I have tried the same thing on another computer with the exact same spreadsheet and it works 100%.
I'm running Inventor 2013 service pack 2 on a Lenovo Y570 with an Nvidia GeForce GT555M GFX card
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
We have a points file to create a "bottom of peat level" surface. The only problem is, along with the X and Y, it only gives us the distance from OGL, not the actual Z Elevation at each point. How do we import these into C3D to create a surface? We have a topo survey for the whole site, so we have and EG surface.
When I import points from an external project point database (LDD) which I do quite often to import points from 2008 to Civil 3d it works fine for me, but when a co-worker tries doing it from the same exact drawing just a different computer it does not work. Whe he tries to do it, a red "X" appears telling him there is some kind of error. VERY strange and I have no clue why????
I was wondering what is the difference between importing points under the Prospector tab versus importing points under the Suvey tab? And how either of the two methods relate to using Data Shortcut?
I would like to create a survey topo drawing that contains points and surface information which other Design drawings that are attached to the Data Shortcut project can access but not be able to make any changes to the original points and existing surface information.
I am building a new template for our office and just finished building my Description Key Code Set, and Figure Prefix Database. I stopped to do a quick trial run on one of our surveying files, but when I imported the file all of the figure lines imported correctly but the points all came in the default point style and label style. I went to the Settings Tab/Points/Commands and made sure my "Disable Description Keys" was set to False. This is not my first template and I have never had this issue before.
We're moving [slowly, painfully] from LDD to Civil 2012. When importing a survey fieldbook in LDD, my method has always been to "clean up" the fieldbook during the import. Rather than search through the fieldbook text file manually, I'll let the import process find the duplicate, overwritten points, or errant linecodes, and then exclamate them or change them in the fieldbook and, if necessary, reimport the fieldbook. Figures and breaklines use the initial coordinate, for instance, so sometimes a reimport is (was) necessary.
So our survey crews "overwrite" points in the field for bad rod heights, angles, descriptions, etc... During the LDD import process that point number is flagged and I am given the option to overwrite/average/etc.... In Civil 3D I seem to be stuck with an average of the two observations, and I'm not even alerted about which point numbers come from these "multiple observations." So I've no idea without sifting through the often substantial list of point numbers which points have duplicate data connected to them.
I've combed through the import options and I just don't see what I'm looking for, which, in a phrase, is to be alerted when there are duplicate numbers in the fieldbook.
I have a .dwg file with an AT-LCC projection assigned to it. There are some .shp files connected to it.
Can I choose the projection of to-be-imported-points when I import some laserscan-files in ASCII format? So I can tell AutoCAD: these points are in MGI-AT.AUT-Central/GK projection, please convert them to my desired projection.
There is a method which takes much too long:
open a new document assign the origin-projection (here; MGI-AT.AUT-Central/GK) to the fileimport the pointsexport the points as .shp file, define a projection-system conversion to target projection (here: AT-LCC)open the file with the target projection assigned to it (here: AT-LCC)import the .shp file
Our Surveyor created the Point Styles and description keys for processing our field work. These were incorporated in our template. Yesterday he brought in field work an noticed that only a few of the symbols incorporated into the markers came in.
The blocks exist in the drawing but when you go to edit the point marker only 8 out of 152 blocks show in the window below "Use AutoCAD BLOCK symbol for marker". I tried a backup of that template from 5 months ago and got the same results. I've verified that the blocks still exist in the drawing both by listing them and exploring them in Design Center. If I try other templates the window shows all the blocks.
I have tried Audit and Recover with no improvement. Thirteen errors fixed but the blocks still don't show. Additionally I found a backup of the template from Feb., 2013 and get the same problem but the lack of blocks only just occurred.
This is an example showing the depleted block list:
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
I want to know why I can't change coordinate of points while importing points from Points menu?
I created new file, assigned any coordinate system to the model. Opened Import points windows there, created new file format which there I assigned Coordinate zone transform to the coordinate system of the text file and imported my text file. But the coordinates of points didn't changed or transformed. When I do it by Survey in Toolspace its works good. I want to know whether I did any wrong or it is problem of software.
I use AutoCADCivil 2013 64 bit in Windows 7 64 bit!
I’ve run into an issue with importing survey data using field books.
I started by importing my primary control using a field book. There were no issues with importing these points. I then proceeded to import subsequent field books with additional control and then topographic mapping. In the last field book some points were accidentally overwritten due to an error in the field collection. No error message was given to let me know the survey points were in use and being overwritten. Luckily I caught the error before I proceeded to the next field book.
I tried to reimport the field book that originally created the points that were overwritten. At that point C3D told me that the points being occupied in the field book did not exist. I checked the point list for the primary control field book under the "Import Events" in the Survey Tab of the Toolspace and indeed the points in question were no longer listed.
I then proceeded to reimport all the field books in order, starting with the primary control. I got through several of field books before C3D again told me the point being occupied did not exist. This despite the fact that this same point was occupied in previous field books. After trying once again I was able to get through the field books.
I know that to design for example a 3d curve i have to import a XYZ data points from excel. What if i wanna link these points from excel to Inventors curve? Everytime i change the excel file i want my curve to be updated.
when I use the tool "import points from excel to inventor" in sketch mode, it looks fine. I pick the option "create lines". is there any way to create one line by one line? because inventor will give you "Z" shape when you create two different line in different "row".
I've just finished up a ground level survey. I've jotted the coordinate and levels down in my notebook and typed them up on Excel. I'm having trouble getting the coordinates from excel into AutoCAD Civil 3D 2013 version.
I'm VERY new to this sort of stuff as a trainee site engineer the most I do is simply take coordinates from a drawing to set out on site. I'm importing the points from file using Civil 3D.
I've simply saved the coordinate on excel as, for example:
430245.454 434264.654 62.321
I get this error "No point file format match found" when I try and import them. I've had a look at some Youtube videos and I'm not sure what I'm doing wrong. Maybe it's the file type I'm saving it under.
Currently i am trying to get an Excel sheet incorporated into my AutoCAD layout. I get it in and it seems way to small. I re-scale the excel insert and get it right then update the sheet to get the new info and it shrinks back down. Now i thought at first it was the excel insert that was the problem, but now looking my layout seems to be extremely large and that's why the excel sheet is off. How can i take my existing layout and change it to fit 11x17. I really don't want to have to redraw the whole layout to make it fit 11x17.
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.
I've made a big calculation in a Pipe Stress Analysis program and the program has auto created 10 autocad drawings that is used to find points in the system.The problem is that the program has random numbered (with no intelligence) and now I have a big report which for example points at a number some where in the 10 drawings, which is hopeless to find.
Can I somehow:
1. Find all numbers in this drawing. 2. Put them into Excel. 3. Sort them after size. 4. Add an extra column which tells which drawing I can find the number. 5. Last put all the numbers from all the drawing into one Excel sheet and sort them after size, now I have a number index, so I can find which number is in which drawing.
Can Autocad find all numbers in a drawing and let me copy them to Excel for editing?
I want to link an excel sheet with a drawing, so changing the excel changes the drawing.
I used this awesome site to learn about going to Edit->Paste Special->Paste Link->AutoCAD Entities...but I don't have that choice. Just the one that makes the OLE image. While that will work, that is less than ideal. It appears in just normal paste, but not under paste link.
AutoCAD 2007, A.54; Excel 2003 SP3; Windows XP SP3.