Support forums

Forum Home  >  Add-on support  >  Export  >  Thread

Search     Advanced Search

   
 
member_group  
Brian Coult
 Posted: 06 March 2012 05:54 PM —   [ Ignore ]  
Newbie
Rank
Total Posts:  10
Joined  2010-04-19

For some reason or other i dont seem to be able to pull out the member_group into this list.. the code below doesnt seem to work

{exp:ajw_export sql="SELECT screen_name, member_group, email FROM exp_members" format="csv" filename="memberlist.csv" } 
Profile
 
 
Andrew Weaver
 Posted: 06 March 2012 06:14 PM —   [ Ignore ]   [ # 1 ]  
Administrator
Avatar
RankRankRankRank
Total Posts:  1085
Joined  2006-04-12

Is it group_id rather than member_group?

Not online at the moment to check, sorry.

Andrew
Profile
 
 
Brian Coult
 Posted: 06 March 2012 06:59 PM —   [ Ignore ]   [ # 2 ]  
Newbie
Rank
Total Posts:  10
Joined  2010-04-19

Group_id seems to just return the number… so for example 8 or 9… where as i want the group.. its not super time sensitive Andrew.. just as and when you get chance.

Thanks
Profile
 
 
Andrew Weaver
 Posted: 06 March 2012 07:23 PM —   [ Ignore ]   [ # 3 ]  
Administrator
Avatar
RankRankRankRank
Total Posts:  1085
Joined  2006-04-12

I think that ill be:

SELECT exp_members.screen_name, 
 exp_member_groups.group_title, 
 exp_members.email
FROM exp_members INNER JOIN exp_member_groups ON exp_members.group_id = exp_member_groups.group_id 

The member group name is in a different table

Andrew
Profile
 
 
Brian Coult
 Posted: 07 March 2012 12:43 PM —   [ Ignore ]   [ # 4 ]  
Newbie
Rank
Total Posts:  10
Joined  2010-04-19

Thanks Andrew… will give that a go! much appreciated.
Profile
 
 
   
 
 

‹‹ EE1 Version      select specific fields ››

Select A Theme