Speaking of open access books, there are websites that allow librarians to incorporate their records from literally hundreds of thousands of open access books. OA books can be anything from creative commons-licensed works to classic works where the copyright has expired. As a librarian with limited budget, I try to make access to this works easier for students by pulling the records into my online catalog. Here are some the sites where librarians can integrate open access books:
x1. Start with a MARC file, not a .mrk file.
2. On the main MARCEdit menu, choose TOOLS
3. EXPORT TAB DELIMITED RECORDS
4. Set the file paths
a. first folder=your MARC file
b. second folder=destination file and folder. Select TAB DELIMITED .txt format!
5. Set field delimiter as TAB
6. Click on "next"
7. Define your fields
a. check off "normalize field data"--this gets rid of indicators and other stuff you don't need in your spreadsheet
b. check off MARC since you are working with a MARC file
c. Add the following fields:
- 245$a - TITLE
- 856 - URL
- 100 - AUTHOR
- 260$b - PUBLISHER
- 260$c -YEAR OF PUB
- 020 - ISBN
- 600, 610, 611, 650, 651, 655, 656 -SUBJECT HEADINGS
- 050 - LC CALL NO
- 082 - DEWEY CALL NO.
8. MarcEdit will generate a message that the data has been exported.
Be sure to read the second half of this tutorial that explains how I opened the records in Excel and formatted them for the Google Spreadsheet-based library catalog.