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, DOBHe sent me a second file containing the following "global" data:
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