Author Topic: DBSIG: British Home Children.  (Read 47330 times)

Offline Berlin-Bob

  • Moderator
  • RootsChat Marquessate
  • ********
  • Posts: 7,443
    • View Profile
Re: DBSIG: British Home Children.
« Reply #63 on: Sunday 27 August 17 17:01 BST (UK) »
On behalf of "alanmack" I have just added 118 BHC children from the ship "Samaratian", landing in Canada in 1872.

Just in case anybody else would like to do it this way, here is how !

Alan sent me a text file with 118 lines: each line consists of
Surname, Forename, DOB

He sent me a second file containing the following "global" data:
Quote
Static Data Sarmatian Aug 1872

   DOB Year status = "approx"

   Country of Arrival = "CAN"

   Date of arrival = 17-08-1872
   Status = "exact"

   Ship = "Sarmatian"

   Agency (Canada)   = Macpherson Homes

   No family Link/created by alanmack

I imported the name file to an excel table, and then added the static data to each line.
After exporting this as a CSV file I added a few "nuts and bolts", renamed it as an SQL file and wrote the data directly into the database.

This sounds more complicated writing about it; in fact it is fairly easy and fast.

So if any of you are transcribing ships lists and want to save yourselves some work, do it Alan's way and send me the files :)

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

Offline cherylcam

  • RootsChat Extra
  • **
  • Posts: 7
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: DBSIG: British Home Children.
« Reply #64 on: Monday 04 September 17 16:30 BST (UK) »
Hi everyone. I would very much like to add my BHC but can't figure out how to do that. When I click on Add new record I get a message about PM's but my pm's are activated.

Offline Berlin-Bob

  • Moderator
  • RootsChat Marquessate
  • ********
  • Posts: 7,443
    • View Profile
Re: DBSIG: British Home Children.
« Reply #65 on: Tuesday 05 September 17 06:52 BST (UK) »
Hi Cheryl,

You may have to logout of RootsChat, delete all your cookies and then try again.
If you don't want to delete all your cookies, then just delete any with "RootsChat" in the name.

If that doesn't work, let me know.

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

Offline David C. Mackechnie

  • RootsChat Extra
  • **
  • Posts: 12
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: DBSIG: British Home Children.
« Reply #66 on: Monday 18 December 17 19:39 GMT (UK) »
I am not sure what has been more frustrating....years trying to find any information on my BHC grandfather, or trying to enter his information in this database.
Extremely frustrating.  I keep getting the must be able to use the PM system message. Have cleared all Rootschat cookies, etc., etc......
HELP! Please!
Thanks
MacKechnie - Stirling; Fife, Scotland
McKechnie - as above
McKechney - as above
Wallace - Arbroath, Angus, Scotland
Johnston - Killeshandra, Drumcrow, Cavan, Ireland
Rogers - Liverpool, Lancashire


Offline Berlin-Bob

  • Moderator
  • RootsChat Marquessate
  • ********
  • Posts: 7,443
    • View Profile
Re: DBSIG: British Home Children.
« Reply #67 on: Wednesday 20 December 17 08:01 GMT (UK) »
Hi David,

I've entered your user name manually in the database.
Please try again (and let me know ihow you get on)

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

Offline David C. Mackechnie

  • RootsChat Extra
  • **
  • Posts: 12
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: DBSIG: British Home Children.
« Reply #68 on: Wednesday 20 December 17 15:33 GMT (UK) »
Hi Bob,  Thanks for your response.  Tried again this morning after clearing all RootsChat cookies.  As you can see from the attached, nothing has changed!
Thanks anyway...
David
MacKechnie - Stirling; Fife, Scotland
McKechnie - as above
McKechney - as above
Wallace - Arbroath, Angus, Scotland
Johnston - Killeshandra, Drumcrow, Cavan, Ireland
Rogers - Liverpool, Lancashire

Offline Romilly

  • RootsChat Marquessate
  • *******
  • Posts: 5,428
    • View Profile
Re: DBSIG: British Home Children.
« Reply #69 on: Wednesday 20 December 17 21:27 GMT (UK) »

Well I didn't have any problems when I added my 2 Great Uncles.

Romilly.
Any census information included in this post is Crown Copyright, from www.nationalarchives.gov.uk
Researching:
Wilson, Warren, Dulston, Hooper, Duffin, Petty, Rees, Davies, Williams, Newman, Dyer, Hamilton, Edmeads, Pattenden.

Offline Robynkc

  • RootsChat Extra
  • **
  • Posts: 33
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: DBSIG: British Home Children.
« Reply #70 on: Friday 14 June 19 03:44 BST (UK) »
Hi there,
I'm trying to trace grandparents who came to Fairbridge Farm in 1910/1920. His surname is Allen and don't know the grandmothers names.  They apparently married at Fairbridge Farm where they met. Possible marriage around 1928/1931. I was adopted and cannot find my mother Jean Allen, B.1932 as she may have passed. So am trying to find my grandparents names then maybe find some siblings of my biological mother. 
Thank you Robyn Condran (on behalf of adoptee)

Offline mollipops1

  • RootsChat Senior
  • ****
  • Posts: 318
  • Census information Crown Copyright, from www.nationalarchives.gov.uk
    • View Profile
Re: DBSIG: British Home Children.
« Reply #71 on: Friday 14 June 19 04:17 BST (UK) »
Hi Robyn

Possible is Walter Bevis ALLEN (1901-1981), who arrived aboard Belgic in 1913 and was at Fairbridge.

He married Edith Blanche BRANSBY in 1929, they divorced in 1935. But I can't see her in the index to Fairbridge. https://trove.nla.gov.au/newspaper/article/94903238

He remarried in 1940 to Hilda WHITWORTH and died in South Australia.