The New Books List

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