LibStats

1
LibStats
University of Queensland Library
Liz Jordan, Manager, Quality Services Matt Smith,
Senior Systems Programmer
2
Statistics - From this
3
Issues

• Time consuming
• Variability
• Discrepancies
• Lack of security
• Work involved in bringing together and
• Analysing for reporting

4
To This
5
(No Transcript)
6
Reports
7
2005 Review

• Project manager
• Time
• Reference Group representatives from branches
  and sections
• Programmer

8
2005 Review

• What are we counting?
• What are we not counting?
• What should we count?
• What is happening in the branches?
• What needs clarification?
• What confusions or inconsistencies are there?

9
(No Transcript)
10
What do we need?

• Consistency
• Single Tool
• Facility to import from ILMS
• Highly Configurable
• Type of statistics - create/delete tables
• Include notes
• Management functionality
• Security
• Differing access levels for different staff
• Security of data
• Import from Excel backsets of data from 1990s

11
What do we need ..

• Reporting function
• Totals
• Comparatives
• change
• Time series
• Graphing capability
• Export to Excel
• CAUL report

12
What did we get?

• All the above
• Ease of use results in higher compliance
• Security features ensure stability
• Reports function heavily used
• Visibility to staff has promoted greater interest
  in participation in Librarys core purposes

13
The package

• Libstats is licensed under the GNU-GPL
• http//www.library.uq.edu.au/software
• User Manual
• http//www.library.uq.edu.au/about/qm.html
• Installation Manual
• http//www.library.uq.edu.au/about/qm.html

14
Minimum software requirements

• PHP 5
• Apache - not tested on 2.x but should work
• SQL - UQ uses MySQL 4.1
• Linux - it should work on Win32 but it seems to
  depend on getting the right combination of
  php/apache windows binary releases.

15
Hardware

• We are using A Dell Poweredge 2650 with 1Gig of
  RAM.
• Disk space usage
• 17Mb for the PHP files
• The size of the DB is 5.6Mb

16
Main Page
17
Entering Statistics into Libstats
18
Enter Stats - 1
Stats categories click on to select
19
Enter Stats - 2
Selected
Table for entering monthly stats shows. Click on
month to select
20
Enter Stats - 3
September has been selected from previous screen
Some figures are imported directly from Innopac,
(auto update) some are entered by Branch staff
box to place figure in
21
Enter Stats - 4
Instructions on how to collect figures can be
included. (These are high use and non-high use
material figures, taken from Innopac)
22
Enter Stats - 5
Once the cut-off date for entering stats each
month has been reached, they can be closed off.
The months then no longer show as links
23
Enter Stats - 6
Stats can be added daily or weekly, and cumulate
towards the monthly total.
Name of person entering stats, and date, display
Stats can be amended (pencil icon) or deleted ( x
icon), by the person who entered them, or by a
(system defined) manager for the Branch
24
Managing Users
25
Manage Users - 1
Staff members to be given rights to enter or edit
stats are entered here. (Can be imported from
staff database)
Staff can be designated as Standard users (enter
and edit), Managers (can manage permissions for
staff, and amend others entries), and
Administrators (full rights)
Branch(es) for which a staff member may enter
stats are designated here
Users has been selected
Staff members primary branch is designated here
Listing of staff members and their details
26
Manage Users - 2
More of the list of users
27
Manage Users - 3
List of Branches, with members staff who can
enter/edit stats for each branch
To edit the Branch membership, click on pencil
icon
In the Manage User Access module, Manage
Branches has been selected
28
Manage Users - 4
Members can be removed (click on X), or added via
the box.
The edit branch icon for Corporate Services (CS)
has been clicked
29
Manage Users - 5
Staff members are authorised to View, Edit, or
Administer stats. Rights can be restricted to
particular groups of Stats, and in particular
branches
Authorisation link has been clicked
30
Configure LibStats
31
Configure - 1
This is where the stats groups are set up. All
aspects are configurable
32
Configure LibStats - 2
Stats groups display, showing code, name of
group, notes, branches in which group applies,
and columns in the group. Pencil icon allows for
amending any aspect of the set up. The Edit
Columns link allows columns to be added or
deleted.
33
Configure 3
The update icon for 1d Loans by patron type has
been clicked. This page allows additional columns
to be added, columns to be deleted.
34
Configure - 4
Stats can be closed off, so that no further
changes can be made. Only the System
Administrator can action this function.
Close Stats has been selected
35
Reports
36
Reports - 1
Whole of library reports can be viewed, or
individual branches.
When Reports are selected from Main Page, Totals
opens
37
Reports - 2
Index is provided
38
Reports - 3
For Graphs, check the boxes, and click Graph
39
Reports - 4
40
Reports - 5
41
Branches Reports
Reports - 6
42
Reports - 7
Stats Group Enquiries is selected, for the
three hospital libraries
43
Reports - 8
44
Reports - 9
45
Reports - 10
Turnstile for all branches to August 2006
46
Time Series Reports
Reports 11
47
Reports - 12
Total for the years can be selected, or months,
quarters or semesters can be compared
48
Reports - 13
49
Reports - 14
50
Reports - 15
51
CAUL Report
These values are entered into LibStats annually
in November.
These are YTD figures
52
Questions?