Reply To: How can I export?

09/04/2014 at 3:17 pm #302793
Steven Zahm
Keymaster

@ 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!