2005-02-21
Maintained by Adam Chandler (alc28 at cornell.edu)
Purpose of script: To convert Project Counter formatted JR1 usage data to the Project Counter XML format.
Syntax: jr12xml.pl filename startingcell endingcell year
Example: jr12xml.pl file.xls A6 N558 2004
File must be in Excel format and end with .xls
The Excel input file should be in a directory called input.
The XML output file will be written to directory called output.
Starting cell: The starting cell should say Title and is in the same row as the month names.
Ending cell: The ending cell is the last cell that contains usage data, located in the far bottom right cell.
For details about the Counter Excel format see: http://www.projectcounter.org/codeofpractice.pdf
DTD: http://www.projectcounter.org/dtd/2004/reports.dtd
Outstanding issue: The version fo the script available beolow does not completely handle character encoding mappings. I will be addressing this in a March 2005 version.