...
Using the Batch Processing Stats Database
How to Compile Batch Processing Statistics for the Fiscal Year End
Using the Principal Cataloger's and Director of Cataloging and Metadata Special Reports
...
- Go to \\files.cornell.edu\LIB\ds-deptshares\tsstats and open the .mdb file called “3_BATCHstats.mdb.”
- At the right side of the screen, double-click on the macro called “1 – Batch BIB Summary Report.” (see below)
The following window will appear (below). Enter the starting and ending dates for the time period for which you wish to collect data.
If you haven’t already been in an Access database for Voyager during your computing session, Access will ask you for the VGR7 username and password (dbread, dbread). (see below)
The script will start to run a series of queries. When it is done, it will open the report containing the data for the date range you entered. (See next page for screenshot.) NOTE: If you want to save a copy of your report, you’ll need to right click on it and Export it as a PDF. If you or someone else runs the query before you’ve done that, your report will be overwritten and you will have to run it again (and export it immediately) in order to save the information it generated. Here's a sample report (below). See also the annotated version, after this one.
...
G. How to Compile Batch Processing Statistics for the Fiscal Year End
(Note: This process is carried out by the TS Stats Database Admin on behalf of the Batch Processing Supervisor. It is done by running multiple queries from multiple databases, and utilizes multiple spreadsheets. Please click on the section G title, above, to go to the documentation for this process.)
...