Community Support Forums

Hi,

Is there a way to generate custom member reports, that includes custom profile fields and login tracking? If not, is this something that will be added, maybe to the Pro version?

Thanks,

Dana

No response?
I need this as well. When I export my users to CSV I get a cryptic string.
tvta_wp_s2member_custom_fields
a:1:{s:9:"volunteer";a:3:{i:0;s:5:"LeadH";i:1;s:6:"TrailM";i:2;s:3:"Web";}}

I am working on a web site for a non profit volunteer organization. I myself am a volunteer. I can write a formula to extract what I need in excel but this is not user friendly. =MID(AK2, SEARCH("LeadH",AK2), 5)

We need to be able to export user information to excel so that we can extract data such a list of people who will volunteer for trail maintenance or a list of members in a certain postal code, or just simply get member's address and print address labels using MS Word mail merge.

Does anyone have any hints on the SQL code that I can use to exrtact data? I have the Exports and Reports By Scott Kingsley Clark which will generate custome reports but unfortunately while I can hack from examples I don't know SQL.

I need
first name
last name
membership level
s2member EOT
s2member custom fields such as the volunteer one in the example above and address fields.

Unfortunately the only way to output that data in the format you want is to create a script that queries the database and assembles the data in your preferred format. You might look here for a programmer that can help with this: s2Member Install Help / Projects / Custom Coding viewtopic.php?t=4158