acosta-mccarthy
Here you will find the code and sample reports from "The Prequel to The SQL", presented at the Mid-Atlantic Innovative Users Group meeting on 10/12/2018
Pinned Repositories
Annual-reports
Create system-wide masterlist of holdings,additions, and borrowers for Annual Report of New York State. Includes code for both the January report, as well as the school district report to be run in July.
Collection-Evaluation
SQL query with Python code to trigger two different emails depending on the number of rows pulled.
Detailed-fine-data
Get list of patrons and associated fines owed to a specific library during a certain time period
Expiring-patrons
Get list of patrons whose cards are expiring next month
Funds
SQL query to create a list of funds for Sierra and the amount expended
Holds
SQL query to create a list of bibs with holds in which the pick-up location is specified.
Invalid-Locations
Get list of order records created with invalid location code
Locate-deleted-item-fine
Search the fines table to locate an outstanding fine on deleted item (No python code, just adapt and SQL query as needed)
Manage-suppressions
Get list of circulating items attached to suppressed bib record
orderstatus
AutoIt macro to update order status in a review file in the Sierra ILS
acosta-mccarthy's Repositories
acosta-mccarthy/Annual-reports
Create system-wide masterlist of holdings,additions, and borrowers for Annual Report of New York State. Includes code for both the January report, as well as the school district report to be run in July.
acosta-mccarthy/Collection-Evaluation
SQL query with Python code to trigger two different emails depending on the number of rows pulled.
acosta-mccarthy/Detailed-fine-data
Get list of patrons and associated fines owed to a specific library during a certain time period
acosta-mccarthy/Expiring-patrons
Get list of patrons whose cards are expiring next month
acosta-mccarthy/Funds
SQL query to create a list of funds for Sierra and the amount expended
acosta-mccarthy/Holds
SQL query to create a list of bibs with holds in which the pick-up location is specified.
acosta-mccarthy/Invalid-Locations
Get list of order records created with invalid location code
acosta-mccarthy/Locate-deleted-item-fine
Search the fines table to locate an outstanding fine on deleted item (No python code, just adapt and SQL query as needed)
acosta-mccarthy/Manage-suppressions
Get list of circulating items attached to suppressed bib record
acosta-mccarthy/orderstatus
AutoIt macro to update order status in a review file in the Sierra ILS
acosta-mccarthy/Volume-field-check
Get list of items added the previous day that contain volume fields