README.md

📎 Klimb

A node.js application to add candidate records from Excel to mongo database

📕 Objective

● Make a node.js application to add candidate records from Excel to mongo database

📙 Requirements

● A web landing page as per wireframe

● Provide an excel upload option

● Success or Error Message

📒 Tech stack

● Node.js - mandatory

● MongoDB - mandatory

● We can choose rest of the stack

📗 Technical design

● Backend should have logical separation of Model & Controller

● Demonstrate the use of callbacks

📘 Data handling

● Add all properties defined in Excel into a mongo collection

● All properties can be stored as strings or any data type of your choice

📒 Async-each-series

● Use async-each-series to process one candidate at a time, after reading from excel

● This has to be implemented in the API code

📔 Unique records

● Email id should be unique

● This validation should be implemented in the API code

● Duplicate check has to be done for each row against the database using a mongo query

● Skip row if duplicate exists in database

📓 Test Data

● Use enclosed excel for test data

📕 API Response

● Return success if excel is processed

Developed Solution

● Designed a Node.js application to add candidate records from Excel and it gets added to MongoDB

Steps

1️⃣ Landing Page

This is the landing page of the website.

2️⃣ Choose File

Choose the file by clicking on "choose file".

3️⃣ Upload Excel

Upload the excel file in .csv format by selecting the file

4️⃣ MongoDB

Connect MongoDB to view the records

View the records in raw form or in table form

Full Video Demo