HCMC Blogs

Sent email to CP (cc'd RLK, AL, SA) with site updates. (Included: template edits (home page buttons); contact information; page mirroring)

Medals
Awarded during WWI (from http://www.veterans.gc.ca/eng/remembrance/medals-decorations/orders-decorations)

Victoria Cross
George Cross (none in DB yet)
Commander of the Order of the British Empire (CBE)
Distinguished Service Order (DSO)
Officer of the Order of the British Empire (OBE)
Member of the Order of the British Empire (MBE)
Royal Red Cross Class 1 (RRC)
Distinguished Service Cross (DSC)
Military Cross (MC)
Distinguished Flying Cross (DFC)
Air Force Cross (AFC)
Royal Red Cross Class 2 (ARRC)
Distinguished Conduct Medal (DCM)
Conspicuous Gallantry Medal (Naval) (CGM)
George Medal (GM) (none in DB yet)
Distinguished Service Medal (DSM)
Military Medal (MM)
Distinguished Flying Medal (DFM)
Air Force Medal (AFM) (None in DB yet)
British Empire Medal (Military and Civil) (BEM) (None in DB yet)

Others recommended by Jim:
Croix de Guerre (Belgium)
Croix de Guerre (France)
Cross of Military Merit 3rd Class (Bavaria)
Knight Commander of the Order of the British Empire
Member of the Order of the British Empire
Officer of the Order of the British Empire (OBE)

26 total. Approved by Jim. in notes section. Finished flagging appropriate medals as Approved by Jim 6-9

Note: There are two medals flagged as Unclear (Conspicuous Gallantry Medal and Royal Red Cross) that do not specify which of the two medals they are, but both belong on the approved medal list.

824 new page-images (in three different sizes) from the following volume have been added to the Colonial Despatches collection: CO 60 Vol 18 (BC 1864 Despatches to London January to June). These will now be linked into the transcription documents.

JSR is now looking at the spreadsheet I created a couple of weeks ago attempting to integrate GIS data with our lot-based info. Many questions arise out of this, and we've had a long email discussion; I've done some programmatic investigation of some difficult issues including block/lot identifier collisions, and we're coming down to a set of instructions for moving forward, which I'll try to codify when the discussions are complete, and execute next week.

MB and MT reported that many of the IML files are now fixed. Went back and updated my conversion code to take account of the fact that the header metadata is now removed into three separate remote files, and ran the conversions against MND and MV files with apparent success; DJ has the former files and JJ the latter, for checking and to use as the basis for further editing work. I now have to handle one remaining stage, which is the processing of the text-node-level ligature/glyph encoding.

Integrated some new changes and fixes from ST into the live site, and rewrote much of the initialization JS so that additional editing features can be made available in a module way. An options object is now a final optional parameter to the startup function.

Edited footer (assets-blocks-template-footer) with department contact info.
Reviewing site daily: compiled list of additions/edits/revisions to be addressed
Scheduled next site-review meeting (June 21, 2016) with RLK, PS, JN.

Tested on dev, then deployed and tested on live. These are the details:

/* Changes to the db to add support for Rights to Purchase. */


/* Additions to the Titles table. */

ALTER TABLE `titles` ADD COLUMN `ttl_rp_amount` int(11) default NULL AFTER `ttl_marketvalue`;
ALTER TABLE `titles` ADD COLUMN `ttl_rp_interest` DECIMAL(5,2) default NULL AFTER `ttl_rp_amount`;
ALTER TABLE `titles` ADD COLUMN `ttl_rp_outstanding` int(11) default NULL AFTER `ttl_rp_interest`;

/* Creation of a new linking table for RP holders. */

CREATE TABLE IF NOT EXISTS `rpholders_to_titles` (
  `rph_rph_id` int(11) NOT NULL auto_increment,
  `rph_owner_id_fk` int(11) NOT NULL,
  `rph_title_id_fk` int(11) NOT NULL,
  PRIMARY KEY  (`rph_rph_id`),
  KEY `rph_owner_id_fk` (`rph_owner_id_fk`),
  KEY `rph_title_id_fk` (`rph_title_id_fk`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

ALTER TABLE `rpholders_to_titles`
  ADD CONSTRAINT `rpholders_to_titles_ibfk_1` FOREIGN KEY (`rph_owner_id_fk`) REFERENCES `owners` (`own_owner_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `rph_to_titles_ibfk_2` FOREIGN KEY (`rph_title_id_fk`) REFERENCES `titles` (`ttl_title_id`) ON DELETE CASCADE ON UPDATE CASCADE;


/* Additions to the Titles table in local_classes.php. */


$this->addField(new MdhOneToManyField('ttl_rpholders', 'RP Holders',
                                'ttl_title_id', 
                                'owners',
                                'own_owner_id',
                                'own_desc',
                                'rpholders_to_titles',
                                'rph_rph_id',
                                'rph_title_id_fk',
                                'rph_owner_id_fk',
                                true, 'own_desc', true));
$this->addField(new MdhIntField('ttl_rp_amount', 'RP Amount', '', true));
$this->addField(new MdhDecimalField('ttl_rp_interest', 'RP Interest Rate', '', 5, 2, true));
$this->addField(new MdhIntField('ttl_rp_outstanding', 'RP Outstanding Balance', '', true));

Busy.

Implemented the bundle code feature, but didn't want to make major changes while the team is working; wrote the SQL and PHP to do it, and tomorrow morning first thing I'll run them on dev and if they work, port the changes to live.