MySql Data is not pusing to Mailchimp Listmembers Table

  • 135Views
  • Last Post 22 July 2019
0
votes
rahul kumar posted this 22 July 2019

In the screenshot below I select Source as CSV to import contact from the computer and push the data to the target Mailchimp Listmembers table. When pressing on run button it shows 4 errors row and 0 success rows and why did that failed?

 

I even tried doing by  selecting Source as Mysql to import contact from the database and push the data to the target Mailchimp Listmembers table. When pressing on run button it shows  errors row and nothing on success rows. why is that?

 

 

 

Where can i find the following tables in mailchimp? In my mailchimp account I added extra fields for the contacts which i dont see in none of the tables below.

Attached Files

0
votes
Mariia Zaharova posted this 22 July 2019

Hi Rahul!

 

Your package fails due to the incorrect mapping for ListId column. You are mapping it with the Email column while ListId column cannot contain email address. Please look at this link http://kb.mailchimp.com/lists/managing-subscribers/find-your-list-id

 

Thus, you need to know your ListId value and use Constant mapping in order to import new contacts to this list. For example:

 

Also we recommend you to look at https://support.skyvia.com/thread/import-and-update-list-memebers-to-mailchimp/

 

As for tables, Skyvia works with MailChimp via its API: https://developer.mailchimp.com/documentation/mailchimp/reference/overview/

 

Do not hesitate to contact us with any further questions.

Close