Capital Trials at the Old Bailey

Received the proofed 1780-84 data file from SD. After adding "HighTreason" as a crime_normalized, the file has 100% validation.

As of today, these are the data sets that are complete (i.e. use the latest schema and are 100% valid):

• 1780-84
• 1785-89
• 1790-99
• 1800-09

Sent SD the 1785-89 XML file that was converted from the Excel spreadsheet he sent me the other day. He will check all the data and address the few validation errors that I didn't fix.

Now that SD is putting his data into Excel spreadsheets, the import procedure is (thankfully!) a lot simpler than the first process:

Step 1:

1. Use Oxygen to convert Excel spreadsheet to XML (File -> Import -> MS Excel File); ensure that "First row contains field names" is checked
2. Save as step_1.xml

Step 2:

1. Transform step_1.xml with transformations/1_to_2.xsl
2. Save as step_2.xml

Step 3:

1. Transform step_2.xml with transformations/2_to_3.xsl
2. Add RNG schema line to the top of the file:
   <?oxygen RNGSchema="http://web.uvic.ca/~lang02/bailey/schema/bailey_trialfile_proofing.rng"type="xml"?>
3. Validate and correct any errors. Given the variable nature of the data, 100% validation probably won't be possible at this point
4. Save as step_3.xml
5. Send the file to SD for proofing/final validating

Judges:
Adair-J
Gould-H
Hotham-N
Nares-G
Willes-J
Willes-E

Normalized outcome:
T3

Respite delays:
ThreeDays
TenDays

If you want to loop through a series of XML elements in an XSLT stylesheet and group by more than one element (for example, the combination of <first_name> and <last_name> elements), use the concat function to create a 'virtual key':

<xsl:for-each-group select="row" group-by="concat(First_Name, ' ', Last_Name)">
    <xsl:variable name="theKey" select="current-grouping-key()"/>
<xsl:for-each-group>

Received 1785-89 data from SD, which he put into an Excel spreadsheet. This will be the standard way for him to give us data from now on. I will be writing a new raw-to-XML procedure to handle the import process shortly. Hopefully this method will be less painful and time-consuming than the previous method, which began with a MS Word doc.

Received the 1790-9 data XML file from SD yesterday, freshly re-proofed and ready for re-import into the development website.

Heard from SD the other day, who is back from Britain. He's going to re-proof the 1800s data. His hopeful plan is to have all data from 1714-1810 in order by the end of the summer. As long as the new data looks roughly the same as the data we've already received, this shouldn't be a problem on our end.

SD is in Britain from April 2 - May 16. Since the ball is currently in SD's court - he's double checking the 1790s and 1800s data - progress will be on hold until the latter half of May.

Regular HTML multiple select fields are ugly and not very user-friendly, so for the Bailey search form I'm using a JQuery plugin called bsmSelect to turn the select fields into something more usable: https://github.com/vicb/bsmSelect