Archives for: April 2012, 12

12/04/12

Permalink 04:28:07 pm, by sarneil, 114 words, 43 views   English (CA)
Categories: Activity log; Mins. worked: 240

hist : add 6 years of data to colonist index db

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.

Depts

This blog is for work done for academic departments which does not fall under other categories.

Reports

Categories

April 2012
Sun Mon Tue Wed Thu Fri Sat
 << < Current> >>
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30          

XML Feeds