Custom Reports and Files Created by Blob Searches on MARC Records

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 _at_ Georgia State
University rcravey_at_gsu.edu
2
Voyager Reporting System Design Overview
Workstation Application
3
(No Transcript)
4
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

5
Circulation Reports

• 26 report options covering
• statistics
• charges, fines and status and
• patron information

6
Cataloging Reports

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

7
Cataloging Reports (continued)
Reports of specific interest in this session
8
Cataloging Reports (continued)
Why distinguish between Keyword Selections and
Blob Search?
Keyword Selections is 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.
9
Voyager Database contains over 400 Oracle Tables
10
Example Bib_Index Entries
11
Example Bib_Data Entries
Example MFHD_Data Entries
12
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

13
Closer Look at Keyword Selections
14
Keyword Selections (subject specialty count)
Search for Korea /or/ japan china /or/ chinese
Field 245
15
Keyword Selections (subject specialty count)
Qualify using Advanced Selections
16
Keyword Selections (subject specialty count)
Assign a type of Filter
17
Keyword Selections (subject specialty count)
Select the specific Filters
18
Keyword Selections (subject specialty count)
Assign additional Filter types or submit the
search
19
Keyword Selections (subject specialty count)

• Choose to display counts by
• Location
• Language
• Medium
• Form of Material
• Type of Record

20
Keyword Selections (subject specialty count)
Transcribe counts, redistribute by different
group or print the report
21
Keyword Selections (subject specialty count)
Printed report
22
Keyword Selections (simple search)
Field 245
Search for folk /and/ songs
23
Keyword Selections (Advanced filtering)
24
Keyword Selections (Select type of filter)
25
Keyword Selections (Make filtering selections)
26
Keyword Selections (Process request)
27
Keyword Selections (results list)
28
Keyword Selections (output options)
29
Keyword Selections (View/Print 1 Line
Format - MS Access)
30
Keyword Selections (Excel output option)
31
Keyword Selections (Excel spreadsheet
based on content of
MS Access tables)
32
Keyword Selection -- MS Access - Brief Entries
33
Keyword Selections (Full MARC output)
34
Keyword - Full MARC
35
Keyword Selections (MARC output
specifications)
Additional search qualification is optional.
36
GIL Library-File Utility
The utility is called by the VRS Build command
it starts and stops automatically
Used to format Full MARC output
37
Keyword Selections (Full MARC Print Output)
Text-file display using Notepad
38
Keyword Selections (MARC output specifications)
Screen Display with Interleaved Blobs
39
Keyword Selections (Full MARC Screen Output)
40
Keyword Selections (Interleaved Print File)
Bib
MFHD
41
Keyword Selections (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. 245h 245-Field, h included

42
Keyword Selections (Excel Interleaved Output)
Specify Excel output fields
Filter on sound recording, 245-Field
43
Keyword Selections (Interleaved Excel
Spreadsheet
sound recording)
44
Blob Search - Full MARC
45
Blob Search - menu button
46
Blob Search - Direct

• Search entire record for
• song /OR/ poetry
• AND
• birds /OR/ prose

Tag 000a will default to searching entire Blob
47
poetry, prose
song, bird
48
Blob Search - Direct
Output Bib Fields 001, 245, and 856
Search 856-Field for http
49
Blob Search - Direct Bibs with URLs
50
Blob Search - Direct Holdings with URLs
51
Blob Search - Direct Holdings with URLs
52
Blob Search - Restriction
You cannot search both the Bib blob and the
Holdings blob in the same request.
53
Blob Search - Matching Rules
Wildcard characters (asterisk) multiple
chars _ (underscore) single char
Example Search Strings Search String Field
Matching Values Include man - - - - - "Man
", " man ", " man ", " man-power " man_ -
- - - - " mane ", " Manx " man - - - -
- "manual ", " manuscript ", "Man ", " man
", " man ", " man-power ", " mane ", "
Manx " man - - - - - " Emanuel " plus
matches for man
54
Blob Search - Boolean Rules

• - operators must be input as /AND/ or /OR/
  (slashes required)
• - operators must be preceded and followed by
  one space
• (Valid entry China /AND/ Japan /AND/ Korea )
• - operators cannot be mixed within one textbox
  
• (Invalid entry China /OR/ Korea /AND/ Japan )
• operators between textboxes must be of the
  same type.
• - negative matching or exclusion based on a
  match is not supported.
• (Invalid expressions /AND/ NOT Japan /NOT/
  Japan )

55
Blob Search - Direct
Output same Field Tag in both Bib and Holdings
(e.g., b856, m856)
Either Bib or Holdings
56
Blob Search - Direct same Field Tag in
both Bib and Holdings
Bib 1
Bib 2
57
Blob Search - Direct same Field Tag in
both Bib and Holdings -- Spreadsheet
Bibs with multiple 856-Fields produce multiple
entries
58
Blob Search - Direct Subject Search
Search the 651-Field for georgia /AND/ history
59
Blob Search - Direct Subject Search - Excel
An entry is repeated for each 651-Fld in a
qualified Bib.
60
Blob Search - Direct Missing Subfield
To check a field for a missing subfield code,
input the field tag and key string in the top
row in second row input the target field tag
followed by - and the missing subfield code
leave the search string blank Ex Find all 856
Fields without a z.
61
Blob Search - Direct Missing Subfield
62
Blob Search Help
63
Blob Search Help
64
VRS
Blob Search DEMO
Contact your GIL Service Site for more
information or assistance.