Support has been upgraded!
The Support Forum is closed. Not to worry! Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.
Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?
Please open a Support Ticket in your user account.
Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.
Please open a new support topic in the WordPress support forums for Connections.
- This topic has 7 replies, 3 voices, and was last updated 8 years, 2 months ago by Steven Zahm.
09/03/2014 at 6:05 pm #302709Michael SeguinParticipant
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…09/04/2014 at 3:17 pm #302793
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.
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!09/04/2014 at 5:00 pm #302799Michael SeguinParticipant
@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!
Michael09/05/2014 at 12:17 pm #302877
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.09/05/2014 at 12:18 pm #302878
Oh, the ETA, I’m hoping before end of year … but you know how that can go, things always takes longer than expected.01/08/2015 at 12:40 pm #314458cheryl lymanParticipant
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.01/08/2015 at 1:05 pm #314471cheryl lymanParticipant
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. thanks01/09/2015 at 9:58 am #314571
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.
You cannot reply to this support topic. Please open your own support topic.