[Michael Seguin]

Hi Steven et al. I see you created a freelancer post for this almost a year ago and there was a winning bid… can I assume that means that there is an export function and I am just too silly to find it? I searched and while I see several references to your intention to create this functionality for pro features, dating to circa 2009, I cant actually find any reference to an existing feature?

I just need a simple csv export with name and email address for mailchimp integration. Open to suggestions…

[Steven Zahm]

@ Michael

I didn’t create a freelance post … I seem to recall seeing it though, awhile back. I may have a copy of it even, not sure for certain. But the scrip found here was donated by a user.
https://github.com/shazahm1/Connections-Export

This is NOT a plugin and it has a rather complicated setup but is reported to work quite well after it is.

If you just want to export the email address with first and last name…

Run the following query using phpMyAdmin:

SELECT first_name, last_name, address FROM wp_connections AS r INNER JOIN wp_connections_email AS e ON ( r.id = e.entry_id ) WHERE e.address != ''

**Make sure to change wp_ to the correct prefix or the query will fail.

After the query is run, there will be a export link at the bottom of the page. Click that and you can choose to export the query as a CSV file.

I grabbed over 15,000 email addresses and names from my test db in under a couple minutes.

Hope that helps!

[Michael Seguin]

@Steven – weird! Not that it matters, but this was the reference that I stumbled on in searching… https://www.freelancer.com/projects/PHP-Script-Install/Export-Feature-Added-Connections.html

In any event, I should have been more explicit – phpmyadmin is not a good option for me, as I need an end user to be able to grab the updated email list monthly. Moreover, phpmyadmin is not enabled by default on any of my hosts as it is just one more vector to worry about, but that is more of a personal issue.
C’est la vie, I was hoping for a visual/simple solution, but the php export script you shared will likely do the trick for me! FWIW I do think that this is a useful feature to have… a good rule of thumb IMHO is if you allow import, you ought to allow export!

Thanks,
Michael

[Steven Zahm]

@ Michael

Boy, were those underbid … there’s no way even at $250 due to the complexity involved and the time required to deal with that complexity in attempting to export all the Connections data out as a flat CSV file would be fair. If someone did win and build it, they lost their shirt, hope they do not have a family to feed!

That complexity is why I have not done it myself. Trying to export Connections data as a flat CSV file would be the same as trying to export WordPress data as a CSV file … which is why their export is XML (sort of).

With all that said … I am planning on including a CSV Export in the free core plugin, they’ll be caveats to the exported data. What exactly those caveats will be at this point I do not know but I;m sure they’ll be very similar to the caveats in the script I linked to.

[Steven Zahm]

@ Michael

Oh, the ETA, I’m hoping before end of year … but you know how that can go, things always takes longer than expected.

[cheryl lyman]

Is the export feature ready? I need to be able to export the info and pics so that I can have a hard printed copy of our directory. We only have several hundred in ours.

[cheryl lyman]

if this hasn’t been released yet, can someone tell me how to use the file listed above that you download? i’m not technical but need way to export. thanks

[Steven Zahm]

@ cheryl

Sorry, but there is not a simple, non-technical way, to do a CSV export. Right now this is set to be included in the 8.2 release.

[Author]

Posts