Roy, I can just about read that alright, as said earlier I transcribed about 10 years worth of entries for one particular mine here in Cornwall at the old Redruth Studies Library, my eyesight was a lot better then.

Lozz.

I am, as we speak, using Roy's Mining Journal images in conjunction with his images of George's index.

You have an image of a page that is it, nothing flash. Neither is digitally searchable. However use the two in conjunction and you have a phenomenally powerful research tool. I don't think you need anything more complex.

Over the years a lot of people have talked at great length about a grant funded, all singing and dancing MJ and have got nowhere. Roy, on t'other hand plugged away on his own and achieved more than all the talkers.

If it is going to happen the way forward would be for a very loose collective of individuals to get together and, on an individual basis, take on photographing a volume in its entirety in much the same way Roy has done. The results could then be chucked into a common pot for the benefit of all.

Some folks (such as I) might be mainly interested in the mining reports of the individual mines (in my case mines in Cornwall) that would make compiling an index easier and would reduce the number of scans/photo's needed per issue.

Lozz.

I am, as we speak, using Roy's Mining Journal images in conjunction with his images of George's index.

You have an image of a page that is it, nothing flash. Neither is digitally searchable. However use the two in conjunction and you have a phenomenally powerful research tool. I don't think you need anything more complex.

Over the years a lot of people have talked at great length about a grant funded, all singing and dancing MJ and have got nowhere. Roy, on t'other hand plugged away on his own and achieved more than all the talkers.

If it is going to happen the way forward would be for a very loose collective of individuals to get together and, on an individual basis, take on photographing a volume in its entirety in much the same way Roy has done. The results could then be chucked into a common pot for the benefit of all.

Well yes, and off the top of my head the index could be populated simply by transcribing page numbers into an Excel speadsheet provided that the correct indexes where first entered.
Information can be imported directly from Excel into Access tables.

Below is database relationships. This is actually very simple compared to same projects

🔗101259[linkphoto]101259[/linkphoto][/link]

Below is a screenshot of left scrolled 'pages' table

🔗101260[linkphoto]101260[/linkphoto][/link]

First field is record ID which is irrelevant to data import because its not participating in any relationships, a bit like me at the moment.
The next 2 are important, look at the relationships table. 'MineID tells the system what mine it relates to, 'EditionID' what volume number.
Look across and you will see the hyperlink which was concatenated in VBA at entry time. This could alternatively be done at run time and possibly would be better, see I was storing my images on a 'D' drive, some may use an external or primary or whatever.

---

A bit more for those interested.
In the relationships shot tables not participating in any relationships are nothing to do with the Mining Journal. The two 'sys' tables are MS Access system, the others are my own standard error logging and security.
I never used Access or Windows security but preferred my own which did follow standard practice of group permissions etc.
Lockout relates to an attempted system hack.

I wrote the algorithm of successive comparisons which returns APR on credit installment agreements. I was interested in this stuff for years but made more money selling second hand cars
:lol:

---