This shows you the differences between two versions of the page.
public:nnels:cataloguing:add-subject-headings [2020/03/27 19:19] lilith [E. Check missing subject headings] |
public:nnels:cataloguing:add-subject-headings [2024/05/09 05:04] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Adding subject headings to vendors' | ||
- | NNELS implements LoC and FAST subject headings. This page provides instructions on how to add these subject headings to vendors' | ||
- | |||
- | Although some vendors' | ||
- | |||
- | Download the [[https:// | ||
- | |||
- | ===== A. Batch search OCLC with ISBNs ===== | ||
- | - Open the vendors' | ||
- | - Save the xml file as mrk by adding the .mrk extension. | ||
- | - 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.) | ||
- | - Open MarcEdit > Tool > Export Tab Delimited Records. | ||
- | - For MARC File use the converted vendors' | ||
- | - Choose Tab (t\) as Delimiter. | ||
- | - Add field 020 and subfield $a (or the corresponding field with ISBNs). | ||
- | - Check Normalize Data and click Process.\\ {{: | ||
- | - Open the new txt file in Excel. | ||
- | - Remove the first row, i.e., 020$a.\\ {{: | ||
- | - Use Text to Columns to separate the repeated fields if present. | ||
- | - highlight the first column | ||
- | - go to Data > Text to Columns | ||
- | - in the pop-up wizard, choose Delimited, follow the prompts, choose Semicolon, and then Finish\\ | ||
- | - make sure the ISBNs are shown correctly. If not, fix the cell format: | ||
- | - go to Home tab, choose More Number Formats...\\ | ||
- | - go to Custom, and choose 0.\\ {{: | ||
- | - Copy the first column (records may have more than one ISBN, but likely one ISBN is enough to retrieve useful subject headings) to TextEdit (or any plain text editor) and save. This is to ensure that all formatting is cleared. | ||
- | - Open Z39.50/SRU Client in MarcEdit. | ||
- | - Query OLUCWorldCat database. (Contact Content Coordinator for login information.) | ||
- | - Check Batch Search, choose the newly created txt file with the ISBNs, and choose the name and destination of the save file. | ||
- | - Select ISBN in the dropdown menu, and click the search icon, which will create a mrc file. | ||
- | |||
- | =====B. Prepare OCLC records===== | ||
- | The preparation needed is included in a task file that you are about to download. It includes several steps: move BISACSH from field 650 to a NNELS local field 946$a, delete all subject headings except LoC and FAST. You only need to run the task file described below. | ||
- | |||
- | - Download the {{ : | ||
- | - Open MarcEdit. | ||
- | - Go to MarcEditor. | ||
- | - Go to Tools > Manage Tasks to open Task Manager. | ||
- | - Click the dropdown menu of Manage Existing Tasks \\ {{: | ||
- | - Choose Import Selected Tasks. | ||
- | - Navigate to the task file you downloaded earlier and import it. | ||
- | - Open the record set you generated in step A.16 in MarcEditor. | ||
- | - Go to Tools > Current Tasks and choose the task you just imported: '' | ||
- | - You should get a Results screen with information on how many records have been processed\\ {{: | ||
- | - Save the file in .mrk extension. | ||
- | |||
- | ===== C. Prepare vendors' | ||
- | - Open the vendors' | ||
- | - Repeat B.9 to B.11. | ||
- | |||
- | ===== D. Merge OCLC and vendors' | ||
- | We will merge two fields (650 and 946) of the two record sets we prepared in B. and C. to get all available LoC and FAST subject headings. | ||
- | |||
- | - If the option of "Merge MARC records" | ||
- | - Make sure both the Source File (vendors' | ||
- | - Name the Save File. | ||
- | - Choose " | ||
- | - Enter " | ||
- | |||
- | |||
- | |||
- | ===== E. Check missing subject headings ===== | ||
- | - Go to Edit > Edit Shortcuts > Field Edits > Find Records Missing Field\\ {{: | ||
- | - Enter 650. | ||
- | - If the result is 0, your record set is ready. | ||
- | - Otherwise, highlight the record and click '' | ||
- | - Note the title and author (since we already did the OCLC search with ISBN, we will use title and author to search for missing subject headings). | ||
- | - Open Z39.50/SRU Client in MarcEdit. | ||
- | - Query OLUCWorldCat, | ||
- | - Choose a record, click View Selected Record, locate the 650 field(s) that contain LoC and/or FAST subject headings, and copy the field(s) to the corresponding vendors' | ||
- | - Save and repeat the steps with other items without subject headings. | ||
- | - When you are satisfied with all the records, go to File > Save As and add .xml as file extension. | ||
- | |||
- | Note: Although it is possible to do batch search in OCLC using title or author if a lot of records are missing, due to the nature of title and author name variations, it is not easy to ensure that search results are accurate. It is more reliable to work on each record individually. | ||
- | |||
- | |||
- | |||
- | |||
- | ===== F. When ISBN isn't in 020$a ===== | ||
- | 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. | ||
- | - Open the file in Marc Editor. Go to Tools > Copy Field. | ||
- | - Put " | ||
- | - Continue with D.4. | ||
- | - After the records are merged, delete the 020$a from the vendors' | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||