[Wactclc-alma] Problems with Gale COUNTER 5 reports

[Thomas, Kirsti]

Here's a list of the problems I found generating Gale COUNTER 5 reports and loading them into Alma manually.



It sounds like if you have SUSHI harvesting set up with Gale for COUNTER 5 reports, you won't run into these problems.

Kirsti S. Thomas
Library Technical Service Manager
Seattle Colleges
kirsti.thomas at seattlecolleges.edu




Problems with Gale COUNTER 5 reports

Sunday, March 1, 2020

12:30

1) In the Database Master and Platform Master reports, numbers larger than 3 digits contain commas.  THERE SHOULD BE NO COMMAS!  Format any cells containing numbers to *not* use 1000 separator





[Machine generated alternative text: Format Cells  Number  Category:  General  Number  Currency  Accounting  Date  Time  Percentage  Fraction  Scientific  T ext  Special  Custom  x  Alignment  Font  Border  Protection  mple  8493  Decimal places:  use 1000 Separator C)  Negative numbers:  -1234  1234  (1234)  (1234)]







Additional errors can be identified by using the COUNTER 5 Validation Tool:

https://stats.redi-bw.de/counter-r5-validation-preview/





2) In all reports, the cell listing the Report Filters used in the report has an error



Data_Type=Database|Journal|Book|Newspaper or Newsletter|Report|Multimedia|Other



should be



Data_Type=Database|Journal|Book|Newspaper_or_Newsletter|Report|Multimedia|Other



3) In the Title Master Report-- if you've set the report to include the Data Type column-- the Data Type value Newspaper should be Newspaper or Newsletter (i.e. it should match the value in the Report Filters cell)



4) In the Title Master Reports, the Publisher is missing for Merriam Webster's Collegiate Dictionary. The Publisher should be Merriam-Webster, Inc.



5) In some Title Master reports, a 10-digit ISBN appears in the ISBN column. All ISBNs in this column should be 13-digit ISBNs. Use the ISBN Converter at isbn.org to calculate the 13-digit ISBN from the 10-digit ISBN. Replace the 10-digit ISBN with the 13-digit ISBN.





Created with Microsoft OneNote 2016.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200310/92100897/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 13118 bytes
Desc: image001.png
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20200310/92100897/attachment.png>