A reader asked recently about getting a MailChimp list into FileMaker Pro.
The work that I did on the MailChimp integration demo was based on a project that I did a customer who wanted to start syncing an existing FileMaker data set with MailChimp, so we were starting with the data in FileMaker. It was not built to pull down existing records from MailChimp into FileMaker. In my client’s case, when new people sign up on MailChimp, a staffer views the new adds list on Mailchimp and then they add people semi-manually to FileMaker, so that someone is checking for duplicates.
Demo: FileMaker 12
Demo: FileMaker 7-11
Previous Articles on MailChimp and FileMaker Integration:
Download your MailChimp List

A simple approach is to download a list from Mailchimp, (click the download button at the right of your list view). Log into your MailChimp account and click on the Subscriber List you want to import into FileMaker.
Look for a ‘members’ file in your Downloads folder

This is the text file we will be importing into FileMaker.
In FileMaker select Import Records from the File Menu

In the Open File dialog box, set the file types to All Available so that the .csv file is accessible

Map the fields to import

Map the fields to the import by dragging the Target fields on the right up or down by clicking on the small up/down arrow next to the target field name. Make sure the little arrow in the middle is clicked, or no data will be imported into that field.
At the bottom of the Import dialog box, select the ‘Add New Records’ option.
Related Articles
Digital Fusion: Sending Email from FileMaker Using Mandrill
Trackbacks/Pingbacks
[…] See on hbase.net […]
[…] FileMaker MailChimp Integration – Part 5 of 4 – Importing FileMaker Mailing Lists into MailChimp. […]