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

    Utility to view p_file_20 input records

    • Article Type: General
    • Product: Aleph
    • Product Version: 19.01

    Description:
    We are getting errors in p_file_20 trying to load particular patron records. The input file as displayed in the abc50 $data_scratch is just one big long string and difficult to decipher. Is there a better way to check the PLIF input file?

    Resolution:
    util f/2/5/1 can be used to check a PLIF input file. Let's say that you see the following in the $alephe_scratch p_file_20 log:

    Error (b_file_20_chk_edit_record) : Errors in Z303. Record No 000024
    Number of Errors = 02
    Load: /exlibris/aleph/u17_1/utf_files/exlibris/aleph/u17_1/alephe/error_eng/check_z303
    Error 0201 : Z303-ILL-LIBRARY is not valid (check tab_sub_library)
    Error 0212 : Z303-HOME-LIBRARY is invalid (check tab_sub_library)

    You can do util f/2/5/1 to see the formatted input record. (You enter in the "Record No" as the "line number"):

    Enter file name in scratch directory (or q to exit)

    file name: student_ads.txt

    Enter line number (CR cont, Q quit) : 24

    *** Line no.: 000000024

    USER-REC
    ACTION........... A
    MATCH-ID-TYPE.... 02
    MATCH-ID......... R00269694
    ID-1.............
    ID-2.............
    VERIFICATION-1... 9699
    VERIFICATION-2...
    VERIFICATION-3...
    CON-LNG..........
    NAME-TITLE.......
    NAME............. Smith, Paula
    BIRTH-DATE....... 19850927
    BUDGET...........
    EXPORT-CONSENT... Y
    DELINQ-INDEX.....
    DELINQ...........
    DELINQ-N.........
    FIELD-INDEX......
    FIELD............
    PROFILE-ID....... HSC
    ILL-LIBRARY...... BLUE
    HOME-LIBRARY..... BLUE
    ILL-TOTAL-LIMIT..
    ILL-ACTIVE-LIMIT.
    SEND-ALL-LETT.... Y
    PROXY-FOR-ID..... +
    PRIMARY-ID.......
    CON-LNG..........
    TYPE.............
    PLAIN-HTML.......
    WANT-SMS.........
    NOTE-INDEX.......
    NOTE.............
    SALUTATION.......
    NO-ID............ 03
    NO-ADDRESS....... 02
    NO-BOR........... 03

    Display IDs (CR cont, Q quit, S skip) :

    USER-KEY-REC # 01
    ACTION............. A
    KEY................
    TYPE............. 01
    LOGIN............ 21295005727694
    VERIFICATION....... 8699
    VERIFICATION-TYPE.. 00
    STATUS............. AC
    ENCRYPTION......... Y

    USER-KEY-REC # 02
    ACTION............. A
    KEY................
    TYPE............. 02
    LOGIN............ R00269694
    VERIFICATION....... 8699
    VERIFICATION-TYPE.. 00
    STATUS............. AC
    ENCRYPTION......... Y

    USER-KEY-REC # 03
    ACTION............. A
    KEY................
    TYPE............. 03
    LOGIN............ R00269694
    VERIFICATION....... 8699
    VERIFICATION-TYPE.. 00
    STATUS............. AC
    ENCRYPTION......... Y

    Display Addresses (CR cont, Q quit, S skip) :

    ADDR-REC # 01
    ACTION...... A
    SEQUENCE.... 01
    TYPE........ 01
    ADDR-1...... Paula Smith
    ADDR-2...... 3115 South Fork Drive
    ADDR-3......
    ADDR-4......
    ADDR-5...... Dallas, TX
    ZIP......... 75205
    PHONE.......
    PHONE-2.....
    PHONE-3.....
    PHONE-4.....
    E-MAIL...... paula.smith@abchsc.edu
    START-DATE..
    STOP-DATE...
    SMS-NUMBER..

    ADDR-REC # 02
    ACTION...... A
    SEQUENCE.... 02
    TYPE........ 02
    ADDR-1...... Paula Smith
    ADDR-2......
    ADDR-3......
    ADDR-4......
    ADDR-5......
    ZIP.........
    PHONE.......
    PHONE-2.....
    PHONE-3.....
    PHONE-4.....
    E-MAIL...... paula.smith@abchsc.edu
    START-DATE..
    STOP-DATE...
    SMS-NUMBER..

    Display Bor (CR cont, Q quit, S skip) :

    BOR-REC # 01
    ACTION...... A
    SUB-LIBRARY. ALEPH
    TYPE........ 00
    STATUS...... 34
    EXPIRY-DATE.
    REG-DATE....

    BOR-REC # 02
    ACTION...... A
    SUB-LIBRARY. ABC50
    TYPE........ 00
    STATUS...... 34
    EXPIRY-DATE.
    REG-DATE....

    BOR-REC # 03
    ACTION...... A
    SUB-LIBRARY. SWC
    TYPE........ 00
    STATUS...... 34
    EXPIRY-DATE.
    REG-DATE....

    Trying to find match...
    --------------------------------------------------------------
    Load: /exlibris/aleph/u17_1/alephe/tab/tab100
    --------------------------------------------------------------
    Load: /exlibris/aleph/u17_1/abc50/tab/tab100

    Match found for
    MATCH-ID-TYPE... 02
    MATCH-ID........ R00269694

    Matched on
    ID.............. ID74957
    NAME............ Smith, Paula

    Note: this utility works only with the Sequential format input file, not the XML; the XML file, having the XML label for each field, does not really need it.


    • Article last edited: 10/8/2013