Hey,
This code should do the trick. It will need to be modified to fit your needs of course. The $_GET['x'] was implented to gather columns as this was made to break down a massive csv into specific lists.
set_time_limit(15000);
require 'ConstantContact.php';
// Authentication to Constant Contact
$ConstantContact = new ConstantContact("basic", "YOUR APIKEY", "YOUR USERNAME", "YOUR PASSWORD");
// Set row value
$row = 1;
// Start the URI of which to pass to bulk activities
$BeforeEmailAddress = "activityType=SV_ADD&data=Email+Address";
// set value of totalContacts
$totalContacts = 0;
// Used for to pass in the column number for large CSV
// You may want to remove this depending on your integration
$x = $_GET['x'];
if (($handle = fopen("YOURCSVFILE.csv", "r")) !== FALSE) {
// itterate through rows
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
// how many columns are in a row
$num = count($data);
// use echo for testing
//echo "<p> $num fields in line $row: <br /></p>\n";
$row++;
// $c = 0 if your not using X;
// data[0] is your first column, this needs to contain your email address
for ($c=$x; $c < ($x+1); $c++) {
// Checks for value of "x" as this meant that the contact
// belongs to the current column list
if ($data[$c] == "x" && $totalContacts < 20000) {
$emailAddress .= "\n" . $data[0];
$totalContacts++;
// Bulk activities have a limit of 20k contacts you must have more than 20 contacts
// to submit the contacts via bulk activity
// if contacts are over 20k then you need to start a new activity
}else if($data[$c] == "x" && $totalContacts >= 20000){
$emailAddress2 .= "\n" . $data[0];
$totalContacts++;
}
}
}
// $lv sets your list value and $c can be added to or subtracted to offset difference in list value
// for example, column in excel = 3 but list = 4
// $lv = $c +1;
$lv = $c;
$list = "http://api.constantcontact.com/ws/customers/YOURUSERNAME/lists/".$lv;
fclose($handle);
}
// Echo's the string to verify that you are targeting the correct information to the correct list
echo $BeforeEmailAddress.urlencode($emailAddress)."&".urlencode($list);
// Remove below echo statement to make this script active, always test as your contacts may go to the wrong list
//echo $ConstantContact->bulkAddContacts($BeforeEmailAddress.urlencode($emailAddress)."&lists=".urlencode($list));
// Start second bulk load activity if more than 20k contacts existed.
if(isset($emailAddress2))
{
//echo $ConstantContact->bulkAddContacts($BeforeEmailAddress.urlencode($emailAddress2)."&lists=".urlencode($list));;
}
// Tells you how many contacts were uploaded to which list id.
echo $totalContacts . " Have been uploaded to " . $list;
?>
You do need the wrapper to use this which is found under code samples.
Let me know if this helps.
Ryan Davis
Quality Engineer
