Canadian Mysteries

With Merna's retirement Sarah Taekema has been brought on board as the new "Admin" for non technical work at Canadian Mysteries.

Her duties include the social media aspects of the project (Twitter, newsletter writing) and also answering email. Sarah has been given access to the email account "mysteries". I gave her the credential and also changed the .htaccess file located in /teachers/guides/admin on the GUMICH server to include her netlink ID.

John says the project will continue to run down over the next two or three years.

Franklin site has four standard sizes for the image of each object in the archive: original as provided, 1024px wide, 500px wide, 100x100px thumbnail. In the archive/imageImages folder of the site, there are subfolders original, thumbnail, 1024 and 500

For the batch of new images from Parks Canada, I created a new folder for each size containing the original images. I then
cd into the 500 folder
sips --resampleWidth 500 *.jpg [image is 500px wide by Ypx high to maintain aspect ratio of original]
cd into the 1024 folder
sips --resampleWidth 1024 *.jpg [image is 1024px wide by Ypx high to maintain aspect ratio of original]
cd into the thumbnail folder
sips --resampleHeightWidth 100 100 *.jpg [image is 100px wide by 100px high, aspect ratio will be sacrificed - image distorted]

Then I copied those images into the appropriate subfolder in the archive/imageImages folder

The two learning materials pages are in the root of the franklin site, i.e. not in any section or subsection and thus outside the navigational structure of the site (kind of orphaned). Also means these two html pages have to be maintained manually, rather than by maintaining the xml data file and then transforming to create the html files.
I've created an xml file in the Home section for french (material pedagogique) and for english (learning materials) and modified the transformation and schema files to generate html pages properly in the home section.
The two files in the root folder, I've added a meta redirect to each to redirect to the appropriate page in the home section of the site.

JL called asking for a list of the Canadian cities from which teachers have registered. I pulled the XML version of the tg_users table from the server and ran this:

let $tables := for $t in //table[column[@name='mailingCountry'][normalize-space(upper-case(.)) = 'CANADA']] return $t
let $addresses := for $t in $tables return normalize-space(upper-case(concat($t/column[@name='mailingCity'], ', ', $t/column[@name='mailingState'])))
let $uniqueAddresses := distinct-values($addresses)
let $orderedAddresses := for $u in $uniqueAddresses order by $u return $u
return string-join($orderedAddresses, '
')

to get a quick-and-dirty list of city, province. I had to search-and-replace some ugly character encoding issues -- the db thinks it has UTF-8 but the data coming in has obviously been 8859-1. Sent the results to JL.

changed 22 instances of "csmgenr2.uvic.ca" to "gen1p.mysql.uvic.ca" as the old mysql server is being decommissioned.
Some old instances Seems to be working. If there are problems, they will occur trying to create or authenticate a teacher id and password.

I styled the Google Search bar and results page for the for the Franklin site.

It can be seen here:
http://www.canadianmysteries.ca:8080/demo/current/home/googleCSE.htm

Styling was done using a combination of the Google provided console for "look and feel" and many forced styling changes with "!important" rule to override Google's property values. This was done through the sites own style sheet: FranklinLayout.css.

While waiting for the site's owners to approve or not approve the engine we have to figure out a method of providing a French language results and search bar. This involves making a second search engine with French as its default language and then serving it only to pages with "_fr" in their file names.