hist : add 6 years of data to colonist index db
Posted by sarneil on 12 Apr 2012 in Activity log
Finished process of processing files into tab delimited text files for upload into the mySQL DB, following process in the documents HowTo/HowToProcessColonistFiles.txt and HowTo/sql_for_load_data_file.txt files.
Modified HowToProcess document a bit to capture new conventions for encoding cemetary plot identifiers.
Modified sql_for_load_data_file as it had the field names in the wrong order (cemetary followed transcript rather than preceded it in the list of fields)
Uploaded data for 1927, 1928, 1929, 1930, 1931, 1932 into the database.
Reorganized folders containing data files and synchronized the files on the server and the files on my Mac so I have identical copies of the data files and the website on both machines.