This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
public:nnels:cataloguing:add-subject-headings [2020/03/10 15:30] lilith [Adding subject headings to vendors' record sets with MarcEdit] |
public:nnels:cataloguing:add-subject-headings [2020/03/27 12:44] lilith [F. When ISBN isn't in 020$a] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | <note important> | ||
- | |||
====== Adding subject headings to vendors' | ====== Adding subject headings to vendors' | ||
- | NNELS implements | + | NNELS implements |
- | ===== A. If vendors' | + | Although some vendors' |
- | ==== I. Eliminate all subject headings except LCSH in field 650 ==== | + | |
- | - Open MARCXML file in MarcEdit > MarcEditor. | + | |
- | - Save the xml file as mrk by adding the .mrk extension. | + | |
- | - Close the file and reopen | + | |
- | - Go to Tools > Add/Delete Field. | + | |
- | - Type " | + | |
- | - Now only LCSH remain in the records. Click Save. | + | |
- | ==== II. Fill in missing subject headings ==== | + | Download the [[https:// |
- | - Go to Edit > Edit Shortcuts > Field Edits > Find Records Missing Field\\ {{:public: | + | |
- | - Enter 650. | + | |
- | - Depending on the number | + | |
- | - if there are only one or two records, | + | |
- | - note the Record Number of the records that don't have subject headings | + | |
- | - go to Edit > Jump to... > Jump to Record...\\ {{: | + | |
- | - enter the record numbers noted in step A.II.3.a.I. to locate the records with 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 LCSH, and copy the field(s) to the corresponding vendors' | + | |
- | - save and repeat the steps to other items without subject headings. | + | |
- | - if there is a larger number of records without subject headings, | + | |
- | - go to File > Select Records for Edit | + | |
- | - put " | + | |
- | - click " | + | |
- | - follow B.I. to batch search OCLC for the missing 650. | + | |
- | + | ===== A. Batch search OCLC with ISBNs ===== | |
- | ---- | + | - Open the vendors' |
- | + | - Save the xml file as mrk by adding the .mrk extension. | |
- | ===== B. If vendors' | + | - 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.) |
- | ==== I. Batch search OCLC with ISBNs ==== | + | |
- Open MarcEdit > Tool > Export Tab Delimited Records. | - Open MarcEdit > Tool > Export Tab Delimited Records. | ||
- | - For MARC File use the converted vendors' | + | - For MARC File use the converted vendors' |
- Choose Tab (t\) as Delimiter. | - Choose Tab (t\) as Delimiter. | ||
- Add field 020 and subfield $a (or the corresponding field with ISBNs). | - Add field 020 and subfield $a (or the corresponding field with ISBNs). | ||
Line 50: | Line 24: | ||
- go to Home tab, choose More Number Formats...\\ | - go to Home tab, choose More Number Formats...\\ | ||
- go to Custom, and choose 0.\\ {{: | - 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 and save. This is to ensure that all formatting is cleared. | + | - Copy the first column (records may have more than one ISBN, but likely one ISBN is enough to retrieve useful subject headings) to TextEdit |
- Open Z39.50/SRU Client in MarcEdit. | - Open Z39.50/SRU Client in MarcEdit. | ||
- Query OLUCWorldCat database. (Contact Content Coordinator for login information.) | - 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. | - 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. | - Select ISBN in the dropdown menu, and click the search icon, which will create a mrc file. | ||
- | - Open the newly created mrc file. | ||
- | - Repeat A.I to retain only LCSH. | ||
- | ==== II. Merge vendors' and OCLC records ==== | + | =====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 LCSH 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: ''Add LCSH and FAST'' | ||
+ | - You should get a Results screen with information on how many records | ||
+ | - 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 LCSH and FAST subject headings. | ||
- If the option of "Merge MARC records" | - If the option of "Merge MARC records" | ||
- Make sure both the Source File (vendors' | - Make sure both the Source File (vendors' | ||
- Name the Save File. | - Name the Save File. | ||
- | - Choose " | + | - Choose " |
- | - Enter " | + | - Enter "650" and "946" in Field List and check Merge Unique Items, click Process.\\ {{: |
- | - Repeat A.II to find and fill in missing subject headings. | + | |
+ | |||
+ | |||
+ | ===== 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 LCSH and/or FAST subject headings, | ||
+ | - 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 | ||
- | ---- | ||
- | ===== C. Some useful steps ===== | ||
- | ==== I. Task List ==== | ||
- | As A.I is likely to be a repeated task for different vendors' | ||
- | - Go to Marc Editor > Tools > Manage Tasks. | ||
- | - Select "New Task" in Task Actions dropdown menu. | ||
- | - Enter Task Name. | ||
- | - Select the task just created and choose "Edit Task" in Task Actions dropdown menu. | ||
- | - 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.) | ||
- | - Run task by going to Marc Editor, open the file to be worked on. Go to Tools > Current Tasks and select the corresponding task. | ||
- | ==== II. When ISBN isn't in 020$a ==== | + | ===== 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. | + | 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, |
- Open the file in Marc Editor. Go to Tools > Copy Field. | - Open the file in Marc Editor. Go to Tools > Copy Field. | ||
- Put " | - Put " | ||
- | - Continue with B.II. | + | - Continue with D.4. |
- | - After the records are merged, delete | + | - After the records are merged, delete |
+ | - go to Tools > Add/Delete Field | ||
+ | - enter 020 in Field | ||
+ | - click '' | ||