1 / 34

The New Books List

Enhance your library's WebVoyáge system with an unofficial add-on for showcasing new books, easy to install and fully automated. Join over 300 users benefiting from this free, customizable tool!

ralphd
Download Presentation

The New Books List

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The New Books List Michael Doran, Systems Librarian Ex Libris Southwest Users Group February 6, 2008 – Santa Ana College

  2. An unofficial WebVoyáge add-on Michael Doran, Systems Librarian

  3. The “New Books” tab Michael Doran, Systems Librarian

  4. New Books search results Michael Doran, Systems Librarian

  5. Link into WebVoyáge record Michael Doran, Systems Librarian

  6. New Books search results Michael Doran, Systems Librarian

  7. Why implement it? • Provides a useful service • Easy to install • Fully automated • Maintenance-free after initial setup • Integrates into WebVoyáge • Many built-in configuration options • Open source software, so it’s customizable • It’s free… Michael Doran, Systems Librarian

  8. Can’t beat free… Michael Doran, Systems Librarian

  9. Can you implement it? • Why not? • Over 300 current users, many of them small and/or special libraries • Extensive documentation • Detailed installation instructions • Helpful commenting in Perl scripts • Website with “About” pages • (Limited) support from developer Michael Doran, Systems Librarian

  10. Can you implement it? • Why not? • Over 300 current users, many of them small and/or special libraries • Extensive documentation • Detailed installation instructions • Helpful commenting in Perl scripts • Website with “About” pages • (Limited) support from developer Michael Doran, Systems Librarian

  11. Installation in a nutshell • Download “tarball” and put on server • Uncompress/extract files • Copy files to proper locations • Test newbooks.cgi • works “out of the box” • Configure newbooks.pl • To generate your own newbooks.txt • Edit configuration parameters in: • newbooks.ini • newbooks.English • Set up a cron job to run newbooks.pl (or a “Scheduled Task” on Windows) • Add “New Books” tab via opac.ini Michael Doran, Systems Librarian

  12. Download… Michael Doran, Systems Librarian

  13. Download the “tarball” Michael Doran, Systems Librarian

  14. Uncompress/extract files (on server) rocky: /tmp => gzip -d -c newbooks-6.1.tar.gz | tar xvf - x newbooks-6.1, 0 bytes, 0 tape blocks x newbooks-6.1/CHANGES, 18390 bytes, 36 tape blocks x newbooks-6.1/English-alt.gif, 855 bytes, 2 tape blocks x newbooks-6.1/English.gif, 889 bytes, 2 tape blocks x newbooks-6.1/Finnish.gif, 551 bytes, 2 tape blocks x newbooks-6.1/INSTALL, 14795 bytes, 29 tape blocks x newbooks-6.1/dope.sh, 3512 bytes, 7 tape blocks x newbooks-6.1/README.unicode, 2202 bytes, 5 tape blocks x newbooks-6.1/Swedish.gif, 898 bytes, 2 tape blocks x newbooks-6.1/Welsh.gif, 967 bytes, 2 tape blocks x newbooks-6.1/newbooks.English, 10210 bytes, 20 tape blocks x newbooks-6.1/newbooks.Finnish, 10391 bytes, 21 tape blocks x newbooks-6.1/newbooks.Language, 9350 bytes, 19 tape blocks x newbooks-6.1/newbooks.Swedish, 10280 bytes, 21 tape blocks x newbooks-6.1/newbooks.Welsh, 10465 bytes, 21 tape blocks x newbooks-6.1/newbooks.cgi, 45364 bytes, 89 tape blocks x newbooks-6.1/newbooks.ini, 13972 bytes, 28 tape blocks x newbooks-6.1/newbooks.pl, 27142 bytes, 54 tape blocks x newbooks-6.1/newbooks.txt, 126550 bytes, 248 tape blocks rocky: /tmp => Michael Doran, Systems Librarian

  15. Uncompress/extract files (on server) rocky: /tmp => gzip -d -c newbooks-6.1.tar.gz | tar xvf - x newbooks-6.1, 0 bytes, 0 tape blocks x newbooks-6.1/CHANGES, 18390 bytes, 36 tape blocks x newbooks-6.1/English-alt.gif, 855 bytes, 2 tape blocks x newbooks-6.1/English.gif, 889 bytes, 2 tape blocks x newbooks-6.1/Finnish.gif, 551 bytes, 2 tape blocks x newbooks-6.1/INSTALL, 14795 bytes, 29 tape blocks x newbooks-6.1/dope.sh, 3512 bytes, 7 tape blocks x newbooks-6.1/README.unicode, 2202 bytes, 5 tape blocks x newbooks-6.1/Swedish.gif, 898 bytes, 2 tape blocks x newbooks-6.1/Welsh.gif, 967 bytes, 2 tape blocks x newbooks-6.1/newbooks.English, 10210 bytes, 20 tape blocks x newbooks-6.1/newbooks.Finnish, 10391 bytes, 21 tape blocks x newbooks-6.1/newbooks.Language, 9350 bytes, 19 tape blocks x newbooks-6.1/newbooks.Swedish, 10280 bytes, 21 tape blocks x newbooks-6.1/newbooks.Welsh, 10465 bytes, 21 tape blocks x newbooks-6.1/newbooks.cgi, 45364 bytes, 89 tape blocks x newbooks-6.1/newbooks.ini, 13972 bytes, 28 tape blocks x newbooks-6.1/newbooks.pl, 27142 bytes, 54 tape blocks x newbooks-6.1/newbooks.txt, 126550 bytes, 248 tape blocks rocky: /tmp => Michael Doran, Systems Librarian

  16. Perl scripts + a “database” • Main programs (Perl scripts) • newbooks.pl => extraction program • newbooks.cgi => web interface • Configuration files (also Perl scripts) • newbooks.ini • newbooks.English (etc…) • Flat-file “database” • newbooks.txt • Installation instructions and other help files Michael Doran, Systems Librarian

  17. Version 6.1 Michael Doran, Systems Librarian

  18. A quick test of newbooks.cgi Michael Doran, Systems Librarian

  19. Version 6.1 Copy these files to this directory on your WebVoyáge server: /m1/voyager/xxxdb/webvoyage/cgi-bin/ (your db name, natch) Michael Doran, Systems Librarian

  20. Type New Books URL into browser http://your-server.univ.edu/cgi-bin/newbooks.cgi Michael Doran, Systems Librarian

  21. Version 6.1 Copy newbooks.pl to this directory on your Voyager database server: /m1/voyager/xxxdb/sbin/ (your db name, natch) Michael Doran, Systems Librarian

  22. Edit the newbooks.pl script • Required … • Your Oracle read-only username & password • Your “xxxdb” database name • Optional … • Intervals (weeks or months) • Lag time • File transfer • etc… Michael Doran, Systems Librarian

  23. Version 6.1 Michael Doran, Systems Librarian

  24. Configure search interface Michael Doran, Systems Librarian

  25. Configure search interface, cont. For examples, see: http://rocky.uta.edu/doran/autolist/configexamples.html Michael Doran, Systems Librarian

  26. Version 6.1 Michael Doran, Systems Librarian

  27. The “New Books” tab http://your-server.univ.edu/cgi-bin/newbooks.cgi http://your-server.univ.edu/cgi-bin/Pwebrecon.cgi Michael Doran, Systems Librarian

  28. Add extra HTML code to “Tab_Text=Course Reserves” in the Course_Reserve_Search_Page stanza Version 6.1 A tip o’ the hat to Alan Keely Michael Doran, Systems Librarian

  29. Common installation pitfalls • newbooks.pl script • Finding the DBI/DBD modules • Solution: using the right Perl path • Run the “dope.sh” script to troubleshoot • Transfer of newbooks.txt file • Small libraries usually don’t have this problem because they have a single Voyager server • Not (really) a New Books List script issue • newbooks.ini configuration file • Location matching “fragments” • Look at how others have done it (view source) Michael Doran, Systems Librarian

  30. Prerequisites • On Voyager database server • Perl • Perl DBI module • Perl DBD::Oracle module • On WebVoyáge server • Perl This stuff is already on your system! Michael Doran, Systems Librarian

  31. What’s a “new” book? SQL query 1 (in newbooks.pl) retrieves physical items item.create_date between (sysdate - 35) and (sysdate - 7) and (mfhd_master.create_date between (sysdate - 35) and (sysdate - 7) or mfhd_master.update_date between (sysdate - 35) and (sysdate - 7)) Michael Doran, Systems Librarian

  32. What’s a “new” book? SQL query 2 (in newbooks.pl) retrieves electronic-only items mfhd_master.create_date between (sysdate - 35) and (sysdate - 7) and elink_index.record_type in ('M') and elink_index.link is not null For more info see: http://rocky.uta.edu/doran/autolist/secure/sql.htm Michael Doran, Systems Librarian

  33. Installation best practices • Read the documentation • Make copies of files before editing Known issues • Dupe 856’s => dupe new book listings For more information... • Go to the New Books List website: http://rocky.uta.edu/doran/autolist/ Michael Doran, Systems Librarian

  34. Questions? Michael Doran, Systems Librarian

More Related