• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!


MOML Crosswalk

Page history last edited by Yael Mandelstam 10 years, 8 months ago


  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



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


  • Preparing the input file by getting your MOML file out of your ILS and converting it into a text file using MarcEdit
  • Running the script using the Eclipse program
  • Converting the output text file into MARC using MarcEdit  


Preparing Your Input File

  • in your local ILS, prepare a file of MOML records and export it to your desktop (since this process varies from one ILS to another, check with your ILS vendor how to complete this step. Innovative users can consult the instructions at the bottom of this page).
  • open MarcEdit.
  • select MarcBreaker and click on the Input File Browse link. From the Files of Type drop-down menu at the bottom, select All Files (*.*). Select your MOML file
  • select your Output File (clicking on Browse and Save will save it on the desktop next to your Input File).
  • click on Execute at the bottom then click on Edit.
  • select File – Save as – From the bottom Save as Type select Text Files (*.txt). Name your file "input" and save it in C:\eclipse\workspace\
  • make sure crosswalk.txt in is also in C:\eclipse\workspace\


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

  • launch C:\eclipse\eclipse.exe. The Workspace box should have: C:\eclipse\workspace. Click OK
  • select File -- Refresh
  • on the left panel. expand the library tree (click on +)
  • expand src
  • expand (default package)
  • right click Process.java
  • select Run As  >Java Application


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

  • open MarcEdit and select MARC Maker
  • select your MarcEdit Input file (which is the file called output.txt from C:\eclipse\workspace)
  • name your MarEdit output file
  • click on Execute


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.


Comments (0)

You don't have permission to comment on this page.