===== PAGE OUTDATED ARCHIVED =====

=== 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)