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

Offline Berlin-Bob

  • Moderator
  • RootsChat Marquessate
  • ********
  • Posts: 7,437
    • 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)

My research interests (and data found) can be seen on my website:   http://www.margulies-chronicles.com/

RootsChat is the busiest, largest free family history forum site in the country. It is completely free to use. Register now.
Also register instantly with Facebook or Twitter (and other social networks). Start your genealogy search now.


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.

RootsChat is the busiest, largest free family history forum site in the country. It is completely free to use. Register now.
Also register instantly with Facebook or Twitter (and other social networks). Start your genealogy search now.


Offline Berlin-Bob

  • Moderator
  • RootsChat Marquessate
  • ********
  • Posts: 7,437
    • 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)

My research interests (and data found) can be seen on my website:   http://www.margulies-chronicles.com/

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,437
    • 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)

My research interests (and data found) can be seen on my website:   http://www.margulies-chronicles.com/

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: 4,334
    • 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.