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 14:42] rapeterson |
alexander_street_marc_loading [2020/04/01 14:04] jeustis |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Alexander Street Press MARC Record Loading. ====== | + | ===== THIS PAGE IS USED ONLY FOR REFERENCE FOR PAST PROCEDURES ====== |
- | - Go to: http://alexanderstreet.com/marc-records | + | This page describes the general procedures for loading records into Aleph. Individual vendor records may require special handling. |
- | - Click on Product title for collection that you are loading. | + | |
- | - Click on the record set that you are loading. ASP typically has a base set and adds supplemental sets as the records are added. If this is the first time that records are being loaded for a collection (e.g., it is a new subscription), click on the base set, otherwise you can click on the supplement that you wish to load. | + | ** Below is a list of vendors that use these basic loading instructions: ** |
- | - This will download a zip file that you will need to unzip. | + | * [[http://alexanderstreet.com/marc-records|Alexander Street Press Collections]] |
- | - In the zip file you will find a MARC file. | + | * [[http://iopscience.iop.org/books/MARC-records|IOP]] |
+ | * [[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) | ||
+ | * [[http://www.oxfordreference.com/page/59/marc-records|Oxford Reference]] (MARC records removed from Aleph) | ||
+ | * [[http://dl.acm.org/contents_dl.cfm?|ACM]] (MARC records removed from Aleph) | ||
+ | * [[http://www.oecd-ilibrary.org/marc|OECD]] (MARC records removed from Aleph) | ||
+ | |||
+ | ==== Loading New Records ==== | ||
- Use MARCedit to open the file. | - Use MARCedit to open the file. | ||
- {{::marcbreaker.png?200|}} | - {{::marcbreaker.png?200|}} | ||
Line 12: | 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 40: | Line 51: | ||
- Character Conversion: “OCLC UTF to UTF (a in position 9 of the LDR) | - Character Conversion: “OCLC UTF to UTF (a in position 9 of the LDR) | ||
- *Item/Holdings creation table: [Use E-Book with call number (tab_hol_item_create_umebk if the collection has call numbers, otherwise use E-Resource (tab_hol_item_create_umelec)] | - *Item/Holdings creation table: [Use E-Book with call number (tab_hol_item_create_umebk if the collection has call numbers, otherwise use E-Resource (tab_hol_item_create_umelec)] | ||
+ | - 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 ==== | ||
Line 74: | Line 64: | ||
- * New or Replacement Records: “Replacement Records (requires SYSNO key)” | - * New or Replacement Records: “Replacement Records (requires SYSNO key)” | ||
- Character Conversion: “OCLC UTF to UTF (a in position 9 of the LDR) | - Character Conversion: “OCLC UTF to UTF (a in position 9 of the LDR) | ||
+ | - Email address : [This email will receive a copy of the load report with the bib numbers affected] | ||
- * Item/Holdings creation table: E-Resource (tab_hol_item_create_umelec) | - * Item/Holdings creation table: E-Resource (tab_hol_item_create_umelec) | ||
- Library: “FCL01” (Again, this is important) | - Library: “FCL01” (Again, this is important) | ||
Line 84: | Line 75: | ||
- Character Conversion: “OCLC to UTF (a in position 9 of the LDR) | - Character Conversion: “OCLC to UTF (a in position 9 of the LDR) | ||
- * Item/Holdings creation table: E-Resource (tab_hol_item_create_umelec) | - * Item/Holdings creation table: E-Resource (tab_hol_item_create_umelec) | ||
+ | - 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 | - Update holdings on OCLC |