We need a c# or vb.net project for a quick "SQL to Mailchimp Integration" project.
All of the below must be completely compatible to MS/SQL 2005 DBs.
1st - a console app (exe)(not a service) that can be run from the command line (or task scheduler) at anytime that will:
Connect to our mailchimp account using our API key and pull back the bounced emails
from our mailchimp list(s).
We will keep these list names in a table, then add these bounced emails with all
into an "optout" MSSQL table and include the date/time added.
This routine will also pull from mailchimp, all regular mailchimp users into our "optin" table that will hold email address, mailchimp list,
first/last name, as well as, add users to our mail chimp lists from our "optin" table.
We need to be able to send the console app which list we want to perform the "sync" on.
2nd-We need a small c# or vb.net form that will allow us,
-to add/modify text file ([url removed, login to view]) that will hold:
----the MSSQL: server IP(port number) address or DNS name of the SQL server
-----MSSQL ID and password or set to (WinAuth) if using Windows Authorization
-to add/modify/delete our mailchimp "lists" into a "lists" table
-to add/modify/delete the "optin" OR the "optout" user tables
We must be given all of the complete source files and projects.