User Tools


Export a MARC record set from MarcEdit

  1. Open MarcEdit (make sure you have the latest version)
  2. Open the Z39.50 Client in MarcEdit
  3. Query the OLUCWorldCat database (ask the Content Coordinator for login information)
  4. You can search by Title, Author, Subject, ISBN, ISSN, Record Number, and Raw (Adv.)
  5. There are two ways to search the database:
    1. Batch search
    2. Individual record search

Batch search is used for retrieving multiple records. As the purpose is to create record sets of specific items, the Title, Author, and ISBN would provide more relevant hits.

  1. Prepare a text (.txt) file with a list of ISBNs, Titles, or Authors. Separate individual items using line breaks
  2. Check Batch Search
  3. Choose the search index, for example "Author"
  4. Open the text file
  5. Name the file to be exported
  6. Click the search icon
  7. Open MarcEditor
  8. Open the saved file
  9. Examine the records
  10. With batch search, unwanted records may be included
  11. If there are multiple records of the same item, select one that looks nice and clean and includes a 520 (summary) field
  12. Erase unwanted records (highlight the whole record and click delete; each record is separated by an empty line) and add necessary information
  13. You'll need to add in key metadata that's missing (i.e. field 520 summary and field 655 NNELS genre terms)
    1. for 520, find the right paragraph in the record (the fields are usually organized in ascending order), press enter to get to a new line, and type "=520" followed by 2 spaces, and then type "\\$a" and paste the summary you have (no space between "$a" and the summary)
    2. for 655, find the right paragraph in the record, press enter to get to a new line, and type "=655" followed by 2 spaces, and then type "\4$a" and type the NNELS genre term (no space between "$a" and the term. If there is more than one term, add a new 655 entry and repeat the same
  14. When you are satisfied with all the records, go to File > Save As and add .xml as file extension
  15. You can also save the file from the beginning and do so regularly to avoid possible data loss. It is advisable to use .mrk format during editing, and at the end save it as .xml also
  16. Lastly, if your record set contains BISAC headings, follow the instructions on Handling BISAC headings in records. You can check this by opening your newly created record set in MarcEdit, go to Edit > Find, and type in "bisacsh"

You can also search for books on an individual basis, or combine different indices, such as Author and Title. However, the operator “Not” doesn’t seem to work.

  1. In the Z39.50 Client window, choose the index or indices, and type in your search and select the operator
  2. Highlight the record you would like to view and then click "View Selected Record"
  3. Select the record from the hits (choose one that looks nice and clean and includes the 520 summary field)
  4. Before downloading the chosen record, go to Preferences (you can access it on the app homepage of MarcEdit)

  5. Go to the tab Z39.50 Option
  6. Make sure that under "Save File Behavior" you have checked "Prompt to append or overwrite existing file"
  7. After choosing a record you would like to save from the search, click "Download Selected Records"
  8. For the first record(s), you will be prompted to save the file, and in the subsequent download, you will be prompted to append or overwrite; choose append to create your record set
  9. When you are done, open the saved file to do necessary edits, such as adding in key metadata that's missing (i.e. field 520 summary and field 655 NNELS genre terms)
    1. for 520, find the right paragraph in the record (the fields are usually organized in ascending order), press enter to get to a new line, and type "=520" followed by 2 spaces, and then type "\\$a" and paste the summary you have (no space between "$a" and the summary)
    2. for 655, find the right paragraph in the record, press enter to get to a new line, and type "=655" followed by 2 spaces, and then type "\4$a" and type the NNELS genre term (no space between "$a" and the term. If there is more than one term, add a new 655 entry and repeat the same
  10. When you are satisfied with all the records, go to File > Save As and add .xml as file extension
  11. You can also save the file regularly to avoid possible data loss
  12. Lastly, if your record set contains BISAC headings, follow the instructions on Handling BISAC headings in records. You can check this by opening your newly created record set in MarcEdit, go to Edit > Find, and type in "bisacsh"

To upload this MARC XML record set to Drupal, continue on to Uploading a MARC XML record set.

public/nnels/cataloguing/export-marc-from-marcedit.txt · Last modified: 2020/02/26 09:48 by lilith