[Forum] Making a .CSV list of member emails for upload to Vertical Response

[findagroomer]

If you use the email tools - Vertical Response service, the VR site wants you to create a .CSV list of member emails in Vb to upload.

Anyone know how I do that?

Thanks in advance.

[findagroomer]

Wait! Found it! Thanks.

[kirstie]

I'm having the same issue. How did you export the list to .csv?

[alkrida]

any one can let us know how to do so

[Wayne Luke]

Users -> Generate User List.

[jdj]

Sorry if this is an old question: I can't find any answer more current or relevant than this.

I've noticed that if you want to generate a CSV file to update your Vertical Response master list then you do this by going to admin cp, users, generate mailing list.

What do you put in here if you don't want just email addresses, you also want user names in order that you can insert into your mailing "Hello[username]". ?

[Wayne Luke]

With that tool, there isn't an option. You can try the newer Email Tools -> Upload List if you have SOAP installed within PHP and a Vertical Response account already.

[jdj]

With that tool, there isn't an option. You can try the newer Email Tools -> Upload List if you have SOAP installed within PHP and a Vertical Response account already.

Thanks. I'm not familiar with "SOAP" but if I get time I'll look into it and for now I'll just proceed with email addresses.

What I'm trying to do is generate a CSV file to upload to my master list in Vertical Response.

From the admin cp I can see I go to Users, Generate Mailing List.

I can see that I select the group I want and criteria I want.

In the box I'm choosing "," for commas and quotes then hitting enter as I'm assuming there's some value in having each address on a separate line. That generates me a mailing list within the box in the admin CP.

Having pressed "submit" I get a list of email addresses. However, there's no option that I can see to export this list to a CSV or other file. There's no "extract" button to export to a XML file for example as we would have if we were exporting a style.

If I copy the entire list to excel using copy and paste the "," extension comes up after the end of each email address.

So how do I extract the list generated in the admin cp into a file that is uploadable to Vertical Response in order to update the master list? There's nothing about this in the manual, I can't see anything on this forum.

PS: Just discovered by trial and error that if you ignore the instructions in the admin CP to include "," for "commas and quotes" and put a space in instead with nothing else that gets you a mailing list which you can then copy and paste to excel without "," appearing at the end of each email address. So that then gives you an excel file that you can save as a CSV file.

So I can't now see the point of the instructions suggesting ",". Have I missed something obvious? An extract button or something else?

[Wayne Luke]

Under Email tools there is Submit List which submits the list to Vertical Response in the format they wish to use.

[jdj]

Under Email tools there is Submit List which submits the list to Vertical Response in the format they wish to use.

Under my "Email tools" section in the admin CP I can see

Vertical Response (plus the registered trademark symbol)
Upload List

Presumably what you mean by the "Submit List" must be the "Upload List" option, or is there a missing field that I need to enable somewhere?

PS:

Just trying this out now. The options that come up are:

"Select an existing VerticalResponse® list to overwrite it with the contents of your selection below.
Enter a new VerticalResponse® list title. (This will take precendence over the selection above if applicable.)
Number of users to be processed per cycle. If you have many users and enter too large a number here, then the process will time out. VerticalResponse® limits the uploads to 40,000 records max.

There are no options to update the master list, only to overwrite it: We've just tried the option "overwrite" master list, the software whirs away and seems to be doing something. However, if we then go into Vertical Response and look at the master list the number total it gives us hasn't changed at all. So in summary the option to "overwrite" does not seem to work and there's no option to "update". And we've just tried the "Enter a new Vertical Response List Title" option and hit the upload button. Once again the software whirs away; when we go into Vertical Response the new list title comes up in our available lists. But the total number of people on the list is exactly the same as the master list, even though we know it should have changed because we've had a lot of new registrants since we last mailed our users.

Looks like I have to go back to excel and a manual CSV file upload because doing it from the only options we can see from the admin cp doesn't seem to work.

Just tried again by manually uploading CSV file and got it to work.

For anyone else trying to do this manually with CSV there's a Vertical Response article on it here.

[jdj]

Our feedback on Vertical Response.

We've tried Vertical Response for a while now rather than the built-in emailing feature in vBulletin.

Feedback from the admin on our site who does our mailings (and is less computer literate than me) is that exporting the data you need to MailChimp and using MailChimp is much easier than using the in-built Vertical Response feature in vB4. She says that it's an order of magnitude easier.

Furthermore, her feedback is that Vertical Response don't tell you who has unsubscribed where as MailChimp do. So in effect by using Vertical Response you become tied in to using them because ultimately they end up owning your mailing list.

I don't know whether this will be changed with the closer integration of Vertical Response in vB5 but we're going to be using MailChimp for now. If there is no feedback mechanism from Vertical Response to your vB installation telling you who has unsubscribed then it's unlikely we'd be using Vertical Response even in vB5.