When we migrated from Dynix to Spydus I was keen that we didn't lose more management information than we needed. I ran copies of the canned reports and all the usual suspects but there were two things I particularly wanted to preserve:
- I wanted to be able to give the stock manager an overview of the state of the collections at each library.
- We had 21 years' worth of data in Dynix's Statistical Reports Manager and I wasn't keen to lose all that management information.
So I wrote some Recall reports to strip out the data in text format. These are the Recall Vocs and the local dictionary items that I used.
COLLECTIONS.REPORT
0001 PA Saved at 15:15:22 23 SEP 2005 by steveh
0002 CS
0003 DISPLAY
0004 DISPLAY
0005 DISPLAY The system is now sorting all the Holdings records
0006 DISPLAY A report will be sent to the screen
0007 DISPLAY
0008 DISPLAY This will take some time
0009 DISPLAY
0010 DISPLAY If you want a copy of this report in Word or Excel
0011 DISPLAY please ask the Systems Manager
0012 DISPLAY
0013 DISPLAY working.....
0014 DISPLAY
0015 SORT HOLDINGS BY AGENCY2 BY COLLECTION BY L-ITEM.AGE BREAK-ON L-LIBNAME "TOTAL FOR 'V'" BREAK-ON T-COLL "TOTAL FOR 'V'" BREAK-ON L-ITEM.AGE "'V'" TOTAL COUNTER HEADING "LIBRARY CATALOGUE STOCK AS OF 'TL'" (CDIP
Enter DICT NAME : L-ITEM.AGE
1 FIELD NAME 1/ YEARS
2/ OLD
2 FIELD NUMBER 0
3 JUSTIFICATION L
4 DISPLAY LENGTH 25
5 CONVERSION 1/ MCT
6 CORRELATIVE 1/ A; IF N(L-YEARS.OWNED2) < "5" THEN "LESS THAN FIVE YEARS OLD" ELSE IF N(L-YEARS.OWNED2) > "10" THEN "MORE THAN TEN YEARS OLD" ELSE IF N(L-YEARS.OWNED2) = "" THEN "MORE THAN TEN YEARS OLD" ELSE "5 TO 10 YEARS OLD"
Enter DICT NAME : L-YEARS.OWNED2
1 FIELD NAME 1/ YEARS OWNED
2 FIELD NUMBER 0
3 JUSTIFICATION R
4 DISPLAY LENGTH 10
5 CONVERSION 1/
6 CORRELATIVE 1/ A;(D-N(DATE.ADDED))/"365"
STAT.MGR.DUMP.REPORT
0001 PA Saved at 16:29:48 30 APR 2012 by steveh
0002 SELECT STAT.MGR WITH L-PERIOD="DAY"
0003 SELECT STAT.MGR WITH L-KEY NOT "[.OV"
0004 SELECT STAT.MGR WITH L-KEY NOT "[.PO.]"
0005 SORT STAT.MGR BY L-DATE BY L-CODE.TRANSLATE BY L-LIBRARY L-DATE L-CODE.TRANSLATE L-LIBRARY L-TOTAL (CHIP
STAT.MGR.MONTH.DUMP
0001 PA Saved at 10:55:50 10 MAY 2012 by steveh
0002 SETPTR ,500,5000,,,3
0003 SELECT STAT.MGR WITH L-PERIOD="MONTH"
0004 SELECT STAT.MGR WITH L-ELEMENT2 GT "3000"
0005 SORT STAT.MGR BY L-PERIOD BY L-DATE BY L-CODE.TRANSLATE BY L-LIBRARY L-PERIOD L-DATE L-CODE.TRANSLATE L-LIBRARY L-TOTAL HEADING "Monthly issue statistics from Dynix as of 'TL'" (NIP
Enter DICT NAME : L-PERIOD
1 FIELD NAME 1/ PERIOD
2 FIELD NUMBER 0
3 JUSTIFICATION L
4 DISPLAY LENGTH 10
5 CONVERSION 1/
6 CORRELATIVE 1/ A;IF N(L-ELEMENT1)="M" THEN "MONTH" ELSE IF N(L-ELEMENT1)="D" THEN "DAY" ELSE ""
Enter DICT NAME : L-ELEMENT1
1 FIELD NAME 1/ FIRST BIT
2 FIELD NUMBER 0
3 JUSTIFICATION L
4 DISPLAY LENGTH 10
5 CONVERSION 1/
6 CORRELATIVE 1/ G.1
Enter DICT NAME : L-KEY
1 FIELD NAME 1/ KEY
2 FIELD NUMBER 0
3 JUSTIFICATION L
4 DISPLAY LENGTH 80
5 CONVERSION 1/
6 CORRELATIVE 1/
Enter DICT NAME : L-DATE
1 FIELD NAME 1/ DATE
2 FIELD NUMBER 0
3 JUSTIFICATION L
4 DISPLAY LENGTH 10
5 CONVERSION 1/ D2
6 CORRELATIVE 1/ G1.1
Enter DICT NAME : L-CODE.TRANSLATE
1 FIELD NAME 1/ TRANSLATED CODE
2 FIELD NUMBER 0
3 JUSTIFICATION L
4 DISPLAY LENGTH 50
5 CONVERSION 1/ MCT
6 CORRELATIVE 1/ G3.2
2/ TCODES;X;;1
Enter DICT NAME : L-LIBRARY
1 FIELD NAME 1/ LIBRARY
2 FIELD NUMBER 0
3 JUSTIFICATION L
4 DISPLAY LENGTH 35
5 CONVERSION 1/
6 CORRELATIVE 1/ A;"EX.";N(L-AGENCY);:
2/ TCODES;X;;1
Enter DICT NAME : L-AGENCY
1 FIELD NAME 1/ AGENCY
2 FIELD NUMBER 0
3 JUSTIFICATION L
4 DISPLAY LENGTH 25
5 CONVERSION 1/
6 CORRELATIVE 1/ G2.1
Enter DICT NAME : L-TOTAL
1 FIELD NAME 1/ TOTAL
2 FIELD NUMBER 0
3 JUSTIFICATION R
4 DISPLAY LENGTH 6
5 CONVERSION 1/
6 CORRELATIVE 1/ F;2;S
Enter DICT NAME : L-PERIOD
1 FIELD NAME 1/ PERIOD
2 FIELD NUMBER 0
3 JUSTIFICATION L
4 DISPLAY LENGTH 10
5 CONVERSION 1/
6 CORRELATIVE 1/ A;IF N(L-ELEMENT1)="M" THEN "MONTH" ELSE IF N(L-ELEMENT1)="D" THEN "DAY" ELSE ""
Enter DICT NAME : L-ELEMENT2
1 FIELD NAME 1/ SECOND BIT
2 FIELD NUMBER 0
3 JUSTIFICATION R
4 DISPLAY LENGTH 10
5 CONVERSION 1/
6 CORRELATIVE 1/ G1.1