Will write one XSLT file that turns all the texts of normalized values into integers corresponding to the id of that text value in the appropriate table. End result will be an XML structure identical to the one that went in, but with all the normalized, and group values modified.

I'll also migrate the code that modifies the data from the convention used in the XML to what the SQL requires.

That leaves another XSLT transform file which will take the output generated above and render SQL statements. Then I'll need to modify some javascript code to take all the id's generated by the XSLT (which are in the form X3Y124) and render them as integers. Result of that should be an sql file full of statements to populate the relevant tables with the data for a decade.

Have begun on the first XSLT file, got the crime-groups and judge-names working, leaves crime-normalized, respite-normalized, outcome-normalized, and probably jury-type and jury-subtype and a couple of others to do.