This project is for a Drupal 6 site using a mySQL database, and will also need to access a MSSQL database hosted on another server which stores additional data for each of the users in the Drupal site.
This project involves setting up triggered emails in Drupal that will check certain criteria in the mySQL database and/or the MSSQL database, and then send a customized email to a specific user. The emails should be able to use tokens that will pull information from either/both databases. Each email needs to be fully customizable by admins, and I need to be able to set up additional triggers in the future using other various information from both databases. Admins should be able to add additional triggered emails in the future as necessary. Existing Drupal features and/or modules can be used, or a custom module designed from scratch. When bidding, please specify if you intend to use existing modules or create a new one.
The following are EXAMPLES of the types of emails that will be able to be configured with this project:
1) Check each user's $ balance in the MSSQL database on a certain day of the month. If the user's $ balance is above zero, trigger an email to that user which including the $ balance.
2) Check each user's contract date in the MSSQL database on a certain day of the month. If the contract date is within a certain number of days, trigger an email to that user with information including the contract date.
3) If the user has not logged into the site in a certain amount of time, trigger an email that includes various user information that reminds them to log in.
These are just examples - emails with various other database criteria must also be able to be created by the site Admins.
Please, only programmers with documented Drupal 6 experience should bid. You should ask me questions before you bid so you are sure you understand all that is required. We will be able to provide a sample of the MSSQL database upon request. Please feel free to ask questions before bidding. We will be happy to answer them for you!
We are a reputable US-based company, and we have been in business for over 10 years. We will put 100% of the bid into escrow before you start, and we will release the escrow to you in full upon completion and testing.
Thank you so much for your consideration! We look forward to reviewing your bid.