AdminCP reporting feature - Members list to spreadsheet?

[Keith]

I've had a look around VB and VB.ORG for but can't seem to find what I'm looking for. The AdminCP allows me to generate a membership/user report on screen, but it's not something I can copy/paste into a spreadsheet like Google Docs. I need to do this in order to create a list for a hardcopy spiral bound membership directory we print and distribute to members each year.

Currently the existing AdminCP "member search" features allows me to get pretty granular in selecting search criteria, and I could probably even use the onscreen output if there was a delimeter between the fields.

Does anyone know of an existing mod to do this?

I'm probably over thinking this function, perhaps I can just do an SQL query long hand and generate such a report?

[Keith]

Still trying to figure out how I can tackle this. From all of our members, I simply want to create a report which shows 112 of our full fledge members (a particular usergroup) with all of their information and userfields which can be downloaded as a spreadsheet.

I thought there might be a hack for this, but there doesn't appear to be one. If that's the case, how challenging would it be to write a script to do this, or use SQL PHPMyAdmin to do it?

Thanks in advance for any insight and recommendations.

[kh99]

As it happens someone else was just asking about getting the user info from the db. You could try this is PHPMyAdmin:

SELECT user.*, userfield.* FROM prefix_user AS user
LEFT JOIN prefix_userfield AS userfield
USING ( userid ) 
WHERE usergroupid = 6 OR FIND_IN_SET( 6, membergroupids )

The parts in red you'll probably need to change: 'prefix_' to your table prefix if you have one (or delete otherwise), and the '6's to the group id you want.

After this executes you can choose "export" and get a csv or whatever you want.

This contains all the fields in the user and userfield tables. I know you won't be interested in some of them, some fields may not be in a useful format, and I'm not sure if there's anything else in the db that you may want to add, but it should get you started.

[Keith]

kh99,

Can't thank you enough for the reply, the format and idea is exactly what I needed to get started. I feel like a knucklehead because that was so easy, I guess I was thinking it would be a more complex process.

I used PHPMyAdmin and tweaked the query to suit what I wanted to pull out of the database and it worked great. After I pulled the data, I downloaded it in CSV format, imported it into the spreadsheet and deleted the columns I don't need from the extra userfields. Now I can send this to the Club Secretary and Board of Directors. Many thanks!!