Importing class registrations for e-reserves: can't supply Aleph patron ID

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

Description:
Is there a better explanation of the procedure for loading students and their course numbers than what I find in the system librarian chapter for course reserve - p. 15-16 in my copy.

It says incoming file must match z303-id, but that, as far as I can tell, is an ALEPH id, and there's no way the Banner system would know how to match such an id with a course number.

With plif we match on barcode. Our barcodes are 13 digits, and apparently not in z303. Our course numbers are alpha-numeric (not like the example in the chapter).

Resolution:
The computer center created a file with the patron barcode (minus the 5-digit prefix -- since there's only room for 12 digits of ID).

* I placed this file into abc50 $data_files as z107.seqaa.

* I ran p_file_04 to load this z107 file into Oracle. The resulting z107 looked like this:

> s+ abc50
> select * from z107;

Z107_REC_KEY
--------------------------------
09217757 FRST100-5941
09818075 FRST100-5941
09818364 FRST100-5941
09827878 FRST100-5941
09848973 FRST100-5941
09859590 FRST100-5941
09887310 FRST100-5941
10023129 FRST100-5941
10024036 FRST100-5941
10027658 FRST100-5941
10087645 FRST100-5941
10132961 FRST100-5941

Then I ran the following SQL:

abc50@ALEPH19T> update z107 set z107_rec_key = substr (z107_rec_key,13,20) || ( select z308_id from z308 where z308_rec_key like '01%' and substr (z308_rec_key,8,8) = substr (z107_rec_key,1,8) and substr (z308_rec_key,8,8) is not null);

Then I put the Aleph patron ID first, as expected:

abc50@ALEPH19T> update z107 set z107_rec_key = substr(z107_rec_key,21,12) || substr(z107_rec_key,1,20);

That substituted the Aleph patron ID for the patron barcode (minus the 5-digit prefix):

Z107_REC_KEY
--------------------------------
ABC000006343FRST100-5941
ABC000006414FRST100-5941
ABC000006417FRST100-5941
ABC000006424FRST100-5941
ABC000006436FRST100-5941
ABC000006446FRST100-5941
ABC000006473FRST100-5941
ABC000006557FRST100-5941
ABC000006559FRST100-5941
ABC000006564FRST100-5941
ABC000006632FRST100-5941
ABC000006635FRST100-5941
ABC000006679FRST100-5941

This is the form expected by the Course Reserve programs.

[Note: If you use the University ID as your PLIF match point, you could create the input file with that as the input ID rather than the barcode. In that case, you would need to specify the following for the first update statement:

update z107 set z107_rec_key = substr (z107_rec_key,13,20) || ( select z308_id from z308 where z308_rec_key like '02%' and substr (z308_rec_key,3,12) = substr (z107_rec_key,1,12) and substr (z308_rec_key,3,12) is not null);

[The '02%' in the preceding presumes that your university ID is type '02'. If it's 99 or something else, you will need to specify that instead.]