Export members to Excel

Vote:
 

Is it possible to export community members to Excel? How?

/Jonas

#51149
May 25, 2011 13:43
Vote:
 

Guess you need to make your own code

you can find all the members like this

foreach (MembershipUser membershipUser in System.Web.Security.Membership.GetAllUsers())
{
    IUser user =  CommunitySystem.CurrentContext.DefaultSecurity.GetUserByUserName(membershipUser.UserName);
    

    

#51159
Edited, May 25, 2011 19:42
Vote:
 

Is this a one-time thing or something you want to do regularly?

As a one-time-thing, you have all the users in an SQL Server table, tblEPiServerCommonUsers. If you want to do this regularly, you'd want to use code to do it. Going directly to the Community APIs is the most efficient way:

foreach (EPiServer.Common.Security.IUser user in EPiServer.Common.Security.SecurityHandler.Instance.GetUsers())
{
    //user.UserName
    //user.EMail
}

#51631
Jun 17, 2011 16:03
This thread is locked and should be used for reference only. Please use the Legacy add-ons forum to open new discussions.