Depts

Had a project proposal from MC in Philosophy, and responded with some more detailed questions. She will now set up a meeting with Greg in a couple of weeks to thrash out the details, but it looks as though a Wordpress front end with an AdaptiveDB back end for the data might be the simplest approach. For integrating the db content into the Wordpress front end, we can follow Jamie's excellent example and use the plugin he's written.

Assigning this as a task to me, so that I remember to come back to it in August.

Digitized two Japanese teaching tapes (permission has been obtained) for MK. The digital files will still need to be chopped into the appropriate chunks; I'll do that over the summer.

Update to Rels site at SA's instructions.

Made the preliminary changes to the Kings db following the project meeting today. This is the SQL:

/**
* Changes to Kings DB made July 2011.
**/

/* Add the new field to three tables. */
ALTER TABLE monarchs ADD mn_dateInfo VARCHAR(128) AFTER mn_notAfter;
ALTER TABLE refs ADD rf_dateInfo VARCHAR(128) AFTER rf_notAfter;
ALTER TABLE sources ADD sc_dateInfo VARCHAR(128) AFTER sc_notAfter;

/* Delete the old datePrecision field from the three tables, along with 
   its associated table. */
  
ALTER TABLE monarchs DROP FOREIGN KEY mn_datePrecision_fk;
ALTER TABLE monarchs DROP mn_datePrecision;

ALTER TABLE refs DROP FOREIGN KEY rf_datePrecision_fk;
ALTER TABLE refs DROP rf_datePrecision;

ALTER TABLE sources DROP FOREIGN KEY sc_datePrecision_fk;
ALTER TABLE sources DROP sc_datePrecision;

DROP TABLE datePrecisions;

Parallel changes were made to local_classes.php.

Moving CB from Faculty to Emeritus, at LW's request.

Met with PC today, and discussed the db structure. We arrived at the following changes to be made this week:

• Replace the datePrecision field in multiple tables with a plain text field called dateInfo, in the db, and then in local_classes.php.
• When that's done, delete the datePrecisions table from the db and from local_classes.php.
• Add a new multiline text field called sc_citation to the sources table, and include it in local_classes.php.

PC will also send over the latest block of biblio items he's collected into Zotero in MODS output format, which I'll then try running through my mods_to_sql.xsl file to create an import file and get them into the db. It's not clear how well this will work, but if it proves relatively simple it'll be worth doing to eliminate a lot of manual data entry.

Minor updates to site on DR's instructions.

Another update to the PA site at DR's request. The person who usually does the updates on the development site on lang03 is unable to at present, so I'm making the updates in both places, to keep everything in sync.