/data-engineering

Coding challenge for the Associate Developer position.

Primary LanguageJavaScript

#Author: Joshua Porter

Goals of this application

This web-based application is designed to take a text file delimited by tabs and turn it into a normalized database. It uses a combination of PHP, SQL, HTML, CSS, and Javascript to create a pleasant user experience for transforming the file into a relational database. As a point of reference, the textfile MUST be delimited by tabs and the first line of the file MUST contain the column names: purchaser name, item description, item price, purchase count, merchant address, and merchant name. This is important for a successful import.

Application Prerequisites

  1. You must have a hostname, username, and a password to a SQL database.
  2. (RECOMMENDED) Best viewed in Google Chrome 10+
  3. MAMP for Mac for a MySQL Database.

How to use this application

  1. Load to the index of the application.
  2. Enter your desired database name.
  3. Input your login credentials for your database.
  4. Browse to the location of the text file.
  5. Click "Upload File"
  6. (Optional) Click "View the Orders" to view what your Gross Income was calculated on.