In Progress

SQL to Mailchimp Integration

We have an existing Microsoft SQL 2008 database that we would like to integrate with MailChimp. The requirements are to write a connector that extracts the appropriate information fields from the SQL database (using Stored Procedures developed by us) and updates the MailChimp database on a daily basis. This will be a two way street.

We will provide stored procedures to do the following:

1. Zero parameter stored procedure that will gather information from our database and provide a dataset. This dataset will then need to be verified against MailChimp's Database. If there is an existing list then update the contact information within the list. If there is no existing list then create a new list with the dataset. The following dataset will be returned initially: (*** needs flexibility to add more columns in the future. ***)

-Email Address

-Contact Name

-Title

_School Name

-OrgClass

-City

-State

-Postal Code

-Phone Number

-Extension

-Fax Number

-Organization Shipments

2. One parameter (email) stored procedure that will update our system's mailing lists for users that unsubscribed.

3. One parameter (email) stored procedure that will update our system's mailing lists for users that bounced.

The program will need to do the following:

[url removed, login to view] Subscribe users with data from sql 2008 database with a column (e.g. Email, FirstName, LastName, Category, Business, etc.) *** needs flexibility to add more columns in the future. ***

2. Unsubscribe users by passing an email parameter into the stored procedure mentioned above.

3. Unsubscribe bounced users by passing an email parameter into the stored procedure mentioned above.

We will create a table within our system (EmailLists) that will contain the following:

-Index - int identity

-MailChimpID - varchar(100)

-ListName - varchar(100)

-EListSproc - varchar(100)

-UnsubSproc - varchar(100)

-BouncedSproc - varchar(100)

-Active - bit

-LastListSync - datetime

-LastUnsubSync - datetime

-LastBounceSync - datetime

The program must be able to scan the table and find programs that have not been synced within 24 hours per task. Any program meeting this criteria must then use the parameters stored within the table columns to call the appropriate stored procedure per task. The appropriate sync column timestamp must be updated once the task has been completed:

The technology we currently use is:

- .Net Frameowrk 4.0

- Console Application

- Sql Server 2008

- Visual Studio 2010

- C#

Skills: .NET, C# Programming, SQL

See more: mailchimp sql, mailchimp sql mailing list, mailchimp sql integration, sql mailchimp, mailchimp sql server, integrate mailchimp net, mailchimp database integration, integration mailchimp net, mailchimp create list sql, sql database integration mailchimp, mailchimp integration sql, mailchimp sql database, sql database program, sql database business, index bit, find net business, email mailing lists, bit index, mailchimp batch unsubscribe, find mailing address, call lists, timestamp, stored procedures, sql microsoft, sql integration

About the Employer:
( 1 review ) Erie, United States

Project ID: #1261827

10 freelancers are bidding on average $458 for this job

MMaghawry

I'm professional in .Net with SQL Server , so please let me do it , noting that I should be done as a windows service not as a console.

$500 USD in 8 days
(53 Reviews)
5.7
sikandermandal

Please see pmb.

$500 USD in 5 days
(22 Reviews)
5.4
subhanisaleem

hi plz check pmb

$500 USD in 20 days
(5 Reviews)
5.1
tuyenvt

Dear Sir,I can do it,Please see my profile for details.Thanks

$300 USD in 10 days
(13 Reviews)
4.7
thingfixwhencome

Please see the PM

$250 USD in 11 days
(5 Reviews)
4.1
PARMJEETKUMAR

Hi, I am Parmjeet Kumar having 4 years experience in asp.net, MVC 2-3 and MVP. My specialty is in Microsoft Technology's. I can build application in 3 tier and also in N tier structure have strong skills in Mail Chimp More

$300 USD in 7 days
(4 Reviews)
2.8
mjguru

Hi, please check your private message. Thanks

$350 USD in 7 days
(0 Reviews)
0.0
MDCTAS

Please See PMB.

$500 USD in 7 days
(0 Reviews)
0.0
aboujosef

waiting for your reply

$500 USD in 15 days
(0 Reviews)
0.0
ghazanfarkavish

Dear Sir/Madam, I'm a certified database administrator have a quality experience in SQL Server 2000/2005/2008 R2,database design, database administration and MS BI (SSIS,SSAS,SSRS). I'm very interested in your job pos More

$480 USD in 5 days
(1 Review)
0.0
logac

Our business consultants have significant consulting and industry experience to implement best business practice and have proven project management skills. Our technical consultants are experienced in modifying and enh More

$750 USD in 20 days
(0 Reviews)
0.0