- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
Importing survey points from excel in to multiple blocks
I have around 4000 points in excel in the format shown in the table below. I would like to be able to import the Point with a description that includes the Point ID, the Elevation and Description.
I have attached a file with points that have already been imported using Carlson Software pulled directly from the surveying data collector. We ware wanting to bypass the need for using Carlson and just use AC for our survey data.
Carlson would create a block with the point and the description for each point. With the three parts of the description in different layers
Im looking for a way to do the same thing by importing an ASCII file or an excel file and have AC create blocks the points and the descriptions for the points in separate layers.
I’m a one month user of AC and have know idea if this is even possible.
Thank you for any help
| Point ID | X | Y | Z | Description |
| 11903 | 582.4535 | -2243.07 | 1312.77 | NUCRSHRRKBX |
| 11904 | 423.192 | -2272.82 | 1311.58 | CRSHRRKBX2 |
| 11905 | 500.4956 | -2206.11 | 1312.8 | TP3 |
| 11906 | 163.441 | -2258.23 | 1307.05 | TP4 |
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
Since the data is in Excel, you can easily make a script file from the spreadsheet content and let the script insert your blocks in automation. Make a suitable block definition then run the script.
This blog post describes the process of creating layers in AutoCAD from Excel content, it would easy to adapt it to a block insert script.
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
Civil 3D can easily do this because it has the capability import survey points. Your points should go directly from Carlson to Civil 3D and should not even touch Vanilla AutoCad. Using Plain Vanilla AutoCad is inappropriate.
Chicagolooper
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
Joseph,
Can you elaborate a little on what you want to do? Create a surface for road design or pad layout, calculate dirt quantities, boundary survey map? If you're calc'ing points for total station or GPS layout, then either the Carlson software or Civil 3D will be much easier than Vanilla AutoCAD.
Dave
Dave Stoll
Las Vegas, Nevada
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
We are an underground limestone mine the deposit is relativity flat and uniform so we don't have much need for 3d modeling, every thing is viewed in plan view. Most survey data is used to determinant where surface points relate to underground points for positioning of shafts and the also mapping the pillars of the mine. I would like to be able to create points like the ones in the cad file I attached.
i have found a way of creating a script formula in word that will import all the points with a description the problem is i can't create a block out of each point location.
I haven't given survey layout to much thought yet but do you think i could use data extraction to import into my data collector?
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
https://forums.autodesk.com/t5/autocad-forum/importing-csv-into-autocad-2018-as-block-and-including-...
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
Joseph,
"...use data extraction to import into my data collector?"
The problem you'll face is that your block insertion point is not the same as the AutoCAD point. I would save your drawing as DXF format and load that into your data collector.
Dave
Dave Stoll
Las Vegas, Nevada
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
Creating a block is not necessary. If you want to bypass Carlson and want to import your points collected directly into Civil 3D, then you have two options:
OPTION 1:
From you 'data collector, spit out the data you have collected, but this time, put it into a format that Civil 3D can understand and use. Your goal will be to get the data in a txt and csv format. Once it's in one of these formats, open the Microsoft Excel program view your data in a spreadsheet. Go to File=>Open=>Browse=>browse to your csv or txt=>click OPEN.
Next, perform EDITS, if needed, on the file you just opened into an acceptable format that you can IMPORT into C3D. Save the edits by saving over the current file. Acceptable formats include, are not limited to, PENZD, PNEZD, PNE, PNEZ, ENZ, NEZ, PENZ, etc. Import these file into C3D with an output of Cogo Points. This method would be the fastest way to move your survey data from your hand held to Civil 3D.
OPTION 2:
Do this then complete steps 1 thru 8.
Open the same dwg file you uploaded in post #1 of this thread. Click on one of the 'text' labels=> right-click=>choose Select Similar from shortcut menu. Your Properties Palette will indicate 345 blocks (named SRVPN01) have been selected. Next, put all of these selected blocks on 0 (zero) layer. Freeze (turn off) the original layer named PNTS. Run the DATAEXTRACTION command, a wizard-type of utility consisting of multiple pages, page 1 thru 8.
- invoke DATAEXTRACTION command. Create a new data extraction. Name and save the dxe file in your project folder. Image-1.
- Select objects=>click the MANUAL button and use a crossing window to select all 345 SRVPN01 blocks. Image-2
- Check the box named SRVPN01. You don't need 'Attribute Definition' so do not check that box. Image-3.
- On the right, Cateory filter, check Attribute and Geometry. On the left, check the five (5) Properties shown. You don't need the other Properties, they are 'extra baggage' and will weigh you down. Image-4.
- Check 'Combine identical rows' then OK. You may click Preview but it's not necessary. Later, not now, you will be able to perform edits such as manipulate the columns and rows. Image-5.
- You are now on page 6 of 8. Check 'Output data to external file' option. Name and save to 'xls' format placing it in your project folder. Image-6. <<WARNING: If you check the option to 'Insert table into drawing' you'll proceed to page 7. However, the option you're choosing will skip page 7 and take you directly to page 8.>>
- Click FINISH. Image-7. To view your new file, open Excel, then go to File=>Open=>Browse=>Select your xls file=>Open.
- Your xls file will look like this. Image-8. While in Excel, perform edits by manipulating and/or moving the headings, columns, and rows. Finally, go to C3D to create your points. Go to Home tab=>Create Ground Data panel=>Points dropdown=>Point Creation Tools. Create cogo points which are Civil 3D-ish type of blocks commonly used when importing survey points. If you are ambitious and want to impress your boss, create Point Groups when you're Importing your Cogo Points.
Image-1.
Image-2.
Image-3.
Image-4.
Image-5.
Image-6.
Image-7.
Image-8..
Chicagolooper
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Denunciar
If you would like some serious automation for your existing drawing processes without the complexity, cost and huge learning curve of Civil3D, take a look at DotSoft's MapWorks. It also reads and writes Carlson binary CRD files directly so you won't need to convert them, nor work with scripts at all. Try the full working 45-day evaluation for yourself.