[Roy Bucklin]

Is it possible to download the membership list in an excel, database or other format?

[Steven Zahm]

@ Roy

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!

[Murray Summers]

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?

[Steven Zahm]

@ Murray

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 .

[Murray Summers]

Thanks, Steven.

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…

[Roy Bucklin]

How will I know when the CSV Export will be added?

Thanks,

Roy

[Steven Zahm]

@ Roy

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.

[Steven Zahm]

@ Murray

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.

[Author]

Posts