This program was written to fulfill a very specific need for Bell Photographers, Inc. Bell uses an SQL database hosted on a local computer to track all email orders, phone orders, and online store orders. The software used to manage this SQL database is rather cumbersome and slow, and in the future I plan on replacing the entire piece of software with my own.
Action Item Scanner was written to easily and quickly mark an order (action item) as complete. The previous process required the user to search through a list of all current action items, find the action item needed to be marked off and then mark it off. During the busiest part of our work year, we could easily have up to 400 action items that need to be marked off each day, and the user would have to search through a list of 1600+ action items to find the correct one to mark as complete.
With the new program, Action Item Scanner, the user opens the program, and scans the barcode on the order printout using a barcode scanner, and the action item status is updated as complete. If the user makes a mistake they can select the option to mark the action item as ‘new’ again. Because it is a simple barcode scan, the user can easily scan through stack of action item printouts and mark them as complete, no longer requiring the user to find each action item in a list one by one. My estimate is that during the busiest parts of the year this will turn a 2 hour per day job into a 10 minute per day job.
Features
Program, upon opening, checks online for any updates. If there are new updates, the program will prompt the user to install the new update.
The cursor remains in the textbox allowing the user to scan quickly through a set of barcodes.
Barcodes can be scanned or hand-typed.
Radio buttons allow user to select whether the action item will be marked as ‘complete’(default) or ‘new’.
Genderizer was written for Bell Photographers, Inc. as a solution for entering genders for a large quantity of records in a database. Bell sells several products that are gender specific, and so there is a need to have employees enter the gender information for each subject in certain databases. Genderizer allows the user to open a database, and enter genders quickly. User selects database to open, and uses the 1 and 2 keys on the keyboard to mark a subject as Male or Female.
Features
Genderizer starts on first record and progresses to the end, notifying user when the end has been reached.
User presses 1 to mark subject as Male, and 2 to mark subject as Female.
If user makes a mistake, user may press ‘3’ to move back to the previous record.
Slider bar below image allows for easy navigation through records.
Genderizer saves as the user enters the data, no need to save at the end.
Image displays large enough for user to determine gender of the subject.
First name of subject displays in case image is difficult to determine gender.
If a gender has been entered previously, gender is displayed in red. If no gender has been assigned, the current subject shows a red question mark for gender.
When program is opened it checks online for any new updates.
School Tracker was written for Bell Photographers, Inc. as a way to track contacts between the sales staff and schools. When a salesperson contacts a school they use the School Tracker website to log their visit for future reference. Once logged in, the program allows the salesperson to add a new school to their account, and add a visit or contact with the school. The website will log the GPS coordinates when the salesperson adds a visit, with the intention that management will be able to track where the salesperson was when the visit was made.
This web application was developed as a delivery method for digital images purchased by customers of Bell Photographers. When a customer purchases their digital image, they receive a token which can be entered at the site to retrieve their image.
Features
User enters token to retreive their image.
User must enter a Captcha code to ensure they are human and not a robot.
If both codes are correct, the application allows user to download image.
A simple program for copying essential files from a specific location on a network server to a specific location on the local hard drive.
Employees no longer need to remember where to copy to and from, they simply run the program and files copy to where they are needed.
Features
Open program and click 'Install', that simple!
Program checks Operating System for 32 or 64 bit to ensure the files are copied to the correct location.
Token Creator opens up a Microsoft Access database storing subject information and generates a unique alphanumeric token or password for each
subject in the database. The user opens the database, selects the range of subjects and generates the code.
Features
User has ability to select the appropriate range of records.
Passwords are generated using cryptographically secure PRNG.
Generated passwords are checked against an SQL database to ensure uniqueness.
