PoshCode Archive  Artifact [e2bb2501f9]

Artifact e2bb2501f99596c8a6885f265d08f152802cdcfd9a9c91cf1831b5ae0c681c66:

  • File MailChimp-GetDistributio.ps1 — part of check-in [8932cff6db] at 2018-06-10 13:26:18 on branch trunk — A quick little script to get members of a Distribution Group to sync with MailChimp instead of using Active Directory. (user: Tozzi June 2012 size: 2020)

# encoding: ascii
# api: powershell
# title: MailChimp GetDistributio
# description: A quick little script to get members of a Distribution Group to sync with MailChimp instead of using Active Directory.
# version: 1.3
# license: CC0
# x-poshcode-id: 3479
# x-archived: 2015-12-06T18:40:34
# x-published: 2012-06-25T09:45:00
#
#Author: Tozzi June 2012
#OriginalAuthor: Ant B 2012
#Purpose: Batch feed recipients to MailChimp

$ie = new-object -com "InternetExplorer.Application"

# Vars for building the URL
$apikey = "api-key-from-mailchimp"
$listid = "list-id-from-mailchimp"

# Important is to use correct MailChimp data centre. In this case us5, yours might be different
$URL = "https://us5.api.mailchimp.com/1.3/?output=xml&method=listBatchSubscribe&apikey=$apikey"
$URLOpts = "&id=$($listid)&double_optin=False&Update_existing=True"
$Header = "FirstName","Lastname","PrimarySmtpAddress"
$GroupName = "distribution-group-name"

# Get members of the group
$DGMembers = Get-DistributionGroupMember $GroupName | select FirstName, Lastname, PrimarySmtpAddress

# Copy the array contents to a CSV for comparison on the next run, we'll use it to look for removals
if (test-path "C:\submitted.csv") {
	Clear-Content submitted.csv
}
$DGMembers | select PrimarySmtpAddress | export-csv C:\submitted.csv

# Check for the CSV created above and dump it to an array for comparison
if (test-path "C:\submitted.csv") {
	$list = Import-CSV -delimiter "," -Path C:\submitted.csv -Header $Header
}
$Removals = compare-object $DGMembers $list | Where {$_.SideIndicator -eq "=>"}

# Loop through the array of group members and submit to the MailChimp API
ForEach ($ObjItem in $DGMembers)
{
	$batch = "&batch[0][EMAIL]=$($ObjItem.PrimarySmtpAddress)&batch[0][FNAME]=$($ObjItem.FirstName)&batch[0][LNAME]=$($ObjItem.Lastname)"
	$MailOpts = "&batch[0][EMAIL_TYPE]html"
	$FURL = $URL + $batch + $MailOpts + $URLOpts
	Write-Host $FURL
	$ie.navigate($FURL)
	Start-Sleep -MilliSeconds 300
}