Drill hole locations from spreadsheet

[caduser051574]

I am using Map 3D 2005. I have an Excel spreadsheet of exploration drill holes, with columns for the Status, Easting, Northing and HoleId. I am wondering if it is possible in Map to use the spreadsheet to generate a map showing the location of each hole with the hole number and whether it is proposed or completed. I have tried generating a query using the linked spread sheet, but I keep getting lost somewhere along the way. Any suggestions would be welcome.

Prior to this I have been using attributed blocks and inserting them with a script, but I feel it should be easier by using the GIS capabilities of Map.

TIA,

Ray

[JeremiahM]

You can use Create Points in the Civil menu in Map. It's still not "linked" but it makes nice usable points that are pretty powerful when it comes to how you want to see them or if you wanted to create surfaces for analysis. Once the points are in they are held in the Point DB in the drawing and you can manipulate and work with them in the DB format.

Jeremiah

[sdaniel.3467]

One possibility would be to build a script in Excel to run in Map.

=CONCATENATE("-insert",CHAR(10),"<<blockname>>",CHAR(10),A1,",",B1,CHAR(10),"1",CHAR(10),"1",CHAR(10),"0",CHAR(10),C1)

Where A1 is the X coordinate and B1 is the Y coordinate.
CHAR(10) is a carriage return.
C1 would be an attribute.

Once the formula works (test one line in acad). Copy the formula column to notepad and replace all the " with nothing.
Then Select all the text from notepad and paste it to the command line in Map.

If you would like to use object data, here's another idea:

=CONCATENATE("mapdigitize ",A1,",",B1,CHAR(10),C1)

Where A1 is the X coordinate and B1 is the Y coordinate.
CHAR(10) is a carriage return.
C1 would be an attribute.
Good luck!

[caduser051574]

Thanks, but I think it is about as easy to do it the way I have been, i.e. saving the spreadsheet as a csv file and bringing it into Notepad for final edits.

Ray

[MHultgren]

You might be able to find something on Dotsoft's website that will work for you. They have been working more and more with Map and LDT interfaces lately.

[bruce.adams]

I am using Map 3D 2005. I have an Excel spreadsheet of exploration drill holes, with columns for the Status, Easting, Northing and HoleId. I am wondering if it is possible in Map to use the spreadsheet to generate a map showing the location of each hole with the hole number and whether it is proposed or completed. I have tried generating a query using the linked spread sheet, but I keep getting lost somewhere along the way. Any suggestions would be welcome.

Prior to this I have been using attributed blocks and inserting them with a script, but I feel it should be easier by using the GIS capabilities of Map.

TIA,

Ray

Using the common LDT point creation and point importing from a file has been a staple of point generation for years. The import options can use any kind of database. You just need to select the proper import settings to match your database and delimiters. I may be confused of what you're trying to do, but importing points to match the data and using description key files and settings is the way the problem you seem to be describing, has been done for a long time now.

Battle Mountain, NV ....HeHe...Don't they have the armpit of america fest there?

[caduser051574]

I will give that a try Monday. I am going to the Mine Expo in Elko, tomorrow.

And yes, they do have the Armpit Festival here, sponsored by Old Spice.

Thanks,

Ray