Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...