PAGE OUTDATED ARCHIVED

Films on Demand MARC Record Loading.

  1. Go to: http://admin.films.com/AdminLogin.aspx (Login information available from Acquisitions)
  2. Click on MARC Records
  3. Download the .mrk file that you are going to load into Aleph.
  4. Open the downloaded file with the MARCedit MARCeditor
  5. Use the “Films on Demand” Assigned Task to update the records.
  6. Save the file and compile it into MARC format (.e.g, umfod140521.mrc).
  7. 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.
  8. In the Cataloging client, under the “Aleph” menu, click on “Connect to…” and select “UMA50 - UMass Administrative”.
  9. Under “Services” → “Custom Services” select “UM MARC prep (umprocload-01)”
  10. Enter the following:
    1. *Input File : [the name of the MARC file created above]
    2. *Match Routine : “0359A - Match 0359 subfield a”
    3. Library: FCL01 (This is important, since you have switched to UMA50, the default library will be UMA50).
    4. Click “Submit”
  11. This will create 3 files:
    1. Unmatched records: [the name of the MARC file created above] with fix1 appended (e.g., umfod140521.mrcfix1).
    2. Matched records: [the name of the MARC file created above] with fix2 appended (e.g., umfod140521.mrcfix2).
    3. Records with multiple matches: [the name of the MARC file created above] with fix3 appended. This should not happen.
  12. Load the “fix1” file. Under “Services” → “Custom Services” select “UM MARC load (umload-01)”
  13. Enter the following:
    1. * Input File: [the name of the fix1 file]
    2. * New or Replacement Records: “New Records”
    3. Character Conversion: “OCLC UTF to UTF (a in position 9 of the LDR)
    4. * Item/Holdings creation table: E-Resource (tab_hol_item_create_umelec)
    5. Library: “FCL01” (Again, this is important)
  14. Update holdings on OCLC
    1. Under “Services” → “Retrieve Catalog Records” select “Download Machine-Readable Records (print-03)
    2. Enter the following:
      1. * Input File: [the name of the fix1 file] with bib appended (e.g., umfod140521.mrcfix1bib)
      2. * Output File: [name your output file] (e.g., umfod140521.mrcfix1bib035)
      3. * Field 1 + Indicator: 035
      4. * Format: ALEPH Sequential
      5. Library: FCL01
    3. Submit
    4. Download [Output File from above].
    5. Open [Downloaded Output File] with Excel.
      1. In the “Text Import Wizard” choose “Fixed width” and click “Next”
      2. Create a break line before the OCLC number (only the number not the ocn or ocm) and click “Next”
      3. Change all columns to text data format and click “Finish”
      4. Delete all of the rows except the OCLC number
      5. Save as a text file.
      6. Close file.
    6. Open Connexion.
    7. Under “Batch” select “Holdings by OCLC Number…”
    8. Click “Browse” and select the file created in e above.
    9. Click “Import” (if the file is still open in Excel, the file will not import)
    10. When asked, “Do you want to delete your original import file?” click “No”
    11. Select “Update Holdings” from the “Action” menu.
    12. Click “OK”
  15. If there are any records in the “fix2” file, load those records. Under “Services” → “Custom Services” select “UM MARC load (umload-01)”.
  16. Enter the following:
    1. * Input File: [the name of the fix2 file]
    2. * New or Replacement Records: “Replacement Records (requires SYSNO key)”
    3. Character Conversion: “OCLC UTF to UTF (a in position 9 of the LDR)
    4. * Item/Holdings creation table: E-Resource (tab_hol_item_create_umelec)
    5. Library: “FCL01” (Again, this is important)