Differences

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

Link to this comparison view

films_on_demand [2016/04/07 11:11]
rapeterson created
films_on_demand [2019/01/07 12:20]
Line 1: Line 1:
-Films on Demand MARC Record Loading. 
- 
-  - Go to:  http://​admin.films.com/​AdminLogin.aspx (Login information available from Acquisitions) 
-  - Click on MARC Records 
-  - Download the .mrk file that you are going to load into Aleph. 
-  - Open the downloaded file with the MARCedit MARCeditor 
-  - Use the “Films on Demand” Assigned Task to update the records. 
-  - Save the file and compile it into MARC format (.e.g, umfod140521.mrc). 
-  - FTP the file to the /​exlibris/​aleph/​u21_1/​fcl01/​scratch directory on the Aleph server. Or use the file upload function from the Aleph Cataloging client to put the file in the fcl01/​scratch directory. 
-  - In the Cataloging client, under the “Aleph” menu, click on “Connect to…” and select “UMA50 - UMass Administrative”. 
-  - Under “Services” -> “Custom Services” select “UM MARC prep (umprocload-01)” 
-  - Enter the following: 
-    - *Input File : [the name of the MARC file created above] 
-    - *Match Routine : “0359A - Match 0359 subfield a” 
-    - Library: FCL01 (This is important, since you have switched to UMA50, the default library will be UMA50). 
-    - Click “Submit” 
-  - This will create 3 files: 
-    - Unmatched records: [the name of the MARC file created above] with fix1 appended (e.g., umfod140521.mrcfix1). 
-    - Matched records: [the name of the MARC file created above] with fix2 appended (e.g., umfod140521.mrcfix2). 
-    - Records with multiple matches: ​ [the name of the MARC file created above] with fix3 appended. This should not happen. ​ 
-  - Load the “fix1” file. Under “Services” -> “Custom Services” select “UM MARC load (umload-01)” 
-  - Enter the following: 
-    - * Input File: [the name of the fix1 file] 
-    - * New or Replacement Records: “New Records” 
-    - Character Conversion: “OCLC UTF to UTF (a in position 9 of the LDR) 
-    - * Item/​Holdings creation table: E-Resource (tab_hol_item_create_umelec) 
-    - Library: “FCL01” (Again, this is important) 
-  - Update holdings on OCLC 
-    - Under “Services” -> “Retrieve Catalog Records” select “Download Machine-Readable Records (print-03) 
-    - Enter the following: 
-      - * Input File: [the name of the fix1 file] with bib appended (e.g., umfod140521.mrcfix1bib) 
-      - * Output File: [name your output file] (e.g., umfod140521.mrcfix1bib035) 
-      - * Field 1 + Indicator: 035 
-      - * Format: ALEPH Sequential 
-      - Library: FCL01 
-    - Submit 
-    - Download [Output File from above]. 
-    - 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…” 
-    - 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” 
-  - If there are any records in the “fix2” file, load those records. Under “Services” -> “Custom Services” select “UM MARC load (umload-01)”. 
-  - Enter the following: 
-    - * Input File: [the name of the fix2 file] 
-    - * New or Replacement Records: “Replacement Records (requires SYSNO key)” 
-    - Character Conversion: “OCLC UTF to UTF (a in position 9 of the LDR) 
-    - * Item/​Holdings creation table: E-Resource (tab_hol_item_create_umelec) 
-    - Library: “FCL01” (Again, this is important) 
  
films_on_demand.txt · Last modified: 2019/01/07 12:20 (external edit)
[unknown link type]Back to top
www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0