search

CUB-Libraries-CTA / counter-data-loader

Loads COUNTER database from JR1 report spreadsheets
1 stars 2 forks source link

JR1 report does not meet COUNTER 4 standard #2

Closed ghost closed 4 years ago

ghost commented 4 years ago

The COUNTER 4 standard is very specific on how JR1 reports are to be formatted. Any deviation from this standard will likely cause an exception to be raised during processing. When this happens, the offending JR1 report is skipped and is not processed.

One specific formatting problem will raise an exception at the outset of processing. If the JR1 report does not start at row 1 in the spreadsheet, the current script will not be able to process the report. The offset needs to be considered when parsing data from the report.

ghost commented 4 years ago

This problem has been temporarily solved by introducing an offset variable to shift the row count to where the data rows actually start in the spreadsheet. Going forward, though, it is proposed to more strictly adhere to the COUNTER specifications (R4 and R5) when loading spreadsheets. Any deviance from the standard will cause the loading process to stop and move to the next item in the list. This change will be addressed in the next release.