ISSUE SUMMARY:

The export users functionality currently generates a CSV file with basic Joomla user info (name, username, email, registration date, last login etc)

The export file does not seem to contain any Jomsocial fields.

I would like to export user info that includes Jomsocial fields as columns. I want to export the file to a newsletter and need information such as country and city, which are JS fields, for marketing purposes.

Is this possible with the current JS export functionality?

If not, what SQL function could i call on the jos_community_fields_values table to have user_ID as a row, and field_ID numbers as columns in a CSV file?

many thanks for your help,
Mark

Hi Mark,

Actually its export with Jomsocial fields and avatar URL as well, you should export it from Jomsocial members manager.

thank you!