This shows you the differences between two versions of the page.
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) | ||