Trello based backoffice app with Nodejs

The application we are going to discuss is “Trello based backoffice app” for Resume filter and upload. It helps to organise your work as well as saves time. This app will help us to allign the resumes according to the expertise of the person. We also used webhooks for event notification via HTTP POST.

Trello helps you to manage all your projects, at work or at home. It is an useful project management tool that makes collaboration well organised. While using Trello we can create boards to organise anything you’re working on individually or group of team members.Entrepreneur’s work in an ever-changing environment and Trello gives them the maximum amount of flexibility.
Node.js is an open-source, cross-platform JavaScript run-time environment for executing JavaScript code server-side. Node.js is a packaged compilation of Google’s V8 JavaScript engine aiming to create real-time websites with push capability, “inspired by applications like Gmail”. Node.js shines in real-time web applications employing push technology over websockets.

So i just thought to link both the technologies together and create an app that create or filter resume’s with the help of Node.js and Trello as it is infinitely flexible and incredibly easy to use.

Setting it up:-

These modules we need to install are:-

1. Install Node-trello from npm(Node Package Manager).

user@user:~$ npm install node-trello

2. Install Imap from npm.

user@user:~$ npm install imap

3. Install pug/jade.

user@user:~$  npm install pug

4. Install nodemailer from npm.

user@user:~$ npm install nodemailer

5. Install mail-notifier.

user@user:~$ npm install mail-notifier

6. Install webhooks.

user@user:~$ npm install node-webhooks --save

Steps for set-up:-

1. Require all the modules discussed above and all the third party plugins.

2. After installing all the modules view the engine set-up and start the server.

3. Then add the code for receiving email’s and sending them to Trello board

var imap = {
   user: "XXXX@xxxxx.com",
   password: "xxxxxxxxx",
   host: "imap.gmail.com",
notifier(imap).on('mail',function(mail){
console.log(mail.from[0].address, mail.subject);      console.log("GOT MAIL");
console.log(mail.text);
var sql = 'SELECT * FROM applicant WHERE email ='+ "'"+mail.from[0].address+"'";
connection.query(sql, function(err, results) {
if (err) throw err
var t = new Trello("xxxx", "xxxxx");
t.post("/1/cards/"+ results[0].cardId + "/actions/comments", {"text": mail.text }, function(err, data) {

Filtering Resume on Trello

The image above shows how filtering a resume becomes very simple on Trello. It allows agile teams to easily and regularly re-prioritise their project delegation during every monthly/weekly meeting or daily kickoff.

Similarly the image below shows the description of user for which we are using webhooks to trigger notification to send email to the desired person.

After the resumes have been filled out and checklists completed, you’ll end up with both well documented research via this Trello based application, and a list of action items that will change your product for the better. Try it out and let me know what you think in the comments section below.