Download
custom reports and files created by blob searches on marc records n.
Skip this Video
Loading SlideShow in 5 Seconds..
Custom Reports and Files Created by Blob Searches on MARC Records PowerPoint Presentation
Download Presentation
Custom Reports and Files Created by Blob Searches on MARC Records

Custom Reports and Files Created by Blob Searches on MARC Records

153 Views Download Presentation
Download Presentation

Custom Reports and Files Created by Blob Searches on MARC Records

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Custom Reports and Files Created by Blob Searches on MARC Records … and other VRS added features GUGM May 17, 2007 Presenter: G. Randall Cravey, Coordinator GIL Service Site @ Georgia State University rcravey@gsu.edu

  2. Voyager Reporting System: Design Overview Workstation Application

  3. Acquisitions Reports 7 report options that include • Titles on Order • Titles by Line Item Status • Donor List • Requestor List • Requestor Notice • Item Expenditures • Titles by User Fund

  4. Circulation Reports • 26 report options covering • statistics; • charges, fines and status; and • patron information

  5. Cataloging Reports • 29 report options that provide information on • collection size, • distribution, and • content.

  6. Cataloging Reports (continued) Reports of specific interest in this session

  7. Cataloging Reports (continued) Why distinguish between Keyword Selections and Blob Search? Keyword Selectionsis based on the content of the Bib_Index table. (supports left-anchor searching) Blob Search is based on the content of the Bib_Data and the MFHD_Data tables. (contain full MARC records) ** The Voyager Keyword Index is maintained outside the boundaries of the Oracle DB and is not accessible through the ODBC connection.

  8. Voyager Database contains over 400 Oracle Tables

  9. Example Bib_Index Entries

  10. Example Bib_Data Entries Example MFHD_Data Entries

  11. Features of the Two Search Options • Keyword Selections • Predefined Voyager Access Points • VRS Advanced Filters • Maximum Number of Output Choices • Blob Search • Search Bib or Holdings Records • Access to All Tagged Data • Field Independence

  12. Closer Look at Keyword Selections

  13. KeywordSelections (subject specialty count) Search for: Korea* /or/ japan* china /or/ chinese Field: 245

  14. KeywordSelections (subject specialty count) Qualify using Advanced Selections

  15. KeywordSelections (subject specialty count) Assign a type of Filter

  16. KeywordSelections (subject specialty count) Select the specific Filters

  17. KeywordSelections (subject specialty count) Assign additional Filter types or submit the search

  18. KeywordSelections (subject specialty count) • Choose to display counts by: • Location • Language • Medium • Form of Material • Type of Record

  19. KeywordSelections (subject specialty count) Transcribe counts, redistribute by different group or print the report

  20. KeywordSelections (subject specialty count) Printed report

  21. KeywordSelections (simple search) Field: 245 Search for: folk* /and/ songs

  22. KeywordSelections (Advanced filtering)

  23. KeywordSelections (Select type of filter)

  24. KeywordSelections (Make filtering selections)

  25. KeywordSelections (Process request)

  26. KeywordSelections (results list)

  27. KeywordSelections (output options)

  28. KeywordSelections (View/Print – 1 Line Format - MS Access)

  29. KeywordSelections (Excel output option)

  30. KeywordSelections (Excel spreadsheet – based on content of MS Access tables)

  31. KeywordSelection -- MS Access - Brief Entries

  32. KeywordSelections (Full MARC output)

  33. Keyword - Full MARC

  34. KeywordSelections (MARC output specifications) Additional search qualification is optional.

  35. GIL Library-File Utility The utility is called by the VRS Build command; it starts and stops automatically Used to format Full MARC output

  36. KeywordSelections (Full MARC Print Output) Text-file display using Notepad

  37. KeywordSelections (MARC output specifications) Screen Display with Interleaved Blobs

  38. KeywordSelections (Full MARC Screen Output)

  39. KeywordSelections (Interleaved Print File) Bib MFHD

  40. KeywordSelections (MARC output specifications) • In a Blob Search Field Tag textbox, the search results can be refined further by using embedded subfield symbols: • minus (-) : specifies subfield is missing or not found ex.: 245-b = 245-Field, $b missing • plus (+) : specifies subfield is included or found ex.: 245+h = 245-Field, $h included

  41. KeywordSelections (Excel Interleaved Output) Specify Excel output fields Filter on “sound recording”, 245-Field

  42. KeywordSelections (Interleaved Excel Spreadsheet : sound recording)

  43. Blob Search - Full MARC

  44. Blob Search - menu button

  45. Blob Search - Direct • Search entire record for: • song* /OR/ poetry AND • birds /OR/ prose Tag “000a” will default to searching entire Blob

  46. poetry, prose song*, bird

  47. Blob Search - Direct Output Bib Fields 001, 245, and 856 Search 856-Field for “http”

  48. Blob Search - Direct : Bibs with URLs

  49. Blob Search - Direct : Holdings with URLs