Year end Custom Reports, Korn Shell Programs and Processes done by ITS
- Around March 6th re-run the custom report yeprobserordv2 (currently scheduled monthly) which will list problem serial orders for Serial Acq for the new way they do orders. Any serial orders with CLAIM segments are listed. Line one of recurring orders are NOT anaylzed for problems. Cancel errors where not all copies received and date to cancel is past but none are cancelled. Partial cancellations (for orderline) are listed in case the cancellation notice never went out. Any serial orders with a date ready of NEVER and number of copies on order greater than zero. More copies paid than received for non-DATED orders. Order is received but not paid (based on date received in criteria). Order has no funding segments.
- Around March 12th re-run (currently scheduled monthly) run the yeprobmonorder custom report which is based on the Work/NDL/Carl/problemmonoord.ksh program which targets specified fical cycles and detects monographic order errors. Output is sent to the head of Acq. Dept.
Get the Date Rec'd that should be invoiced from C. Hayward. Run the program
targeting EACH fiscal cycle
which is still open (I did ALL cycles 1996 onwards) (I did 2004 and less2004. -mjp,
3/14/2005). Problemmonoord.ksh was the original script which was run as in: problemmonoord.ksh (FISCAL CYCLE to target in format: YYYY) (output file)
- Problems targetted and reported out are--
- CANCEL errors:
- no copies are cancelled but date to cancel is past, outstanding copies unrcvd
- partial cancellations (maybe never printed a notice!)
- CLAIM errors:
- Orders which have date to claim as NEVER (outstanding unrcvd copies)-NOT APPROVAL
- claims with no reason in them
- claim with open status when order fully rcvd/cancelled
- Order errors:
- Orders with a date ready of NEVER
- Orders with too many order lines if multi-part N--allowed ONE orderline,
- if multi-part Y--# orderlines cannot exceed # copies o/o plus # copies cancelled
- Orders paid but not rcvd--NOT PREPAY
- Accounting errors:
- Orders rcvd but not paid (order type is firm,approval or prepay)
- Run other Monograph Acq. error reports which would normally be run early in the month like zeroinvlines and INVnotPDinvlin and ZEROorderlines.
- Use to run around March 26 and April 2nd SERIALfunderro to detect serial funds (level1=SERIAL and level2=LIB52,LIB87) in current fiscal cycle that have block overencumb set to Y. Results to adforte and damour.--no need since we rely on fundencumbflagUCBVnewcyc to change all UC,BV funds/fundcycs to block overenc:N in NEW fiscal cycle before we roll over orders.
- Allow a day or so for Mono.Acq. to cleanup the errors, and when they are done, rerun error reports to ensure that the database is cleaned up.
- Repeat the two problem order programs around March 29th for final cleanup.
- Run serialfundnegbal.ksh and send to A.Forte to edit any serial,standing level1 funds with neg free balance. (Run a few days before the actual roll over day so that they can be fixed.)
- Around March 1st run /NDL/serordersmonofund.ksh which will give a list of all serial orders on monograph funds for Budget Manager. This was required in the past because in the old financial system, funds on a non-major 80 and with memo codes of 3, 1, etc, did not get picked up for commitments; these commitments had to be set up manually, but not any more! Now it is needed for A.Waller to do some fund changes or checks etc.
List of 2007 Serial Orders on Monograph Funds
=============================================
...produced on neter.lib.ucalgary.ca on Wed Mar 7 08:16:32 MST 2007
Library|Order ID|Line#|Fiscalcycl|Fund ID|AMT Encumb|Order type|
UCALGARY|986120|1|2007|4125E-91|$0.00|SUBSCRIPT|
UCALGARY|986121|1|2007|4125E-91|$0.00|SUBSCRIPT|
UCALGARY|986168|1|2007|8001-81|$0.00|SUBSCRIPT|
UCALGARY|986175|1|2007|8001-93|$0.00|SUBSCRIPT|
.......
- ALWAYS on April 1st around 0:05 run the billyrend reports for accounts. These are setup as templates in the NEVER run list (so setup and modify and schedule). They are called:
- S.Telfer and A.Forte final monographic fund report, using Sirsi canned reports
- monreordercount -setup & schedule
- monofundlist -setup & schedule
- serbacksetfundlist -setup & schedule Print finished reports for Sandra(?) and Andrew adforte@ucalgary.ca.
- Remember to modify the templates for these two reports to the next fiscal cycle so that when they are requested they will actually produce the new information.
- Remember to modify the templates for monthly or regular reports which target the current fiscal cycle as well:
- blockencNmono
- orderNmono
- blockencNserback
- orderNserback
- monofundlist
- monreordercount
- serbacksetfundlist
- yevendorlst2007 (Suspended in 2006)
- CANCELerror
- edisend
- serclaimDOU1, serclaimDOU2, serclaimDOU3
- UNLINKEDorders
- recurpdnotrecd (No fiscal cycle change needed yet-leave at >2005 til asked to do otherwise.)
- DOUordersNOTrecd
- probmonorders
- probserorders (based on custom yeprobserordv2)
- monofreeErrors (3rd at 4:10)-- (SUSPENDED since 2009)
- Cron programs of fundencumbyacct.ksh (run twice once for MONOGRAPH and once for SERIAL)
- Cron program of trackCHRHIN.ksh
- Cron program of tracknonCHRHIN.ksh
- REMEMBER all the biborderload reports check /Rptsched/schedlist and grep for biborderload to see current ones that need to be updated.
Make sure STMARYS - Colleen Rowe, has used the wizard Review All Funds to search for all the STMARYS fiscal cycle about to be closed records, and used the two helpers to grab all the financial, performance and copy data for that fiscal cycle.
- Unicorn Roll Over process is a 9 step process around Apr. 1st.
- QATAR should be included in all these steps as of April 2010 to April 2015 and STMARYS as of March 2011. Then QATAR broke off into a Jan-Dec fiscal cycle so they are done separately at end of Dec starting in 2015.
- Could decide to run later if needed the various listings below:
- ROserialfundlsNEWBVSMUC setup & schedule to get LISTING of what serial,standing funds UCALGARY,BOWVALLEY,STMARYS will be rolled over. The actual rollover reports never give a list of what actually rolled over so preliminary listings based on the same selection criteria is needed. Simply archive this report as a safeguard if any troubles arise and you require it to investigate.
- ROmonofundls1BVSMUC -setup & schedule giving another LIST of UCALGARY,BOWVALLEY,SMARYS monographic funds which will be rolled over which have Level1=SERIAL and Level2=LIB52,LIB87 (equals the old BACKSET category) and Library is UCALGARY. Simply archive this report after checking that it ran properly without any errors.
- ROmonofundls2BVSMUC -setup & schedule giving the second set of UCALGARY,BOWVALLEY,STMARYS,monographic funds which will be rolled over which have Level1=MONOGRAPH,OTHER and LIBRARY=UCALGARY. Archive after checking that it ran without errors.
- ROvendorcyltBVSMUC -setup & schedule gives list of vendors (UCALGARY,BOWVALLEY and STMARYS) which will be rolled over into next fiscal cycle. Archive this report as a safeguard if any investigation is required later. (The actual roll over vendor reports do not say WHICH vendors were rolled over so this report lists them.)
- ROvendorBVSMUC -JAVA report -setup & schedule ACTUAL roll over report CAREFUL! Remember to modify the old and new fiscal cycles! After reviewing the finished report for any errors, archive it. For UCALGARY,STMARYS and BOWVALLEY.
- Ensure that ALL funds rolled over are set to roll over with order flag set to YES! This is part of the ROfund report.
- ROmonofund1wfUC -JAVA setup & schedule ACTUAL roll over report CAREFUL! Ensure that the funds are rolled over with 60% increase for UCALGARY. (Was 50% til April 2007 process.) Level1=SERIAL and Level2=LIB52 and LIB87 (was BACKSET til April 2007) library is UCALGARY. Remember to modify the old and new fiscal cycles! After reviewing the finished report for any errors, archive it.
- ROmonofund2wfUC -JAVA setup & schedule ACTUAL roll over report CAREFUL! Ensure that the funds are rolled over with 60% increase for UCALGARY. Level1=MONOGRAPH,OTHER library is UCALGARY. Remember to modify the old and new fiscal cycles! After reviewing the finished report for any errors, archive it.
- BVfundcyclist -JAVA setup & schedule change fiscalcycle targetted. Send results to A.Forte of this fundcyclelist of BOWVALLEY funds giving free balance etc.. He will use it to edit BowValley funds manually after they are rolled over.
- YEfundcyclistAM around April 30th--before AUC-NUC rollovers -JAVA setup & schedule change fiscalcycle targetted. Send results to Sandy Ayer and Barbara Quaale this fundcyclelist of AMBROSE funds giving free balance etc. for fiscal cycle being closed off.
- ROmonofund1BVSM -JAVA setup & schedule ACTUAL roll over report CAREFUL! Ensure that funds are rolled over with 100% increase. Level1=SERIAL and Level2=LIB52 and LIB87 and library=BOWVALLEY and STMARYS. Remember to modify the old and new fiscal cycles! After reviewing the finished report for any errors, archive it. (This is what you can use at end of Dec for Qatar as well for amounts to roll over.)
- ROmonofund2BVSM - JAVA setup & schedule ACTUAL roll over report CAREFUL! Ensure that the funds are rolled over with 100% increase. Level1=MONOGRAPH,OTHER and library=BOWVALLEY,STMARYS. Remember to modify the old and new fiscal cycles! After reviewing the finished report for any errors, archive it.
- Run serialfundnegbal.ksh and send to A.Forte to edit any serial,standing level1 funds with neg free balance. (Generally done earlier in the week before the actual roll over day) Once they are done then:
- Run yezerofreebalSMUC against UCALGARY/STMARY's OLD fiscal cycle's level1=serial,standing funds...Use at end of Dec. for QATAR as well. (Any errors listed in the log about Allocation NOT updated is generally due to a neg amount paid or invoiced. These few cases can be cut and pasted from the log and sent to A.Forte to zero free balance manually.) NOTE: Bowvalley is NOT included here on purpose. Andrew F. deals with their funds manually. After yezerofreebal runs, then:
- ROserfundBVUC -JAVA client setup & schedule ACTUAL roll over report CAREFUL! Ensure that the level1=SERIAL,STANDING funds are rolled over with 150% (was 200% until April 2007) increase and library is UCALGARY,BOWVALLEY. Remember to modify the old and new fiscal cycles! After reviewing the finished report for any errors, archive it. (COULD have level two is NOT equal ot LIB52,87 to avoid error 100s for the "backset" funds that were already rolled over via ROmonofund1 but error 100s don't hurt ...)
- ROserfundBVUC change for new libraries STMARYS,QATAR!! -JAVA client setup & schedule ACTUAL roll over report CAREFUL! Ensure that the level1=SERIAL,STANDING funds are rolled over with 100% and library is QATAR,STMARYS. Remember to modify the old and new fiscal cycles and library! After reviewing the finished report for any errors, archive it. (COULD have level two is NOT equal ot LIB52,87 to avoid error 100s for the "backset" funds that were already rolled over via ROmonofund1 but error 100s don't hurt ...)
- fundencumbflagBVSMUCnewcycWF -setup and change to NEW fiscal cycle JAVA to change all UCALGARY,BOWVALLEY and STMARY funds/fundcycs to block overenc: N IN NEW FISCAL CYCLE before rolling over orders so no orders roll over without funding/distribution segments. (Use similar for just Qatar at end of Dec.)
- ROrecurringordBVQSMUC -JAVA setup & schedule NEW since 2006, Ensure that orderlines with: #of copies>0, #cancelled copies=0, number copies received=0, # copies invoiced=0, #copies paid=0, #copies loaded=0 library=UCALGARY,BOWVALLEY,QATAR,STMARYS. This SHOULD ensure that only line one of a non-cancelled recurring order is rolled over into the new fiscal cycle.
- To find any non-line one recurring order that slipped through and was rolled over do:
$ selorder -f"2016" -t"EXCHNG-SO,GLOBAL-SO,MEMB-SO,STANDING" -oKJb | selorderlin -iO -oSJ > 2016recurorders.ndl
$ head -5 2016recurorders.ndl
UCALGARY|2016|903925|1|733170|1|
UCALGARY|2016|932864|1|733171|1|
UCALGARY|2016|900901|1|733172|1|
UCALGARY|2016|931296|1|733173|1|
UCALGARY|2016|904665|1|733174|1|
Fields are Library|Fiscal|OrderID|#lines on order|OrderKey|OrderLineNumber|
$ egrep -v "\|1\|$" 2016recurorders.ndl | more
UCALGARY|2016|908891|2|733610|3|
...
ALERT Serials of any problem orders that show up.
- ROdatedordsBVSMUC -setup & schedule (run once with a renewal date of NEVER and again with renewal date ANY) NEW since 2006, Ensure that orderlines with number of cancelled copies is exactly zero (or check for new procedures for April 2007 process!) NOTE: we may have to run this TWICE after GL3.0 upgrade it appears that new dated orders have to have a sub period greater than 0 which means real renewal dates instead of NEVER so run once with renewal date of NEVER and another run with renewal date of ANY. After reviewing the finished report for any errors, archive it. (Use similar for Qatar end of Dec.)
NOTE: in March provide a list of the non-NEVER renewal date cases to serials for them to fix. (In March 2011, asked to generate this non-never renewal date case list on a monthly basis via crontab.) But still run the two roll over reports in case any cases slip through or were not fixed. How to find non-never dated orders:
use datednonnever.ksh script in /NDL to get this listing. As in:
datednonnever.ksh 2008 datednonnever.out
The file datednonnever.out is generated with the output as in:
Report of 13 Dated Orders in 2008 with non-never date to renew
===========================================================
...produced on neter.lib.ucalgary.ca on Mon Mar 24 11:22:17 MDT 2008
Library|Fiscal|OrderID|Line#|Date to renew|
UCALGARY|2008|983149|101|20070705|
UCALGARY|2008|984466|38|20070419|
UCALGARY|2008|986088|3|20080328|
....
Check the log for such things as:
**#SYNegative amount is not allowed (order:902975 cycle:2009 line:1)
**#SYNegative amount is not allowed (order:934689 cycle:2009 line:1)
**#SYNegative amount is not allowed (order:985469 cycle:2009 line:1)
These are orders that did NOT roll over because of neg amounts paid.
- PRE-2006 used: ROserorders -setup & schedule ACTUAL roll over report CAREFUL! Ensure that order lines with number of cancelled copies is exactly zero; ie. Don't roll over cancelled lines.
- RObasictype1BV - JAVA setup & schedule NEW since 2006, rolling over monograph orders to new fiscal cycle. Results of this report log and prn were put on web for acqusitions to reference.
Orders will be selected if the number of line items is more than 0.
Orders will be selected if the fiscal cycle is 2004.
Order will be selected if type is APPROVAL, BACK-REORD, BACKFILES, BINDERY, FI
RM, FREE-MONO, GIFT-MONO, or PREPAY.
Order will be selected if library is UCALGARY
336501 order record(s) considered.
27387 order record(s) selected.
UNICORN order selection finished on Thursday, April 6, 2006, 1:24 PM
UNICORN orderline selection v2003.1 started on Thursday, April 6, 2006, 1:22 PM
The order key will be read from standard input.
The orderline key will be written to standard output.
Orderlines will be selected if the number of copies is more than 0.
Orderlines will be selected if the number of copies received is 0.
Orderlines will be selected if the number of copies invoiced is 0.
Orderlines will be selected if the number of copies paid is 0.
Orderlines will be selected if the number of copies loaded is 0.
Orderlin will be selected if library is UCALGARY.
Orderlines will be selected if the number of copies claimed is 0.
- RObasictype1BV - setup MODIFY & schedule this time target STMARYS and a separate report again for UCALGARY. (Easier to get output for each library). (End of Dec for Qatar.)
- RObasictype2BV - setup & schedule NEW since 2006, rolling over monograph orders to new fiscal cycle. Same criteria as type1 except number of copies claimed is more than 0. Results of this report log and prn were put on web for acqusitions to reference.
- RObasictype2BV setup MODIFY & schedule this time to target STMARYS and a separate report again for UCALGARY. (End of Dec for Qatar.)
- Run NDL/postrolloverorderlistLIB.ksh to generate listings of orders which did not roll over from past cycles but have outstanding issues...some may need to be manually rolled over and others won't. This program also lists out orders which had claims on them but the claim segments do NOT roll over into new fiscal cycle. Run for all libraries EXCEPT AMBROSE. Run as in (where fiscal cycle is the OLD fiscal cycle):
$ postrolloverorderlistLIB.ksh 2011 UCpostroll2011 UCALGARY
Output for Monographs has been mailed to Nella and is in file UCpostroll2011
- Example output:
Post Roll Over Monograph Order Report for UCALGARY 2011...
=============================================================
...produced on sirsi1 Mon Apr 4 09:57:15 MDT 2011
FiscalCycle|OrderType|OrderID|Ln#|#On order|#rcvd|#Pd|#Inv|#loaded|#claimed|Libr
ary|
109 Orders in 2011 which did NOT roll over:
2011|FIRM|339907|1|1|0|1|0|0|1|UCALGARY|
2011|PREPAY|343647|1|1|0|1|0|0|0|UCALGARY|
2011|PREPAY|346646|1|1|0|1|0|0|1|UCALGARY|
2011|PREPAY|346968|1|1|0|1|0|0|1|UCALGARY|
2011|PREPAY|347781|1|1|0|1|0|0|1|UCALGARY|
2011|PREPAY|347781|2|1|0|1|0|0|1|UCALGARY|
2011|PREPAY|347781|3|1|0|1|0|0|1|UCALGARY|
2011|PREPAY|347845|1|1|0|1|0|0|1|UCALGARY|
2011|PREPAY|349890|1|1|0|1|0|0|1|UCALGARY|
2011|FIRM|351255|1|1|0|1|0|0|0|UCALGARY|
2011|PREPAY|352814|1|1|0|1|0|0|1|UCALGARY|
....
141 Orders which rolled over but lost their original CLAIM segments which are on
ly in the OLD fiscal cycle:
2011|FIRM|280043|1|1|0|0|0|0|1|UCALGARY|
2011|FIRM|323670|1|1|0|0|0|0|1|UCALGARY|
2011|FIRM|324035|1|1|0|0|0|0|1|UCALGARY|
2011|FIRM|327351|1|1|0|0|0|0|1|UCALGARY|
2011|FIRM|328768|1|1|0|0|0|0|1|UCALGARY|
2011|FIRM|330330|1|1|0|0|0|0|1|UCALGARY|
2011|FIRM|330346|1|1|0|0|0|0|1|UCALGARY|
2011|FIRM|330383|1|1|0|0|0|0|1|UCALGARY|
2011|FIRM|330423|1|1|0|0|0|0|1|UCALGARY|
....
- For Ambrose run postrolloverorderlistAmbrose.ksh since they do not pay, invoice or claim orders, their program only looks at the old fiscal cycle for orders that have copies on order that do not equal the number loaded or received and lists those out. Run as in:
$ postrolloverorderlistAmbrose.ksh 2016 ambrosepostroll2016
- NOTE if any of the RO order reports have the following style error messages in them, report to acquisitons for manual roll over:
**#SYNegative amount is not allowed (order:900427 cycle:2007 line:1)
**#SYNegative amount is not allowed (order:901886 cycle:2007 line:1)
**#SYNegative amount is not allowed (order:930944 cycle:2007 line:1)
- After monographic order errors are fixed, it is time to get statistical information out of the system for Carl etc.
- Change the DFC (default fiscal cycle) in /Screens/system.h and do a makeall in that directory as sirsi : nohup sh makeall >&makeall.err&
- Change all related property defaults in /Unicorn/Config/Properties/...(all the files in this directory). Sample line from Apr. 2003 changes in all of the properties files:
PROP_ACQSESSION_CYCLE_D|2003
- non-statistical reports run at this time too:
- save the orders that are about to be purged by running NDL/saveorderstobepurged.ksh. Run it for each library that will have orders purged. Example:
$ saveorderstobepurged.ksh 2008 BOWVALLEY testBVpurpgedump
The start time for this process is Wed Mar 26 12:19:33 MDT 2008
Library is valid, continuing program...
Your report of this dump of orders in in /s/sirsi/Unicorn/Work/NDL/testBVpurpgedump
The end time for this process is Wed Mar 26 12:19:55 MDT 2008
The report when viewed is like this:
There are 84 basic orders being purged from 2008 for BOWVALLEY.
These are the basic order types: FIRM,APPROVAL,GIFT-MONO,FREE-MONO,PREPAY,BACKFI
LES,BINDERY,BACK-REORD.
Here is a list of those cases:
Library|Fiscal|OrderID|order key|line#|orderlin key|
BOWVALLEY|2008|BV-143|392640|1|419724|
BOWVALLEY|2008|BV-147|392641|1|419725|
BOWVALLEY|2008|BV-189|392647|1|419731|
BOWVALLEY|2008|BV-208|392700|1|419786|
....
The file of dumped backup orders is at /s/sirsi/Unicorn/Work/NDL/orders_to_purge
.BOWVALLEY.2008
Move this file into the Rptcustom/YRendbackupYYYY directory as appropriate.
NOTE: this file may have some extra orderLINES because dumpflat order
dumps out all lines for an order key. But better too many than too few!
This was created by NDL/saveorderstobepurged.ksh
- purgemonordersUCBV JAVA setup & schedule -target the orders that rolled over into new fiscal cycle for monographs (see template report and 2006 archived report for details.) Results of this report, log and prn were put up on the web for acquisitions to reference.
- New 2010 due to a roll over bug in the sirsidynix software, we need to check the rolled over orders to see if the new commitment (encumb) amount equals the old PAID or old commitment amount-and report out cases where it does NOT match. So run /s/sirsi/Unicorn/Work/NDL/Serials/datedNOTpdreview.ksh and datedPDreview.ksh. Give report results to Andrew Forte to make adjustments as necessary.
- YEsercontrolvendorWF Copy, modify fiscal cycle (to the "old" fiscal cycle that is being closed off), run. This will list serial controls which are linked to "inactive" vendors (vendors without orders)-for UCALGARY. If the report has results, then in order to send them a simple list of just the vendors involved run vendoronlyNEW.ksh in /Rptcustom/Run/Serctlvend and an email like the sample below will go to ndlall:
- Now repeat by setup & schedule YEsercltvendBVC. If there are any results generated, then run the /Rptcustom/Run/Serctlvend/vendoronlyNEW.ksh program. Send this report to Doucette and Serial Acq. so that they can "manually" roll over the vendors into the next fiscal cycle which will be needed for the controls to properly roll over in the next report. Report critieria... In order to send them (Mack Staff: mcgonigl@ucalgary.ca and Doucette staff: kangas@ucalgary.ca) a simple list of just the vendors involved run vendoronlyNEW.ksh in /Rptcustom/Run/Serctlvend a email like the sample below will go to ndlall:
This is the number of ACTIVE controls associated with the vendors
listed below. These are inactive vendors or vendors with zero orders attached.
Send this list to Doucette and Serial Acq for manual rollover of these vendors.
Count|LIBRARY|VENDOR_ID|
1 UCALGARY|S-ABLANDCOMPBOAR|
1 UCALGARY|S-ABMEDIASSO|
- rollserctlvcyc New sirsi report in SERIAL tab. Run in test mode to get a listing of controls that will be rolled over...previous to April 2011 used: rollovrserctl Run in test mode to get a listing of controls that will be rolled over
- rollserctlvcyc Run this Sirsi Serial report in similar fashion to the old....rollovrserctl Run this custom report, during day or evening when no serials staff are eding the database, in order to roll the serial controls into the new fiscal cycle. Ensure that you make a serctl selection choice of having the STATUS equal to ACTIVE. (This helps so that serial claim notices all get printed together for one vendor. They use to get spread apart as vendor's had controls associated with various fiscal cycles.) Send any "error" listings from the end of the report to Serial Acq and or Doucette as appropriate and then archive the report.
- yezerocopdist custom report to flip all the OLD fiscal cycle serial order's distribution segments to zero so that OPAC doesn't display multiple copies on order for previous years. DO for UCALGARY,BOWVALLEY,QATAR and STMARYS--any library that is doing year end roll overs and has serial orders flipped into new fiscal cycle. Run after hours so no staff are touching this database when it runs and review the results. Archive. NOTE: if serials had to manually roll over any orders eg negative amounts paid on an order will prevent it from rolling over via the report but they can do it manually, then ITS will have to manually zero out the dist segment in the related old fiscal cycle order.
- Review the reports for errors and archive.
- Modify all the serclaimDOU1, serclaimDOU2, serclaimDOU3, serclaimDOU4 etc. reports to target the new fiscal cycle. Do the NEVER cases within the Sirsi Report software modify mode in order to see if some vendor's drop off now that no active controls exist on those vendors in the new fiscal cycle. Then CAREFULLY, you can modify the 4 reports which run weekly in the SHELL to match the criteria of the matching NEVER template. The reason to modify them in the shell is so that the report schedule ordering of reports is undisturbed. We know that modified reports may run in the wrong order if the report server ever had lapsed downtime or a report ran over its time extensively. CAREFUL, if you are in the shell, not only do you need to edit the fiscal cycle in the appropriate .set file, you must ensure that the .id file lists the current vendors only and the .selans file has the appropriate vendors and fiscal cycle listed!! Ensure that your NEVER report files match the schedule report files. If you are unsure about shell work, DON'T do it this way. (List of reports to modify are found above under Statistical Reports for Budget and MIS officer section.)
- Serial Acq has 4 or 5 days to begin updates, cancellations, fund number changes and commitment changes.
- yezerofreebal Run this custom report for OLD fiscal cycles after the roll over process and after the Monograph Order errors are cleaned up. Since the serial/standing old fiscal cycle was done on the day of the roll over, the MONOGRAPH/OTHER level one funds are done at this time. (NOTE: errors in logs of Allocation not adjuted, can be cut and pasted and sent to A.Forte to manually zero out the free balance. These occur when there is a neg. amount paid or invoiced.) Later, the funds related to the DATED serial orders in the new cycle will be yezerofreebal'd out as well. NOT those related to recurring orders since those funds will have zero encumbered against them but still need a "pool" of funds to spend through the year. (Again this was run after 15:30 in 2003.) Sample output can be found about three quarters of the way down this webpage. Ensure it runs without errors and then archive it.
- Fix up the flags on funds for old and new cycle using the SirsiDynix delivered managefundcyc report--April 2015 onwards:
fundsOLDFYmanageBVSMUC--use for target libraries to change and target old fY:
* Ordering Active : NO
* Paying Active : NO
fundsNEWFYmanageBVUC--target the proper libraries and the new fiscal cycle:
* Ordering Active : YES
* Paying Active : YES
* Block Over Encumbrance : YES
fundsNEWFYmanageSM-STMARYS new fiscal cycle settings are:
* Ordering Active : YES
* Paying Active : YES
* Block Over Encumbrance : NO
- OLD obsolete way to fix fund flags:
- Block overencumb - use fundencumbflag or shell in 2007 April block overencumb was set to Y for NEW cycle (Retired now but April 2009 and earlier we also changed the block overencumb flag to N for old cycle.) It is now believed that the old fiscal cycle is frozen down with the two flags ordering allowed N and paying allowed N so no need to adjust the block overencumb flag also.
- fundencumbflag target all funds in new fiscal cycle and set it to Y. (April 2007 - April 2009 we also ran it a second time: target all funds in old fiscal cycles(s) and set the block over encumb flag to N.)
- ordering flag set to Y for NEW funds and N for all old funds - use fundinactive or shell
- paying allowed set to Y for NEW funds and N for all old funds - done in the shell as in: selfundcyc -f"NEWCYCLE" -y"UCALGARY,BOWVALLEY" -oK | editfundcyc -h"Y"
- Review the reports for errors and archive.
- serialfundnegbal.ksh is a Korn script found in Work/NDL will run against NEW fiscal cycle to check on the serial funds and output a listing of all SERIAL funds that have a free balance less than zero. Run as in : serialfundnegbal.ksh (4 digit NEW fiscal cycle) (output file) The output goes to A.Forte so they can adjust those funds to a positive balance before yesercom runs. Sample output Repeat this script on the NEW fiscal cycle AFTER serials staff have done all their price adjustments.
- yezerofreebal custom report is run against serial funds (level1=SERIAL which is linked to the DATED order types--with encumb) for the NEW fiscal cycle after A.Forte has checked output from serialfundnegbal.ksh and serials are done all their corrections, around April 18. Fund criteria is set so that Level 1: contain SERIAL and library is UCALGARY. [NOTE: we do NOT touch level1=STANDING because these are linked mainly to recurring order types which have zero encumberance set in them but we don't want the budget to be brought to zero on them!]
NO longer needed as of April 2010.....changing auto PO ids range is done in the Unicorn/Autoid directory in file called: po1 keep the initial and most characters and only change the numeric values.
$ more po1
##349929#
yedatereadyser custom report to run against the newly rolled over serial and monograph orders (Bowvalley and Ucalgary) to set the date ready to the desired "date ready". Ensure you select the NEW fiscal cycle in the fiscal cycle selection phase. ALSO NOTE: the date you set the new rolled over serial orders MUST be LATER than the date of the last run of the serial commitment interface!! Review the report for errors and archive.
arltitlecnt.ksh is a new program as of Nov 2009 which resides in /Work/NDL and is used to count the number of titles for ARL purposes. (Modified fall 2013 to include QATAR counts per S.Telfer's request.) Sample output:
ARL TITLE COUNT from CATALOGUE
==============================
...produced on sirsi1 Wed Aug 25 10:52:01 MDT 2010
Number of UCALGARY TITLES in the catalogue: 2282882
Of this number, 9979 are bound with titles.
NOTE: titles are ONLY counted if they either have copies or are BOUND
to another bibliographic record.
NOTE: criteria avoids IN-PROCESS home locn and MICROFORM locations of:
3LT-MCARD,3LT-MFICH,3LT-MREF,LAW-MICRO,MED-MICRO
This report avoids any records whose copies are all at shadow current locations
or shadowed at title level.
The report also filters out non-print items by removing VM format.
It also filters out MAPS via removing MAP format titles.
hincounts.ksh is a new program since April 2007 which resides in /Work/NDL and is used to count the number of monograph vs serial items at all HIN locations. Sample output:
Final report for HIN Counts
===========================
...produced on seter.lib.ucalgary.ca on Mon Apr 9 12:36:19 MDT 2007
ALL items at HIN locations is: 5211 broken down by home location:
====================================================================
1390 ACH
16 ACH-REF
1100 PLC
25 PLC-CHI
21 PLC-REF
1984 RGH
134 RGH-CHI
9 RGH-REF
63 TBCC
469 WHKC-CHI
Monograph (format NOT serial) item count is: 4665 broken down by home location:
===================================================================================
1234 ACH
12 ACH-REF
965 PLC
25 PLC-CHI
20 PLC-REF
1831 RGH
127 RGH-CHI
7 RGH-REF
3 TBCC
441 WHKC-CHI
SERIAL (format SERIAL) item count is: 546 broken down by home location:
==============================================================================
156 ACH
4 ACH-REF
135 PLC
1 PLC-REF
153 RGH
7 RGH-CHI
2 RGH-REF
60 TBCC
28 WHKC-CHI
***********End of Report******
Used only in 2007--then not needed....yestandingordnorcptlist.ksh new since 2007 and resides in /Work/NDL and is used to give a listing to collections (Heather, Sandra and Andrew) of all orders related to STANDING level 1 funding that had no receipts, commitments or payments in the targetted fiscal cycle. Note for 2007, ITS had to filter out a bunch of vendors and one order type due to the project of moving many standing orders to dated order type which has not been finished. The list to avoid was provided by Lynn and will have to be modified for 2008's run of this program! Sample output:
List of 2007 Serial Orders on level1 STANDING Funds
with no receipts, commitments or payments
======================================================
...produced on seter.lib.ucalgary.ca on Fri Apr 13 11:12:46 MDT 2007
Library|Fiscalcyc|OrderID|Line#|Order type|Fund ID|Amt encumb|Vendor ID|Shelving key|Call#|title|Title sort|ckey|
UCALGARY|2007|159765|1|STANDING|6406-62|$0.00|S-HARRASSOWITZ|G 001938 .T6 T65 LFG.000001 SUPPL.|G1938 .T6 T65 LFG.1 SUPPL.|Tirol-Atlas / im Auftrag der Tiroler Landesregierung krsg. unter der gesamtleitung von Ernest Troger|TIROL-ATLAS|1057549|
UCALGARY|2007|23561|1|STANDING|7106-63|$0.00|S-SHIPSOUROILPOLL|KF 001299 .W38 C35 002000/000001|KF1299 .W38 C35 2000/01|The administrator's annual report / Ship-source Oil Pollution Fund|ADMINISTRATORS ANNUAL REPORT|1542454|
UCALGARY|2007|24359|1|STANDING|7106-63|$0.00|S-LAWSOCIAB|KF 000294 .L25 A552|KF294 .L25 A552|Rules of the Law Society of Alberta / The Law Society of Alberta|RULES OF THE LAW SOCIETY OF ALBERTA|1525322|
...
branchcnts.ksh is a program which resides in /Work/NDL and is used to count the number of print monograph titles and copies received in a given time period and break them down into free vs paid. A value for the paid items is calculated from the sirsi price in the copy record which is known to not always be accurate but gives a ballpark figure. Counts are for LAW and MEDICAL titles and items only. The criteria for "monograph" in this case is format MARC and item NOT : EBOOK,EJOURNAL,ERESOURCE and NOT any of the MICROFORM locations. Run the program as in:
$ branchcnts.ksh 20040101 20040606 > YOUR_CHOICE_of_OUTPUT_filename
SAMPLE OUTPUT:
Number of Print Monographs Purchased for LAW after 20030331 and before 20040401
...produced on neter.lib.ucalgary.ca Fri Jun 11 12:17:14 MDT 2004
LAW volumes: 1957
LAW FREE items: 1421
LAW PAID items: 536
...value COMMITTED for these items is: 54246.17
LAW titles: 1371
LAW FREE titles: 872
LAW PAID titles: 500
**NOTE: number of FREE titles plus PAID titles will NOT always
equal the number of titles total if some copies are free
and some copies are paid on the same title.
=====================================================================
Number of Print Monographs Purchased for MEDICAL after 20030331 and before 20040
401
...produced on neter.lib.ucalgary.ca Fri Jun 11 12:17:32 MDT 2004
MEDICAL volumes: 1696
MEDICAL FREE items: 777
MEDICAL PAID items: 919
...value COMMITTED for these items is: 94770.78
MEDICAL titles: 1616
MEDICAL FREE titles: 744
MEDICAL PAID titles: 880
**NOTE: number of FREE titles plus PAID titles will NOT always
equal the number of titles total if some copies are free
and some copies are paid on the same title.
=====================================================================
- This is a very new program just developed in Jun 2004 and was not fully found to be satisfactory to S.Telfer due to the fact that the price values seemed to be "off". As expected, the value isn't accurate due to our workflow of receiving an item before paying it so the copy price in the sirsi item record is the committed value rather than the paid price. In order to investigate the values more closely for now there are some extra files output into /s/sirsi/Unicorn/Work/NDL with the names of LAW.pd, LAW.free and LAW.all and MEDICAL.pd, MEDICAL.free and MEDICAL.all. These files gives lists with item key and the copy price field.
- We know this program is missing an IN-PROCESS items so thought was given to perhaps using a holding code like IN-PROCESSM and IN-PROCESSL so these could be trapped and counted too.
American Library Directory TITLE counts statistics for S.Telfer which counts roughly title counts for American Library Directory. Shadow items are ignored, electronic and non-book items are generally ignored. Criteria developed by S.Telfer consulting with C.Baker and J.Fahlman. So format MARC and SERIAL non shadowed and number of call numbers over zero plus the item is NOT at CYBERSPACE branch, is at UCALGARY library and NOT shadowed in current location or by shadow flag and item type is NOT INTERNET and it is a PERMANENT item. Run the program around Mar. 31st or early April. The program is called amlibdir.ksh and resides in the Unicorn/Work/NDL/Carl directory. This report takes about 10 minutes to run. Archive the result as indicated for the CARL and INSURANCE reports below. Sample output Run as in:
$ amlibdir.ksh testalibdir2
Please be patient this will take some time...
DEBUG is ON so there are files for review and cleanup
They all have prefix of /tmp/amlibdir15908
Your output will be in /s/sirsi/Unicorn/Work/NDL/Carl with filename: testalibdir2
Monographs received through Serials item count of the monographs received through serials for S.Telfer run around Mar. 31st or early april. This program is called monoviaserials.ksh and resides in the Unicorn/Work/NDL directory. The results are only as accurate as the procedure put in place to track these cases which means that an 087 is created with the fund number followed by a M or m. Output is ckey, barcode, and home location, one 087 with the M (if more than one 087 with M on the bib record) and a total counts-item and titles. Archive the result as indicated for the CARL and INSURANCE reports below. NOTE: once a bib record has the 087 with a M on it, all copies added to that bib record through the years will meet the criteria for this program and be counted as monographs received through serials! NOTE: since March 2007 avoid HIN locations of: ACH,ACH-REF,PLC,PLC-REF,PLC-CHI,RGH,RGH-REF,RGH-CHI,TBCC,TBCC-REF,TBCC-CHI,WHKC,WHKC-REF,WHKC-OFFIC,MED-CHI. Run as in:
$ monoviaserials.ksh items_created_after_YYYYMMDD items_created_before_YYYYMMDD output_file_name
SAMPLE output....
The total number of monograph items received via serials between
20060401 and 20070115 is : 1939
These items are on 1860 bib.records or TITLES.
This count is only as accurate as the staff follow the procedure
of adding the M to the end of the 087 fund number!
NOTE: HIN located copies are NOT counted. Locations excluded are:
ACH,ACH-REF,PLC,PLC-REF,PLC-CHI,RGH,RGH-REF,RGH-CHI,TBCC,TBCC-REF
TBCC-CHI,WHKC,WHKC-REF,MED-CHI
NOTE: once a bib record has the 087 with a M on it, all copies added
to that bib record through the years will meet the criteria for this
program and be counted as monographs received through serials!
CKEY|BARCODE|HOME LOCN|087 with M-may be more on record|
1049273|00009627488 |MACK-TOWER|Fund 2006-63M|
116350|00009703161 |MACK-TOWER|Fund 50545M|
1337674|00009625672 |2LB-REF|Fund 25173M|
1337674|00009626690 |2LB-REF|Fund 25173M|
1337674|00009626691 |2LB-REF|Fund 25173M|
1337674|00009627312 |2LB-REF|Fund 25173M|
1337674|00009627979 |2LB-REF|Fund 25173M|
1337674|00009628669 |2LB-REF|Fund 25173M|
...
monoviaserialsHIN.ksh is also in NDL and has to be run at this time. It is the same as above BUT targets just the HIN locations.
No Longer required per Process Working Group decision 2/22/2011...Electronic reference material item count procedure devised Feb. 2004 for S.Telfer and elecreference.ksh program is run around Mar. 31st or early April. This program resides in the Unicorn/Work/NDL directory. The results are only as accurate as the procedure put in place to track these cases which means that an 087 is created with the fund number followed by a R or r. Output is ckey, barcode, and home location, one 087 with the R (if more than one on the record) and a total counts-items and titles. Carol Baker advised an added criteria that the records had to have 095 CURRENT SUBSCRIPTION. Archive the result as indicated for the CARL and INSURANCE reports below. NOTE: once a bib record has the 087 with a R on it, all copies added to that bib record through the years will meet the criteria for this program and be counted as electronic reference! NOTE: since March 2007 avoid HIN locations of: ACH,ACH-REF,PLC,PLC-REF,PLC-CHI,RGH,RGH-REF,RGH-CHI,TBCC,TBCC-REF,TBCC-CHI,WHKC,WHKC-REF,MED-CHI. Run as in:
$elecreference.ksh items_created_after_YYYYMMDD items_created_before_YYYYMMDD output_file_name
Sample output:
The total number of electronic reference items received between
20060401 and 20070115 is : 31
These items are on 13 bib.records or TITLES.
NOTE: once a bib record has the 087 with a R on it, all copies
added to that bib record through the years will meet the criteria
for this program and be counted as electronic reference as long as
the 095 CURRENT SUBSCRIPTION is still on the bib record too!
Based on procedure of adding R or r to fund in 087 tag and
095 CURRENT SUBSCRIPTION. Count is only as accurate as
staff follow procedure!
NOTE: HIN located copies are NOT counted. Locations excluded are:
ACH,ACH-REF,PLC,PLC-REF,PLC-CHI,RGH,RGH-REF,RGH-CHI,TBCC,TBCC-REF
TBCC-CHI,WHKC,WHKC-REF,MED-CHI
CKEY|BARCODE|HOME LOCN|Material Type|087 with R-may be more on record|Title|
1005277|00009628296 |2LB-REF|UNKNOWN|Fund 89084R|American men & women of science|
1005277|00009628297 |2LB-REF|UNKNOWN|Fund 89084R|American men & women of science|
1005277|00009628298 |2LB-REF|UNKNOWN|Fund 89084R|American men & women of science|
1005277|00009628299 |2LB-REF|UNKNOWN|Fund 89084R|American men & women of science|
...
CARL and INSURANCE information/statistics for S.Telfer run around Mar. 31st or early April. Print or email the results as indicated below and archive the outputs in the appropriate subdirectory under Rptcustom. Eg. Carl stats which ran March 31, 2000 were archived in the Rptcustom/Yrendbackups9900.
- A group of 3 programs is run to get PERIODICAL information out of the system. NOTE that periodicalpt1.ksh needs to be run annually in order for other reports to run properly to remove periodicals from counts etc. BUT periodicalpt2.ksh and periodicalpt3.ksh are only required when requested. They were developed initially for the CURIE insurance which is only done once every 10 years. (So if you run pt2 and pt3, just archive the information and don't send it to anyone and confuse them!)
- periodicalpt1.ksh in Work/NDL is run to select all the periodical ckeys out of the database. Criteria is complex and was developed by C.Baker and J.Fahlman here is HOW it determines what a periodical is in our database:
PURPOSE: of PART 1: is to EXTRACT the records from the system with PERIODICAL
# or actually: PERIODIC$ in
# 090 OR 099 or in 949(not |x--too vague and not all of
# these are "real" periodicals) PLUS NEWSP$ in 090 or 099 or 949|v
,
# PLUS electronic periodicals found via: EJOURNAL item cat1 where
# it doesn't have PERIOD$ or SERIAL in 090/099
# PLUS SERIAL ABBREV$ RECORD in 500 tag without PERIOD$ in 090 or 099.
- (There is no output to print or save from this first program it just generates NDL/periodicalout.ndl used by part 2 and part 3.) The program will tell you to select additional shadow locations if you want and tell you where to find any output as in:
This is a list of the current shadow locations on the system...
NOTE: 4LT-ITS, DAMAGED and STAFF-USE shadow locations were left IN the counts because
it was felt they are valid items to be counted!
BOOKSALE SELECTION CANCELLED RESDISCARD
WITHDR98 SERORDER 4LT-ITS WITHDR99
DAMAGED DISCARD BOARDOFGOV LOST
WITHDR00 PIERCLEAHY WITHDR01 MISSING
SHADOWED STAFF-USE WITHDRAWN PERSCOPY
These are the shadow locations the program already avoids
Current locations of: LOST,MISSING
Home locations of: CANCELLED,RESDISCARD,WITHDR98,SERORDER,WITHDR99,DISCARD
LOST,MISSING,WITHDRAWN,PERSCOPY,SELECTION,BOARDOFGOV
WITHDR00,SHADOWED,REORDER,BOOKSALE
Please enter any ADDITIONAL location(s) to avoid:WITHDR01
Here is/are the location(s) you say you want to avoid counting: WITHDR01
Here is what will be avoided, if program already looking for some of your input, it
has been stripped leaving only NEW locations to avoid : WITHDR01
Done checking the stripped down input locations...all are valid.
Extracting periodical ckeys from database...this will take 15-20 minutes!
....then you'll see:
Now run periodicalpt2.ksh to do the analysis on ckeys extracted...
- Not required at year end by ST after April 2009, although she may ask for it on an adhoc basis. periodicalpt2.ksh in Work/NDL is run next to actually get counts of number of periodical titles by branch with the BARD location broken down by original "home" branch. Outputs are created in Work/NDL which the program will itemize for you. These outputs list possible error areas as well and associated files of error records so that corrections to the counts and records can be done. Read the output carefully to be informed about how to use them. NOTE: this breakdown is only required for CURIE insurance which only is done every 10 years so no need to run annually unless requested.
ERROR: periodicalpt2.ksh (output file name-can't be a file that already exists)
$ periodicalpt2.ksh periodicalpt2out
Your output will be found in /s/sirsi/Unicorn/Work/NDL/periodicalpt2out.MULTI_CNT_PERIODICALS and
also in /s/sirsi/Unicorn/Work/NDL/periodicalpt2out.SINGLE_CNT_PERIODICALS.
This will take awhile...
- Sample output for SINGLE count periodicals--cases, where there is only ONE location for the periodical title.
- No longer required at year end by ST post April 2009, but she may ask for it on an adhoc basis. periodicalpt3.ksh in Work/NDL is run last to get a subgroup of the periodicals in the system which are located within the MacKimmie Block. Counts for just the block are broken down and outputs generated in Work/NDL as indicated by the program as it begins the process. Outputs go to S.Telfer and problems are researched and sent to Bib.Services as indicated below. NOTE: this breakdown is only required for CURIE insurance which only is done every 10 years so no need to run annually unless requested.
$ periodicalpt3.ksh
ERROR: periodicalpt3.ksh (output file name-can't be a file that already exists)
$ periodicalpt3.ksh periodicalpt3out
Your output will be found in /s/sirsi/Unicorn/Work/NDL/periodicalpt3out.MACK_BLOCK.MULTI_CNT_PERIODICALS and
also in /s/sirsi/Unicorn/Work/NDL/periodicalpt3out.MACK.BLOCK.SINGLE_CNT_PERIODICALS.
This will take awhile...
- Sample output from this program for the MULTI-COUNT periodicals-or those periodicals which are in MORE than ONE location.
- PROBLEM records are reported out of this process via the collectionFAST.ksh program which writes the final reports. These problems are reported in prob.$INPUT files where the ckey is given etc. The type of problem is when a HOME LOCATION that is counted in the EXTERNAL branch counts was also counted in the non-EXTERNAL branch counts. Example here is an example of the final report from periodicalpt2.ksh for the SINGLE count periodicals:
Final report for perpt2apr9.SINGLE_CNT_PERIODICALS Collection Analysis
============================================
...produced on osiris.lib.ucalgary.ca on Tue Apr 9 08:55:47 MDT 2002
...file extraction date and name: Apr 09 08:55 /tmp/newallsingles.ndl
MACKIMMIE titles: 17738.
DOUCETTE titles: 70.
GALLAGHER titles: 354.
LAW titles: 1474.
MANAGEMENT titles: 262.
MEDICAL titles: 2152.
CYBERSPACE titles: 1615.
BARD titles: 708.
236 EXTERNAL branch titles are broken down as follows:
12LT-UARC titles: 4.
9LT-CMC titles: 79.
INTERNET titles: 4.
LEARN-COMM titles: 1.
MEDICAL titles: 2.
NICKLE titles: 44.
REGIMENTS titles: 102.
TOTAL perpt2apr9.SINGLE_CNT_PERIODICALS titles in the collection: 23901
NOTE: The following EXTERNAL locations were also counted under NON-EXTERNAL branches!
2 12LT-UARC titles located at MACKIMMIE.
13 9LT-CMC titles located at MACKIMMIE.
5 INTERNET titles located at MACKIMMIE.
1614 INTERNET titles located at CYBERSPACE.
1461 MEDICAL titles located at MEDICAL.
1 REGIMENTS titles located at MACKIMMIE.
...for detail listings of these errors see: /s/sirsi/Unicorn/Work/NDL/prob.newallsingles.ndl
- Look at the MEDICAL cases, 2 of them were counted into the EXTERNAL count but 1,461 were counted in the MEDICAL count. Obviously, the 2 counted into the EXTERNAL count are incorrect and should be sent to Bib.Services for correcting. The INTERNET cases in the EXTERNAL count also appear to be wrong since 1,614 of them are in CYBERSPACE branch, again these are sent to Bib.Services for correcting. Since these are NOT in the "detail listings" of the errors in the file prob.newallsingles.ndl, you hunt for them from the system via selitem -g"EXTERNAL" -l"MEDICAL,INTERNET" -oBIgl > probbranchlocn.ndl This will give Bib.Services the barcode, full 3 section item key, the branch and the home location.
- Within the detail error listing in the file prob.newallsingles.ndl, some will NOT be errors, as in the MEDICAL cases found at the branch MEDICAL. Egrep -v the cases which are correct out of this listing before sending it off to Bib.Services. The program has generated this listing based on the assumption that ALL EXTERNAL locations were correct and looking into the original file of items collected for any of those "TRUE EXTERNAL" locations which might have been counted in a different branch. cat the cleaned up file | selitem -iI -oBIS > file to send to Bib.Services with just the "real" problems of items at HOME locations whose branch SHOULD be EXTERNAL. This file will now have the barcode for them.
- This last set of errors was found in Apr. 2002 by looking at all the prob.* files and related final reports to see all the TRUE external locations that ended up being counted in the MACKIMMIE branch. The one composite list for these error items was then obtained via: selitem -l"REGIMENTS,INTERNET,9LT-CMC,12LT-UARC,CLASSICS,KANANASKIS,LEARN-COMM,NICKLE" -g"MACKIMMIE" -oBIlg | sort +4df -5 > probhomebranch.ndl Then that file was emailed out to Bib.Services for fixing.
- The files ending in *.nobranch can be easily cat through | selitem -iC -gn -oBClm to give to bib.services the BARCODE|CKEY|HOME|CURRENT location of all items without a branch in item_cat2.
- All of these errors have decreased greatly each year with the annual cleanup.
insurespace.ksh also in Work/NDL is a program which generates eleven different count outputs for Insurance purposes. ALL are limited to UCALGARY library items and filter out many shadow locations with specific criteria as follows:
- PRINT material ITEM count and distribution over branches -criteria is to exclude periodicals, format: MARC,SERIAL,MANUSCRPT. NOT current locations of LOST,MISSING, NOT itemcat1 of SCORE and NOT home locns of any MFILM, MFICH, MCARD, IN-PROCESS and INTERNET and any *-ELEC locations. This count does NOT and cannot include records without copies (old gov. docs) and bound with records since there are NO items to count! Sample output This is NOT required on an annual basis, so if generated without a request, just archive it.
- Not required regularly at year end by ST after April 2009, she may ask for it now and then....IN-PROCESS is a single count of all home location=in-process items then break that count down into serial and non-serial items. Then the title count is is generated for how many titles those in-process items are attached to. Sample output This is NOT required on an annual basis, so if generated without a request, just archive it. It might be asked for from time to time.
- Not required at year end by ST after April 2009, she may request it now and then....music SCORE count where item_cat1=SCORE the one count is all ASSUMED to be MACKIMMIE items. Sample output
- Not required regularly at year end by ST after April 2009, but she may askf ro them on an adhoc basis. AUDIONONMUSIC: Spoken recordings where itemcat_1=SPOKENREC broken down by branches. Sample output This is NOT required on an annual basis, so if generated without a request, just archive it.
- Not required regularly at year end by ST after April 2009, but she may ask for it on an adhoc basis. AUDIOMUSIC: Musical recordings (itemcat_1 is NOT SCORE nor SPOKENREC) and format is MUSIC. Sample output This is NOT required on an annual basis, so if generated without a request, just archive it.
- Not required at year end by ST after April 2009, although she may ask for it now and then...VM count broken down by branch (for OTHER MATERIAL count for kits/realia) Note: this count includes all kits and realia but also includes OTHER types of VM material. Sample output
- MONOITEMS: single count of all the MONOGRAPH ITEMS in the collection (format NOT SERIAL)--avoid any periodicals again which were catalogued as non-serial formats. Sample output This is NOT required on an annual basis, so if generated without a request, just archive it.
- number of SERIAL ITEMS in the collection avoiding periodicals, format is SERIAL. Sample output This is NOT required on an annual basis, so if generated without a request, just archive it.
- number of TITLES in the collection-note this has to include bound withs. Sample output This is NOT required on an annual basis, so if generated without a request, just archive it.
- CARLMONOPRINT for count of monograph print TITLES for CARL-based on format MARC,MANUSCRPT and remove periodical ckeys-then get title count for ARL and another CARL count without any cases which have CURRENT {095}. This is meant to give ARL a count including monographic series and CARL excludes them. Both of these counts include SCORES (old cases catalogued as MARC format loaded from DOBIS) and Monograph Electronic titles too. Another title count for the number of bound with titles. The number of DOBIS loaded bib records without copies too for MARC,MANUSCRPT format created before 19960601 non-shadowed title record with a visible call number record but the call number record has NO copies and is a visible call number and is NOT a child record. It gives number of monographic microform titles too based on home location 3LT-MFILM,3LT-MFICH,3LT-MCARD,BUS-MFICH,LAW-MICRO,MED-MICRO. Sample output NOTE: as of April 7, 2010 only one count is required for both ARL and CARL equal to what ARL specs are.
- CARLCD for a count of CD monograph TITLES for CARL based on a search of ELECTRONIC ADJ RESOURCE in 245 tag and NOT CURRENT 095 tag with format MARC,MRDF nonshadowed record and then hunt through the 300 tag for a string matching "computer .*dis". If a fiscal cycle is part of the parameters to the program run for this keyword, then it will find which of these cases are attached to orders in the fiscal cycle provided. To find the number of electronic monographs from serials dept repeat criteria without the NOT CURRENT 095 criteria and get the difference between the first output and this output to find these cases. This is to get the serial subscription cases out. Sample output
By typing the program name in alone, you will get a message about what the keywords are and what parameters the program requires. Outputs for VM, PRINT (about .5 hour to run), INPROCESS, SCORE, MONOITEMS (about .25 -.5 hour to run), SERIALITEMS, TITLE (about .25-.5 hour to run), AUDIONONMUSIC, and AUDIOMUSIC counts with any associated BARD and PIERCLEAHY items being brokendown by original branch location are all dropped into Work/NDL. Two later reports for CARLMONOPRINT (1.5 hr to run) and CARLCD were added and are explained in detail here. NOTE: that CARLCD can target a fiscal cycle as in: $ insurespace.ksh CARLCD carlcd.2004 2004 Send outputs to S.Telfer, or print them and give them to her and archive them. (NOTE that there will be some prob.* files dropped into /NDL as in periodicalpt2 and pt3 with the associated detective work to discover the "REAL" problem items and ship them off to Bib.Services for cleanup.) Sample of running this program:
$ insurespace.ksh SCORE SCORE2002
NOTE: 4LT-ITS, DAMAGED and STAFF-USE shadow locations were left IN the counts
because it was felt they are valid items to be counted!
Here are the shadow locations which the program currently does NOT avoid.
12LT-UARSH 4LT-ITS DAMAGED DIGITIZN
IMAGEVID PIERCLEAHY RESRCHDATA STAFF-USE
ULETHBSHD
Remember that it does avoid the CURRENT locations of:
LOST,MISSING
Please enter any ADDITIONAL location(s) to avoid:
Here is/are the location(s) you say you want to avoid counting:
Your output for SCORE counts will be found in /s/sirsi/Unicorn/Work/NDL/SCORE2002.
This will take awhile...
collectionFAST.ksh is an assoicated program which the insurespace.ksh program and periodicalpt2.ksh and periodicalpt3.ksh uses for "writing" the final reports.
CARL programs are all found in Work/NDL/Carl
- OBSOLETE....Aside: Edit the crontab after the first of the month to change the fiscalcycs being passed into the two carl reports which are run monthly: run.carlsercancelmedmack.ksh and run.carlnewserialv3.ksh.
- some scripts are used by other programs and are like subroutines.
- eneordNEW.ksh takes a set of input and breaks it down into two groups electronic versus non-electronic
- nonepdfreeordNEW.ksh input of non-electronic ORDERS and breaks them down into paid versus free groups
- fpnoteBybranchNEW.ksh Extract the TITLE counts based on ELEC_NOTE for electronic items recvd but filters it out for PO range for the specified branch
- rptNEW.ksh is the final report writing script used by carl1small.ksh and carlnewserialv3.ksh
- OBSOLETE...not used April 2007 on carlnewserialv3.ksh is a program to extract the NEW serial orders based on a comparison between a previous fiscal cycle's PO#'s and the current fiscal cycle's PO#'s. Since procedures changes in 2006/07, only line one of recurring orders are analyzed. (This program uses some of the scripts listed above.) Two output reports, one for MacKimmie and one for Medical, give a count of the new orders and new titles and a file of the orders counted is saved for reference purposes. The newmedmack.awk script is used by this program. Sample MacKimmie Report output Output is sent to S.Telfer or printed for her and archived. Currently, serials and medical are reviewing the listings and reports on a monthly basis so there is no need to run it separately, just archive the results from April 1st which are saved in the /NDL/Carl directory but which you need to archive in the /Rptcustom/YrendbackupsYYYY directory.
- carl1small.ksh is a complex program to breakdown ACTIVE not cancelled serial orders and titles (orderlines) in to free/paid groups and within each group break them down further by electronic, non-electronic and mix funded cases. Since 2006/07 procedure changes, Recurring order types only line one is used and it is assumed paid even though line one always has zero encumbered, I force it to be a non-zero amount. July 2004-, this program produces three reports one for MED one for LAW and one (the rest of the orders) for MACK but since early 2008, the program now generates 6 reports: LAW, VET, MED, HIN, MACK-GALL-BUS and a COMBO report. It runs in about 10 minutes time. It uses the following awk scripts toonewmedmack.awk, fp.law.awk ,fp.med.awk, carl1.med.awk. The same breakdown is done for serial TITLES. The report details some of the cases which may need investigation and saves two output files per branch reported on which can be used for detailed investigations if necessary. Medical sample output. Law sample output. MacKimmie-Gallagher-Business sample output. VET sample output. HIN sample output. COMBO sample output. The program also spits out a COMBO report that reviews all serial orders in targetted fiscal cycle with no branch breakdowns. Run the program to target the latest complete fiscal cycle. Output is sent to S.Telfer and archived. Old sample MacKimmie output:
REPORT REVIEWING MACKIMMIE SERIAL ORDERS PLACED IN 2004
...produced on neter.lib.ucalgary.ca on Wed Jul 28 12:39:34 MDT 2004
THESE RESULTS TAILORED FOR EXTERNAL REPORTING PURPOSES ONLY!
====================================================
8652 serial orders.
2578 free orders.
51 free electronic orders.
2525 free non-electronic orders.
2 free mix funded orders.
6074 paid orders.
251 paid electronic orders.
5807 paid non-electronic orders.
16 paid mix funded orders.
=============================================================
9848 serial TITLES on order in 2004 per orderline counts.
*PLUS 513 additional titles due to orderline NOTE counts
2791 free titles *PLUS 13 additional Titles due to NOTE counts
53 free electronic titles.
13 free electronic titles per ELEC_NOTE detection.
2738 free non-electronic titles.
0 free non-electronic titles per NOTE detection.
7057 paid titles. *PLUS 500 additional Titles due to NOTE counts
310 paid electronic titles.
500 paid electronic titles per ELEC_NOTE detection.
6748 paid non-electronic titles.
0 paid non-electronic titles per NOTE detection.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Serial ORDERS where electronic and non-electronic level 2
funds are associated with the same order.
These are found in the MIX order counts!
****************************************************************.
FREE mix funded cases:
958334 981778
PAID mix funded cases:
906837 908656 937415 937907
939870 955108 955594 980668
980805 981601 983272 983689
984468 985323 985348 985542
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
The following orders had ELEC_NOTE fields with text containing:
Includes Electronic
These were FREE note electronic orders:
904518 904519 936659 936893
936894 958272 980791 982036
982273 983149 983149 983732
984911
These were PAID note electronic orders:
900032 900105 900375 900380
900385 900388 900393 900397
...cut tons...
List of all orders can be found in /s/sirsi/Unicorn/Work/NDL/Carl/carl1.serorders.MACK.2004
List of all orderlines can be found in /s/sirsi/Unicorn/Work/NDL/Carl/carl1.serorderlins.MACK.2004
This report produced by script found in /s/sirsi/Unicorn/Work/NDL/Carl/carl1small.ksh
####End####
Run this program as shown below:
$ carl1small.ksh
Please enter your name:nella
*****Welcome to CARL SERIAL STATISTICS file production, nella
Please enter a four digit fiscal cycle to target:2004
2004.
Valid 4 digit fiscal cycle provided...
Please enter a filename for the output to be put into:carl1testout
Valid file name provided for output, producing report...
Your output will actually be found in: carl1testout.LAW.2004
Your output will actually be found in: carl1testout.MED.2004
Your output will actually be found in: carl1testout.MACK.2004
...processing....this will take some time! :-) ..............
The start time for this process is Wed Jul 28 12:31:20 MDT 2004
There was no serorderNONELEC.ndl file for the mixpdfree.ksh program to use.
There were NO NOTES with Includes Paper found for 2004.
There were NO NOTES with Includes Paper found for 2004.
There were NO NOTES with Includes Paper found for 2004.
The end time for this process is: Wed Jul 28 12:39:34 MDT 2004
Review of Processing: admin 18750 30530 1 12:39:34 pts/2 0:00 grep carl1small.ksh
admin 30530 76334 0 12:31:09 pts/2 0:00 ksh carl1small.ksh .
- No longer required reqularly at year end by ST after April 2009. But she may ask for it on an adhoc basis. carlsercancel.ksh formerly called: carlsercancelmedmackCRON.ksh. This program is used to breakdown cancelled serial orders in Medical and MacKimmie counts. Six output reports are generated: VET, HIN, MED, LAW and one for MacKimmie-Gallagher-Business and a COMBO report. The breakdown is based on PO number ranges. cancelmedmack.awk is a script used by this program. OLD Sample output....also here are the Reasons for slight price discrepancies of program results versus manual results This was generated monthly through 2001 to 2006 for review purposes via a cron job. Ouput goes to S.Telfer and is archived at year end. (Find the April 1st results from the cron run in /NDL/Carl/Output and archive in the Rptcustom/YrendbackupsYYYY directory.) Since procedure changes in 2006/07, the each report doubled because dated orders still have money on them but recurring orders only analyze line one and has no money associated with it. MacKimmie-Gallagher-Business sample output. LAW sample output. VET sample output. HIN sample output. Medical sample output and COMBO sample output.
- OBSOLETE use version 3 now...carlrcvdcopiesv2.ksh in the NDL/Carl directory is a program which gives statistics on the number of MONOGRAPH copies received (FOR UofC UCALGARY LIBRARIES not fund level 4 of 10-54135 HIN or 10-18870 DOUCETTE) and a second report of all MONOGRAPH copies rcv for DOUCETTE (by fund level4) and a third report of all MONOGRAPH (by order type) copies rcv for HIN (by fund level4) in the past year. [NOTE for April 2007, the report generated 2 reports-one for MACK and one for Doucette and HIN was just excluded. Pre April 2007 the two reports were for ALL UCALGARY monograph orders and a separate report for Doucette so that MacKimmie copies could be obtained by subtracting the Doucette counts from the TOTAL copies received.] Sample output. Criteria for the program is the start date and end date for receipts and then it finds all Ucalgary orders with receipts in that date range. Order types selected are: FIRM,APPROVAL,PREPAY,FREE-MONO,GIFT-MONO and the payments are based on fund level 1 of MONOGRAPH or OTHER and NOT fund level4 of 10-18870 (Doucette). Send the output to S.Telfer and archive the results. The old program carlrcvdcopies.ksh is in NDL/Carl/Carlretired as are the other 4 scripts this OLD script called:
- carldourcvd.ksh
- carlfreercvdcopies.ksh
- carldoufree.ksh
- carlmonopaid.ksh
- carlrcvdcopiesv3.ksh to be used for FISCAL 2012 on in the NDL/Carl directory is a program which gives statistics on the number of MONOGRAPH copies received (FOR UofC UCALGARY LIBRARIES not fund level 4 of 10-54135 HIN or 10-18870 DOUCETTE) and a second report of all MONOGRAPH copies rcv for DOUCETTE (by fund level4) and a third report of all MONOGRAPH (by order type) copies rcv for HIN (by fund level4) in the past year. [This new version allows ACQ to use multi-part Yes and have more than one volume or part ordered on one line but this program will use distribution keys to go and find how many actual physical copies were received on those MULTI-PART YES orderlines.]. Criteria for the program is the start date and end date for receipts and then it finds all Ucalgary orders with receipts in that date range. Order types selected are: FIRM,APPROVAL,PREPAY,FREE-MONO,GIFT-MONO and the payments are based on fund level 1 of MONOGRAPH or OTHER and NOT fund level4 of 10-18870 (Doucette). Send the output to S.Telfer and archive the results.
- CARL circ stats use the custom report statforcirc and run without breakdown for date range covering the year. S.Telfer removes the DOUCETTE and consortium stats from the totals for her purposes. NOTE: S.T. only needs the totals so use the Excel file (pipedelimitedfile) so go to the Rptcustom/Run/Statforcirc directory and run the yrendtrimnew.ksh program which will reduce the outputfile to the lines ST needs and redirect the output from this program > CARLYYYYtoYYYY.stat Vi the file to add all the UCALGARY unnamed stations from the pipedelimitedfile too. Then send her this information and archive the full report and the Excel file.
- NOTE: this report is tricky if NAMED stations have been added during the year as in 2005-06 and again April 1, 2009. One must run the report in sections then and direct the program (Rptcustom/Run/Statforcirc/circstat.ksh) to use a file other than the admin file for station information so that it is accessing the station information that was relevant for that time period. (What was a floating station number for one time period may become a named station later in the year!) If you do NOT have an admin file for the time period in questions, as in April 1, 2009--then run the affected time period and try to figure it out--see what self renewals show up in strange stations--those are the cases that changed from floating to named. Sample output.
- NOTE the numbers of selfrenewal COULD be obtained from the report above if one adds up the appropriate User Access lines for PUBLIC,MAIPUB,CLAVIS,COMMUNALUM,SIPCHK,SYSTADMIN,SELFCHK1A, SELFCHK1B, SELFCHK2, SELFCHK3, SELFCHKGAL, SELFCHKHSL,RTNINSIDE,RTNOUTSIDE,RTNSORTER and any others that are known to be strictly self renewal cases BUT for now we need another report since we need it broken down by branch too (to show how their collections are being used). CARL circ stats part b use the CARLselfrenewWF copy and modify for appropriate date range covering the year. Also, ensure that the UACS's used cover all the appropriate statforcirc (for the year) unnamed stations. Sample output. S.Telfer can extract the RESERVE circ (charge/renewal counts) stats from the output that is sent to her. Archive the report as well. NOTE the User access selected are CLAVISV (for the CLAVISV user), CLAVIS (most users self renew will be under the two users associated with this UACS-WEBSERVER and CLAVIS), SYSTADMIN UACS is associated with ADMIN user in case ITS self renew their books while logged on as admin, MAIREF associated with MAIREF user might be used to self-renew at times, MAIPUB used by the MAIPUB user for CHUI in the library, REMOTE UACS is for user REMOTE which I do not think is used, PUBLIC UACS is associated with over 82,000 user records and is selected in case a user somehow renewed as themselves i.e. the old access button way, and now currently they can log in as themselves if seter is down and thoth is not and they get the login screen and they use their own login instead of the default WEBSERVER login to renew items. DO NOT include the "NOACCESS" user access in this report since it is used by many internal library user records for check outs to BINDERY and such.
- NOTE!!! discovered summer of 2007 CLAVIS user access was linked to ALL webserver users so that CLAVIS user access was all self renewals done at UCALGARY and all the consortia libraries as well. On Aug 17 I assigned new User Access's to the consortia library webserver users as follows:
stmarysweb -new user access stmarysweb (duplicate of clavis)
bvcweb - new user access bvcweb (duplicate of clavis)
aucnucweb - new user access aucnucweb (duplicate of clavis)
NOTE that the CLAVIS user (for UCALGARY) and HIN user (for HIN) both use the CLAVIS user access.
- The newly written statforcirc perl program will separate out the old CLAVIS self renewals by library as well since it breaks unnamed station transactions down by library.
- Last used in 2004--should NOT need if CARL circ stats run properly and named stations are thought out properly! This is probably what really happened in 2002-2003!CARL circ stats part c use the CARLselfrenew2 copy and modify as above but this report is used to detect if any of the stats given above should be removed from the counts because they were actually done at NAMED stations. So check the results and cull it to report out just the NAMED stations in the system-those from the Config/admin file with field 8 NOT equal to 3. Do this with /NDL/carlselfrenew2.ksh which will give the culled output. Again, this report errored out in April 2004 with too many selections error. So, I ran the report about 5 times targetting all the named stations. So in report one I looked at the full year but only for stations: 42 (ACCOUNTS), 49 (ACCOUNTS2), 50 (ACCOUNTS3), 9 (CIRC2), 28 (CIRCDDS-1), 26 (CIRCDOUC-1), 34 (CIRCDOUC-2), 35 (CIRCDOUC-3). I used this to find all the named stations in the /Config/admin file:
$ grep "^STAT\|" admin | cut -d"|" -f"2,3,8" | egrep -v "\|3$" | sort -t"|" +2df -3 | more
NAMED stations are output. List includes a two, 6 called TY-DISPLAY and 7 called TY-EDIT, I wouldn't have thought to be named stations but used them anyway for this report since they are "named" stations per setup.
$ carlselfrenew2.ksh /s/sirsi/Unicorn/Rptprint/fngq.prn carlrenew2out
$ more carlrenew2out
This is a list of the NAMED Stations within the original
report CARLselfrenew2 run on 200403121032. Refer to that log
for selection details.
STATION 1WEEK 2WEEK 3DAY DEFINITE DOU2WK LAW3DAY TOTAL
CIRCMUS-2|0|27|48|1178|97|1|1351
- NOTE: For example in 2002-2003, there were thousands of CLAVIS self-renewals done a the CIRCMAP-1 and 2 station. These numbers had to be removed from the CARLselfrenew stats by Sandra to get accurate self-renewals, since statforcirc considered any renewals done at a named station to be staff mediated. Sandra may request that the original CARLselfrenew report be rerun, one run per any named station that had results in CARLselfrenew2. This would give S.Telfer 100% of what she requires to get perfect agreement between the statforcirc and CARLselfrenew results.
CARL withdrawn stats run the custom report carlwithdrcnt to target the appropriate WITHDRYY location, where YY is the last two digits of the year covered. Eg. for 2000 to 2001, the location was WITHDR00. This gives S.T. some idea of the types of material that have been withdrawn in the past year. I archived the email of these results in 2002. Then run CARLremitem template report. Modify the date range as appropriate and send S.Telfer the log and result for her to add to the totals found via shell work. (Again, see the year end binder for details. This will be made into a program at a later date but April 2000 was the first year this information was obtained by me for S.Telfer. Sample output.
Some odds and ends year end stuff to do: The fundorder web stuff needs to be updated so that means:
- change sirsi's crontab so that fundorderwebA.ksh targets new fiscal cycle
- generate an old fiscal cycle version by running fundorderwebA.oldFY.ksh and target the old fiscal cycle (This uses the fundorderoldfy mysql table and fundorderloadOLDFY.bsh load program on webapps2, library1 servers and the fundorderoldfyTEST.php on library and fundorderoldfy.php on webapps2.) Run it and the file gets scp'd to the servers but you need to run the bash programs to load the file to mysql table. Check that all the webpages work,since the ~ndlall one failed since it goes to webapps2 ndlall fundorderold.php but that redirect was not working and I had to tinker to get it going again.
- generate an archive of the current -2 year fiscal cycle version by running fundorderwebA.oldFY.noscpksh and grab the fundorder.YYYY file from /Work and scp it over to c1 in the Tempstuff directory for an archive. As in fundorder.2009.
- Run ebookcounts.ksh for Heather D'Amour, Joyce and Aaron. Sample ouput. It is a script in Work/NDL which you run as in:
ebookcounts.ksh FISCAL_CYCLE_to_target Name_of_output_file
- Run bvccounts.ksh soon after July 1 each year and provide information to Ada-Marie and Aaron Wood.
Script is in Work/NDL run as in:
bvccounts.ksh 2007 2008 20070701 20060630 bvccounts.out
This would be what one would input when we are asked for something like:
Give us a report of BowValley numbers for fiscal 2007 and 2008 where
the fiscal cycle goes from Julyl 1, 2006 to Jun 30, 2007.
Sample output is:
Final report for Bow Valley College Counts
==========================================
...produced on seter.lib.ucalgary.ca on Wed Aug 22 10:31:55 MDT 2007
Count of orders, titles, items related to BOWVALLEY for 2007 and 2008
for year end after 20060630 and before 20070701.
NOTE: BASED on date mailed in orderline.
====================================================================
Number of BowValley items created after 20060630 and before 20070701: 1429.
Number of BowValley titles created after 20060630 and before 20070701: 1125.
Format for these titles is:
6 MAP|
1057 MARC|
5 MRDF|
21 MUSIC|
20 SERIAL|
16 VM|
Creator login for these titles is:
1 AAWOOD|
12 ACHOATE|
1 ANCOLLEEN|
2 ANVAL|
12 AWAGNER|
3 BADICK|
81 BATCH|
11 BBIRTWIS|
5 BJMARTIN|
2 BUCHANAN|
2 CKEWONG|
41 COBURN|
3 DKELL|
....
The added titles (titles above which had items at other libraries is): 415.
There were 1105 copies related to those added titles.
Number of orders for 2007 and 2008 ordered after 20060630 and before 20070701:
============================================================================
511 orders
515 orderlines
526 number on order
484 number rcvd NOTE: to date run of this report
***********End of Report******
Special Ambrose report for circ stats
- AMBuserUCchargestats - New report to list the number of charges and renewals of U of C Library items by Ambrose usercat2 and user profile, for the preceding 12 months, that Ambrose (Diane/Sandy Ayer) would like after year end. Start in 2013 and run early May. See template in sirsi1.
Scripts in the Work/NDL/Awaller directory are useful for obtaining LARGE reports on the serials in the collection.
