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.
08/04/2015 at 6:25 pm #342218Roy BucklinParticipant
Is it possible to download the membership list in an excel, database or other format?08/06/2015 at 1:13 pm #342410
Later this summer CSV Export will be added until then the easiest way is to use phpMyAdmin from the web host’s control panel and download the Connections tables from the database as CSV files.
Hope that helps!08/12/2015 at 10:54 am #342861Murray SummersParticipant
Steven: Thanks for your good help with these nice plugins!
I have a member list with approximately 380 names, some of which are public and some are private. I am trying to read the connections table to extract only the emails for those marked as private (which I should easily be able to do with PHP/MySQL). However, when I print the extracted names along with their ‘visibility’ field, all of them show “public”, even though I can see that some are “private” in the data table. Short of using Navicat to extract and then export those names (which of course is a way to do it), I’d like to modify my extract files to only extract only those names that are legitimately marked as “public” or those that are legitimately marked as “private”. Can you think of anything special about how you are entering that “visibility” data into the table that would cause all to come across as public?08/13/2015 at 9:52 am #342959
What is the query you are running? It should be as simple as this to query only public entries:
SELECT * FROM `wp_connections` WHERE `visibility` = 'public'
Of course you’ll need to change the table name in the query and add the INNER JOIN for the email table on the id and entry_id .08/13/2015 at 12:39 pm #342969Murray SummersParticipant
I am using basically the same query as you –
$values = mysql_query(“SELECT * FROM “.$table.” WHERE ” . $field . ” = ‘public'”);
In my case, $table is set to “wp_connections” and $field is set to “visibility”. All records in the recordsset are showing a visibility of “public”. When I look into that same table with remote Navicat I can see that about half of my members are “private”. Well, this is surely beyond the scope of your support, but I just wanted to know if this rang any bells with you…08/13/2015 at 3:39 pm #343004Roy BucklinGuest
How will I know when the CSV Export will be added?
Roy08/14/2015 at 9:53 am #343022
It’ll show up as tool on the Connections : Tools admin page. This is the next feature I am working on starting next week. The version of Connections will be released with CSV Export will be 8.5.08/14/2015 at 9:56 am #343023
I don’t see any reason why that would not work. The queries in Connections are a bit more complex but basically, this is the query I use to retrieve public/private or unlisted.
You cannot reply to this support topic. Please open your own support topic.