System similar to [url removed, login to view]
We need to be able to validate email addresses. There are some well documented approaches to checking email validity via smtp servers, dns lookup etc.. There are a lot of 3rd party services that do this so I am pretty sure there should be some reliable methods. In your bid please specify at some high level how you will do this so I can properly weigh the complexity of your system against others.
Here is how we see our system.
Users can hit a single page site and view some html marketing text and pick a package to signup
In next phase we will integrate ecomm. So after signup we send welcome email to the user and they join the system (as if they paid)
User can create sub users which can all use the system.
The user will upload an excel sheet with the following fields into the system: First Name | Last Name | email (optional) | Company URL, if additional columns are in the sheet they will be kept in the same position in the final output and basically ignored by the system but are added to the output/export
Upon upload the user will be presented with all of the column header names found in the sheet. They will tell the system which is supposed to be used for first name, last name and domain. This feature will help users be able to use real excel sheets and not need to make one specifically for this system and then have to do work when they get the results.
The system will take all rows with an email address provided and send it straight to the validation step. If a lead does not have an email address, the system will generate some tests/guesses for it based on the following ideas
John | Doe | [url removed, login to view]
• john at [url removed, login to view]
• doe at [url removed, login to view]
• [url removed, login to view] at [url removed, login to view]
• jdoe at [url removed, login to view]
• johnd at [url removed, login to view]
Which will then be sent to the validation step. (The rules for guesses should be in some config file so we can add additional guesses types in the future
Our premise is that a single one of the above will validate. In the event multiple validate we will create a new column in the excel sheet and place all of the emails that passed validation.
The validation system will send an SMTP request test to the email server of the company and attempt to validate which of the emails is correct or which is the most likely to be correct.
The system will store the rules by domain so that subsequent future submissions by someone at the same company can jump to the correct email structure instead of guessing. We will also store an encrypted version of results on the server so if someone else uploads the same person again, it won’t keep validating over and over. (Simple hash table works here)
If a user in one of the rows has an email address already, we will pass it to the validation engine flow to test it. If it passes we will indicate it in the output excel, if it fails, we will start the above test process for guessing what it might be. These outcomes will be clear in the excel output so data is not lost and the user is not surprised by what has happened.
We would like the dashboard for the user to have some real-time components to it. Maybe while the system is processing it can update in real time a table for the user. Sockets would be nice here.
o App framework like express, sails, totaljs
o Plugin for read/writing XLSX/CSV – XLS not in scope
• Phython (if needed)
• Mongodb- long term storage
• Redis (maybe use this as the working table during processing?)
• Theme for site will be based on [url removed, login to view] ( I will provide html for you from this theme)
6 freelancer bu iş için ortalamada 966$ teklif veriyor
Hi, how are you? Im Computer Science graduated and SaaS and NodeJS expert. I can do it starting now! If you are interested, please contact me! You will not regret! Thanks you very much! Greetings!