Using the phpMyAdmin console, I ran an SQL query on the Membership Pro database, table ..._Subscribers, selecting various fields, with specific criteria.
Oops, my SQL statement was blocked, so I'll make a fake one that shows what I was trying to do:
SEL field1, field2, field3, field4 ... field10 FR subscribers WH status=1
Then I export the result to an Excel CSV file.
Is it possible to do this from the front end?
I tried to use the Member List plugin, but it really isn't intended for this - can't select fields and can't download easily.
Is there another plugin I need to use, or some another way to do this? I do not know PHP, so that's not an option.
*** We can always do this manually from phpMyAdmin, but it would be nicer to allow our membership person to do this herself.
*** The other alternative is to export the subscribers list to an CSV file and manually get rid of unwanted columns, rows, reformat, etc.
We will use one of these methods if there isn't another simple way to do this.
Thanks,
Darlene
-
