SharePoint Bhagavad gita

Search This Blog

How to find Windows Server 2008 license type

March 04, 2014

Get link
Facebook
X
Pinterest
Email
Other Apps

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Export SharePoint Group to Excel using PowerShell

$siteUrl="SiteURLHere" $groupName="GroupNametoExport" $Output = @("GroupName|Name|Login|Email|Department|Title") $web = Get-SPWeb $siteUrl $site = $web.Site $rootWeb = $site.RootWeb $UserList = $rootWeb.Lists["User Information List"] $web.SiteGroups[$groupName].Users|%{$user = $UserList.GetItemById($_.ID) if($user -ne $null) { $JobTitle = $user["JobTitle"] $Department = $user["Department"] } $Output += ($groupName+"|"+$_.Name+"|"+$_.UserLogin+"|"+$_.Email+"|"+$ Department +"|"+$JobTitle) } $rootWeb.Dispose() $web.Dispose() $site.Dispose() $Output > "D:\MembersExport.csv" Import Users from Excel to SharePoint using PowerShell # Import the .csv file, and specify manually the headers, without column name in the file $userList=IMPORT-CSV C:\UserToUpload.csv -header("GroupName","UserName") #Get the site name to the variable ...

Submitting InfoPath data to a SharePoint list

InfoPath data can be stored anywhere, in any database, even in a text file. Sometimes, there is a need to store the data somewhere else other than the library itself. The form that is submitted and saved in Forms library is an XML form and contains data. This data can also be submitted to other locations when user clicks the submit button. In this article, we will see how we can store this data in a SharePoint list. 1. Create a custom list in SharePoint with the following fields: a. FirstName b. LastName c. Address d. Zip e. City f. State g. Country h. Phone i. Fax j. Web Data type for all the fields will be "Single line of Text". 2. Open "user registration" form in editor. 3. Open VSTA 4. Add reference to "Microsoft.SharePoint.DLL". There are some steps that you need to take before adding the real code. We covered these steps in previous articles but just in case, if you landed directly on this page, here are the steps again: 5. Add a event handler in ...

Template copy

Powered by Blogger