Drupal 6- Triggered emails using data from various databases

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.

Skills: Drupal, MySQL, PHP

See more: various experience, us contract programmers, types of programmers, set data, pull escrow, project based contract sample, necessary of programmers, mysql data access, log used on company, i have programmers ask me, free business log, examples of databases, examples databases, data set testing, databases examples, custom php contract, create mysql database using php, create business log, c c++ programmers for contract, ask programmers, access database programmers, escrow contract, create company log, zero day, us emails

About the Employer:
( 8 reviews ) Baltimore, United States

Project ID: #1114801

6 freelancers are bidding on average $237 for this job


experienced Drupal developer, please check PM for details

$250 USD in 5 days
(228 Reviews)

A team of drupal guru at Shanghai, plz check pmb

$250 USD in 3 days
(40 Reviews)

Very interesting job and we are available for the same. kindly check PMB for more details.

$250 USD in 5 days
(4 Reviews)

dear sir Dolphinesoft is a professional Software Development Company providing complete IT solutions. website designing, software development and internet marketing and full featured web services including B2B and B2 More

$200 USD in 10 days
(1 Review)

I am expert in Drupal please check PMB for my portfolio.

$250 USD in 5 days
(0 Reviews)

hi,it is honor to find this project here,we have experience in this area,pls check my [login to view URL]!

$220 USD in 5 days
(0 Reviews)