MOML Crosswalk


 


  Vendor-Supplied Records Advisory Working Group


Important update: MarcEdit has a new record merging functionality, so feel free to ignore the instructions below and follow instead the simpler method posted on this wiki on April 19, 2010. 

 

 

Getting Current OCLC Numbers into Your Original MOML Records

 


Background

Many libraries still have in their databases the original MOML records they purchased from Gale, which have the microfiche record numbers in the 001 field. If you want your library to have the current OCLC numbers in your records, you have two options: request the new MOML file from Gale/Cengage (contact Karen Stec at Stec@cengage.com) and load it into your system, or use the script described below to insert field 035 with the current OCLC numbers into your original MOML records.

 

About the Script

The program was written by Ying Andrews (Fordham University), modified slightly by Tom Kaczorowski (Fordham Law Library), and suggested by Yael Mandelstam (Fordham Law Library). Anyone may use and modify it. The instructions below were written by Tom and Yael.

 

Disclaimer: the script worked for us, but if you decide to run it, you do so at your own risk!! We will be happy to try and help, though, so if you have any questions, feel free to contact us.

 

The crosswalk is a text document we received from OCLC. The document has two columns: on the left are the current OCLC numbers, and on the right are the corresponding old numbers. Here is a sample of the crosswalk:  

 

60738534           CTRG99-B994

60738535           CTRG99-B995          

60738536           CTRG99-B998                    

60712632           ocm11907452

60712633           ocm11907466

60712634           ocm11907491

 

The program takes your input file (input.txt), processes it using crosswalk.txt, and outputs the modified records to output.txt.  Any errors are output to log.txt.

 

Each 001 field is matched in the crosswalk.txt file and if a match is found, field 035 is created from the data in crosswalk.txt using the proper syntax. If a match is not found, the 001 is output to log.txt.  The filenames and paths of input.txt and crosswalk.txt are mandatory for the program to work.

 

Tools You'll Need

In addition to your ILS, you will need two free programs: MarcEdit and a Java application called Eclipse. MarcEdit is available at http://oregonstate.edu/~reeset/marcedit/html/downloads.html, and the entire Eclipse Folder, including the java script and the MOML crosswalk, is available on this wiki. A click on the Eclipse Folder will take you to a zip file. Click on that file and save it on your root C, Once all the files are in C:\Eclipse, all you need is your input file so you can start running the script.

 

Step-by-Step Instructions

Summary

 

Preparing Your Input File

 

Important note: if you added or removed any prefixes or suffixes to the original numbers in the 001 field, you'll need to adjust those to conform to the original format, otherwise there will be no match between your 001 numbers and those in the crosswalk. To ensure proper overlay when reloading the records, you'll need to adjust the numbers again to the format used in your system before loading the records back into your system. 

 

Running the Script

 

The program will process your input.txt through crosswalk.txt and output to C:\eclipse\workspace\output.txt.

When it is done you should see a message telling you how the program did.

If you see Failure Count: x, you have x number of records with an 001 field without a match in the crosswalk.  The 001’s of all such records are output to C:\eclipse\workspace\log.txt.

You can edit crosswalk.txt in notepad, or create your own, but you must keep the format the same.

To view/edit the program, doubleclick Process.java.  Edit and save, but do so at your own risk.

 

Converting your Output File Into MARC

 

You now have a MARC file ready to be loaded back into your system. Since loading instructions vary from system to system, we will not include them here. 

 

Warning: This part of the proccess must be performed ONLY by those in your institution who know how to batchload


For Innovative Users Only: Preparing your input file 

 

Create a file of MOML records using Create Lists

Go to Data Exchange. Select Process: Output MARC records to another system using IFTS (out)

Click on Create, name your Output File, retrieve the MOML Review File you created earlier, and click Start. When done, click on the Close button.

Select your file, Click on out PC, From the Save drop-down menu select Desktop and click on the Save button.

Once your file is on the desktop, continue with the instructions above. 

 

As to loading your output file back into your ILS, there are too many variables even within the Innovative system, so we cannot include instructions for that final phase.