WordPress.org

Ready to get started?Download WordPress

Forums

Constant Contact for WordPress
Importing lacks support for multiple columns in CSV (5 posts)

  1. benknight
    Member
    Posted 3 years ago #

    Trying to import anything except CSV files with a single column of email addresses causes the plugin to make an Invalid API request. Seriously?

  2. jamesbenson
    Member
    Plugin Author

    Posted 3 years ago #

    It could be many reasons why this fails, without the files your talking about I have no way to know what your uploading.
    Presumably it's a text file with one email address per line?
    If that's the case I think you have to include an EmailAddress column but please read the docs at constant contact as I'm unsure.

  3. benknight
    Member
    Posted 3 years ago #

    Here's the CC docs regarding uploading CSVs:
    http://constantcontact.custhelp.com/cgi-bin/constantcontact.cfg/php/enduser/std_adp.php?p_faqid=2523

    Essentially there's no strict formatting guidelines - it will accept any CSV in which there's a column of email addresses. They also have information regarding contact details and a reference for which headings to use, but this is optional.

    As I was troubleshooting the plugin, I ultimately narrows my CSV file down to one column of email addresses, followed by one column of numeric IDs (integers, no quotes) and the results were that WITH the column of IDs, the upload failed, with an error message of "Invalid Request". Removing the column of IDs resulted in a successful import of the contacts.

    I can email you a copy of the CSV file I used for testing if you like!

    Thanks for your quick reply.

    Ben

  4. Zack Katz
    Member
    Plugin Author

    Posted 3 years ago #

    Hi Ben,
    We'll include a fix for this in a future upgrade. Thanks for bringing it to our attention.

  5. jamesbenson
    Member
    Plugin Author

    Posted 3 years ago #

    This was built based on the link you gave, if your trying to include an ID and it's failing I reckon it's because constant contact don't like that.

    If your importing contacts the file should like exactly like the txt or CSV examples on this link because the plugin parses the file you upload, if I remember this correctly:
    http://constantcontact.custhelp.com/cgi-bin/constantcontact.cfg/php/enduser/std_adp.php?p_faqid=2523

    I've not tested or used this for a while so could be broke now for all I know :)

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic