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:new-create-modify-record-set-in-marcedit [2024/04/03 17:21] robert.macgregor [Appendix B - Batch Method for Copying 650 fields] |
public:nnels:cataloguing:new-create-modify-record-set-in-marcedit [2024/04/03 23:07] 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:// | ||
- | * 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/ |
- | + | ||
- | After a Record Set has been cleaned up/ | + | |
=====Downloads===== | =====Downloads===== | ||
- | |Current MarcEdit | + | |Current MarcEdit |
- | |Text file with some easy to copy Marc Fields|{{ : | + | |Text file with some easy to copy Marc fields|{{ : |
- | |Excel | + | |Excel |
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, | + | 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. | 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. | ||
Line 63: | Line 48: | ||
These aren't full breakdowns of each field - basic knowledge of cataloguing is assumed. | These aren't full breakdowns of each field - basic knowledge of cataloguing is assumed. | ||
- | Include end of field punctuation, | + | Include end of field punctuation, |
- | + | ||
- | 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. | + | Each record needs an LDR. These are partially computer generated. |
- | ====001, 003==== | + | ====001, 003 - Control Numbers==== |
- | These fields are for Control Numbers. | + | These will generally be in Vendor and Copied Records, but are not necessary so can be omitted in New Records. |
- | ====005==== | + | ====005 |
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 |
- | **This field is parsed by Drupal** - It contains various pieces of information about the nature of the record (intended audience, form, format). | + | This field contains various pieces of information about the nature of the record (intended audience, form, format). |
Example: | Example: | ||
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 |
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. | 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. | ||
- | ====020==== | + | ====020 |
- | Identifier. | + | 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 |
- | Identifier for Drupal. | + | This field contains an identifier that will be used for NNELS when doing batch uploads. |
- | ====100==== | + | ====100 |
- | **This field is parsed by Drupal** - Author' | + | Author' |
- | ====245==== | + | ====245 |
- | **This field is parsed by Drupal** - Title. | + | 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). |
Example: | Example: | ||
Line 261: | Line 244: | ||
If there is a need to create a New Record from scratch, there is a template in the Marc Fields Text File that can be copied into MarcEditor and modified. | If there is a need to create a New Record from scratch, there is a template in the Marc Fields Text File that can be copied into MarcEditor and modified. | ||
+ | |||
+ | =====Final Step - Converting .mrk Files to .xml for Upload to Drupal===== | ||
+ | |||
+ | |||
=====Appendix A - Batch Method for Copying Records===== | =====Appendix A - Batch Method for Copying Records===== | ||
Line 276: | Line 263: | ||
=====Appendix B - Batch Method for Copying 650 fields===== | =====Appendix B - Batch Method for Copying 650 fields===== | ||
- | This method is useful for large sets of Vendor Records. | + | This method is useful for large sets of Vendor Records. |
- | - Make sure the record set is in .mrc or .mrk format | + | - Make sure the record set is in .mrc or .mrk format |
+ | - Select Tools from the toolbar in MarcEdit -> Export -> Export Tab Delimited Records {{ : | ||
+ | - 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 " | ||
+ | - Open the .txt file in Excel | ||
+ | - 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 and click Finish {{ : | ||
+ | - |