Tracking Usage of EGovernment Publications

1
Tracking Usage of E-Government Publications

• Susan L. Kendall,
• San Jose State University
• Celia Bakke,
• San Jose State University

2
Traditional Ways of Tracking Materials

• Circulation Records
• In house shelving counts
• Surveys of patrons

3
Tracking Use of Electronic Materials

• User could be in the library or ..
• For confidentiality of records, user location is
  not kept.

4
Government Publications Architecture
Client
Programming languages COLDFUSION, HTML, CSS
Database Miscrosoft SQL Database (MS SQL DB)
stat_govPub_(month).txt (text file)
Front-end
Back-end
Stores data- bibNum
stat_govpub.htm parameters receive
-bibNum -vendor url
insert into
extract data using cfhttp

• Collects data
• bibNum
• suDoc
• class
• title

Gov_Pub DB

• Stores data
• bibNum
• suDoc
• class
• title

MS SQL DB Server
insert into
Redirect to vendor website
Extract data using cfhttp to initiate a one-way
request from information from a remote server
(the library catalog) http//mill1.sjlibrary.org/s
earch/.bibNum/.bibNum/1,1,1,B/marcbibNum
Lyna Nguyen
5
Government Publications Architecture
Admin.
Programming languages COLDFUSION, HTML,
CSSDatabase Miscrosoft SQL Database (MS SQL DB)
stat_govPub_(month).txt (text file)
Front-end
Back-end
Stores hit data- bibNum
stat_govPub.htm -login/logoff -view by month
year -sort by a-z, suDocs, highest hits-search
by bibNum, suDocs, title
read file
extract data
user submits

• Retrieves/Groups/Counts data
• count
• bibNum
• suDoc
• class
• title

Gov_Pub DB

• Data from DB
• bibNum
• suDoc
• class
• title

MS SQL DB Server
display to web browser
query data
connect to db
Lyna Nguyen
6
What to change in the database
7
Steps to Modifying the Bibliographic Record

• Identify the Bibliographic Record Number
• TITLE Nominations of Hon. Todd Walther Dillard
  and Robert R. Rigsby
• B19650826 Bibliographic Record Number

8
Then add the bibliographic record number to the
prefix

• The prefix is http//univ-intranet.sjlibrary.org
  /scripts/database_statistics/stat_govpub.htm?id19
  650826

9
Find the URL for the record

• 856 field will have the URL record
• http//purl.access.gpo.gov/GPO/LPS24014xSJSU

10
Then add tracking information

• 856 41 uhttp//univ-intranet.sjlibrary.org/scrip
  ts/ database_statistics/stat_govpub.htm?id1965082
  6pathhttp //purl.access.gpo.gov/GPO/LPS24014xS
  JSU

11
How to Change the Database(using character based
version)
12
Overall Database changes

• Search records in the database using Review Files
• Initial search strategies
• 856 has GPO (Bibliographic records search)
• Since most of these records have a purl,
  records are grouped into one review of batch
  changes.

13
Next step

• Use a script/macro to grab the bibliographic
  record number for each record
• Add the prefix to the URL.
• Also consider using a do loop in the script to
  perform batch changes
• Majority of records can be batch processed with
  the script

14
Time required for initial run

• 37,000 bibliographic records / 50,000 entries
• 2 weeks to run initial database change
• Many records had non standard URLs attached

15
On-going monthly maintenance

• Search for records to be changed after
  downloading monthly Marcive records
• Use script to do an automatic search
• Scan the records to check URLs
• Run a script/macro to batch change the records
• Total staff time less than 10 minutes
• Total Machine time less than 2 hours

16
Results
17
Sorting capabilities
18
Sorting, continued
19
Statistics 08/04-01/05
20
Statistics will be used for

• Collection development
• Selection of print versions
• Increase / decrease in areas identified
• Training
• Internal focus professional development on most
  used areas
• External offer workshops for the community
  based on requested materials

21
These statistics have

• Proven the online catalog is a resource for
  finding electronic documents as well as print
  materials
• Shown the ongoing need for multiple access points
  to finding complex documents