Original Posting

Imagine that LivingSocial has just acquired a new company. Unfortunately, the company has never stored their data in a database and instead uses a plain text file. We need to create a way for the new subsidiary to import their data into a database. Your task is to create a web interface that accepts file uploads, normalizes the data, and then stores it in a relational database.

Here's what your web-based application must do:

1. Your app must accept (via a form) a tab delimited file with the following columns: purchaser name, item description, item price, purchase count, merchant address, and merchant name. You can assume the columns will always be in that order, that there will always be data in each column, and that there will always be a header line. An example input file named example_input.tab is included in this repo.
2. Your app must parse the given file, normalize the data, and store the information in a relational database.
3. After upload, your application should display the total amount gross revenue represented by the uploaded file.

Your application does not need to:

1. handle authentication or authorization (bonus points if it does, extra bonus points if authentication is via OpenID)
2. be written with any particular language or framework
3. be aesthetically pleasing

Your application should be easy to set up and should run on either Linux or Mac OS X. It should not require any for-pay software.

Install rvm

$ curl -sSL https://get.rvm.io | bash -s stable

Clone the repo

$ git clone https://github.com/dotnet236/data-engineering

Install ruby if prompted

$ rvm install ruby-2.0.0-p353

Bundle the project gems

$ bundle --binstubs

$ rails server

$ rake

$ rake spec:functional

Must install PhantomJS first

$ rake spec:browser

All contributions should be submitted in a pull request from your personal fork back to this repository.

Before submiting your pull request, please verify that running

$ rake

and

$ rubocop

complete successfully