Export and Import Subsite in SharePoint 2013 using PowerShell

September 28, 2015    , , , , , ,
Export-Import subsite using PowerShell in SharePoint 2010 how to export SharePoint subsite? export subsite SharePoint 2013 PowerShell, Unlike SharePoint 2013, you'll have to create a subsite first and then import. Export-SPWeb cmdlet used to export a sub site, list or document library. Open SharePoint 2013 Management Shell and run this command. Change Site URL and Path values accordingly. Export-SPWeb "http://sharepoint.company.com/sites/Sales/US/" ` -Path "C:\sales-us.cmp" -IncludeVersions All -includeusersecurity To export a site, list or document library by using Central Administration: You can also export a Subsite from SharePoint 2010/2013/2016 Central Administration via "Export a site or list"  capability. Go to SharePoint Central Administration >> Backup and Restore >> Click on "Export a site or list" link under "Granular Backup" group. Important: Both the source and destination sites should
Read More
Export and Import Subsite in SharePoint 2013 using PowerShell Export and Import Subsite in SharePoint 2013 using PowerShell Reviewed by Salaudeen Rajack on September 28, 2015 Rating: 5

Get SharePoint Timer Job History using PowerShell

September 27, 2015    , , , , , ,
Requirement: Retrieve and review the SharePoint timer job history for troubleshooting an issue. Solution: SharePoint 2013 Central Administration site provides an interface to get timer job history. Here are the steps to get SharePoint timer job history in SharePoint. Navigate to SharePoint 2013 Central Administration site Go to Monitoring >> Check Job status Click on "Job History" link from left navigation Under the "View" filter, choose "Job Definition". You'll find an cascading filter appears as "Job Definition" once you choose View filter as "Job definition". You can also choose options such as: Service, Web Application, Server. Click on the job definition filter to "change job definition" Pick the relevant timer job definition. E.g. Audit Log Trimming, Immediate Alerts, etc. Now, you'll find the jobs history for selected timer job as below. PowerShell script to search and export timer job histo
Read More
Get SharePoint Timer Job History using PowerShell Get SharePoint Timer Job History using PowerShell Reviewed by Salaudeen Rajack on September 27, 2015 Rating: 5

Open with Explorer: Network Error - Windows cannot access URL@SSL\DavWWWRoot\SiteURL

September 26, 2015    ,
Problem:  Open with Explorer button in SharePoint 2010 site gave this error message on a particular document library. Network Error - Windows cannot access URL@SSL\DavWWWRoot\SiteURL\Library You do not have permission to access \\web-app-url@com@SSL\DavWWWRoot\Library-URL. Contact your network administrator to request access. Observation:  Issue is happening only with a particular library. Explorer view works fine with all other document libraries in the same environment. Issue is not specific to a particular client machine or user. Open with explorer from the Root level of the library and got the above error. Tried going into each sub-folders and clicking on "Open with Explorer" worked fine, Except for one folder where SharePoint prompted for credentials three times and gave "Your client does not support opening this list with Windows Explorer." - So that's the culprit. Solution: Tried running Windows update, Various hot fixes from Microsoft KB&#
Read More
Open with Explorer: Network Error - Windows cannot access URL@SSL\DavWWWRoot\SiteURL Open with Explorer: Network Error - Windows cannot access URL@SSL\DavWWWRoot\SiteURL Reviewed by Salaudeen Rajack on September 26, 2015 Rating: 5

Open SharePoint List Items in Edit Mode by Default

September 25, 2015    , , , ,
Requirement: Open SharePoint Task list items in Edit form directly instead of "Display form". Solution: Go to your SharePoint task list, Click on Site settings gear, Choose "Edit page"   Add a script editor and place this code: jQuery to launch list items in Edit mode: <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js"></script> <script type="text/javascript"> $(document).ready(function() { //Change display form links to edit form links $('.ms-vb a[href*="listform.aspx"]').each(function(){ var url = $(this).attr('href'); url = url.replace("PageType=4", "PageType=6"); $(this).attr('href', url); }); }); </script> Save and close! Now, on clicking any task item link, you'll be taken into Edit form directly.
Read More
Open SharePoint List Items in Edit Mode by Default Open SharePoint List Items in Edit Mode by Default Reviewed by Salaudeen Rajack on September 25, 2015 Rating: 5

SPD Error: Microsoft SharePoint designer does not support editing non-SharePoint sites

September 25, 2015    ,
Error: "Microsoft SharePoint designer does not support editing non-SharePoint sites" - while trying to open a SharePoint 2016 site with SharePoint designer 2013, got this error message. Solutions: Simply close all instances of your SharePoint Designer and then reopen it. Check if client integration is enabled https://support.microsoft.com/en-us/kb/981223 Clear SharePoint designer cache. Here is How to Clear SharePoint Designer Cache Try re-installing SharePoint designer!
Read More
SPD Error: Microsoft SharePoint designer does not support editing non-SharePoint sites SPD Error: Microsoft SharePoint designer does not support editing non-SharePoint sites Reviewed by Salaudeen Rajack on September 25, 2015 Rating: 5

SharePoint Online: Get All List Items using PowerShell Script

September 23, 2015    , , , ,
Requirement: SharePoint Online PowerShell to Get List Items SharePoint Online: PowerShell to Get All List Items How to get items from a SharePoint Online list using PowerShell? Well, here is an example PowerShell CSOM script to get you all items in the given list or library, including items from all sub-folders recursively. #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Variables for Processing $SiteUrl = "https://crescent.sharepoint.com/" $ListName="Projects" $UserName="admin@crescent.com" $Password ="Password goes here" #Setup Credentials to connect $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($UserName,(ConvertTo-SecureString $Passw
Read More
SharePoint Online: Get All List Items using PowerShell Script SharePoint Online: Get All List Items using PowerShell Script Reviewed by Salaudeen Rajack on September 23, 2015 Rating: 5

Access Denied Error After Migrating from SharePoint 2010 to SharePoint 2013

September 18, 2015    , , , , , ,
Problem: After migrating from SharePoint 2010 to SharePoint 2013 using database attach method, all users received "access denied" error and they were unable to login. Made sure, both the source and destination SharePoint farms are in same Active Directory domain. Root cause: This is because, by default SharePoint 2013 web applications are created with Claims authentication. So existing classic mode accounts (domain\UserName) are not recognized by claims mode (i:0#.w|domain\username) web application. Tips: You can verify if your SharePoint 2013 is using claims mode by using:   (Get-SPWebApplication "<Web App URL").UseClaimsAuthentication Solution:  After some trial and error, found granting permission again to the users resolves the problem. However, its impossible to provide access to all users to wherever they have had permissions again manually, isn't it? Well, the right solution is: Convert the authentication method from classic-mode to claim
Read More
Access Denied Error After Migrating from SharePoint 2010 to SharePoint 2013 Access Denied Error After Migrating from SharePoint 2010 to SharePoint 2013 Reviewed by Salaudeen Rajack on September 18, 2015 Rating: 5

How to Create a Service Application Pool in SharePoint using PowerShell?

September 15, 2015    , , , , , ,
Service Application pools runs service application proxy web services inside IIS. Typically all of the service applications can be run with the same application pool. You can create a new service application pool while creating new service applications in SharePoint 2013. Ever wanted to create an new service application pool in SharePoint using PowerShell? Well, Here is my PowerShell script to create new AppPool. Prerequisites: We need a managed account (or login credentials of a service account) to create a service App Pool. PowerShell Script to Create New Service Application Pool in SharePoint 2013: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Configuration Parameters $AppPoolAccount = "Crescent\SP16-SearchAppPool" $AppPoolName = "Search Service Application App Pool" #Check if Managed account is registered already Write-Host -ForegroundColor Yellow "Checking if Application Pool Accounts already exists" $AppPoolAc
Read More
How to Create a Service Application Pool in SharePoint using PowerShell? How to Create a Service Application Pool in SharePoint using PowerShell? Reviewed by Salaudeen Rajack on September 15, 2015 Rating: 5

Server Error in '/x' Application - Excel Web App Error - Solution

September 14, 2015    ,
Problem: All of a sudden Office Web Apps Excel Web App stopped working and gave this Runtime error message on opening Microsoft Excel files from SharePoint 2013: Server Error in '/x' Application. Solution:  This occurs due to the public key which connects to the WOPI application such as Office Web Apps Server to the SharePoint farm goes out of sync! To resolve the issue, Run from any SharePoint Server:   Update-SPWOPIProofKey
Read More
Server Error in '/x' Application - Excel Web App Error - Solution Server Error in '/x' Application - Excel Web App Error - Solution Reviewed by Salaudeen Rajack on September 14, 2015 Rating: 5

Access Denied Error on Insert Picture/Link/Upload File in SharePoint 2010

September 13, 2015    , , ,
Problem: Users getting "Access Denied" error message while trying insert a picture via SharePoint 2010 Rich text editor. Verified that the user has "Full Access" permissions on the specific list, Still gets access denied on accessing layout pages such as: /_layouts/RteUploadDialog.aspx, /_layouts/RteDialog.aspx. Found it happens to other ribbon actions as well: Insert Link or Upload file. Solution: Found that the particular list is with broken permissions! Although not a perfect solution, Granting "Read" access at site level fixed this problem!
Read More
Access Denied Error on Insert Picture/Link/Upload File in SharePoint 2010 Access Denied Error on Insert Picture/Link/Upload File in SharePoint 2010 Reviewed by Salaudeen Rajack on September 13, 2015 Rating: 5

SharePoint Online: Import CSV File into SharePoint List using PowerShell CSOM

September 09, 2015    , , , , ,
Scenario: My requirement is to import data from CSV file to SharePoint online list from a local drive, every day! Create a List in SharePoint Online, matching columns from the CSV file, before running the script! PowerShell Script to import SharePoint List Items from CSV File: Here is the SharePoint Online PowerShell to import CSV #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" ##Variables for Processing $SiteUrl = "https://crescent.sharepoint.com/sites/POC/" $ListName="Contacts" $ImportFile ="c:\Scripts\EmpData.csv" $UserName="Salaudeen@crescent.com" $Password ="Password goes here" #Setup Credentials to connect $Credentials = New-Object Microsoft.SharePoint.Clien
Read More
SharePoint Online: Import CSV File into SharePoint List using PowerShell CSOM SharePoint Online: Import CSV File into SharePoint List using PowerShell CSOM Reviewed by Salaudeen Rajack on September 09, 2015 Rating: 5

Top 50 Use Cases of SharePoint in the Industry

September 09, 2015    
Most of the people knows Microsoft SharePoint as a File Share, But apart from File Share, there are number ways SharePoint is being used by organizations. Here is the list of top 50 use cases in my experience: Document Management System File Shares Content Management System Enterprise Search Center (Search site to index and search all sites, including non-SharePoint sites of the company) Enterprise Social Networking Site - Yammer! Corporate News Portal-Intranet-Extranet-Internet web Sites Project Management tool (with or without project server integration) Team Collaboration work space Employee Self-Service portal - Employee requests center Business process Automation/Workflows – BPM E.g. Expense Reimbursement, Travel Request Event Management - Party! Knowledge Base - KB sites Issue/bug Tracker system Reporting Tool - SSRS! Task Management Calendar Sharing - Corporate Calendars with important events and schedules Help desk management - Ticketing system Incident/Chang
Read More
Top 50 Use Cases of SharePoint in the Industry Top 50 Use Cases of SharePoint in the Industry Reviewed by Salaudeen Rajack on September 09, 2015 Rating: 5

How to Add a Link to SharePoint 2013 Suite Bar?

September 07, 2015    , ,
Requirement : Add a link to SharePoint 2013 suite bar. Solution: Edit SharePoint 2013 Master page to add a new link in Suite Bar Adding link to suite bar in SharePoint 2013 can be achieved by following these simple steps: Open your SharePoint 2013 site in SharePoint designer 2013. Navigate to "Master Pages" folder Right click on your master page (by default: Seattle.master) and choose "Edit file in Advanced Mode" Locate the text: id="DeltaSuiteLinks" and add the below code just below the DeltaSuiteLinks tag to add link to suite bar of SharePoint 2013 <span id="CustomerSupport" class="ms-core-suiteLink"> <a class="ms-core-suiteLink-a" href="http://support.crescent.com"> <asp:Label ID="lblCS" runat="server" Text="Customer Support"></asp:Label> </a> </span> Save and close SharePoint designer. This adds link to SharePoint 2013 s
Read More
How to Add a Link to SharePoint 2013 Suite Bar? How to Add a Link to SharePoint 2013 Suite Bar? Reviewed by Salaudeen Rajack on September 07, 2015 Rating: 5

Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the list view threshold enforced by the administrator

September 05, 2015    ,
Problem: When trying to filter a list with large items, got this error message: "Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the list view threshold enforced by the administrator" Root cause: Identified that the particular list has more than 25,000 rows in it. Filter fails as it exceeds the default threshold value configured. Solution: As the error message says: Your SharePoint Administrator got to update the Resource throttling threshold values from SharePoint 2010/2013 Central Administration site.Here are the steps to increase 'List View Threshold' value: Open SharePoint 2010 Central Administration site Go to Application Management' >> Manage Web Applications Choose the web application in which you want to make the changes Now from the ribbon, Click on 'General Settings >> Resource Throttling In the resource throttling page, increase the "List View Threshold"
Read More
Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the list view threshold enforced by the administrator Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the list view threshold enforced by the administrator Reviewed by Salaudeen Rajack on September 05, 2015 Rating: 5

Disable Redirect from User Information Page (userdisp.aspx) to MySite Profile Page (Person.aspx)

September 04, 2015    , ,
If you want to quickly check SharePoint user profile properties, You can get it from user information list or by simply clicking on user name hyperlinks from metadata fields such as: Created by. Usually, user profile page points to: http://sharepointsite.com/_layouts/userdisp.aspx?ID=123 When clicked on user name hyperlink, will get redirected to My Site profile page (E.g. http://mysite/person.aspx?accountname) if the user has a my site profile created. If the user has My site profile created, then the UserDisp.aspx page redirects to his/her My site profile page automatically. Is there any way to get the basic version of userdisp.aspx, instead of redirecting them to the MySite profile of that person when someone clicks on such links? Well, Here is a nifty trick to stop redirecting to user's Mysite profile page and get the simple User Information. Add:Force=True parameter to the above URL. So, it will be: http://portal.ad2012.loc/_layouts/userdisp.aspx? Force=True &ID
Read More
Disable Redirect from User Information Page (userdisp.aspx) to MySite Profile Page (Person.aspx) Disable Redirect from User Information Page (userdisp.aspx) to MySite Profile Page (Person.aspx) Reviewed by Salaudeen Rajack on September 04, 2015 Rating: 5

Fix "The site is not valid. The 'Pages' document library is missing" Error

September 03, 2015    ,
Problem: After trying to deactivate and activate the publishing feature in a site, users started receiving this error: "The site is not valid. The 'Pages' document library is missing". It also happened after importing a subsite backup! Additionally, when tried creating a Publishing Pages they got this error: The site is not valid. The 'Pages' document library is missing. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Microsoft.SharePoint.Publishing.InvalidPublishingWebException: The site is not valid. The 'Pages' document library is missing. Root Cause:  SharePoint Publishing feature stores the ID of the "Pages" library in the "__PagesListId" property  of SPWeb property bag. If this property doesn't match with the current "Pages" library, then w
Read More
Fix "The site is not valid. The 'Pages' document library is missing" Error Fix "The site is not valid. The 'Pages' document library is missing" Error Reviewed by Salaudeen Rajack on September 03, 2015 Rating: 5

Get and Export User Profile Properties using PowerShell in SharePoint 2013

September 03, 2015    , , , , ,
Its a common requirement in SharePoint to prepare reports from user profile properties. Here is my PowerShell scripts to get user profile properties in SharePoint. Important: Make sure User Profile Service Application is created , up and running before running these scripts! and run as Farm Administrator!! Get user profile Properties in SharePoint 2013 using PowerShell Lets get user profile property value for given user. #Configuration Variables $SiteURL = "http://mysite.crescent.com" $UserLogin="Crescent\Salaudeen" #Get Objects $ServiceContext = Get-SPServiceContext -site $SiteURL $UserProfileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($ServiceContext) #Get the User Profile $UserProfile = $UserProfileManager.GetUserProfile($UserLogin) #Retrieve User Profile Properties Write-host $UserProfile["PreferredName"] Write-host $UserProfile["WorkEmail"] You are not limited to these fields, But there are ple
Read More
Get and Export User Profile Properties using PowerShell in SharePoint 2013 Get and Export User Profile Properties using PowerShell in SharePoint 2013 Reviewed by Salaudeen Rajack on September 03, 2015 Rating: 5
Subscribe to: Posts ( Atom )
Powered by Blogger.