Link to home
Start Free TrialLog in
Avatar of PortalSlave
PortalSlave

asked on

Is there a way to export a SharePoint group to an excel file?

I am going to export a SharePoint Group to an excel file and it is not working.  Can anyone help me?  There is no export option for security groups
Avatar of papushka
papushka

well there is no way to export to excel, however if you are just looking to get a list of users added to the site you could run an export on the site and use the switch -includesecurity (dirrect the outpout to text >>export.txt or just look at the export.log) it should give you the list.

http://technet.microsoft.com/en-us/library/cc262759.aspx
switch is -includeusersecurity
I'm not aware of any OOTB feature in SharePoint site or in SPD to make this happen.

You can look at some programmatic way of generating this detail:



SPSite mySiteCollection = new SPSite("http://servername/");
SPWeb site = mySiteCollection.AllWebs["Site_Name"]; 
SPGroupCollection siteGroups = site.SiteGroups; 
 
foreach (SPGroup group in siteGroups) 
{ 
   // this never runs!
   string s =  group.Name; 
}

Open in new window

Avatar of PortalSlave

ASKER

Hi MeiMc,
I did try that but we do not have SIP configured and this is for a SharePoint Security group with Contribute access.  I do not know how to grab the ListID or ViewID for this security group.  It seems like the export to excel would work but it gives all the groups and users for the site collection.  
Thx,
PortalSlave
ASKER CERTIFIED SOLUTION
Avatar of MelMc
MelMc
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi MeiMc,
Here is some info on SIP http://www.voip-news.com/sp/itx/sipswitchfaq.htm#g1. In the example, the screenshot showed Call/Message Selected users which requires SIP to be enabled with SharePoint probably using Microsofts Live Communication Server.

I will try your suggestions.

Thanks,

PortalSlave