im banging my head against a brick wall reading about midlands mines!

Did you know there are/were 3,024 coal mines in this country? zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

I think there are a few 0's missing of the end of that figure

---

That's a lot of coal mines Barney!

If you wanted to upload a lot (not that I'm suggesting anybody would ever want to upload 3000+ mines) I can easily write a batch import script from a spreadsheet.

What info would you want on the spreadsheet? I already have some lists at work and could easily get a list of loads of other coal mines

---

Hi LeeW

The basic data for a mine is simply:

1) Name of mine

2) ID of mineral - although if a batch import of mines of a specific type was being done could be left blank and the import script modified to insert the appropriate value on the basis they were all the same mineral type

3) ID or UK region (as per this page http://www.aditnow.co.uk/region/mines-quarries-uk-region.aspx  and again I can correct/map the data at import time)

4) (optional) Landranger grid reference, however mines can be imported without this information

That's the base information required, and the import scripts create the mines, credit them automatically to the person who provided the data, and create the User and Archive photograph albums automatically.

I can provide a standard spreadhseet to anybody as required, and modify provided data to work with the import process 🙂 The mine is then ready to take photograph and document submissions.

Once a mine is in place, any regional editor can edit the description if required and tag the mine to a forum area.

---

Thanks for that, luckily the database at work includes region and NGR, I assume you'll need sheet letters and 6 fig reference seperately.
If I get time, i'll dig out various spreadsheets next week at work, then add some others I know about

---

That's brilliant, thanks.

Regarding the NGR, it can either be sheet and 6 figures separately or combined, I can tell the script to handle it either way.

Cheers,
Simon

---

Simon, can you e mail me said spreadsheet pleeez? cheers.

Will do good sir :)

Will some time next week be OK? I want to do some thorough tests with it, and checking for duplicates (i.e. already in the database) before running it against the live site in case I break anything 😮

---

Terribly quiet over the past few days, feel like I've been talking to myself 😢

Guess everybody is down holes in the ground.

---

Quite the opposite for me actually.. I finally got to go up in the glider !!!

---

Nimrod dragged me up a mountain today ::)

---

Nimrod dragged me up a mountain today ::)

And back down again.. :lol: :lol:

---

Quite the opposite for me actually.. I finally got to go up in the glider !!!

The instructor pilot with Nimrod said he would push him out if I paid him £5.00.........I said if he did that I would give him £50.00 :lol:

---

Quite the opposite for me actually.. I finally got to go up in the glider !!!

The instructor pilot with Nimrod said he would push him out if I paid him £5.00.........I said if he did that I would give him £50.00 :lol:

Thats not nice....
I would post more, but I don't want to get told off for going off topic on another forum.

Been down in deepest darkest kent, playing with chainsaws, lighting bonfires in the dark and learning how to reverse a tractor mower and trailer..........all bloddy good fun 😮 😮

---

On the surface Wormster??? 😮

All surface working unfunortunatly Barney,

Tho next time I'm in Kent underground exploration WILL happen. :thumbup:

---