UIAS Bibliographic Extraction Directions - ADVANCE

Preliminaries

1. Identify records for exclusion.

For Stanislaus, since all excludable records are handled through the reserves module, our situation is relatively easy because UABE only exports records which are represented in B.MARC and/or A.MARC. The maintenance issues associated with our on-order records are fairly complex, however, so we're spending time trying to figure out how to address deletions (as outlined in point 5 of the Building the Union Catalog for Pharos Directions for Extraction of Gap Bibliographic Records from CSU Library Systems document (http://www.calstate.edu/UIAS/Overview/GapFilExtractionDirections.shtml).

2. Geac recommended that we use a pseudo tape drive for the export in order to avoid the need to deal with file sizing issues. Once set up, the pseudo tape drive worked well in a test run. Directions for setting up the pseudo tape drive follow.

3. We did a test export to get an idea of the length of time required for the export. Stanislaus has approximately 275,000 B.MARC records. Using the pseudo tape drive, our new Sun was able to export all 275,000 B.MARC records in just over 1 hour. Although we had successfully used the USMARC output with the test records sent to Ameritech for the test union catalog created last spring, we had repeated problems with the USMARC output this time around. Switching to OCLC MARC output solved these problems (and Kay Bowen, our support person at Geac, has confirmed that UABE works better with the OCLC output format).

4. Coordinate with the catalog department and any other areas responsible for creating and/or deleting MARC records to insure that no changes are made to existing MARC records while the export is underway, and to verify that procedures are in place to address the maintenance issues associated with the union catalog beginning with the date the export is complete.

Setting up a Pseudo Tape Drive

1. Define the pseudo tape device within universe. (You must have root privileges to edit this file.)

> ED &DEVICE& PMT1
> 17 lines long.
>
> ----: P
> 0001: Pseudo Tape Device PMT1 (UIAS Bib. Export)
> 0002: /adv1/ADV/uias.export
> 0003: 0
> 0004: DT
> 0005:
> 0006: /adv1/ADV/uias.export
> 0007: /adv1/ADV/uias.export
> 0008: find $file -print | cpio -ovcB > $tape
> 0009: cpio -ivcdumB $file < $tape
> 0010:
> 0011:
> 0012:
> 0013: L
> 0014: Y
> 0015: Y
> 0016: 16384
> 0017: Y
> Bottom at line 17.
> ----:
>

2. Creating the export file at the Unix level

Before invoking UABE, you will need to create a file to be used by the pseudo tape device for the exported records. Instructions for doing that follow. (Be sure to create the pseudo tape file in an area that has as much space as your B.MARC file. Check with Geac if you need help determining this figure.)

Issue the following commands at the the unix prompt: 

# touch /adv1/ADV/uias.export
# chown adv /adv1/ADV/uias.export
# chgrp adv /adv1/ADV/uias.export
# ls -l /adv1/ADV/uias.export
-rw-r--r-- 1 adv adv 0 Oct 15 12:32 /adv1/ADV/uias.export

Export

1. Using UABE (cf. Cataloguing Management Guide, Chapter 7), complete the profile for export. This is what our output profile looks like for the UIAS records.
  
                    Convert / Output Marc Records 
 Output Type Code   : UIAS.TEST
 1) Description     : MARC OUTPUT FOR UIAS TEST (10/98)
 2) Database Code   : MAIN
 3) Input Location  : D
 4) Location Detail : B
 5) Output Format   : O            8) Archive status  :
 6) Output Location : T            9) Deletion status :
    Output Detail   :
 7) Local Subroutine:
10) Holdings Tag    :
    Institutions    :
11) Create Tag 001  :             14) Indicator Length : 2
12) Tag Del. Code   :
13) Local subroutine:
Options:
? = ? help # = # line S = Start DEL = Delete FI = File
E = Exit
Once you start UABE, the system prompts you to complete the "Create MARC Output" screen. Ours looks like this:
  
                                           Create MARC Output 
Tape Device Name-&DEVICES& ID : PMT1
Tape Device Number (ndmtu) : 0
Rewind tape drive (Y/N) : N

Are these parameters correct (Y/N/E) : Y

 Since Stanislaus doesn't have to worry about excluding any of our B.MARC records, the selection statement we are using is: SELECT B.MARC WITH @ID GE "10000000". Depending on your circumstances, your statement may differ from ours. You should probably check with Geac if you have questions about the select statement.

2. As per the instructions provided in the extraction document, we are to keep track of the ending LCN and the date, and report this information to both Marvin Pollard (mpollard@calstate.edu) and Sue Lim, the Interim Database Manager (sclim@csupomona.edu).

Since the system doesn't report an ending LCN from the UABE operation, Kay Bowen suggests the following method for determining the ending LCN given the select statement we are using. 

>CT CF.MARC #NEXT.BIB.KEY
The system responds: 
#NEXT.BIB.KEY
0001 10025924
thus the highest LCN would be 10025923.


 Bibliographic Record Extraction Documents
 

 

Last Updated: February 21, 2000