NNELS implements LoC and FAST subject headings. This page provides instructions on how to add these subject headings to vendors' records before importing to Drupal.

1. Open MARCXML file in MarcEdit > MarcEditor.
2. Save the xml file as mrk by adding the .mrk extension.
3. Close the file and reopen it. (I have encountered quite often that edits don't get saved if I work directly with the renamed file. Closing and reopening seems to solve the problem.)
4. Go to Tools > Add/Delete Field.
5. Type "650" in Field, "=650…[0]" in Field Data, check Use Regular Expressions and Remove if field data does not match. (This is to delete all 650 fields that don't use LCSH.)
   
6. Now only LCSH remain in the records. Click Save.

1. Go to Edit > Edit Shortcuts > Field Edits > Find Records Missing Field
   
2. Enter 650.
3. Depending on the number of records missing subject headings:
   1. if there are only one or two records,
      1. note the Record Number of the records that don't have subject headings
      2. go to Edit > Jump to… > Jump to Record…
         
      3. enter the record numbers noted in step A.II.3.a.I. to locate the records with missing subject headings
      4. open Z39.50/SRU Client in MarcEdit
      5. query OLUCWorldCat, using ISBN, title, or author (Contact Content Coordinator for login information.)
      6. choose a record, click View Selected Record, locate the 650 field(s) that contain LCSH, and copy the field(s) to the corresponding vendors' record
         
      7. save and repeat the steps to other items without subject headings.
   2. if there is a larger number of records without subject headings,
      1. go to File > Select Records for Edit
      2. put "650" in Display Field, choose "Field" in Search dropdown menu, click "Does not Match"
         
      3. click "Export Selected" and save it as a separate file
      4. follow B.I. to batch search OCLC for the missing 650.

1. Open MarcEdit > Tool > Export Tab Delimited Records.
2. For MARC File use the converted vendors' mrc or mrk file, name the new txt file.
3. Choose Tab (t\) as Delimiter.
4. Add field 020 and subfield $a (or the corresponding field with ISBNs).
5. Check Normalize Data and click Process.
   
6. Open the new txt file in Excel.
7. Remove the first row, i.e., 020$a.
   
8. Use Text to Columns to separate the repeated fields if present.
   1. highlight the first column
   2. go to Data > Text to Columns
   3. in the pop-up wizard, choose Delimited, follow the prompts, choose Semicolon, and then Finish
      
   4. make sure the ISBNs are shown correctly. If not, fix the cell format:
      1. go to Home tab, choose More Number Formats…
         
      2. go to Custom, and choose 0.
         
9. Copy the first column (records may have more than one ISBN, but likely one ISBN is enough to retrieve useful subject headings) to TextEdit and save. This is to ensure that all formatting is cleared.
10. Open Z39.50/SRU Client in MarcEdit.
11. Query OLUCWorldCat database. (Contact Content Coordinator for login information.)
12. Check Batch Search, choose the newly created txt file with the ISBNs, and choose the name and destination of the save file.
13. Select ISBN in the dropdown menu, and click the search icon, which will create a mrc file.
14. Open the newly created mrc file.
15. Repeat A.I to retain only LCSH.

1. If the option of "Merge MARC records" isn't present in Tools dropdown menu, begin typing mer… in the search bar on the top right corner to call up the tool.
   
2. Make sure both the Source File (vendors' records) and Merge File (OCLC's records) are in mrk format.
3. Name the Save File.
4. Choose "020$a" for Merge method (see C.II if 20$a isn't available in the vendors' record set).
5. Enter "650" in Field List and check Merge Unique Items, click Process.
   
6. Repeat A.II to find and fill in missing subject headings. If there are still records missing subject headings, try using title or author to search OCLC. You may need to try other catalogues.

As A.I is likely to be a repeated task for different vendors' records, it would be helpful to set up a Task List, which then can be applied automatically.

1. Go to Marc Editor > Tools > Manage Tasks.
2. Select "New Task" in Task Actions dropdown menu.
3. Enter Task Name.
4. Select the task just created and choose "Edit Task" in Task Actions dropdown menu.
5. Repeat A.I.4 to A.I.5 to set up the new task. (You can ask the Content Coordinator for this specific Task List and import it using Tools > Manage Tasks > Manage Existing Tasks > Import Selected Tasks.)
6. Run task by going to Marc Editor, open the file to be worked on. Go to Tools > Current Tasks and select the corresponding task.

Some record sets may have the ISBNs in a different field, like 028$a, but Merge MARC records only works with 020$a. In such cases, use Copy Field.

1. Open the file in Marc Editor. Go to Tools > Copy Field.
2. Put "028$a" in Source Field and "020$a" in Destination Field, click Process.
3. Continue with B.II.
4. After the records are merged, delete the 020$a from the vendors' records.