cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting multiple Contact Lists to CSV

Highlighted
New Member

Exporting multiple Contact Lists to CSV

I've been having a great time using the V2 API.  Hopefully someone can sanity check me on something that I am observing with trying to export multiple Contact Lists via Bulk Activities.  My end goal is a CSV for all Contacts.

 

I am using the most current .NET SDK ( https://github.com/constantcontact/.net-sdk ).

 

It seems that when I submit an Export Contacts Activity with multiple lists - I only ever get back the first list in the array of list numbers.

 

Given two lists 1 and 54:

 

1 - ACTIVE - Count = 1

54 - HIDDEN - Count = 744

 

var exportContactsConfig = new ExportContacts
{
    Lists = new[] { "1", "54" },
    ColumnNames = new[] { "Email Address", "Custom Field 1", "Custom Field 2" },
    ExportAddedBy = false,
    ExportDateAdded = false,
    FileType = "CSV"
};
var exportActivity = _api.AddExportContactsActivity(exportContactsConfig);

 

Will result in a CSV file with 2 records (header and one contact).


Changing the Lists property to new[] { "54", "1" } will result in a CSV file with 745 records.

 

Please let me know if there's something I am missing entirely or if this should be an issue with the .NET SDK project.

 

Thank you.

16 REPLIES 16
Moderator

Re: Exporting multiple Contact Lists to CSV

If your goal is to export all of your active contacts, I would recommend using the system list ID "active" instead of numbers. This will give you an export of everyone who you have permission to mail to and is one or more email lists. 

 

We'll take a look at the export not allowing you to specify multiple lists.  Will update when we have additional information.

Dave Berard
Senior Product Manager, Constant Contact
Moderator

Re: Exporting multiple Contact Lists to CSV

We looked into the multiple lists question.  Our documentation is correct, only a single list is currently able to be exported (though this is subtle in the documentation).  We are going to update our schema validation so that it throws an error if you specify more than one list in the request.  If we are able to support multiple lists at the same time in the future, we will update the documentation, schema and announce the update in our release notes.

Dave Berard
Senior Product Manager, Constant Contact
Visitor

Re: Exporting multiple Contact Lists to CSV

Hopefully I'm in the right thread but not allowing to select multiple lists in order to export is a major omission.  I want to export multiple lists and the only way to do it is select one list at a time instead of all of them?  It does not make too much sense to me.  Hopefully this feature will be available soon in the near future.

Moderator

Re: Exporting multiple Contact Lists to CSV

Thanks for the feedback.  We definitely want to add this functionality and the good news is that it will be available in our new Contact Management system we are rolling out now.  Unfortunately, we will not be able to add this feature to the API until we have finished migrating all of our customers to the new platform.  At that time, we will be able to start exposing out all of the great new functionality the new platform provides to our customers through the API. 

 

This is in the list of items to add and, in fact, we prepared for this already by having the lists you export an array.  Once we finish the migration and implement this, we'll change the restriction from one list in the array to multiple lists in the array. While I can't provide an exact timeline of when we can get this, we are expecting to see lots of new Contact Management features start to come out through the API this summer.

 

As always, you can learn more about functionality added to the API in our release notes on the TechBlog http://techblog.constantcontact.com/

Dave Berard
Senior Product Manager, Constant Contact
Occasional Participant

Re: Exporting multiple Contact Lists to CSV

if you had a column showing which list an email is contained in when in "view all contacts" along with the current options of "date added" "source" etc. and the ability to sort the list column it could be a simple if more tedious workaround

Member

Re: Exporting multiple Contact Lists to CSV

Hi Dave,  

 

When doing a google search for help on exporting multiple lists instead of single from constant contact I stumbled upon this thread and would like to know if this has yet been added to the functionality as I have numerous lists to export and would be grateful for a bulk export function.

 

Regards,

Michele

Honored Contributor

Re: Exporting multiple Contact Lists to CSV

Hello Michele,

 

Thanks for reaching out about this! While we do have bulk export available, it is currently still limited to exporting a single list at a time. Dave is unavailable before the end of the week, but I will see if I can get in touch with him to get you some details early next week!

 

Sincerely,

Elijah G.
API Support Engineer
Moderator

Re: Exporting multiple Contact Lists to CSV

Thank you for passing along this feedback.  Elijah is correct, at this time we still not have the ability to select and export multiple lists in our product.  We have taken some feedback on this, as shown by this thread, and we use feedback like this to help us prioritize work.  At this point, the customer feedback has been pretty low for this feature and we do not have any immediate plans to add this to our product.

 

Depending on what your usecase is, you have a couple of alternative options which may not be ideal but can accomplish your goal:

 

1 - If you want to simply export all your contacts who are on any list, you can create a new list and merge all your other lists into that newly created list.  This will make a unique collection of all your contacts who are on at least one list.

 

2 - If you are trying to get an export of which contacts are on which lists, you can go into each list, select all contacts, click Manage Tags and add a tag with the list name on it.  Do this once for each list.  After that, follow step 1 above and merge them into a single list.  Then when you export that list, you will have a Tag that identifies each list a customer was on.

 

I know that this is certainly not ideal but it should allow you to accomplish your goal.  Can you share any additional information into why you are looking to export more than one list?  We try to approach all of our work from a "what problem are we helping our customers solve" so we can provide the best tools possible.  It will help us a lot more to understand what you are trying to accomplish.

Dave Berard
Senior Product Manager, Constant Contact
Visitor

Re: Exporting multiple Contact Lists to CSV

You are right all the alternative options you mentioned are not ideal to say the least.

I'm suprised not many people have requested this.  

Why have this option when you send an e-mail i.e. select the lists that you want to send the e-mail to and not have this option when you want to export lists?