Page Comparison

...

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.

1. Include Bibliographic Details - Local Param 02 as a column in the Details tab
2. In the menu options for Local Param 02, choose "edit formula"
3. Click the f(...) button to Insert Function
4. Navigate to String → Substring and click OK. You will now see the syntax SUBSTRING("Bibliographic Details"."Local Param 02" FROM startPos FOR length)
5. We want the first 8 characters, so edit the last part to FROM 0 to 8 and click OK. You can also rename the column to something like "CAT DATE"

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.