|
Policies and Procedures Technical Services OSCAR Database Management
Date: January 18, 2003 Effective: January 18, 2003 Created by (or Revised by): SER, BSD
Some books in our collection are very old and very brittle. Preservation has undertaken a special project to preserve these books by creating a print reproduction and an electronic reproduction. The bibliographic record for the print reproduction has been load onto OCLC and OSCAR. The electronic reproduction has not been cataloged. The procedures in this document cover the cataloging of the E-book.
Preservation will provide a copy of part of the bibliographic record for the paper reproduction. The paper reproduction has been cataloged and has been loaded into the OCLC Worldcat database as well as in OSCAR. The portion of the record will provide the OCLC number, the call number, the title (field 245) and, in some cases, the uniform title (field 240) and/or alternate title (field 246).
The files for the electronic reproductions are loaded onto an OhioLINK server. Accessing the OhioLINK E-book server is accomplished through the use of the FTP protocol, which can be opened by clicking on the WSFTP icon on the desktop. See your administrator about adding it if the icon is not present. By clicking on the icon, a Session properties screen appears. To open the OhioLINK E-Books server enter the following information:
Once the information is entered, click the OK button. A second screen will appear requesting the password to be entered again. Once this password is entered, the list of e-books stored on the server, which OSUL Preservation has loaded, will appear on the right side of the screen under /ald3/E-Books/OSU as shown in Figure 1:
The file name usually includes the number of pages in the book and the file type (pds). To the right of the file name is the load date of the electronic version and the size of the file expressed in bytes. For example, A Simple Heart has a file size of 24589759 bytes. In the process of cataloging the electronic version, the file name will be modified and the file size converted to megabytes (MB). The file name on the server was usually based on the title of the book (field 245) and the author. However, when similar titles existed, the uniform title or the alternate title was used. The files are arranged alphabetically by title excluding the leading articles. Once the file for the e-book being cataloged is located on the server, note the file size in bytes, the date the file was loaded onto the server, and minimize the server screen for later use. Care must be taken in selecting the appropriate file. If a uniform title or alternate title exists in the paper reproduction record, check to see if files exist on the server for these titles as well as for the title before making the final selection.
Setup a new constant data form called “ebook” under your constant data manager. This form will be used in cataloging the e-books. Your supervisor will help set up this form. See Appendix A for instructions and fields.
Log onto OCLC CatME. DO NOT USE THE OHIOLINK LOG-IN. Even though the e-books are being stored on the OhioLINK server, this is an OSU project. Use the regular login for OSUU. Using CatME, find the record for the paper reproduction in OCLC WorldCat by searching the database using the OCLC number provided in the record. The bibliographic record for the paper reproduction will be used as the basis for creating the record for the e-book. With the record for the print reproduction open, under EDIT on the tool bar, click on “New.” A pop up screen will ask: “Transfer fixed values also.” Click on “yes.” A new record will appear containing the same information that was in the original record for the print reproduction. Save the NEW record to your local bib file where the record will be edited. Log off CatME.
Open the NEW record in your local file and apply the constant data for e-books. Edit the record and verify that the constant data has been properly applied.
Once the record has been edited and validated, it is ready to be produced. Producing the record adds the record to the OCLC database. When this is done, an OCLC number is assigned to the record. This is the number that is needed to complete the URL in the 8564 field and to link the record to the to file name. To produce the record, log on to OCLC CatME. With the record open in the local bib file, click the Produce button. Momentarily, OCLC will add the record to their database and assign the OCLC number. The OCLC number will replace the “NEW” in the record being created and will update the record in the local bib file. Make note of this number. Once the OCLC# is available, update the 8564 field in the newly created record on OCLC and in the record in the local bib file.
Once the OCLC number is available, it is necessary to edit the 8564 field in the new record on OCLC. This is accomplished by opening the record in OCLC WorldCAT, “locking” the record, and updating the OCLC number to the rave link. Using CatME, search the database using the OCLC # and open the record. Under “Action” choose “LOCK” to lock the record for editing. Update the 856 field by adding the OCLC # to the URL. The URL in the 8564 field will now look like: |uhttp://rave.ohiolink.edu/ebooks/dmc/OSU/SimpleHeartHerodius%5Fflaubert%5F246pgs50957134.pdf|zConnect to title online This link cannot be verified until the file name is updated in the database located on the OhioLINK server. Review the record to make sure that you have not missed editing any of the fields as described in the previous step. Make any necessary changes. When the editing is complete, click on “Replace” under ACTION. The record had now been updated in OCLC.
While still logged onto OCLC, update the record for the print reproduction. Note: Before proceeding with editing the record, verify the number of institutions currently using the record. You will find this information at the bottom of the screen where it shows “held” followed by a number. If the number is one, then we “should” be able to “Lock,” edit the record and “Replace,” since we should be the owner of the record. If the “held” number is greater than “1,” you will not be able to edit the record. If this situation occurs, note it on list of records from which you are working. If the record indicates “1”, open the record by using the OCLC#, LOCK the record, and add the following fields:
When the editing is complete, and the record has been carefully reviewed for any typing errors, validate the record. Next, REPLACE the record. Note: Editing the print record on OCLC can only be accomplished if OSU is the owner and no other institution has used it.
The file name must be updated by adding the OCLC number to the file name for the file located on the OhioLINK server. Open the WSFTP icon that was minimized early. Expand the column for the file name until the entire name can be read. Click on the “Rename” button on the right side of the screen and enter the OCLC number before the “.pdf”. As in the example, A Simple Heart, the original file name was: SimpleHeartHerodius_Flaubert_246pgs.pdf When the OCLC number is added, the file name will look like: SimpleHeartHerodius_Flaubert_246pgs50957134.pdf Once the OCLC# has been entered, click on “OK” and the transmission and linking will automatically occur. At the bottom of the screen a report will display indicating whether the renaming was successful or not. In order for the renaming to be successful, you must be logged into CatME and the record must be closed on OCLC or the linking of the file to the OCLC record will fail.
Finish updating the 8564 field in bibliographic record in your local bib file. Add the OCLC number to the record in your local file. Validate the record and export it into OSCAR. Note the bibliographic number assigned to the record.
Open the record for the print reproduction in OSCAR and update it by adding the 530, 7761 and 8564 fields as was done earlier in the record for OCLC.
Now that the file name and the rave link have been updated, go into public OSCAR and call up the record and check the URL for both the print and the electronic to make certain that it works. If it does not work, check the 856 field and the file name to make certain they are correct and make corrections. If corrections were necessary, you must make the same changes in the records on OCLC so that the links work from those records. The new record is now complete if the links in both the print and online work properly. Access has been given to the electronic version of the print reproduction.
006 m d 007 c $b r $d u $e n $f u 500 Text made available in compliance with Section 108 of the Copyright Revision Act of 1976. 530 Online version of print reproduction. 533 Electronic reproduction. $b Austin, [Tex.] : $c BookLab, Inc., $d yyyy. 538 Mode of access: World Wide Web. 538 System requirements: xx.x MB; Adobe Acrobat Reader. 776 1 [author] $s $t $w (OCoLC) 856 4 $u http://rave.ohiolink.edu/ebooks/dmc/OSU/[insert filename] $z Connect to title online 949 0 $l wwb $m a $x - $d mm-dd-yy 949 1 $g 1 $j 0 $l wwb $s g $t 16 $x - 910 nn03mmdd
Return to S/E/R Documentation menu. Return to Tech Services Documentation menu.
|