Skip to main content

Posts

How to Migrate a InfoPath List Form to another List Form in SharePoint 2013

I encountered an issue recently where the Info Path form got published accidentally with improper layout. As we all know that Info Path does not maintain versions and it is impossible to revert to the previous versions.  Luckily I had the back up of the SharePoint list template from where I could open the previous version of the Info path form. Following are the steps I tried to migrate the Info Path form from the back up to the new SharePoint list. 1. Create a new SharePoint list from the list template. 2. Open the newly created list and click on "Customize form" to open the form in Info path designer. 3. Extract the source files by clicking on File->Publish-> Export Source Files. 4. Update the manifest file with the URL, List ID, Content Type ID of the list to which the Info path form has to be published. Steps to update the manifest file: 1. Get the List ID from the URL by clicking on List settings. The List Id would be something like  List=%7B691FF1A0%2...

Search Configuration in SharePoint 2013

How to create and configure a SharePoint Search service application? Following are the basic steps to be carried out for creating a search service application. Create accounts   Create a Search service application   Configure the Search service application Configure the Search service application topology Register a managed account by following these steps. Open the "Central Administration" home page, in the "Quick Launch", click "Security". On the Security page, in the "General Security" section, click "Configure managed accounts". On the "Managed Accounts" page, click "Register Managed Account". On the "Register Managed Account" page, in the "Account Registration" section, type the user name and password that you want to use as credentials for the service account. If you want SharePoint Server 2013 to manage password changes for this account, select the ...

1904 issue when data is extracted from the SharePoint list.

We have an option in SharePoint to export the SharePoint list to an excel.  When a user extracts a report and enable the "user 1904 date system" under Excel Options-> Advanced->When calculating this workbook,  the data columns in the excel would get added by 4 years and 1 day. For example: If the date column has the value 08/03/2019, it would get converted to 09/03/2023. Please click here to know more about the excel date systems. Please follow the steps to correct the shifted dates! Correcting Shifted Dates If you link from or copy dates between workbooks, or if you change the date system for a workbook that already contains dates, the dates may be shifted by four years and one day. You can correct shifted dates by following these steps: 1.     In an empty cell, enter the value 1462. 2.     Select the cell. On the  Edit  menu, click  Copy . Note  In Excel 2007, select the cell, and th...

Hide SharePoint List View based on User Groups

There is a requirement where the users should be allowed to view only the requests raised by them and a particular SharePoint group members should be able to view all the items. We can achieve it using Rest API but a much simpler approach would be to make use of the OOTB features. 1. Please create a view with filter "Created By" is equal to [Me] and make it as the default view. 2. Now navigate to the list view page. Edit Page. Edit web part and check the option "Disable view selector menu" and save the webpart. This would prevent users from selecting the view. In simple words, the user would be able to see only the list items and not the view tab. Now, how to  make all items view visible to the members of a SharePoint group. Please go to the navigation settings and create a link to navigate to the all items view. Set target audience to the particular SharePoint group. Its done! :)

Navigation Settings not found under SharePoint "Look and Feel"

The global navigation can be handled through the navigation settings in SharePoint. The 'Navigation Settings' can be found under Site Settings->Look and Feel. The Navigation Settings would be enabled only if the 'SharePoint Server Publishing Infrastructure'   feature is activated.

ViewFormPagesLockDown Feature - Not able to create Sub Site using custom team site template

Came across this error recently while creating a sub site using a custom template. "This web template requires that certain features be installed, activated, and licensed. The following problems are blocking application of the template: Feature Description Feature Scope Feature ID Problem ViewFormPagesLockDown Feature Site collection 7******3-0**4-4**d-9**a-7c175******4 Not activated" Solution: ViewFormPagesLockdown  is referring to the  Limited Access User Permissions Lockdown mode  feature. Please try to navigate to the site collection where you want to use the template to create a sub-site, then go to Site Settings>Site Collection Administration>Site Collection features to activate the  Limited Access User Permissions Lockdown mode  feature to see the result.

Get list of solutions and features installed on farm using Powershell

Get list of all solutions installed on the farm: [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") $farm=[Microsoft.SharePoint.Administration.SPFarm]::Local foreach ($solution in $farm.Solutions)         {             if ($solution.Deployed){                Write-Host($solution.DisplayName)                $solution.DisplayName >> c:\temp\test.txt             }                  } Get list of all features installed on the farm: [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") $farm=[Microsoft.SharePoint.Administration.SPFarm]::Local foreach ($feature in $farm.FeatureDefinitions)          {             if ($feature.Scope -eq "Farm" -and...