Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>First, I think you need a developer.</p> <p>Second, I don't know Zoho, but, here's what I do know...</p> <p>The <a href="http://apidocs.mailchimp.com/api/1.3/" rel="noreferrer">MailChimp API</a> provides everything you need. The use of <a href="http://apidocs.mailchimp.com/webhooks/" rel="noreferrer">web hooks</a> will also help maintain that sync. In the past I have had a similar situation in which:</p> <ol> <li><p>When a user subscribes (to the list or opts in/out of groups) the information on the MailChimp list is updated using the <a href="http://apidocs.mailchimp.com/api/1.3/listsubscribe.func.php" rel="noreferrer">listSubscribe</a> API call with double_optin=False and update_existing=True. We were doing the double-optin on our side and the update_existing allows both subscriptions and updating the group.</p></li> <li><p>A web hook was setup to capture subscribes, unsubscribes, and profile updates and update our database. The way I was doing this, is using <a href="http://apidocs.mailchimp.com/api/1.3/listmemberinfo.func.php" rel="noreferrer">listMemberInfo</a> in the web hook to make sure I got the opt-in IP and time as well.</p></li> <li><p>I had a weekly cron that ran through all our users and synced them up just in case MailChimp was down when a user subscribed or something else along those lines. A little extra peace of mind.</p></li> </ol> <p>All that being said, I recently spent an entire weekend re-coding the software on our end to not longer need to maintain the redundant data. MailChimp has the subscription status, period. We only store the email address, last known status, optin time, and optin IP on our end. Any time the user makes a change on our site, it is immediately sent to MailChimp and anytime we query the user's subscription status it comes from MailChimp.</p> <p>For example, our "email settings" form is loaded by a call to <a href="http://apidocs.mailchimp.com/api/1.3/listmemberinfo.func.php" rel="noreferrer">listMemberInfo</a> and then the form handler saves the information to MailChimp with a call to <a href="http://apidocs.mailchimp.com/api/1.3/listupdatemember.func.php" rel="noreferrer">listUpdateMember</a> or <a href="http://apidocs.mailchimp.com/api/1.3/listsubscribe.func.php" rel="noreferrer">listSubscribe</a>. The MailChimp API will even pass what types of form fields to use for the groups (checkbox, select, radio). </p>
    singulars
    1. This table or related slice is empty.
    1. POHow Do I Achieve Mailchimp List + External Database List Status Synchronization?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USMicah Carrick
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload