CSVee Plugin Problems
Development and Programming
I wonder if anyone could help me. I am using the CSVEE plugin and the code below to download a csv of member info and one member custom field from certain member groups. My problem is that I am getting results from all member groups not just the pipe delimited selected group_ids.
{exp:csvee group_id="1|6|9" query="SELECT m.screen_name, m.username, m.group_id, m.join_date, d.m_field_id_1 FROM exp_members AS m LEFT JOIN exp_member_data AS d ON d.member_id = m.member_id" filename="ggp-subscribers-list.csv"}Also do you know if its possible to format the display of m.join_date to read as a date rather than the amount of seconds from 1970, the start of the unix epoch, ala “1202917350”?
Thanks
This was resolved via PM. Thought I would just add the remedy here for the future; The group_id=”” param is used only to instruct which member groups can download the csv and in no way affects the query.
A for the join date formatting (not plugin specific):
SELECT m.screen_name, m.username, m.group_id, date_format(from_unixtime(m.join_date), '%d-%m-%Y') as join_date, d.m_field_id_1 FROM exp_members AS m LEFT JOIN exp_member_data AS d ON d.member_id = m.member_id WHERE m.group_id IN (1,6,9)And thanks again to Daniel. Mea culpa for not posting solution for you.