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

Description:
I am interested in getting eShelf data for only one patron from Aleph to Primo. Right now, we have users who prefer Aleph, so I am somewhat hesitant to move the whole thing, because later down the road, users might decide to switch.

Is it possible to extract from the Aleph the eShelf for one user? Then import that eShelf into Primo?

Resolution:
My e-shelf records are z129 records in the $usr_library (at your site, pwd50).

To get the e-shelf for patron ID 00955245, you would do:

pwd50@> spool z129.list
pwd50@> select * from z129 where z129_rec_key like '00955245%';
**** Hit return to continue ****

Z129_REC_KEY Z Z
------------------------------------------------------- - -
Z129_BASE Z129_DOC_ Z129_OPEN_DATE Z129_FOLDER
-------------------- --------- -------------- --------------------
Z129_FOLDER_SEQUENCE
--------------------
Z129_NOTE
--------------------------------------------------------------------------------
00955245 00001 D N
ABC01PUB 001724052 20050722 Environmental Books
1
Environmental Books

The z129 records for this patron would be spooled into a z129.list file with this layout:

Z129_REC_KEY NOT NULL CHAR(55)
Z129_TYPE NOT NULL CHAR(1)
Z129_SELECTED CHAR(1)
Z129_BASE VARCHAR2(20)
Z129_DOC_NUMBER CHAR(9)
Z129_OPEN_DATE NUMBER(8)
Z129_FOLDER VARCHAR2(20)
Z129_FOLDER_SEQUENCE NUMBER(5)
Z129_NOTE VARCHAR2(200)

• Article last edited: 10/8/2013