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:56]
robert.macgregor [Appendix B - Batch Method for Copying 650 fields]
public:nnels:cataloguing:new-create-modify-record-set-in-marcedit [2024/04/04 22:18]
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 63: Line 48:
 These aren't full breakdowns of each field - basic knowledge of cataloguing is assumed.  For more information, Google **marc field xxx** (where xxx is the field number, eg. 245), and the first link should be to a Library of Congress breakdown of that field and its technical aspects (description, indicators, subfields, etc.). These aren't full breakdowns of each field - basic knowledge of cataloguing is assumed.  For more information, Google **marc field xxx** (where xxx is the field number, eg. 245), and the first link should be to a Library of Congress breakdown of that field and its technical aspects (description, indicators, subfields, etc.).
  
-Include end of field punctuation, and make sure subfields are formatted properly with spaces and/or punctuation as necessary. +Include end of field punctuation, and make sure subfields are formatted properly with spaces and/or punctuation as necessary.  Catalogue in English, although the 520 (summary) field can be in the language of the item.
- +
-Catalogue in English, although the 520 (summary) field can be in the language of the item.+
  
 ====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 - Control Numbers====
  
-These fields are for Control Numbers.  They will generally be in Vendor and Copied Records, but are not necessary so can be omitted in New Sets.+These will generally be in Vendor and Copied Records, but are not necessary so can be omitted in New Records.
  
-====005====+====005 - Time Stamp====
  
 This is a computer generated time stamp that records the last time the record was modified. This is a computer generated time stamp that records the last time the record was modified.
  
-====006====+====006 - Bibliographic Data (Parsed)====
  
-**This field is parsed by Drupal** - It contains various pieces of information about the nature of the record (intended audience, form, format).  You may need to modify certain components based on the content.+This field contains various pieces of information about the nature of the record (intended audience, form, format).  You may need to modify certain components based on the content.
  
 Example:  **=006  m\\\\eo\\d\\\\\\0\** Example:  **=006  m\\\\eo\\d\\\\\\0\**
Line 90: Line 73:
   * **0** indicates nonfiction - other options are:  1 = fiction, d = dramas (plays), j = short stories, p = poetry   * **0** indicates nonfiction - other options are:  1 = fiction, d = dramas (plays), j = short stories, p = poetry
    
-====008====+====008 - General Information====
  
 This field contains the information in the 006 field and more.  Drupal will take all the info from the 006 field, although this field contains 3 characters indicating the language.  Vendor and Copied Records will have this field, but it is not necessary to create it for New Records. This field contains the information in the 006 field and more.  Drupal will take all the info from the 006 field, although this field contains 3 characters indicating the language.  Vendor and Copied Records will have this field, but it is not necessary to create it for New Records.
  
-====020====+====020 - Identifier====
  
-Identifier.  This is usually the ISBN.  13 digit ISBNs start with 978, which makes them easy to spot.  10 digit ISBNs are rare.  This is a good place to grab the ISBN to search with in Z39.50.+This is usually the ISBN.  13 digit ISBNs start with 978, which makes them easy to spot.  10 digit ISBNs are rare now.  This is a good place to grab the ISBN to search with in Z39.50.
  
-====028====+====028 - NNELS Identifier====
  
-Identifier for Drupal.  This field contains an identifier that will be used for NNELS when doing batch uploads.  This field should only be used when directed to do so.  It will usually be one of the ISBNs.+This field contains an identifier that will be used for NNELS when doing batch uploads.  This field should only be used when directed to do so.  It will usually be one of the ISBNs.
  
-====100====+====100 - Author (Parsed)====
  
-**This field is parsed by Drupal** - Author's name (Last, First).+Author's name in the form Last, First.
  
-====245====+====245 - Title (Parsed)====
  
-**This field is parsed by Drupal** - Title.  We take an AARC2R approach - Capitalize the first word and the rest are lower case, except for proper nouns (articles like The and A stay at the front of the title).  Followed by the subfield /$c author's name (First Last).+We take an AARC2R approach - Capitalize the first word and leave the rest in lower case, except for proper nouns (articles like The and A stay at the front of the title).  Followed by the subfield /$c author's name (First Last).
  
-Example:  **=245  10$aArtificial intelligence versus God :$bthe final battle for humanity /$cPerry Stone.**+Example:  **=245  14$aThe devil in the white city :$bmurder, magic, and madness at the fair that changed America /$cErik Larson.**
  
 ====260, 264==== ====260, 264====
Line 288: Line 271:
   - 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