online, web-based data collection system february, 2011
TRANSCRIPT
UTAH STATE PAWN DATABASE
Online, Web-Based
Data Collection System
February, 2011
Background Pawn shops must upload transaction data to
the Statewide Pawn Records Database.
A limited number of file formats are accepted for uploading Pawn transaction data.
For those shops that can’t provide data in one of the standard formats, an Access-based data entry system was made available to collect transaction data and upload to the database.
Issues with Access-based System Requires Microsoft Access license.
Can only be used on one computer.
Does not provide editing/cross checking of data.
Requires files to be uploaded manually.
Files could contain errors or missing data.
Web-Based Data Collection System A new web-based data collection system
has been created to replace the Access-based system.
Eventually everyone that uses the Access-based system will be asked to use the Web-based system.
Benefits of Web-based System
Doesn’t require Microsoft Access License.
Can be run from any computer with Internet access.
Can be run from multiple computers. Data is verified for accuracy before
being accepted. Data selections are contained in drop-
down lists and menus.
Web Pawn System Menu Location
Ticket Summary Page
Ticket List Page
Ticket Entry Form
Ticket Entry Form
Ticket Entry Form (Data)
Ticket Entry Form
Ticket List with New Ticket
Ticket List – Add Items
Ticket Item List
Ticket Item List – New Item
Ticket Item Form
Item Form – Data Entry
Item Form – Data Entry
Item Form – Data Entry
Item Form – Data Entry
Item Form – Data Entry
Item Form – Data Entry
Ticket Item List – Item Added
Add Remaining Items
Repeat using the Item Form to add each of the remaining items on the ticket.
Ticket Item List – All Items
Return to Ticket List
Ticket List
Add additional Tickets
Add additional tickets and items by repeating the process of adding the ticket information (using the Ticket Form) and adding items to the ticket (using the Items Form).
Ticket List – Additional Tickets
Finished Entering Tickets
Summary Page
Submit Tickets to Database
Repeat using the Item Form to add each of the remaining items on the ticket.
Submit to Database
Tickets Submitted
After being submitted to the Database, the tickets submitted are no longer available for editing.
The Summary Page lists the last 10 submissions.
Summary Page
Summary
The Web-based data collection system will take the place of the Microsoft Access-based system.
Everyone who currently uses the Access-based system will be asked to use the Web-based system.
Shops that use inventory systems that extract and upload transaction data may still continue to do so.
THANK YOUUtah Statewide Pawn Information System