This is an old revision of the document!
Export MARC Records from Drupal
* Please note that the MARC exporter tool is still under development
Login to nnels.ca.
In the
NNELS Admin
drop-down menu, select
MARX XML File Builder - Searchable (Field Collection)
or
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 across multiple pages. Select the right button. (Note that large amount of records will take a very long time to process, alternatively, you may export multiple records and combine them later.)
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".
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
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:
-
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.