BC Libraries Coop wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Export MARC Records from Drupal ======

<note>Please note that this tool is designed for internal NNELS usage. If NNELS members choose to use this tool, no support will be provided.</note>

NNELS will export its MARC records from Drupal for ingestion into third-party services like OCLC WorldCat and ABC (Accessible Books Consortium). 

  - Login to nnels.ca.
  - In the ''NNELS Admin'' drop-down menu, select ''MARX XML File Builder - Searchable (Field Collection)'' or [[https://nnels.ca/admin/content/exporter/recordset_checkout_base|click this link]].
  - Use the search filters to locate the records that you want to export and click ''Apply''.
  - Check the records that you want to export. 
  - Click ''Generate MARC XML Export File''. You will be given the option to select records on that page only or across multiple pages. (Note that large amount of records, such as more than a few thousands, will take a very long time to process and you may encounter error; in that case, consider exporting records in batches and combine them later.)\\ {{:public:nnels:cataloguing:exportmarc.png?650|}}
  - Enter a title for your record set in the ''Title of new record-set'' field. This is for your reference only.
  - Enter a description for your record set or leave it as the default "my description".
  - Change Export Mode to "All Records".
  - Click ''Next''
  - You will be taken back to the main page. You should see a message at the top of the page similar to: ''File saved: please download via /export-sets/OCLC-batch-1''
  - Click on the above link and you'll be taken to the page where your record set lives.
  - On this page, you should see something similar to: ''MARCXML Export Collection: File marcxml_export_198580.xml''
  - Click on the link to view the MARC XML file in your browser or right-click on the link and select ''Download Linked File As'' to save the MARC XML file to your computer.
  - You can open the XML file using the software of your choice on your computer, i.e. a text editor, a browser, MarcEdit, etc.
  - To locate your exported record set in the future, you can find it on the [[https://nnels.ca/admin/content/cals/marc-export-sets|Marc Export Sets]] page.


====== Convert from MARC XML to MRC using MarcEdit ======

* Instructions may vary slightly depending on your version of MarcEdit.

  - Open MarcEdit
  - Select ''MARC Tools''
  - For ''Input File'' select the exported MARC XML file, i.e. marcxml_export_1.xml
  - For ''Save File'' select where you want to save the output MRC file on your computer. Name it using the .mrc extension, i.e. marcxml_export_1.mrc
  - From the ''Function List'', select: MARCXML=>MARC
  - Leave the other fields as is.
  - Click ''Execute''.
  - MarcEdit will process the XML file and you should find the .MRC file wherever you chose to save it on your computer (in step 4).

===== Convert multiple MARC XML files to MRC =====

  * Open MarcEdit.
  * Click on ''Tools'' in the menu bar.
  * Select ''Batch Process Records''. A new window will open called MARC Utilities.
  * In the ''Source Directory'' field, select the folder where the MARC XML files live. Make sure these are the only XML files in the folder.
  * In the ''File Types'' field, input: ''xml''
  * In the ''Functions'' drop-down menu, select: ''MARCXML=>MARC''
  * Click ''Process''.
  * You will find the output MRC files in a folder called ''processed_files'' within the source directory you specified in step 2.

====== Combine Files using MarcEdit ======

You can use MarcEdit's ''MARCJoin'' feature to combine multiple MRC files into a single file:

  - Open MarcEdit.
  - Select ''MARCJoin''.
  - In the ''Save File'' field, select where you want to save the output file on your computer and give it a name, i.e. marcxml-export-combined.mrc
  - In the ''File(s) to Join'' field, select all the MRC files that you want to combine into one file.
  - Leave the ''Join Individual Files'' box checked.
  - Click ''Process''.
  - MarcEdit will process your files and save the combined file in the location you specified in step 3.

======Troubleshooting records with invalid XML======

Some records may fail to export from Drupal with the error message "Invalid XML". To fix this:
  - Go to the record’s “node” (or main page) in Drupal, e.g., https://nnels.ca/items/thuvia-maid-mars
  - Click ''Edit''.
  - Go to the ''System NoEdit'' tab.
  - Look at the MARCXML there (MARC XML String field) - make sure it is valid (you can use MarcEdit to validate); check that the <marc:record> opening and closing tags exist, and that all other tags have opening and closing tags. 
  - Make any changes as needed.
  - Click ''Save''.
  - Re-export the record.

----
**Note: Export for ABC**

For any BRF files in the exported MARC file, we must manually add data that states if the file is uncontracted or contracted braille.

Insert Contracted or Uncontracted, such that it will look like this:
 
''<datafield tag="300" ind1=" " ind2=" ">
  <subfield code="a">1 BRF Contracted  - Electronic Braille file (39.35 KB)</subfield>
</datafield>''
 
Or
 
''<datafield tag="300" ind1=" " ind2=" ">
  <subfield code="a">1 BRF Uncontracted  - Electronic Braille file (39.35 KB)</subfield>
</datafield>''

Data must be formatted exactly as above in order for successful ingest into ABC.
User Tools

Page Tools

BC Libraries Coop wiki

Site Tools
