search

CUB-Libraries-CTA / counter-data-loader

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

Duplication of usage data when reloading a JR1 report #3

Closed ghost closed 4 years ago

ghost commented 4 years ago

If a JR1 report (spreadsheet) is reloaded, usage data is duplicated causing counts to double (or triple, etc.). If a JR1 report needs to be reloaded for any reason, and if usage data already exists for that report, counts should be updated rather than duplicated.

Identified duplicate date should also be deleted.

ghost commented 4 years ago

Duplicate checking was added to the usage_stat class. New rows are inserted while existing rows are updated.