Publishers are often not able to supply us with an ONIX or MARC 21 record set, but they're able to provide us with metadata in an excel spreadsheet. NNELS provides a standard spreadsheet for their use.
Using MarcEdit, you can map the data in this spreadsheet to their corresponding MARC 21 fields, and generate a MARC 21 record set. You can then save the resulting MARC 21 file as a MARC XML file.
Save Asand save the file in
Tab Delimited Textformat (.txt)
Delimited Text Translator
Source Filefield, upload the excel sheet
Output Filefield, select where you would like to save the resulting .mrk file and give it a name. The name should contain the name of the publisher/supplier, and the current month and year, i.e. Heritage-Group-Jan-2018.mrk
Import Data. You'll be taken to a new
Map Datawindow where you can map the fields in the excel sheet to their corresponding MARC 21 fields.
Selectdrop-down field, select each of the excel fields one-by-one and map them to their MARC 21 field. The excel fields and their corresponding MARC 21 fields are given below.
Map To:field, enter the field and subfield separated by a dollar sign ($), i.e. 035$a
Join Items(this will ensure that subfields $b and $c are both included in field 264)
Ignore Header Row
Edit Subfield Data. Enter the following data:
Field Data, enter a single quotation mark
Remove Text. The quotations should now be gone.
Save Asand saving the file with a .xml extension
Now you have a MARC XML record set that can be uploaded to NNELS. Move on to Uploading a MARC XML record set.
Mapping the fields in the NNELS excel sheet to MARC 21:
Save Templatebox. The template will be saved as a .md file which you can then load next time.