University of Calgary Library

...Database Maintenance and Statistical Gathering : API Programmer as "Hunter, Gatherer"

FUNDCIRCSTAT

This report links order/fund/catalog AND item circulation information. The fields it can generate are:


        1).Fund ID     2).Fund Name      3).Item ID     4).Callnum     5).Author      6).Title          7).Publication
        8).Location    9).Circulation      10).Copy Number     11).Unit Price     12).Order ID

Tons of sort outputs:


   1) Call Number            3) Fund ID/Call Number    5) Fund Name
   2) Fund ID/Author         4) Fund ID/Title

Sample report .prn output:



     Title       :  The integrity of the yoga dar*sana : a reconsideration of
                    classical yoga / Ian Whicher.f
     Publication :  Albany, N.Y. :  State University of New York Press,

        Item ID    : 00009170792           Home Location :  1LT-RESN
        Charge Out :  2                    Unit Price    :  $107.65
        Copy #     :  1


     Call number :  B2430 .L473 A4813 1999
     Author      :  L*evinas, Emmanuel.
     Title       :  Alterity and transcendence / Emmanuel Levinas ; translated
                    by Michael B. Smith.W
     Publication :  New York :  Columbia University Press,  c1999.

        Item ID    : 00009223507           Home Location :  1LT-RESN
        Charge Out :  0                    Unit Price    :  $38.31
        Copy #     :  1

...

  TOTAL FOR FUND :
     Total charge out  : 10869            Total # of items : 1542
     Average cost/item : 66.19          Total price : 102066.93


          **************** TOTAL FOR REPORT ****************

           Total charge out   : 10869
          Total # of items   : 1542
          Total price        : 102066.93
          Average price/item : 66.19

STATFORCIRC

goes through the log files to group CHARGE ITEM/DISCHARGE ITEM/RENEW ITEM/RENEW USER transactions by station name and group them by their Location field and subtotal them.

Take desired log(s) files and cat through a seltrans -c"CV,RV,RY,EV" followed by:
Some sed commands to reduce each line to STATION|UACS|COMMAND_CODE
Use sort and uniq -c and you're basically there.
Sample output of named station section:
Sample output of unnamed station section grouped by UACS:
Output also in pipe delimited file (reported location in LOG) which can be pulled into Excel for easy manipulation (pull unnamed stations into line with appropriate named stations) etc.

AUTHPROBLEMS

checks our authority database monthly for two types of errors.


              AUTHORITIES WITH A 1XX TEXT OF: **REQUIRED FIELD**               

XX1536922
                                      Problem Authority List                   
                                 Page 1 of 2                                  

        AUTHORITY IDs WHICH ARE UNUSUAL or HAVE NO 1XX--TO INVESTIGATE         

LALL, NELLA D.
                                      Problem Authority List                   
                                 Page 2 of 2

UNLINKORDER

lists orders which have no bibliographic link


                                 unlinkorder                                  
                                                                               
                 Produced Monday, August 28, 2000 at 10:58 AM                  
                                                                               
       Order ID:294049                   fiscal cycle:2000 
      Vendor ID:ABC                        order type:FIRM

PRTORDERSUC

custom purchase order report.


Friday, September 01, 2000 ---- PURCHASE ORDER # 298644 ----

Customer Number: CLGY

   Academic Book Center
   5600 N.E. Hassalo Street
   Portland, Oregon
   97213-3640
   U.S.A.

Please ship the items listed below to:

       Monograph Acquisitions
       MacKimmie Library
       University of Calgary
       2500 University Dr. N.W.
       Calgary, Alberta
       T2N 1N4

ORDERS WILL BE CANCELLED IF NOT RECEIVED BY 09/01/2002

           Personal author:Stolba, K Marie.
                     Title:The development of western music : a history / K.
                           Marie Stolba.
                   Edition:3rd ed.
          Publication info:Boston, Mass. : McGraw Hill, c1998.
      Physical description:xviii, 734 p. : ill. (some col.) ; 27 cm.
                Local note:ZUBC+
                      ISBN:0697293793
            LC call number:ML160 .S87 1998
      Local LC call number:MT6.5 .D484 1998
                 Catalog #:acbc.com

    total copies:1
     TOTAL PRICE:U60.68

  * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
                         FOR LIBRARY USE ONLY

            Fund:49041


			Page 1 of 1

Back to: Main API presentation page

Back to: TOP of page

Nella Lall
University of Calgary Library, ITS