Price History is an existing open-source project developed by the Federal Government. Its purpose is to save the taxpayer money by providing transparency into the prices that governments pay. We encourage municipalities to reuse this software. However, it lacked a UI to easily take existing data and load it into the searchable Price History Database. Price History Data Upload along with subproject Mr. CSV Transformer, makes it easy to ingest data into Price History
Price History is installed at http://188.8.131.52/gui/ (the hackathon feature will be uploaded later to this server.)
In this hackathon, we created a new Upload page for Price History, with a link to the Mr. CSV Transformer tool which pre-loads the required target fields in that tool This allow a simple cut and paste back into the Price History, allow very quick upload of a CSV file in any format.
The CSV Transformer is live and usable and can be reused for many purposes beyond Price History.