This is the code dump for the App server I am working on at CCA. All Node.js/Express/Jade (May switch Jade for handlebars depending on my level of comfortability) files will live here. All documentation will be kept within this README file.

Jump back up to the Table of Contents

Create 2 servers, one application server (NodeJS/Express) and one database server (MongoDB), and have them talk between each other. All configuration settings have been documented in the server-conf.txt file. Express should start the server successfully and talk to the MongoDB and present useful feedback to the user. If the webserver is able to get and post data to the database everything has been set up correctly.

Jump back up to the Table of Contents

Develop a front-end application that will handle all the requests to the database. All work done will be committed to this git page. Here are some requirements I have come up with (this is going to change in the future):

• Create the CRUD mongoose models.

• Implement user authentication (Completed 3/24/2016)

• Develop API routes (Completed 3/24/2016)

• Develop a upload function to take excels and convert to JSON and then push them to the database.

  • This should be an update/add function where it checks each entry for existing data (I am going to use email as a unique identifier)

• Add queries and custom searches for specific data requests.

  • Searching for a specific user

  • Searching for specific information (SP tickets, Jira Ticket, etc.)

• Add a function to help clean up any duplicates

• Have the abilty to export data into clean spreadsheats

• Secure the website with user authentication

• This list is a work-in-progress
  

Jump back up to the Table of Contents

Clean up the existing spreadsheat used to keep track of everything. I am going to break this up into sections. First I am going to do CCA employees past and present. Depending on the spead in which it takes me to upload this into MongoDB I may come up with alternative solutions. I have created a plain text JSON file which will be turned into a script for MongoDB. This process is entirely manual. Then I will work on cleaning up and uploading Dell’s system access to MongoDB. Then finally I will clean and upload Optums data. After this I should have a functional database and all future requests should be uploaded and maintained in this database.

Jump back up to the Table of Contents