Transcript Slide 1

Using Process Mapping to Assess
and Improve eResources
Workflow
Kelly Smith
Charleston Conference
November 3, 2010
Workflow
Tools
http://www.flickr.com/photos/geishaboy500/100043823
Workflow Process Mapping
Database Acquisition “Before” Workflow
Vendor
Acquisitions
Staff
eResource
Librarian
Administrative
Coordinator
Collection
Dev. Cte.
Tools
Paper
Folder/File
Cabinet
Log
Renewal
Renewal
Notice
Email/phone
w/vendor/consortia
Vendor
Admin
Sites
Get Usage
Stats
Investigate
Pricing
Renew?
Send Invoice &
License
Notify
Vendor
Yes/no
Maybe
SharePoint
Meeting
Minutes
Get input from
Liaison/ Fac
Pay Invoice
Verify
Continued
Access
End
Approve
payment
Voyager &
Banner
Database Acquisition “After” Workflow
Vendor/
Agent
eResource
Collection
Librarian
Acquisitions
Staff
Administrative
Coordinator
Collection
Dev. Cte.
Log
Renewal
Renewal
Notice
Email/phone
w/vendor/consortia
Vendor
Admin
Sites
SharePoint
Master
eResources
Excel File
Investigate
Pricing
Get Usage
Stats
Shared
Network
“N” Drive
Get input from
Liaison/ Fac
Renew?
Notify
Vendor
Send Invoice/
License
License?
No
Pay Invoice
Approve
Payment
Notify eResource
Access Librarian
Tools
Yes/no
SharePoint
Meeting
Minutes
Yes
Sign
License
Voyager
& Banner
Current Database Acquisition Tools
Before..
After..
Current Database Tool - Sharepoint
Current Database Tool - Sharepoint
The “Electronic Resources” Spreadsheet – Over 170 licensed eResources tracked
Current Database Tool - Sharepoint
The “Electronic Resources” Spreadsheet – Over 170 licensed eResources tracked
Current Database Tool - Sharepoint
“The Sharepoint Spreadsheet” – Renewals Tab
Current Database Tool
“The N Drive” – eResources Folder
Current Database Tool
“The N Drive” – Usage Stats Folder
Current Database Tool
UStat
Current Database Tool
PHP-based Database of Databases
Current Database Tool
PHP-based Database of Databases
Next Step
Need a better TOOL to *Manage* the workflows we’ve developed.
EKU is…
1) Developing a ticketing system using Footprints
software to track
 Changes with journal titles
 Problem reports
2) Building an eResource Management tool using
Drupal


Desired Fields/Functionality: http://tinyurl.com/drupaldb
Mockup:
http://www.flickr.com/photos/kentbye/2053916246
Thank You!
Kelly Smith
Continuing Resources Team Leader
Eastern Kentucky University Libraries
[email protected]