March 28, 2014
PawnMaster to Bravo Data Importer
Python, AutoHotkey
PawnMaster, Bravo Store Systems, data conversion

Transitioned a pawn shop to new point of sale software. Used AutoHotkey extensively to automate the entry of over 50,000 customer records "one by one" into an interface lacking all but "manual" import means. (Any mechanism meant for human input can be automated with AutoHotkey.) Work load was split between 4 virtual machines for additional speed. After much tweaking the import was completed in a few days. With precise control of how the data would look to employees on the new system in comparison to the old, as well as knowledge of how some data was stored in unintended ways within the old system, I was able to carefully preserve all customer information.