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:29] robert.macgregor [Appendix B - Batch Method for Copying 650 fields] |
public:nnels:cataloguing:new-create-modify-record-set-in-marcedit [2024/04/04 22:57] robert.macgregor |
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): |
- **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 |}}| |
| |
| |
| |
=====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 |
=====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). |
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\** |
* **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 - Publishing Information (Parsed)==== |
| |
**This field is parsed by Drupal** - Publisher information. Use either 260 or 264 (not both). Newer material will tend to use the 264 field (which is RDA format). When the publisher's location is not known, use [S.l.]. When the publisher is unknown, use [publisher not identified]. For an unknown year, use either [year?] (ie: [2024?]) or [date of publication not identified]. | Use either 260 or 264 (not both). Newer material will tend to use the 264 field (which is RDA format). When the publisher's location is not known, use [S.l.]. When the publisher is unknown, use [publisher not identified]. For an unknown year, use either [year?] (ie: [2024?]) or [date of publication not identified]. |
| |
====3XX==== | ====3XX - Characteristics (306 Parsed)==== |
| |
These fields indicate the content type. Make sure the content types match - for example, you may use a Copied Record for a print book to create a record for an audiobook, in which case you will need to change the 3XX fields from print to audio (copy and paste-able 3XX fields are in the Marc Field Text File). | These fields indicate the content type. Make sure the content types match - for example, you may use a Copied Record for a print book to create a record for an audiobook, in which case you will need to change the 3XX fields from print to audio (copy and paste-able 3XX fields are in the Marc Field Text File). |
The 306 field is for the length of an audiobook. It needs to be in the form: hhmmss.\\ | The 306 field is for the length of an audiobook. It needs to be in the form: hhmmss.\\ |
Example: =306 \\$a132642\\ | Example: =306 \\$a132642\\ |
This indicated 13 hours, 26 minutes, 42 seconds. | This indicates 13 hours, 26 minutes, 42 seconds. |
| |
====511==== | ====511 - Narrator (Parsed)==== |
| |
**This field is parsed by Drupal** - Narrator. This is only used for audiobooks. Drupal takes the field as is, so input here in the form First Name Last Name, eg: John Doe. If you can't figure out who the narrator is, leave it blank and it can be fixed later in Drupal. Some Vendor and Copied Records will say "Narrated by " or "Read by: ", just delete these introductory statements. If the author is the narrator, then write "Read by the author." | This is only used for audiobooks. Drupal takes the field as is, so input here in the form First Name Last Name, eg: John Doe. If you can't figure out who the narrator is, leave it blank and it can be fixed later in Drupal. Some Vendor and Copied Records will say "Narrated by " or "Read by: ", just delete these introductory statements. |
| |
====520==== | **If the author is the narrator, then write "Read by the author."** |
| |
**This field is parsed by Drupal** - Summary. A summary of the book. This can come from Vendor Records or Copied Records. If it is not present or needs to be recopied, Amazon, Goodreads, or other similar sites are good places to find this information. Some records will be in a form like this: | ====520 - Summary (Parsed)==== |
| |
| This can come from Vendor Records or Copied Records. If it is not present or needs to be recopied, Amazon, Goodreads, or other similar sites are good places to find this information. Some records will be in a form like this: |
| |
"Start of summary...End of summary" %%--%% Provided by Publisher.\\ | "Start of summary...End of summary" %%--%% Provided by Publisher.\\ |
Drupal parses this as is, so remove the quotation marks and the source attribution at the end. | Drupal parses this as is, so remove the quotation marks and the source attribution at the end. |
| |
====650 - Read Carefully==== | ====650 - Subject Headings (Parsed) - Read Carefully==== |
| |
**This field is parsed by Drupal** - Subject Heading. This is an important field that can be difficult at times. There will usually be multiple 650 field entries. We want at least one. **Appendix B** is a batch method for copying large amounts of 650 fields at once through Z39.50. | This is an important field that can be difficult at times. There will usually be multiple 650 field entries. We want at least one. **Appendix B** is a batch method for copying large amounts of 650 fields at once through Z39.50. |
| |
Important note: Drupal only parses the 650 field, which is for topical subject terms. You will come across other 6XX fields like 600 and 651 fields (people and places). If you want these fields parsed in Drupal, you will need to change the field to 650 (it is generally safe to ignore the 648 field). | Important note: Drupal only parses the 650 field, which is for topical subject terms. You will come across other 6XX fields like 600 and 651 fields (people and places). If you want these fields parsed in Drupal, you will need to change the field to 650 (it is generally safe to ignore the 648 field). |
LoC subject terms will be in the form: =650 \0$aSubject term.\\ | LoC subject terms will be in the form: =650 \0$aSubject term.\\ |
FAST subject terms will be in the form: =650 \7$aSubject term.$2fast\\ | FAST subject terms will be in the form: =650 \7$aSubject term.$2fast\\ |
The 0 indicator means specifically Library of Congress, and the 7 means the term is from a taxonomy identified after the $2. | The 0 indicator specifically identifies Library of Congress, and the 7 means the term is from a taxonomy identified after the $2. |
| |
FAST terms can also be written in the form: =650 \4$aSubject term.\\ | FAST terms can also be written in the form: =650 \4$aSubject term.\\ |
=650 \7$aWomen%%--%%Social conditions.$2fast | =650 \7$aWomen%%--%%Social conditions.$2fast |
| |
When Drupal parses subject terms, it splits terms based on the subfield indicators, so if there is an $x in the subject term, the Drupal record will actually show 2 separate terms (Women, Social conditions). | When Drupal parses subject terms, it splits terms based on the subfield indicators, so if there is an $x in the subject term, the Drupal record will actually show 2 separate terms (Women, Social conditions instead of Women%%--%%Social conditions). |
| |
You can check [[https://fast.oclc.org/searchfast/ | searchFAST]] to verify how certain terms are handled. Over time you will learn to spot which terms are likely to use the 2 dash (%%--%%) format, but searchFAST is always a good resource for this. | You can check [[https://fast.oclc.org/searchfast/ | searchFAST]] to verify how certain terms are handled. Over time you will learn to spot which terms are likely to use the 2 dash (%%--%%) format, but searchFAST is always a good resource for this. |
OCLC Classify was the best place to get these terms, however it has shut down. These are generally the easiest alternatives, however if I can find something that works better I will incorporate it. | OCLC Classify was the best place to get these terms, however it has shut down. These are generally the easiest alternatives, however if I can find something that works better I will incorporate it. |
| |
1. Z39.50. The best way to search for records in Z39.50 is using the ISBN. This will generally return multiple records for the same item. Check each record until you find one with FAST subject headings. If the records for a particular ISBN don't have FAST subject headings, try different ISBNs (ie: Paperback vs. Hard cover vs. Large print vs. Audiobook vs. etc.). Failing that, search via title and author. Searching via title often yields pages of irrelevant records. If you must use a title search, use the AND operator and second search box to search for author Name. | 1. Z39.50. The best way to search for records in Z39.50 is by using the ISBN. This will generally return multiple records for the same item. Check each record until you find one with FAST subject headings. If the records for a particular ISBN don't have FAST subject headings, try different ISBNs (ie: Paperback vs. Hard cover vs. Large print vs. Audiobook vs. etc.). Failing that, search via title and author. Searching via title often yields pages of irrelevant records. If you must use a title search, use the AND operator and second search box to search for author Name. |
| |
Note that sometimes these Copied Records will not come with the 650 end of field punctuation (which is a . after the subject term/before the $2). Add that in. | Note that sometimes these Copied Records will not come with the 650 end of field punctuation (which is a . after the subject term/before the $2). Add that in. |
The terms that WorldCat provides do not have subfields or double dashes (%%--%%), however when there is a capitalized word (ie: "Fiction" in the LoC examples) that usually indicates a break in the subject heading. | The terms that WorldCat provides do not have subfields or double dashes (%%--%%), however when there is a capitalized word (ie: "Fiction" in the LoC examples) that usually indicates a break in the subject heading. |
| |
Note: Wives Crimes against. This is a FAST term and because of the capitalization of Crimes, the form should be "Wives%%--%%Crimes against. That will need to be changed when copied into a 650 field. Moving forward, "&&--&&Crimes against" is now recognizable as a secondary FAST term that can be spotted in the future. | Note: Wives Crimes against. This is a FAST term and by noticing the capitalization of Crimes, we can tell that the form should be "Wives%%--%%Crimes against. That will need to be changed when copied into a 650 field. Moving forward, "&&--&&Crimes against" is now recognizable as a secondary FAST term that can be spotted in the future. |
| |
You may also see terms that identify the genre of the item. This is what the 655 field is for, and so can be omitted in the 650 field. In the past, before LoC created a genre taxonomy, genre terms were put in the 650 field, but that is an outdated method. BISAC terms are also genre identifying so can be left out. However, these terms are a good guide as to what the genre is, and so can be helpful in creating the 655 fields. | You may also see terms that identify the genre of the item. This is what the 655 field is for, and so can be omitted in the 650 field. In the past, before LoC created a genre taxonomy, genre terms were put in the 650 field, but that is an outdated method. BISAC terms are also genre identifying so can be left out. However, these terms are a good guide as to what the genre is, and so can be helpful in creating the 655 fields. |
=650 \0$aDetective and mystery fiction.\\ | =650 \0$aDetective and mystery fiction.\\ |
| |
As well as these (they are deprecated LoC terms - old Genre terms for fiction ended in "stories", but new ones end in "fiction"): | There are also deprecated LoC terms to keep an eye out for - some of the old Genre terms for fiction ended in "stories" but the new ones end in "fiction" (these can be removed as well): |
| |
=650 \0$aDetective and mystery stories.\\ | =650 \0$aDetective and mystery stories.\\ |
=650 \0$aLove stories.\\ | =650 \0$aLove stories.\\ |
| |
====655==== | ====655 - Genre Headings (Parsed)==== |
| |
**This field is parsed by Drupal** - Genre Heading. This is a mandatory field. A minimum of one is required, although most often there will be multiple. This is a list of Genre Terms used by NNELS. | This is a mandatory field. A minimum of one is required, although most often there will be multiple. See the Excel sheet linked above for a list of Genre Terms used by NNELS. |
| |
Over time, this list will become second nature. But in the meantime it is worth using it for reference. The list is broken into Fiction, Non-fiction, and Others (terms identify things like Form, Audience, or special interest). Don't use fiction terms for non-fiction items and vice-versa. The Other terms can be applied to both (Poetry and Drama notwithstanding). | Over time, this list will become second nature. But in the meantime it is worth using it for reference. The list is broken into Fiction, Non-fiction, and Others (terms identify things like Form, Audience, or special interest). Do not use fiction terms for non-fiction items and vice-versa. The Other terms can be applied to both (Poetry and Drama notwithstanding). |
| |
**Juvenile fiction** - for Juvenile fiction only use the Genre term Juvenile Fiction - do not include other fictional terms (still use general terms like Canadian fiction or Picture books, etc., but do not include things like Fantasy fiction or Detective and mystery fiction) - this is because we do not have a way to filter for audience on the website, so we do not want patrons to sort for mystery novels and get children's books. For nonfiction, do a regular genre treatment. | **Juvenile fiction** - for Juvenile fiction only use the Genre term Juvenile Fiction - do not include other fictional terms (still include general terms like Canadian fiction or Picture books, etc., but do not include things like Fantasy fiction or Detective and mystery fiction) - this is because we do not have a way to filter for audience on the website, so we do not want patrons to sort for mystery novels and get a bunch of children's books. For nonfiction, do a regular genre treatment. |
| |
**Young adult fiction** - treat the same as adult fiction (full genre treatment). | **Young adult fiction** - treat the same as adult fiction (full genre treatment). |
| |
Canadian terms are used for items by a Canadian other or are about Canada; Indigenous materials follows the same principle.\\ | Canadian terms are used for items by a Canadian auther or are about Canada; Indigenous materials follows the same principle.\\ |
Picture books are used only for children's literature, usually for the standard 32 page juvenile fictional picture books, but sometimes juvenile non-fiction as well - the picture book is more of a format than just anything with pictures.\\ | Picture books are used only for children's literature, usually for the standard 32 page juvenile fictional picture books, but sometimes juvenile non-fiction as well - the picture book is more of a format than just anything with pictures.\\ |
Illustrated material can be for adult or juvenile non-fiction - it can be a photography book, or an art book with paintings or drawings, or a technical book with diagrams.\\ | Illustrated material can be for adult or juvenile non-fiction - it can be a photography book, or an art book with paintings or drawings, or a technical book with diagrams.\\ |
Genre Headings can be tricky. Sometimes they are a best guess. Read the 520 Summary field and use the 650 Subject Headings to make a determination. Amazon and Goodreads, as well as the publisher's website are good sources to determine the Genre(s) and intended audience (be aware that when looking to Subject Headings for guidance, LoC does not distinguish between Juvenile and Young Adult - so LoC 650 Subject Headings can say Juvenile fiction even though it should be Young adult fiction). If you can not figure out the genre for fiction, use "General fiction". | Genre Headings can be tricky. Sometimes they are a best guess. Read the 520 Summary field and use the 650 Subject Headings to make a determination. Amazon and Goodreads, as well as the publisher's website are good sources to determine the Genre(s) and intended audience (be aware that when looking to Subject Headings for guidance, LoC does not distinguish between Juvenile and Young Adult - so LoC 650 Subject Headings can say Juvenile fiction even though it should be Young adult fiction). If you can not figure out the genre for fiction, use "General fiction". |
| |
Use only Genre Headings that are in the Excel sheet. Anything that is not in that sheet (or is misspelled) will not appear in Drupal after it is uploaded. It is a good idea to keep a record open in Drupal - when you type start typing in the Genre, it will provide a dropdown selection menu. I will copy and paste from there sometimes when I forget certain terms. | Use only Genre Headings that are in the Excel sheet. Anything that is not in that sheet (or is misspelled) will not appear in Drupal after it is uploaded. It is a good idea to keep a edit a record in Drupal, click on Genre, and keep it open - when you type start typing in the Genre, it will provide a dropdown selection menu. I will copy and paste from there sometimes when I forget certain terms. |
| |
{{:public:nnels:cataloguing:genre_headings_autofill.png?400|}} | {{:public:nnels:cataloguing:genre_headings_autofill.png?400|}} |
| |
====700==== | ====700 - Added Entry (Parsed)==== |
| |
**This field is parsed by Drupal** - Added entry. This is similar to the 100 field. There can only be one 100 field, so for example if there are multiple authors, the rest will go here; or if there is an illustrated for a graphic work. This field is less important than the 100 field. | This is similar to the 100 field. There can only be one 100 field, so for example if there are multiple authors, the rest will go here; or if there is an illustrator for a graphic work. This field is less important than the 100 field. |
| |
====The Rest==== | ====The Rest==== |
=====Creating New Records===== | =====Creating New Records===== |
| |
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. It includes just the necessities. The 3XX fields may need to be changed, and the 511 field may need to be deleted if not an audiobook. The 028 and 700 fields can be deleted if unneeded. The 006 field will need to be modified depending on the material. I have included the proper spacing, subfield punctuation and end of field punctuation. | 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. It includes just the necessities. The 3XX fields may need to be changed, and the 511 field may need to be deleted if the item is not an audiobook. The 028 and 700 fields can be deleted if unneeded. The 006 field will need to be modified depending on the material. I have included the proper spacing, subfield punctuation and end of field punctuation. |
| |
=====Final Step - Converting .mrk Files to .xml for Upload to Drupal===== | =====Final Step - Converting .mrk Files to .xml for Upload to Drupal===== |
| |
| * From the main screen of MarcEdit click on Marc Tools |
| * Select the MarcMaker Operation |
| * Open the .mrk file |
| * Save as a .mrc file (you can use the same filename, but with the different file extension) |
| * Default Character Encoding should be MARC8 |
| * Check Translate to UTF8 |
| * Click Execute - this will generate a .mrc file |
| * Select the MARC21=>MARC21XML Operation |
| * Open the .mrc file |
| * Save as a .xml file (you can use the same filename, but with the different file extension) |
| * Default Character Encoding should be changed to UTF8 |
| * Uncheck Translate to UTF8 |
| * Click Execute - this will generate the .xml file. |
| |
=====Appendix A - Batch Method for Copying Records===== | =====Appendix A - Batch Method for Copying Records===== |
=====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. Often vendor sets will come with BISAC and/or Overdrive Subject Headings. It can be cumbersome and time consuming to replace those with FAST headings. Like in Appendix A, this method is only worth doing for larger record sets. | This method is useful for large sets of Vendor Records. Often vendor sets will come with BISAC and/or Overdrive Subject Headings. It can be cumbersome and time consuming to replace those with FAST headings. Like in Appendix A, this method is only worth doing for larger record sets. This method will involve extracting the ISBNs from a record set, searching for Subject Headings in Z39.50, deleting all non-FAST headings, and merging the FAST headings with the original record set. |
| |
| ====Create a List of ISBNs==== |
| |
- 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 {{: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 |
| - 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 |
| - 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 {{ :public:nnels:cataloguing:excel_delimited_import.png?400 |}} |
| - Delete any rows and columns that don't have ISBNs - You should only have one column with 1 ISBN per cell |
| - The ISBNs will appear in scientific notation - this needs to be changed by selecting the column of ISBNs |
| - Right click on the cells and select Format Cells |
| - Click on Custom, select 0, and click OK {{ :public:nnels:cataloguing:isbn_excel_cell_format.png?400 |}} |
| - Copy the ISBNs into a text file - one ISBN per line |
| |
| ====Batch Search for Records==== |
| |
| - |