This came trhough on the Koha Mailing List and it looked so useful, I wanted to share it here.  It describes how to load MARC records into the Koha catalog for OverDrive e-books and audiobooks, etc so they are discoverable and show up in the catalog as non-holdable E-Resources avaiable for download.

Note, Brendan Gallagher of ByWater Solutions suggests that you use the "Stage MARC Rcords" option found under Tools (in Koha) so that you can batch remove these records (UNDO import into catalog) when it comes time to remove the OverDrive items from your catalog.

These step-by-step instructions come from Heather Braun of NEKLS (Thanks!):

Overview:  Develop a standard item record line for all of these and use MarcEdit to add this item record line to all the Overdrive records, THEN import them into Koha. 

The item record line I'd developed looked like this: 

=952  \\$bNEKLS$oeBook$d2010-12-30$zeBook from Project Gutenberg$8ERESOURCE$75$cADULT$yBOOK$aNEKLS

What we set up special for this was the ccode ($8) of Electronic resources (EResource) and the Not for Loan status ($7) of Download (which was set to be non-holdable). 

Also we gave them all the call number ($o) of eBook (or whatever the item was -- eAudiobook, etc.) and a public note ($z) explaining what the item was and where it was coming from. All of the records also had an 856$u that added a hyperlink to the location of the downloadable record. I'm assuming your records have this field and information.  

Using MarcEdit (http://people.oregonstate.edu/~reeset/marcedit/html/index.php): 

1. Load the MARC record file into the MarcEditor interface in MarcEdit. (You have to break the MARC file into readable format. See http://people.oregonstate.edu/~reeset/marcedit/tutorials/break_tut.ppt for instructions). 
2. Have your item record code line ready to be added and on the clipboard.   Like the following:    \\$bNEKLS$oeBook$d2010-12-30$zeBook from Project Gutenberg$8ERESOURCE$75$cADULT$yBOOK$aNEKLS
3. In MarcEditor, go to the Tools menu, Add/Delete Field.
4. In the Field dropdown menu, type 952 (Koha's item record field). 
5. For the field data, paste your field data. Example: \\$bNEKLS$oeBook$d2010-12-30$zeBook from Project Gutenberg$8ERESOURCE$75$cADULT$yBOOK$aNEKLS
6. Click Add field, and this 952 line will be added to all of your records in the file. 
7. You'll need to compile the file back into MARC format (File menu, Compile into Marc) and save it in MARC format, then load into Koha. 
8. That should do it! 

Commenting on this Blog entry is closed.