Author Topic: Database: Ancestral Anniversaries ("On this day in ...")  (Read 47259 times)

Offline Pejic

  • RootsChat Veteran
  • *****
  • Posts: 714
    • View Profile
Re: Database: Ancestral Anniversaries ("On this day in ...")
« Reply #9 on: Saturday 20 July 13 07:12 BST (UK) »
Bob,

Yes another field would be needed as well once the numbers get bigger, it was just that I tried to get all the baptisms that were there.

Good news re Excel route - I will hopefully let you have a test worksheet (of actual data) later today.  Do I need / should I get permission/approval from the original posters before harvesting their information?

peter
Richard Wernham (Berkshire 18th century),
William Hissey (1805 to 1813, Hampstead Norris),
Kapirin (Siberia 19th Century),
Kitching 1850,
Mary Howse born 1806 ish,
Chris Truelove marr. John Pocock 2-7-1696, Kintbury, Berks

Offline Berlin-Bob

  • Moderator
  • RootsChat Marquessate
  • ********
  • Posts: 7,443
    • View Profile
Re: Database: Ancestral Anniversaries ("On this day in ...")
« Reply #10 on: Saturday 20 July 13 08:44 BST (UK) »
Hi Peter,

I "took" the data from november without asking, but it would be a good idea to ask.

Quote
Hmm, can I just ask a question. I only post my anniversaries on this thread, am I correct in thinking they will now be lifted onto this other site whether I choose to subscribe or not ?

The "other site" (I am assuming you all mean the database) is purely optional. I entered the details from the November topic just so I had some test data. 

I don't intend to enter data from any other "On this day in ..." topics: your choice, I'll leave that up to you :)

Bob

Perhaps you can send them a PM, with a link, asking them to add their views here on this topic.

regards,
Bob

Any UK Census Data included in this post is Crown Copyright (see: www.nationalarchives.gov.uk)

Offline Pejic

  • RootsChat Veteran
  • *****
  • Posts: 714
    • View Profile
Re: Database: Ancestral Anniversaries ("On this day in ...")
« Reply #11 on: Saturday 20 July 13 09:33 BST (UK) »
Bob,

Mmm! that sounds like more trouble/time consuming than collecting the data - I'll have to think further about how to tackle that.

Meanwhile here is a spreadsheet with 3 entries for myself for you to test/comment upon.

Is there a list of the Country and County abreviations you use?

Ah! It seems I will have to find another way to get it to you as I do not have the file in an acceptable attachment format. Await a PM

peter

peter
Richard Wernham (Berkshire 18th century),
William Hissey (1805 to 1813, Hampstead Norris),
Kapirin (Siberia 19th Century),
Kitching 1850,
Mary Howse born 1806 ish,
Chris Truelove marr. John Pocock 2-7-1696, Kintbury, Berks

Offline Pejic

  • RootsChat Veteran
  • *****
  • Posts: 714
    • View Profile
Re: Database: Ancestral Anniversaries ("On this day in ...")
« Reply #12 on: Saturday 20 July 13 09:54 BST (UK) »
So after opening the Excel Spreadsheet in Word, coverting the table to text (CSV) and saving as text file:

Richard Wernham (Berkshire 18th century),
William Hissey (1805 to 1813, Hampstead Norris),
Kapirin (Siberia 19th Century),
Kitching 1850,
Mary Howse born 1806 ish,
Chris Truelove marr. John Pocock 2-7-1696, Kintbury, Berks


Offline Berlin-Bob

  • Moderator
  • RootsChat Marquessate
  • ********
  • Posts: 7,443
    • View Profile
Re: Database: Ancestral Anniversaries ("On this day in ...")
« Reply #13 on: Saturday 20 July 13 09:59 BST (UK) »
Yes, that would be fine (even better is saving the CSV with quotes around the fileds, but that can be added later.

I'm showing it here, in case others decide they would like to join in (Hint !! Hint !! ;D )

Quote
day, month, year, event, Surname, Forenames, Country, County, Place , Relationship, Submitter
7, 3, 1819, Baptism, WILD, Maria, ENG, BRK, Beedon, my Grandchildren's 2 x Great grandmother, Pejic
14, 8, 1791, Baptism, DAVIS, William, ENG, BRK, Ashamstead, my Grandchildren's 3 x Great grandfather, Pejic
8, 9, 1793, Baptism, HEWARD, Keziah, ENG, WIL, Ramsbury, my Grandchildren's 3 x Great grandmother, Pejic

Bob
Any UK Census Data included in this post is Crown Copyright (see: www.nationalarchives.gov.uk)

Offline Pejic

  • RootsChat Veteran
  • *****
  • Posts: 714
    • View Profile
Re: Database: Ancestral Anniversaries ("On this day in ...")
« Reply #14 on: Saturday 20 July 13 11:52 BST (UK) »
Here is some more of my actual data with double quotes around the fields.  I have made a post on each of the open "On this Day" threads asking anyone who does not want the data in their posts to be copied, to PM me and I will ignore their data. 
Richard Wernham (Berkshire 18th century),
William Hissey (1805 to 1813, Hampstead Norris),
Kapirin (Siberia 19th Century),
Kitching 1850,
Mary Howse born 1806 ish,
Chris Truelove marr. John Pocock 2-7-1696, Kintbury, Berks

Offline quest40

  • RootsChat Senior
  • ****
  • Posts: 310
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Database: Ancestral Anniversaries ("On this day in ...")
« Reply #15 on: Monday 22 July 13 12:39 BST (UK) »
I don't seem able to edit an entry I've made to the database - when I click the 'edit record' button my list of entries doesn't appear.  Am I doing something wrong? 
By the way, I think the database is very useful, and hope more people use it.
Conquest, Crowsley, Giovannelli, Kingham, Marshall, Sewell, Wilson, Ashwell

Offline Pejic

  • RootsChat Veteran
  • *****
  • Posts: 714
    • View Profile
Re: Database: Ancestral Anniversaries ("On this day in ...")
« Reply #16 on: Wednesday 24 July 13 20:54 BST (UK) »
Test data uploaded OK Bob - thankyou, more to follow.

Quest40 - Yes I seem to be having the same problem, but I thought I remembered editing an earlier entry, could be wrong about that - it could have been a SIT record.
Richard Wernham (Berkshire 18th century),
William Hissey (1805 to 1813, Hampstead Norris),
Kapirin (Siberia 19th Century),
Kitching 1850,
Mary Howse born 1806 ish,
Chris Truelove marr. John Pocock 2-7-1696, Kintbury, Berks

Offline quest40

  • RootsChat Senior
  • ****
  • Posts: 310
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: Database: Ancestral Anniversaries ("On this day in ...")
« Reply #17 on: Thursday 25 July 13 00:05 BST (UK) »
Pejic, yes, I also managed to edit one of my first entries, so don't know what's happened?  Glad it's not just me, though!
Conquest, Crowsley, Giovannelli, Kingham, Marshall, Sewell, Wilson, Ashwell