Please be ready to provide specific examples of work with databases and surveys. Preferred to have worked with Limesurvey or PHPsurvey in the past.
We have a SQL database here locally (Seibel CRM records.) We need a script on our webserver that will check this database every night and pull records that have changed to a specific code. Connection from web server to this database is already tested and ready.
The pulled records need to be added to a database on the web server that holds a list of all customers to be surveyed. Database already exists.
Using LimeSurvey the new records need to get an email survey invitation. I would also like a reminder sent to all customers who have not filled out the survey in 10 days. Email invitation should provide a link to survey that allows them to seemlessly log in (code contained in URL)
Limesurvey will validate customer (each customer should have a specific code for log in.)
Limesurvey is alreay up and running on our server.
Please email questions to me right away.