Differences

This shows you the differences between two versions of the page.

--- alexander_street_marc_loading [2016/05/26 14:22]
rapeterson
+++ alexander_street_marc_loading [2019/01/07 17:20]
127.0.0.1 external edit
@@ Line 7: / Line 7: @@
   * Ambrose Digital Video - http://www.ambrosedigital.com/index.php?option=com_virtuemart&page=shop.getfile&file_id=2200&product_id=0
   * Oxford Reference - http://www.oxfordreference.com/page/59/marc-records
-  * Literature Online - http://literature.proquest.com/infoCentre/librarians/admin/marc.jsp
   * IOP - http://iopscience.iop.org/books/MARC-records
   * ACM - http://dl.acm.org/contents_dl.cfm?
@@ Line 19: / Line 18: @@
   - This will open the file with the MARCedit MARCeditor.
     - {{::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).
   - 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]
     - Library: “FCL01” (Again, this is important)
-  - Update holdings on OCLC
-    - Under “Services” -> “Retrieve Catalog Records” select “Download Machine-Readable Records (print-03)
+==== Update holdings on OCLC ====
-      - {{::p-print-03.png?200|}}
-    - Enter the following:
+If the records do not have OCLC numbers, you will need to use the OCLC Batchload process - [[OCLC Batchload Documentation]]. The following collections do not have OCLC numbers for some or all of their records:
-      - * Input File: [the name of the fix1 file] with bib appended (e.g., umasp160406.mrcfix1bib)
+  * ACM
-      - * Output File: [name your output file] (e.g., umasp160406.mrcfix1bib035)
+  * Ambrose Digital Videos
-      - * Field 1 + Indicator: 035
+  * OECD
-      - * Format: ALEPH Sequential
-      - Library: FCL01
-    - Submit
+If the records do have OCLC numbers, use the below steps to update the holdings with OCLC.
-    - Download [Output File from above] via the Aleph client or FTP.
+  - Under “Services” -> “Retrieve Catalog Records” select “Download Machine-Readable Records (print-03)
-    - Open [Downloaded Output File] with Excel.
+    - {{::p-print-03.png?200|}}
-      - In the “Text Import Wizard” choose “Fixed width” and click “Next”
+  - Enter the following:
-      - Create a break line before the OCLC number (only the number not the ocn or ocm) and click “Next”
+    - * Input File: [the name of the fix1 file] with bib appended (e.g., umasp160406.mrcfix1bib)
-      - Change all columns to text data format and click “Finish”
+    - * Output File: [name your output file] (e.g., umasp160406.mrcfix1bib035)
-      - Delete all of the rows except the OCLC number
+    - * Field 1 + Indicator: 035
-      - Save as a text file.
+    - * Format: ALEPH Sequential
-      - Close file.
+    - Library: FCL01
-    - Open Connexion.
+  - Submit
-    - Under “Batch” select “Holdings by OCLC Number…”
+  - Download [Output File from above] via the Aleph client or FTP.
-      - {{::connexionbatch.png?200|}}
+  - Open [Downloaded Output File] with Excel.
-    - Click “Browse” and select the file created in e above.
+    - In the “Text Import Wizard” choose “Fixed width” and click “Next”
-    - Click “Import” (if the file is still open in Excel, the file will not import)
+    - Create a break line before the OCLC number (only the number not the ocn or ocm) and click “Next”
-    - When asked, “Do you want to delete your original import file?” click “No”
+    - Change all columns to text data format and click “Finish”
-    - Select “Update Holdings” from the “Action” menu.
+    - Delete all of the rows except the OCLC number
-    - Click “OK”
+    - 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 ====