This script is currently in beta testing! While in beta testing, this script will not interfere with any existing HIT databases. That means you can, for now, use this in conjunction with the original, simultaneously. However, do not use if you're uncomfortable with a non-finalized product.
This is a complete rewrite of the MTurk HIT Database script from the ground up.
Why should you use this script?
It eliminates outdated and obsolete methods, which not only optimizes performance, but also fixes many of the bugs present in the original. This script is much cleaner, faster, and more efficient than its predecessor. It's also fully compatible with both Firefox and Chrome!
Features
- keep track of all HITs you've submitted
- integrated daily/weekly projected earnings
- automatically save auto-approval times
- keep track of bonuses
- add your own notes to HITs
| - file-based importing supports both JSON and CSV
(no more annoying copy/pasting) - easily create backups of your ENTIRE database
- checking whether or not you've done a HIT is easier and more intuitive
|
User Guide
Navigating the Interface
Overviews
|
|
Pending Overview | Displays all requesters for whom you have pending HITs, sorted by total rewards. Clicking on the blue [+] or [-] will respectively expand or collapse HITs that are still pending for that requester. Results can be filtered by the date inputs and query input search options. |
|
|
Requester Overview | Displays all requesters (regardless of HIT status) sorted by total rewards. Similar to Pending Overview, clicking on the blue [+] or [-] will respectively expand or collapse HITs done for that requester. Results can be filtered by the date inputs and query input search options. |
|
|
Daily Overview | Displays a summary of each day for which you have submitted HITs. Results can be filtered by the date inputs. Clicking on the blue [+] or [-] will respectively expand or collapse HITs done on that day. |
|
|
Imports, Exports, and Backups
|
|
Import | This will open the file selector prompting you to select a file to import. Files must end in a .bak , .csv , or .json extension. Note: Importing from a CSV file is restricted to HITs only. You cannot import notes, daily stats, or anything exported via the overviews (pending, requester, daily). |
|
|
Export CSV | Converts the results that would normally be shown into a tab-separated CSV file which can be loaded into a external SQLite database, spreadsheet file, etc. |
|
|
Create Backup | Self-explanatory; it backs up the entire database which includes HITs, notes, and daily stats. This makes it easy to create periodic backups as a restore point in case anything should happen. It also makes it very easy to transfer a database to another computer. |
|
|
|
Searching
|
|
Status dropdown | Restrict results to HITs matching the specified status |
|
|
Query input | Restrict results to those which the requester's name, HIT title, or HIT id at least partially matches the query |
|
|
Date inputs | Restrict results to those that lie within the range specified |
Projected and Pending Earnings
These values are updated every time the database is updated. Pending earnings may include values for HITs with the status "Approved - Pending Payment". These funds have not been fully cleared and credited to your account, and thus are included here as they are still pending.
Click on the meter under the projected earnings to set your target value for the day/week.
Bonuses
After searching for HITs in the database, click on the cell under the Bonus column to edit. The value is automatically saved when pressing "Enter" or after removing focus from the cell in any way.
Notes
Advanced Usage