nicoleallengrw Goto Github PK

batfile

This is an example of the bat file you will need to run using Task scheduler

callnostats

This is the code for creating call no stats at Greenwich Library.

holdingsreport

Here is a report of all holdings at our Branchs

holds

Here are a bunch of automated reports I have created that help us better manage our holds. We want to ensure almost nothing falls through the cracks and catch issues before our patrons do. Thanks to Brent Searle of Langra College for sharing this query with me!

i-type-stats

This is the SQL query and Python script for pulling circulation stats by i-type and broken up by location

i-typestats

This is how our monthly circulation numbers are pulled. We use the i-types to report our numbers, Since digital numbers are provided by vendors and not through Sierra, they will need to manually entered.

linearfeetforeachcollection

This code pulls each collection by call number ranges. It gives the number on and off the shelf, the average number of items per shelf and the number of linear feet required for each shelf.

marked-missing-more-than-6-months

All materials that have been marked missing for more than 6 months

p-code-3-ct-card-circs-by-month

Circulation of all PCode3 Ct-Card members by home library. In order using the spreadsheet supplied by Ct-Card

patrons-created-last-month-by-p-type

wrongaudience008field

Here is a report that tells you when the 008 field contains the wrong audience code.