Anuncios

The Autodesk Community Forums has a new look. Read more about what's changed on the Community Announcements board.

Importing survey points from excel in to multiple blocks

Anonymous

Importing survey points from excel in to multiple blocks

Anonymous
No aplicable

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 IDXYZDescription
11903582.4535-2243.071312.77NUCRSHRRKBX
11904423.192-2272.821311.58CRSHRRKBX2
11905500.4956-2206.111312.8TP3
11906163.441-2258.231307.05TP4
0 Me gusta
Responder
1.657 Vistas
8 Respuestas
Respuestas (8)

TerryDotson
Mentor
Mentor

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.

0 Me gusta

ChicagoLooper
Mentor
Mentor

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

EESignature

0 Me gusta

Pointdump
Mentor
Mentor

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

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
0 Me gusta

Anonymous
No aplicable

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?

0 Me gusta

Pointdump
Mentor
Mentor

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.

 

dxf_1.png

 


Dave

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
0 Me gusta

ChicagoLooper
Mentor
Mentor

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.

 

  1. invoke DATAEXTRACTION command. Create a new data extraction. Name and save the dxe file in your project folder. Image-1.
  2. Select objects=>click the MANUAL button and use a crossing window to select all 345 SRVPN01 blocks. Image-2
  3. Check the box named SRVPN01. You don't need 'Attribute Definition' so do not check that box. Image-3.
  4. 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.
  5. 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.
  6. 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.>>
  7. Click FINISH. Image-7. To view your new file, open Excel, then go to File=>Open=>Browse=>Select your xls file=>Open. 
  8. 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-1.

 

 

 

Image-2.Image-2.

 

 

 

Image-3.Image-3.

 

 

 

Image-4.Image-4.

 

 

Image-5.Image-5.

 

 

Image-6.Image-6.

 

 

Image-7.Image-7.

 

 

Image-8.Image-8..

 

 

Chicagolooper

EESignature

0 Me gusta

TerryDotson
Mentor
Mentor

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.

0 Me gusta