...
Managers may retrieve statistics for each member of their reportsstaff, and may also retrieve statistics for their units, for any desired date range. They may run these queries at any time they desire. Monthly retrieval of statistics for the entire department is executed by the LTS Administrative Support Specialist, who compiles this information into a spreadsheet for each fiscal year. This spreadsheet is distributed throughout LTS management and shared with Library Administration.
Additional , specialized reports have been written in a separate database to gather information regarding batch processing production in LTS. These statistics are compiled by the Batch Processing Supervisor for each fiscal year.
Anchor connect connect
B. Connecting to the Technical Services Statistics Database
| connect | |
| connect |
Note: if you need help with the following set-up, please send a message to desktop support at cul-dshelp-l@cornell.edu.
- Download and install the MySQL ODBC 5.1 driver. The installer is available on the LTS share, in "netadmins\Software\MySQL." Also, either create a desktop shortcut to the database, or map drive to it. The database is found at \\files.cornell.edu\lib\ds-deptshares\LTS\tsstats\1New_culv2-2012-2013.accdb.
- Ask Amy Blumenthal or Chris Manly for the database password.
- Configure the driver, using the 32-bit ODBC Administrator, here: c:\windows\syswow64\odbcad32.exe. (Note: Do not use the ODBC Administrator in Control Panel/Administrative Tools.)
...