[Koha-bugs] [Bug 34587] Add a Usage Statistics module to ERM

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34587

--- Comment #26 from Pedro Amorim <pedro.amorim at ptfs-europe.com> ---
(In reply to Michaela Sieber from comment #24)
> As far as I can see all titles are harvested now.
> 
> But the usage per month is not correct in my report. 
> First run 01.-31.01.2023
> Second run 01.02.-30.04.2023
> 
> Example: Nature (Online ISSN 1476-4687) 
> 
> normally 3000-4000 Unique_Item_Requests per month.
> 
> Unique_Item_Requests should be: 
>  Jan23: 3431	
>  Feb23: 3159
>  Mar23: 3758
>  Apr23: 2775
> 
> Check Import Logs on Data provider Springer and Download file.
> The usage numbers for Nature (=ISSN 1476-4687) for Platform nature.com are
> correct in the downloaded file .  
> 
> Check now the created J1 report 
> 
> See that the usage numbers for February and March are wrong
> Unique_Item_Requests	
>  Feb23: 20	
>  Mar23:  6
> 
> usage numbers for Jan and April are correct

Hi Michaela.
Once again, thank you so much for this invaluable testing (and sign-off!). We
detected and fixed 2 issues here:

1) The problem seems to have been because the 2 titles titled 'nature' in the
first report have the same 1476-4687 ISSN and Proprietary_ID, in fact the only
thing that differs between the two is the Platform. This was causing the
'nature' title to match erroneously. This is the first time we've seen this and
we improved our matching rules:
https://github.com/PTFS-Europe/koha/commit/a855ea64e5b97262bc9a89826020fc43a601418f

The problem was even bigger for the period of jan to april 2023. Because here
we have 3 instances of 'nature' 1476-4687 ISSN, but all 3 are from different
platforms.

With the above fix, everything should be correct in the first harvest, as well
as all subsequent harvests. These 3 'nature' titles are effectively 3 different
titles in Koha and each have their corresponding correct monthly usages.

I've reset the sandbox with these fixes if you're available to test it once
again.

2) One issue in the logs detected was 'title' column was too short, we changed
it from varchar(255) to mediumtext to address this:
https://github.com/PTFS-Europe/koha/commit/32f6bbf4bc79d07a9815bbaa17756a9ca9938724

-- 
You are receiving this mail because:
You are watching all bug changes.