https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34587
--- Comment #26 from Pedro Amorim <pedro.amo...@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. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/