Sharepoint PowerShell List of all site collections in Web Application

$xl=New-Object -ComObject "Excel.Application" $xl.Visible=$True $xl.Workbooks.Add() $ws=$xl.ActiveWorkbook.ActiveSheet $cells=$ws.Cells $i = 1 $sites = Get-SPSite -Limit All -WebApplication http://pc362/ foreach ($site in $sites) {  $cells.item($i,1)= invoke-command { $site.URL }  $cells.item($i,2)= invoke-command { $site.Owner.UserLogin }  $cells.item($i,3)= invoke-command { $site.SecondaryContact.UserLogin }  $cells.item($i,4)= invoke-command { $site.WebApplication.DisplayName }  $cells.item($i,5)= invoke-command {...

Read More

Sharepoint designer workflow update current item from lookup list based on current lookup field

Sharepoint designer workflow update current item from lookup list based on current lookup field 1. Create new custom list "Provinces". Rename Title to ProvinceID. Create new field ProvinceName (single line of text) 2. Create new custom list Employees. Rename Title to FullName. Create new field ProvinceID lookup to list Province and return ProvinceID.  Create new field ProvinceName (single line of text) 3. Create new workflow (list workflow) 4....

Read More

PowerShell copy list item to another list with same structure

Insert item from source list $web = Get-SPWeb http://yourURL $lista =$web.Lists["Source List Name"] $listb =$web.Lists["Target List Name"] $items = $lista.items foreach ($item in $items) { write-host -foregroundcolor yellow $item["Title"] $newitem= $listb.items.Add() $newitem["Title"] = $item["Title"] $newitem["MultiLine"] = $item["MultiLine"] $newitem["Number"] = $item["Number"] $newitem["HyperLink"] = $item["HyperLink"] $newitem["Choice"] = $item["Choice"] $newitem["Created"] = $item["Created"] $newitem["Author"] = $item["Author"] $newitem["Modified"]...

Read More

Listing All SharePoint Server Features of Web Application dynamic by power shell

Listing All SharePoint Server Features of Web Application dynamic by power shell 1. Writing the function to export all features of web application with parameter function Get-SPFeatureActivated { [CmdletBinding()] param(     [parameter(Mandatory=$true)][string]$Url,#Input your URL of web application     [parameter(Mandatory=$true)][string]$Path,#Input your file name which you want to export like (c:\features.csv)    ...

Read More

export and import lists and libraries full version and permission

How to export and import lists and libraries full version and permission Exporting# specify the site URL to export$web = Get-SPWeb "microsofttechnology.net/sites/sharepoint"# specify output folder to store exported lists$path = "D:\SharepointLists"foreach($list in $web.lists){"Exporting " + $list.RootFolder.URLexport-spweb $web.URL -ItemUrl $list.RootFolder.URL -IncludeUserSecurity -IncludeVersions All -path ($path + $list + ".cmp")}Importing # specify target SharePoint site to import into$site = "microsofttechnology.net/sites/sharepoint1"#...

Read More

Error SharePoint Designer does not support editing non-SharePoint sites

Error SharePoint Designer does not support editing non-SharePoint sites Close SharePoint Designer and Reopen it. The issue will be solved. Done!!...

Read More

What is a SharePoint Administrator?

The role of the SharePoint Administrator is often a topic that comes up when beginning to plan out a SharePoint implementation, as it should. The various roles and responsibilities should be clearly defined upfront, but I often receive the initial feedback from customers that we should be able to just tell them what those responsibilities are. The problem with that philosophy is that the organization, management, goals, and skill sets of every organization are not the same. The role of a SharePoint Administrator will vary depending upon your...

Read More

Bulk Insert/Update/Delete Items from SharePoint List/Library

Bulk Insert/Update/Delete Items from SharePoint List/Library   We have the sharepoint list like as below Create console project to run the code    Code here  Before run => remember change Target framework to 3.5 (i using visual 2010 and sharepoint 2010)  Run application  The result here but have problem with "Throttling" the next topic i will guide to you how to disable it in special...

Read More

How to update only one field using Entity Framework

 How to update only one field using Entity Framework   var tableEmployee = new T_Employees() { EmployeeID = item.EmployeeID , IsDisplayRequired = item.IsDisRequired };                 using (var db = new DBEntitiesContext())                 {                     db.Configuration.ValidateOnSaveEnabled...

Read More

MVC 5 Insert Update Delete CRUD Functionality using EF

MVC 5 Insert Update Delete CRUD Functionality using EF Download project at here: http://www.mediafire.com/download/2s4mwu2vcunlx9d/MVC5.7z 1. Continue with previous article at link: http://www.microsofttechnology.net/2015/08/insert-update-and-delete-data-in-mvc5.html.  Create new class in Models folder call is EmployeesModel at image below 2. Writing code like below 3. Create new controller (Empty) 4. Name is EmployeesController 5....

Read More