Filling the ILS Reporting Void

1
Filling the ILS Reporting Void

• PHP Web Reports VRS

ELUNA 5 June 2007 Presenters Bob Trotter,
Coordinator GIL Service Site _at_ University of
Georgia rwt_at_mail.libs.uga.edu Phil Williams,
Director Virtual Library Support, University
System of Georgia Phil.Williams_at_usg.edu
2
GALILEO Interconnected Libraries - GIL

• 36 USG Institutions (map)
• Georgia Dept. of Archives History
• Atlanta History Center
• 3 Service Sites
• - Ga. Tech (1)
• - Ga. State (21)
• - UGA (16)
• Migrated from 7 ILS
• DRA, Datatrek, GLS, Notis, PALS, Sirsi, and
  UGAs GALIN

3
Voyager Reporting Options

• Reporter
• Access Reports
• Analyzer

USG Libraries began their 3-year migration to
Voyager in 1998. Early in the migration process
Library staff requests for data started to
disprove a basic assumption the staff would
easily move to using MS Access to query the
Voyager database.
4
(No Transcript)
5
Typical Reactions

• The Access Reports are okay, but .
• We dont have time to learn SQL.
• MS Access is too complex.
• I just want a button to click.

6
GIL Reports Committee Recommendations (year 2000)

• GIL Web Reports
• Fast
• Ease of Use
• GIL Workstation Reports
• Filters
• Sort Options
• Output Alternatives
• Security

7
GIL Web Reports

• Following the GIL Reports Committees reporting
  recommendations, work was begun first on the GIL
  Web Reports which use PHP and Apache. Some
  reports were duplicates of Voyager MS Access
  reports, while others were designed with selected
  parameter input to fill the reporting void and
  meet staff demands for information.
• Welcome to GIL Web Reports
  presented by Bob Trotter

8
(No Transcript)
9
Voyager Reporting System - VRS

• As the first GIL Web Reports were being made
  available, work on the workstation reporting
  client was started. The GIL Web Reports have
  bridged many reporting voids, especially for
  consortium reports. They provide data that
  Library staff need on a day-to-day basis through
  a web interface. While MS Access reports
  provide more selection criteria and detail, the
  Library staffs did not want to learn SQL and MS
  Accessthey wanted a point-N-click reporting
  interface.
• Welcome to the Voyager Reporting System or VRS
  presented by Phil Williams

10
Voyager Reporting System - VRS Design Overview
Workstation Application
11
Voyager Database contains over 400 Oracle Tables


12
(No Transcript)
13
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

14
Cataloging Reports

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

15
Circulation Reports

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

Statistics
Patron Rpts.
Circ. Lists
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
(No Transcript)
32
(No Transcript)
33
(No Transcript)
34
(No Transcript)
35
(No Transcript)
36
Multiple Print Format Options
37
(No Transcript)
38
(No Transcript)
39
(No Transcript)
40
(No Transcript)
41
(No Transcript)
42
(No Transcript)
43
(No Transcript)
44
(No Transcript)
45
(No Transcript)
46
(No Transcript)
47
(No Transcript)
48
(No Transcript)
49
(No Transcript)
50
(No Transcript)
51
(No Transcript)
52
(No Transcript)
53
(No Transcript)
54
(No Transcript)
55
(No Transcript)
56
(No Transcript)
57
And More
58
Review - 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

59
Review - Cataloging Reports

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

60
Review - Circulation Reports

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

Statistics
Patron Rpts.
Circ. Lists
61
GIL Web Reports using PHP and the Voyager
Reporting System VRS Filling the reporting void
between what the vendor provides and what the
Library staff wants.
VRS is available at URL http//download.gil.usg.e
du