Specify mailchimp list ID/Name for mysql sync

  • 182Views
  • Last Post 26 May 2017
0
votes
Soma posted this 24 May 2017

How do I specify the exact list ID for my sync with mysql

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 24 May 2017

Common recommendations for synchronization tasks with the ListMembers object (MailChimp):

- the task can be set for a specific ListId only; you should know the ListId and set it as Constant in the Task editor when specifying the mapping;

- you should select the "Use this value as filter of target objects" check box in the mapping for ListId column.

ListId mapping

To get ListId you can use:

- http://kb.mailchimp.com/lists/managing-subscribers/find-your-list-id

- Skyvia Query Tool , select New SQL and then select your MailChimp connection:

SELECT "Id", "Name" FROM "Lists"

0
votes
Soma posted this 24 May 2017

I am using Mysql not SQL. I want to integrate a specific list to a Mysql database table. In Mysql I am able to select the specific table to send data to, but in mailchimp I can't see the option to select list name/ID

0
votes
Mariia Zaharova posted this 24 May 2017

You are working with the Synchronization package with the MailChimp connection as Source and MySQL connection as Target, aren't you?

In this case, you should specify the mapping in the following way:

1) From Source to Target:

2) From Target to Source:

 

In this case, the data will be filtered by specific ListId value while synchronization from MailChimp to MySQL and this constant value will be used in the opposite direction.

For more information, please refer to: https://skyvia.com/resources/docs/index.html?constant_mapping.htm

Please tell us if this information helps.

 

0
votes
Soma posted this 25 May 2017

That was just a test I did. It is not exactly what I wanted to achieve. What I want is to replicate the entire list 2017 OLX SoMA Votes to the table votes_2017. I can't seem to find how to export the fields in that particular list to the specified mysql table

0
votes
Mariia Zaharova posted this 26 May 2017

Thank you for the reply. You can specify the filter conditions to filter data to replicate. For this, click the edit link for the corresponding replicated object in the replication package editor:

In the opened Task Editor window specify the necessary filter conditions:

 

Please note, at the moment, it is impossible to specify custom table for data replication. We will consider the possibility to implement options for table creation in the replication tasks in the future.

For more information about replication, please refer to: https://skyvia.com/resources/docs/index.html?replication.htm

Close