I have a system that people use to request to borrow some equipment. The issue we have today is that the legacy system is just a web form coming from an internal system. We have no good way to remind people to give the equipment back to the manager if the borrower forgets or is delayed. In the request the requestor will outline what they need and the date they need it and the estimated date they will return it. The system that runs this is very old and we don’t want to make changes to it. So we want to trigger off of emails for how our new system works. It will work like this
User completes request form – old legacy system
System sends emails to the requester and the manager, it will also email our nodejs system
nodejs system will parse this inbound email and store some data
Here is the exact info from the email we will be storing.
• Full Name:
• E-Mail Address:
• Phone Number:
• Fax Number:
• Division: West
• Dept Number:
• Type of Equipment Requested:
• Date Needed:
• Date to be returned:
• Customer Name:
• Show/Event Name:
Meta data – not in the email
• Date and time of email
• Blob of email – this is a copy for our records in case we ever need it. We can store the raw data mandrill gives us here as a json object in mongo.
Important to note: Nodejs system should get data from inbound mandrill email processing. This way you don’t need to run smtp server on nodejs side of things. Here is a link
[url removed, login to view]
The goal here is saving time and gaining reliability on email processing
Our system will take these incoming emails and then will be able to consolidate a list of reminders. we will send the manager a single consolidate email a few times a week showing them the people that should be returning things or that need to be reminded by the system to return the borrowed items.
We will give the manager the ability to click from the consolidated email (meaning it has a list of several people) to a single page (we should have obfuscated url format so it handles auth to the page without the user needing to login), they will toggle on each of the people they want to send a reminder to. The user will just need to click on the names and hit send. We will use an email template to send to these people. Each time the system sends a new email to the manager it will generate a new url. The previous email generated urls should expire in 30 days.
If the manager chooses not to remind someone that is on our list they can click “ snooze” which means they did not check in the equipment and we will remind later. If the manager doesn’t click to send a reminder or doesn’t click snooze then the system can make the assumption that the requestor did turn in the equipment and we don’t need to ask about them anymore.
For sending emails out we can use mandrill which has an api. The html template will be there, you will send json to it to actually send the email. I need to be clear here I want to use Mandrill for both outbound and inbound emails.
[url removed, login to view]
let me know your cost and timeline for this system.
The ui of the system will come from this admin theme [url removed, login to view] i will be providing this to you for integration with the nodejs application. We should have the following admin pages
Sign in / logout
Dashboard of all checked out things, list of people, list of reminders to each person, open emails tracking (mandrill supports opens tracking)
Ability to click on 1 or more people in list and send reminder, snooze, or checkin
2 hard coded logins is fine – store in config, most access will be via manager emailed url
Tech to use
I assume app frameworks like expressjs, sailsjs, partialjs?
Mandrill api – email processing
hello, your details looks very straight forward , i can achieve your request as you suggested with sails , express or meteor while i think just express is enough
9 freelancers are bidding on average $1519 for this job
Hello, I can meet your requirements for this project. Contact me if you are interested. ==============================================================