User Tools


Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
public:nnels:cataloguing:new-create-modify-record-set-in-marcedit [2024/04/03 17:54]
robert.macgregor [Appendix B - Batch Method for Copying 650 fields]
public:nnels:cataloguing:new-create-modify-record-set-in-marcedit [2024/04/03 22:27]
robert.macgregor
Line 1: Line 1:
-Notes:\\ 
-Update Marc Field Text File\\ 
-Update Genre Terms Excel Sheet\\ 
-Upload files and include in this Doc\\ 
- 
-Preamble of files to download\\ 
-List of Important sites\\ 
-Screenshots - WorldCat, Z39.50\\ 
- 
-Formatting\\ 
-**This is a .txt file with some of the following Marc fields that can be copy and pasted into MarcEditor** 
- 
 ======Creating and Modifying Record Sets in MarcEdit====== ======Creating and Modifying Record Sets in MarcEdit======
- 
-  * [[https://marcedit.reeset.net/downloads | Download MarcEdit]] and install. 
-  * Set up the Z39.50 module in MarcEdit using the OCLC credentials provided to you. 
  
 Marc Record Sets will need to be edited in MarcEdit in 3 different instances (listed in order from easiest to hardest): Marc Record Sets will need to be edited in MarcEdit in 3 different instances (listed in order from easiest to hardest):
Line 22: Line 7:
   - **New Records** - Records that are created from scratch (this is a last case scenario if existing records can not be found to copy)   - **New Records** - Records that are created from scratch (this is a last case scenario if existing records can not be found to copy)
  
-Some Record Sets will be a combination of Vendor Records and/or Copy Records and/or New Records.+Some Record Sets will be a combination of Vendor Records and/or Copy Records and/or New Records.  In each case, the Record Sets will end up being relatively similar - getting there will be slightly different.
  
-In each case, the Record Sets will end up being relatively similar - getting there will be slightly different. +After a Record Set has been cleaned up/modified/created, it will need to be converted to .xml and ingested into the NNELS website through Drupal.
- +
-After a Record Set has been cleaned up/modified/created, it will be converted to .xml and ingested into the NNELS website through Drupal.+
  
 =====Downloads===== =====Downloads=====
  
-|Current MarcEdit Version to Install|[[https://marcedit.reeset.net/downloads | Download MarcEdit]]| +|Current MarcEdit version to install|[[https://marcedit.reeset.net/downloads | Download MarcEdit]]| 
-|Text file with some easy to copy Marc Fields|{{ :public:nnels:cataloguing:marc_fields.txt |}}| +|Text file with some easy to copy Marc fields|{{ :public:nnels:cataloguing:marc_fields.txt |}}| 
-|Excel Spreadsheet with current Genre Headings|{{ :public:nnels:cataloguing:nnels_genre_terms_20240401.xlsx |}}|+|Excel spreadsheet with current Genre Headings|{{ :public:nnels:cataloguing:nnels_genre_terms_20240401.xlsx |}}|
  
  
Line 42: Line 25:
  
 =====Getting Started===== =====Getting Started=====
 +
 +  * Set up the Z39.50 module in MarcEdit using the OCLC credentials provided to you
  
 ====Vendor Records==== ====Vendor Records====
  
-In MarcEdit:+If the Record Set is not in .mrk format, it will need to be converted in MarcEdit:
  
   * If the Record Set is in .mrk format, just open in MarcEditor and modify from there   * If the Record Set is in .mrk format, just open in MarcEditor and modify from there
Line 57: Line 42:
 =====Important Marc Fields within a Record===== =====Important Marc Fields within a Record=====
  
-These fields are for the most part mandatory, or at least significant in certain ways.  When copying records from Z39.50, try to find records that match the format (ie:  audiobook item -> audiobook record), although it's not entirely necessary, and generally (although not always) choose the records that are more fulsome (ie:  they have more information).+These fields are for the most part mandatory, or at least significant in certain ways.  When copying records from Z39.50, try to find records that match the format (ie:  audiobook item -> audiobook record), although it's not entirely necessary.  Also, generally (although not always) choose the records that are more fulsome (ie:  they have more information).
  
 When Record Sets are ingested into the NNELS website through Drupal, the .xml file will be parsed and each Marc field will have its contents uploaded in Drupal.  For example, the parser will know that the 520 field is a summary of the book/material and that the 245 field contains the title of the work.  Some fields are not parsed, and so are less important to the process (we don't necessarily remove those fields, as we still want to maintain good Marc records). When Record Sets are ingested into the NNELS website through Drupal, the .xml file will be parsed and each Marc field will have its contents uploaded in Drupal.  For example, the parser will know that the 520 field is a summary of the book/material and that the 245 field contains the title of the work.  Some fields are not parsed, and so are less important to the process (we don't necessarily remove those fields, as we still want to maintain good Marc records).
Line 69: Line 54:
 ====LDR==== ====LDR====
  
-Each record needs an LDR.  These are partially computer generated.  They will be included in Vendor Records and in Copied Records, for New Records the LDR can be copy and pasted from the Marc Field Text File.+Each record needs an LDR.  These are partially computer generated.  They will be included in Vendor Records and in Copied Records, for New Records the LDR can be copy and pasted from the Marc Field text file.
  
 ====001, 003==== ====001, 003====
Line 283: Line 268:
  
   - Make sure the record set is in .mrc or .mrk format (some record sets come in .xml format and need to converted using Marc Tools module   - Make sure the record set is in .mrc or .mrk format (some record sets come in .xml format and need to converted using Marc Tools module
-  - Select Tools from the toolbar in MarcEdit -> Export -> Export Tab Delimited Records {{ :public:nnels:cataloguing:export_tab_delimited_records.png?400|}}+  - Select Tools from the toolbar in MarcEdit -> Export -> Export Tab Delimited Records {{ :public:nnels:cataloguing:export_tab_delimited_records.png?400 |}}
   - Use the default delimiter options, click on the folder icons to select the .mrc/.mrk file to open and the .txt file to save the ISBNs in (this method requires that the Vendor Records have ISBNs included in them), and click Next   - Use the default delimiter options, click on the folder icons to select the .mrc/.mrk file to open and the .txt file to save the ISBNs in (this method requires that the Vendor Records have ISBNs included in them), and click Next
   - Check Normalize field data, select 020 from the Field dropdown menu, and put "a" in Subfield (without the quotation marks), then click Add Field, and then click Export   - Check Normalize field data, select 020 from the Field dropdown menu, and put "a" in Subfield (without the quotation marks), then click Add Field, and then click Export
   - Open the .txt file in Excel   - Open the .txt file in Excel
   - The Import Wizard should open -use the default settings (Fixed width) and click next   - The Import Wizard should open -use the default settings (Fixed width) and click next
-  - Step 2 in the Wizard allows you to move the line breaks by moving the arrows - move them to either side of the ISBN {{:public:nnels:cataloguing:excel_delimited_import.png?400| }}+  - Step 2 in the Wizard allows you to move the line breaks by moving the arrows - move them to either side of the ISBN and click Finish {{ :public:nnels:cataloguing:excel_delimited_import.png?400 |}} 
 +  - 
public/nnels/cataloguing/new-create-modify-record-set-in-marcedit.txt · Last modified: 2024/06/14 22:53 by robert.macgregor