Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Extracting order log information in moving to Alma

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local

     

    Description

    The Aleph order log (z71) records, including the order log notes, do not migrate into Alma. (This is not to be confused with the Library Note in the order.)   There are critical notes in some of the order logs.   Is it possible to capture this data? 
     

    Resolution

    Each entry seen in the GUI Acq Order/Subscription/Invoice Log List is a z71 record.   The value in the "Description"
    column of the list corresponds to a value in column 4 of ./xxx50/tab/tab45.lng.  Column 1 of each tab45.lng line is a
    z71_type {such as, "00" for "General note" ("General entry"), "09" for "Budget" ("Budget transactions"), etc.}

    You need to decide which z71_type's you want to export and for what time period.  (Note:  the z71 is usually one
    of the largest tables in the system and exporting all of the z71's would be problematic.)

     

    You can do the following SQL to see how many z71's of each type you have:

    > s+ xxx50
    SQL> select z71_type, count(*) from z71 group by z71_type;

    and this, to see how many for each year:

    SQL> select substr (Z71_OPEN_DATE,1,4), count(*) from z71 group by substr (Z71_OPEN_DATE,1,4);

    The Z71-DOC-NUMBER + Z71-COPY-ORDER-SEQUENCE (bytes 2 - 15 of the z71_rec_key) correspond to the z68_rec_key (the Aleph order record key).

     

    Sample SQL which could be used to output the 00, 05, and 97 order log types on or later than Jan 1, 2016, would be:

    SQL> select * from z71 where z71_type in ('00', '05', '97') and Z71_OPEN_DATE > '20160101';

    If you want to put the output from the SQL into a spreadsheet, that could be done as described in the article " How to put SQL output into a spreadsheet ". 

    The article " How to create SQL script, include in job_list " describes how to create and execute an SQL script.

    A script for this might look like that shown in Additional Information

     

    Additional Information

    Sample script:

    SET PAGESIZE 50000 
    SET PAUSE OFF 
    SET FEEDBACK OFF 
    SET TERMOUT OFF 
    SET MARKUP HTML ON SPOOL ON 

    SPOOL z71.select.lst

    select * from z71 where z71_type in ('00', '05', '97') and Z71_OPEN_DATE >= '20160101' ;

    SPOOL OFF
    EXIT

     


    • Article last edited: 3-Aug-2016