• Article Type: General
• Product: Aleph
• Product Version: 20, 21, 22, 23

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 ("Display PLIF Records from Sequential File") 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