How to produce list of electronic resources in aleph for alma migration
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Question
How to output electronic-resource bib records from Aleph for Alma -- with only one entry for each xxx01 bib record -- that is, a "P2E List", as required by Alma.
Answer
The following script (created by Ex Libris) was used successfully at one Aleph site:
set echo off
set pause off
set term off
set show off
set feed off
set verify off
set heading off
set linesize 25
set pagesize 50000
spool onlin.portfolio.lst
SELECT /*+ DYNAMIC_SAMPLING(2) ALL_ROWS */ distinct 'XXX01' || Z13_REC_KEY || ' ,Portfolio' from XXX01.Z13, XXX50.Z30, XXX50.Z103 where Z13_REC_KEY = substr (Z103_REC_KEY_1,6,9) and substr (Z103_REC_KEY_1,1,5) = 'XXX01' and substr (Z103_REC_KEY,6,9) = substr (Z30_REC_KEY,1,9) and z30_collection = 'ONLIN' order by 1;
spool off
exit
The output from the above SQL might look like this:
XXX01000000123,Portfolio
XXX01000000872,Portfolio
XXX01000001963,Portfolio
XXX01000002694,Portfolio
Note: This was a small site which had few or no resources of types "Package" or "DB" (the other Alma Resource Types): they were all "Portfolio". The Physical to Electronic (P2E) Conversion Process tutorial describes these three types:
1. Portfolio: single title, purchased online in full text
2. Package: a group of journal titles bundled together by the vendor
3. DB: for searching article/title info (These are collections without portfolios, such as indexing and abstracting databases, which may be linked to bibliographic records for discovery purposes.) (Examples: Proquest Social Science Database or EBSCO Literary Reference Center Database.)
The article "How to put SQL output into a spreadsheet" may be relevant.
- Article last edited: 02-Mar-2016