| Table of Contents |
|---|
Loan Count
If you want to include the total number of loans for an item in your Analytics report, you need to use a Physical Items report rather than a Fulfillment report. In the Physical Items report, go to Physical Item Details, then No of Loans. If you use a Fulfillment report, there is a measure called Loans that is actually year-to-date loans, not total.
...
There is a limit to how many rows of a report can be exported to Excel. According to this page, the limit for a CSV file should be 500,000. Observation on 2/23/18 shows the limit seems to be 499,801.
Cataloging Date
The Cataloging Date can be extracted from Local Parameter 2 by using the SUBSTRING function.
...
Once the Cataloging Date is available in its own column you can filter data to get a report of records cataloged during a given date range, such as between 20170701 and 20180630 to report on FY18. Note that this only works from July 2017 forward (post Alma implementation).
Isolating MARC Subfields
Ex Libris now includes MARC subfields in Analytics Local Parameters. Particularly for Local Param 02, it is possible to split this field into separate columns by subfield.
...
- Use the filter for the appropriate field, such as MMS ID or Item ID. If you are expecting an exact match, select "is equal to" and paste in your string of IDs
- If you are not expecting an exact match (e.g., if the identifier is an ISBN and the field probably contains multiple ISBNs) select "contains any"
- There is some limit to how many IDs you can paste into a filter. The limit is much higher if it is an exact match. I usually do four pages of ISBNs at a time and up to 26 pages of Item or MMS IDs. Analytics is sometimes inconsistent about how much it will accept, so if you get an error, trying using fewer IDs temporarily.
- When copying IDs from the Word document, make sure your string does not start or end with a semicolon!
Strategies for Identifying Malformed Barcodes
- Character length
- Duplicate the barcode column
- Edit the formula to
CHAR_LENGTH("Physical Item Details"."Barcode") - In Filters, filter on
CHAR_LENGTH(Barcode) is not equal to / is not in 14 - Contains non-numeric characters
- Duplicate the barcode column
- Edit the formula to
evaluate('REGEXP_INSTR(%1, ''^[0-9]+$'')',"Physical Item Details"."Barcode") - In Filters, filter on
EVALUATE('REGEXP_INSTR(%1, ''^[... is equal to / is in 0 - Barcodes that do not start with 39074 (this applies to Main campus; Ginsburg barcodes may start with 32875; other campuses may have other expected barcode prefixes)
- Duplicate the barcode column
- Edit the formula to
SUBSTRING("Physical Item Details"."Barcode" FROM 0 FOR 5) - In Filters, filter on
SUBSTRING(Barcode FROM 0 FOR 5) is not equal to / is not in 39074