This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
alexander_street_marc_loading [2016/05/24 15:27] rapeterson |
alexander_street_marc_loading [2020/04/01 14:04] jeustis |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== General MARC Record Loading Procedures ====== | + | ===== THIS PAGE IS USED ONLY FOR REFERENCE FOR PAST PROCEDURES ====== |
This page describes the general procedures for loading records into Aleph. Individual vendor records may require special handling. | This page describes the general procedures for loading records into Aleph. Individual vendor records may require special handling. | ||
** Below is a list of vendors that use these basic loading instructions: ** | ** Below is a list of vendors that use these basic loading instructions: ** | ||
- | * Alexander Street Press Collections - http://alexanderstreet.com/marc-records | + | * [[http://alexanderstreet.com/marc-records|Alexander Street Press Collections]] |
- | * Ambrose Digital Video - http://www.ambrosedigital.com/index.php?option=com_virtuemart&page=shop.getfile&file_id=2200&product_id=0 | + | * [[http://iopscience.iop.org/books/MARC-records|IOP]] |
- | * Oxford Reference - http://www.oxfordreference.com/page/59/marc-records | + | * [[http://www.ambrosedigital.com/index.php?option=com_virtuemart&page=shop.getfile&file_id=2200&product_id=0|Ambrose Digital Video]] (MARC records removed from Aleph) |
- | * Literature Online - http://literature.proquest.com/infoCentre/librarians/admin/marc.jsp | + | * [[http://www.oxfordreference.com/page/59/marc-records|Oxford Reference]] (MARC records removed from Aleph) |
- | * IOP - http://iopscience.iop.org/books/MARC-records | + | * [[http://dl.acm.org/contents_dl.cfm?|ACM]] (MARC records removed from Aleph) |
- | * ACM - http://dl.acm.org/contents_dl.cfm? | + | * [[http://www.oecd-ilibrary.org/marc|OECD]] (MARC records removed from Aleph) |
- | * OECD - http://www.oecd-ilibrary.org/marc | + | |
==== Loading New Records ==== | ==== Loading New Records ==== | ||
Line 19: | Line 18: | ||
- This will open the file with the MARCedit MARCeditor. | - This will open the file with the MARCedit MARCeditor. | ||
- {{::marceditor.png?200|}} | - {{::marceditor.png?200|}} | ||
- | - Depending on the contents of the collection use the ebook, Streaming Video, or Streaming Audio assigned task, located in the Tools menu. | + | - Depending on the contents of the collection use the *ebook*, *Streaming Video*, or *Streaming Audio* assigned task, located in the Tools menu. (Tasks can be imported from the 01-Record Loading directory on the ILS Drive Q:) |
- | - Apply the Add Proxy, Move 001 to …, and fix OCLC prefix tasks. (Tasks can be imported from the 01-Record Loading directory on the ILS Drive Q:). | + | - Apply the *Move 001 to 0359* task. |
- | - Use Edit>Replace to replace the UWWW in the 949 $c with the appropriate [collection_codes_for_aleph_marc_records|collection code] (e.g. Replace all $cUWWW with $cUWDIV). | + | - For the collections listed below, use Edit->Replace to add unique identifying information for the collection |
+ | - ACM: change "=035 9\$aum" to "=035 9\$aumacm" | ||
+ | - IOP: change "=035 9\$aum" to "=035 9\$aumiop" | ||
+ | - OECD: change "=035 9\$aum" to "=035 9\$aumoecd" | ||
+ | - Apply the Add Proxy and fix OCLC prefix tasks. | ||
+ | - Use Edit->Replace to replace the UWWW in the 949 $c with the appropriate [[collection_codes_for_aleph_marc_records|collection code]] (e.g. Replace all $cUWWW with $cUWDIV). | ||
- Save the file and compile it into MARC format (.e.g, umdiv160406.mrc). | - Save the file and compile it into MARC format (.e.g, umdiv160406.mrc). | ||
- Use the Task Manager Upload/Download files function to upload the file to: | - Use the Task Manager Upload/Download files function to upload the file to: | ||
Line 49: | Line 53: | ||
- Email address : [This email will receive a copy of the load report with the bib numbers affected] | - Email address : [This email will receive a copy of the load report with the bib numbers affected] | ||
- Library: “FCL01” (Again, this is important) | - Library: “FCL01” (Again, this is important) | ||
- | - Update holdings on OCLC | + | |
- | - Under “Services” -> “Retrieve Catalog Records” select “Download Machine-Readable Records (print-03) | + | ==== Holdings on OCLC ==== |
- | - {{::p-print-03.png?200|}} | + | |
- | - Enter the following: | + | Records should not have holdings set in OCLC. |
- | - * Input File: [the name of the fix1 file] with bib appended (e.g., umasp160406.mrcfix1bib) | + | |
- | - * Output File: [name your output file] (e.g., umasp160406.mrcfix1bib035) | + | |
- | - * Field 1 + Indicator: 035 | + | |
- | - * Format: ALEPH Sequential | + | |
- | - Library: FCL01 | + | |
- | - Submit | + | |
- | - Download [Output File from above] via the Aleph client or FTP. | + | |
- | - Open [Downloaded Output File] with Excel. | + | |
- | - In the “Text Import Wizard” choose “Fixed width” and click “Next” | + | |
- | - Create a break line before the OCLC number (only the number not the ocn or ocm) and click “Next” | + | |
- | - Change all columns to text data format and click “Finish” | + | |
- | - Delete all of the rows except the OCLC number | + | |
- | - Save as a text file. | + | |
- | - Close file. | + | |
- | - Open Connexion. | + | |
- | - Under “Batch” select “Holdings by OCLC Number…” | + | |
- | - {{::connexionbatch.png?200|}} | + | |
- | - Click “Browse” and select the file created in e above. | + | |
- | - Click “Import” (if the file is still open in Excel, the file will not import) | + | |
- | - When asked, “Do you want to delete your original import file?” click “No” | + | |
- | - Select “Update Holdings” from the “Action” menu. | + | |
- | - Click “OK” | + | |
==== Replacement Records ==== | ==== Replacement Records ==== |