Set up SharePoint Designer 2013 Step By Step Part 6

 SharePoint Designer 2013 – a tool that is most useful few years back, still handy in some projects, and that still gives me trouble when need to set up for any new machine. So, here is a set up process that I believe can be helpful in future.

Here is order of installation we are going to follow in this article:

• Pre-requisite Installation
• Service pack 1 for .Net Framework 3.0
• SharePoint Designer 2013
• Service Pack 1
• Security Update for Microsoft SharePoint Designer 2013 (kb2863836)
• Update for Microsoft SharePoint Designer 2013 (kb3114337)
• Update for Microsoft SharePoint Designer 2013 (kb3114721) (this blog)

If you miss any previous post, you can visit using the above links. 

In this blog we are going to install Update for Microsoft SharePoint Designer 2013 (kb3114721) and verify the working. 

·         Update for Microsoft SharePoint Designer 2013

o   spd2013-kb3114721-fullfile-x64-glb.exe
https://www.microsoft.com/en-us/download/details.aspx?id=53389

o   spd2013-kb3114721-fullfile-x86-glb.exe
https://www.microsoft.com/en-us/download/details.aspx?id=53364

o   Double click on “spd2013-kb3114721-fullfile-x64-glb.exe” file to install the security update.

o   It will open the License agreement dialog. Read the terms and click on “Click here to accept the Microsoft Software License Term”. Once checked, continue button will be enabled. Click on Continue button.

o   It will install the update. It may take few minutes to complete this.

o   Click Ok once completed.

 

This will complete the full installation of SharePoint Designer 2013 with all the security updates required.

To verify the correct installation, follow below steps:

• Start SharePoint Designer.
• Open SharePoint Site where you have SharePoint Designer 2013 Workflow.

• Provide URL of the site. It will ask you to sign in. Provide credential to login in to site.

• Go to Workflows tab.

• It will list OOTB and custom workflows.

• Open your custom SharePoint 2013 workflow by right clicking on name and then clicking edit workflow.

• It will open the workflow in edit mode.

Reference –
https://sharepoint.stackexchange.com/questions/218892/error-server-side-activities-have-been-updated-you-need-to-restart-sharepoint-d

Set up SharePoint Designer 2013 Step By Step Part 5

SharePoint Designer 2013 – a tool that is most useful few years back, still handy in some projects, and that still gives me trouble when need to set up for any new machine. So, here is a set up process that I believe can be helpful in future.

Here is order of installation we are going to follow in this article:

• Pre-requisite Installation
• Service pack 1 for .Net Framework 3.0
• SharePoint Designer 2013
• Service Pack 1
• Security Update for Microsoft SharePoint Designer 2013 (kb2863836)
• Update for Microsoft SharePoint Designer 2013 (kb3114337)(This Blog)
• Update for Microsoft SharePoint Designer 2013 (kb3114721)

If you miss any previous post, you can visit using the above links. 

In this blog we are going to Update for Microsoft SharePoint Designer 2013.

• Update for Microsoft SharePoint Designer 2013 (kb3114337)

This update is helpful to fix error - Server-side activities have been updated. You need to restart SharePoint Designer to use the updated version of activities.

o   spd2013-kb3114337-fullfile-x64-glb.exe
https://www.catalog.update.microsoft.com/Search.aspx?q=3114337

Direct link - http://download.windowsupdate.com/d/msdownload/update/software/crup/2016/01/spd-x-none_7c1009a5a70cac8d7012a44d2710faf79d7d7fb5.cab

o   spd2013-kb3114337-fullfile-x86-glb.exe
https://www.catalog.update.microsoft.com/Search.aspx?q=3114337

Direct link - http://download.windowsupdate.com/d/msdownload/update/software/crup/2016/01/spd-x-none_54fcb6afdc9f1f8daa26eaa10613902bcb6f3685.cab

o   Extract the .Cab file.

o   Double click on “spd-x-none.msp” file to install update.

o   It will complete the installation within a minute. It will not provide any completion dialog.

Set up SharePoint Designer 2013 Step By Step Part 4

SharePoint Designer 2013 – a tool that is most useful few years back, still handy in some projects, and that still gives me trouble when need to set up for any new machine. So, here is a set up process that I believe can be helpful in future.

Here is order of installation we are going to follow in this article:

• Pre-requisite Installation 
• Service pack 1 for .Net Framework 3.0
• SharePoint Designer 2013 
• Service Pack 1
• Security Update for Microsoft SharePoint Designer 2013 (kb2863836) (This Blog)
• Update for Microsoft SharePoint Designer 2013 (kb3114337)
• Update for Microsoft SharePoint Designer 2013 (kb3114721)

If you miss any previous post, you can visit using the above links. 

In this blog we are going to install Security update for Microsoft SharePoint Designer 2013 (kb2863836).

• You can download Security Update for Microsoft SharePoint Designer 2013 using below links:
  
  
• spd2013-kb2863836-fullfile-x64-glb.exe
  https://www.microsoft.com/en-in/download/details.aspx?id=42871

• spd2013-kb2863836-fullfile-x86-glb.exe
  https://download.microsoft.com/download/8/9/E/89E909FF-3839-47BB-92D8-A5D900BB805C/spd2013-kb2863836-fullfile-x86-glb.exe
  
  
• Double click on “spd2013-kb2863836-fullfile-x64-glb.exe” to install the update.
• It will open dialog to show terms.
• Click on “Click here to accept the Microsoft Software License Term” after reading the terms. Once checked, continue button will be enabled.
• Click continue.

• It will install the update. It may take few minutes to install.
• Once installation is completed, click ok.

In next blog we will install pending security updates

Set up SharePoint Designer 2013 Step By Step Part 3

SharePoint Designer 2013 – a tool that is most useful few years back, still handy in some projects, and that still gives me trouble when need to set up for any new machine. So, here is a set up process that I believe can be helpful in future.

Here is order of installation we are going to follow in this article:

• Pre-requisite Installation 
• Service pack 1 for .Net Framework 3.0
• SharePoint Designer 2013 
• Service Pack 1 (This Blog)
• Security Update for Microsoft SharePoint Designer 2013 (kb2863836) (This Blog)
• Update for Microsoft SharePoint Designer 2013 (kb3114337)
• Update for Microsoft SharePoint Designer 2013 (kb3114721)

If you miss any previous post, you can visit using the above link:

In this blog we are going to install Service Pack 1.

Once the SharePoint designer 2013 is installed, we need to install Service Pack 1 and other updates. Without this I face blank workflow open or workflow not open issues.

• SharePoint Designer Service Pack 1 download link:
• spdsp2013-kb2817441-fullfile-x64-en-us.exe
  https://www.microsoft.com/en-us/download/details.aspx?id=42009
  
  
• spdsp2013-kb2817441-fullfile-x86-en-us.exe
  https://www.microsoft.com/en-eg/download/details.aspx?id=42015

• Double click on “spdsp2013-kb2817441-fullfile-x64-en-us.exe” to start installation.
• It will ask to read the License terms and accept it.
• Check the “Click here to accept the Microsoft Software License Terms” checkbox after reading the terms. It will enable continue button.
• Click the “Continue” button.

• It will start installation of Service pack 1. It may take couple of minutes to install.
• Once installation is done, click ok.

Once the Service Pack 1 installation is done,  we need to install Security Update for Microsoft SharePoint Designer 2013. 

• First we need to download that. Use below links for the downloading: 
• spd2013-kb2863836-fullfile-x64-glb.exe
  https://www.microsoft.com/en-in/download/details.aspx?id=42871
  
  
• spd2013-kb2863836-fullfile-x86-glb.exe
  https://download.microsoft.com/download/8/9/E/89E909FF-3839-47BB-92D8-A5D900BB805C/spd2013-kb2863836-fullfile-x86-glb.exe

• Double click on “spd2013-kb2863836-fullfile-x64-glb.exe” to install the update.
• It will open dialog to show terms.
• Click on “Click here to accept the Microsoft Software License Term” after reading the terms. Once checked, continue button will be enabled.
• Click continue.

• It will install the update. It may take few minutes to install.
• Once installation is completed, click ok.

In the next blog, we will complete the set up with pending two updates. 

Set up SharePoint Designer 2013 Step By Step Part 2

SharePoint Designer 2013 – a tool that is most useful few years back, still handy in some projects, and that still gives me trouble when need to set up for any new machine. So, here is a set up process that I believe can be helpful in future.

Here is order of installation we are going to follow in this article:

• Pre-requisite Installation 
• Service pack 1 for .Net Framework 3.0
• SharePoint Designer 2013 (This Blog)
• Service Pack 1
• Security Update for Microsoft SharePoint Designer 2013 (kb2863836)
• Update for Microsoft SharePoint Designer 2013 (kb3114337)
• Update for Microsoft SharePoint Designer 2013 (kb3114721)

If you miss any previous post, you can visit using the above link:

In this blog we are going to install SharePoint Designer:

• First step is to download the SharePoint Designer 2013. Check your system type and d
• SharePoint Designer 2013 download link-
• 64-bit (sharepointdesigner2013_64bit.exe)
• 32-bit (sharepointdesigner2013_32bit.exe)
  https://www.microsoft.com/en-in/download/details.aspx?id=35491

Follow below steps to install the SharePoint Designer 2013. For this blog, I will use 64 Bit download:

• Double Click on “sharepointdesigner2013_64bit.exe” file to start the installation.
• It will extract the files first.

• Once extraction is done, it will open Installation wizard. Click “Install Now”.

• It will install the designer in the system. This may take couple of minutes.
• Once installation is done, click close to complete installation.

In the next part we will install Service Pack 1.

Set up SharePoint Designer 2013 Step By Step Part 1

SharePoint Designer 2013 – a tool that is most useful few years back, still handy in some projects, and that still gives me trouble when need to set up for any new machine. So, here is a set up process that I believe can be helpful in future.


Here is order of installation we are going to follow in this article:

• Pre-requisite Installation (This Blog)
• Service pack 1 for .Net Framework 3.0
• SharePoint Designer 2013
• Service Pack 1
• Security Update for Microsoft SharePoint Designer 2013 (kb2863836)
• Update for Microsoft SharePoint Designer 2013 (kb3114337)
• Update for Microsoft SharePoint Designer 2013 (kb3114721)

In this blog we are going to install Pre-requisites:

• Service pack 1 for .Net Framework 3.0
  
  Download link - https://www.microsoft.com/en-in/download/details.aspx?id=3005

This will save you from error - Windows workflow Foundation, part of .Net Framework 3.0 must be installed to use this feature.

• When you start installation, it will take a moment to identify the features to be install. Click “Download and install feature”.

• Once installation complete, click close.

We are done with Pre-requisites. We will start the SharePoint Designer Installation in next part.

Error - manage web site permission issue while creating site collection level app catalog

 Recently, we were deploying a solution for a client. So for UAT set up, we asked them to create a site collection and activate the site collection level app catalog. The IT admin create the site collection and when he ran below command for creating site collection level app catalog.

 Connect-SPOService -Url https://Domain-admin.sharepoint.com/   
 New-SPOSite -Url https://contoso.sharepoint.com/sites/mynewuatsite -Owner user@domain.com -Title "My new site collection"   
 $site = Get-SPOSite https://Domain.sharepoint.com/sites/mynewuatsite   
 Add-SPOSiteCollectionAppCatalog -Site $site  

He faced an error:

add-spositecollectionappcatalog : Must have Manage Web Site permissions or be a tenant admin in order to add or remove sites from the site collection app catalog allow list

As the site collection creation didn't give an error, it was sure that he has SharePoint admin access. So, why the site collection level app catalog is giving error.

So, we go to analysis mode and we found out below reason.

Solution:

So, I found out a community discussion on the google about the same issue. Please see reference link for the same. 

As per that discussion, user must has site collection admin rights on the Tenant level app catalog to create site collection level app catalog with SharePoint Admin rights. 

Once we provided that access, we were able to run the command successfully.

Reference:

• https://github.com/SharePoint/sp-dev-docs/issues/1348

How to start User Profile Service stuck on Starting or Stopping stage

Issue:

Recently, we have requirement to change the farm admin account due to some issue with user. We have changed the user but it broke the User Profile Service. The issue we face is that when we start it, it stuck on Starting. If we try to stop then it stuck on stopping. 

Solution:

So, finally I can across PowerShell script that is working for me that starts & stops user profile and user profile synchronisation service. 

• To stop the service, run using powershell command for user profile service,

 stsadm -o provisionservice -action stop -servicetype “Microsoft.Office.Server.Administration.UserProfileService, Microsoft.Office.Server.UserProfiles, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” -servicename  

•   To stop the service, run using powershell command for user profile synchronization service,

 stsadm -o provisionservice -action stop -servicetype “Microsoft.Office.Server.Administration.UserProfileService, Microsoft.Office.Server.UserProfiles, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” -servicename FIMSynchronizationService  

Now to start the service, you just need to change the action parameter to start in above powershell command.

• To start the service, run using powershell command for user profile service,

 stsadm -o provisionservice -action start -servicetype “Microsoft.Office.Server.Administration.UserProfileService, Microsoft.Office.Server.UserProfiles, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” -servicename  

• To start the service, run using powershell command for user profile synchronization service,

 stsadm -o provisionservice -action start -servicetype “Microsoft.Office.Server.Administration.UserProfileService, Microsoft.Office.Server.UserProfiles, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” -servicename FIMSynchronizationService  

Reference:

• http://sharepointhyfy.blogspot.com/2016/04/user-profile-service-stuck-in.html#gsc.tab=0
• https://social.technet.microsoft.com/wiki/contents/articles/26067.sharepoint-2013-user-profile-stuck-stopping.aspx

SharePoint 2019 FBA Set up Full Name Error

Recently we have set up Form based authentication (FBA) in SharePoint 2019 environment. We have configured the FBA with best practice but when we try to login using windows user or FBA user,  we were getting error – “Fullname”. 

Issue:

We faced below error when we try to login using windows user or FBA user:

 

Solution:

We have checked multiple blogs in google and verified that the set up was done using best practice. So, our doubt goes to configuration in web application, and we found out that “Client Integration” settings is responsible for this.

To disable the “Client Integration” settings follow below steps:

• Go to Central Admin.
• Click “Manage web application” under “Application Management”

• Select your web application.

• Click on “Authentication provider” from Ribbon. 

• It will show default Zone. Click on that. 

• Scroll bottom of the authentication provider settings dialog.
• Click “No” for “Client Integration” Settings. 

• Click Save.
• It will take some time and provide below dialog. Click close.

• Now try to login in web application. You will see the user is able to login successfully.

How to get the strong name of your assembly by adding an External Tool?

Introduction

• For a client, we were developing SharePoint 2019 Web API. For that we were following below post:
  https://www.c-sharpcorner.com/article/create-asmx-service-for-sharepoint/
  
  
• In that we needed to set up strong assembly name. The link was dead. So I thought I should write this blog. 

Solution

This tip will make it easy for you to get that assembly name right within Visual Studio.

• In Visual Studio, Go to Tools –>  External Tools.

• Click on “Add” to add a tool, and put in the following values:
• Title: Strong Name
• Command: Powershell.exe
• Arguments: -command "[System.Reflection.AssemblyName]::GetAssemblyName(\"$(TargetPath)\").FullName"
• Check “Use Output Window”
• Uncheck everything else – here’s how it should look -

  

• Right Click on your solution and Clean Your Project solution.

 

• Now, Right Click on your solution and build Your Project solution.

 

• That’s it, now in your project, Visit Tools –> Strong Name, and in the output window, it will give you the assembly name like this –>

 ProjectName, Version=1.0.0.0, Culture=neutral, PublicKeyToken=e3d610b32dbba675  

 

Please let me know if you face any issues.

SharePoint Permission Matrix

We recently have a client request for SharePoint OOTB Permission Matrix. We thought it would be available easily. But to my surprise, we didn't. Although, Microsoft has put a full page on that but we can't give that to client. 

So I have prepared this matrix comparing things in Microsoft blog. You can find the blog link in reference:

Permission level

Permission

Permission Description

View Only

Limited Access

Restricted Read

Read

Contribute

Edit

Approve

Design

Manage Hierarchy

Full Control

List Level

Manage List

Create and delete lists, add or remove columns in a list, and add or remove public views of a list.

Yes

Yes

Yes

Yes

Overrise List Behavior

Discard or check in a document that is checked out to another user, and change or override settings that allow users to read/edit only their own items

Yes

Yes

Yes

Yes

Add Items

Add items to lists, and add documents to document libraries

Yes

Yes

Yes

Yes

Yes

Yes

Edit Items

Edit items in lists, edit documents in document libraries, and customize Web Part pages in document libraries

Yes

Yes

Yes

Yes

Yes

Yes

Delete Items

Delete items from a list, and documents from a document library.

Yes

Yes

Yes

Yes

Yes

Yes

View Items

View items in lists, and documents in document libraries

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Approve Items

Approve a minor version of list items or document.

Yes

Yes

Yes

Open Items

View the source of documents with server-side file handlers

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

View Versions

View past versions of a list item or document.

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Delete Versions

Delete past versions of list items or documents.

Yes

Yes

Yes

Yes

Yes

Yes

Create Alerts

Create alerts

Yes

Yes

Yes

Yes

Yes

Yes

Yes

View Application Pages

View forms, views, and application pages. Enumerate lists

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Site Permission

Manage Permissions

Create and change permission levels on the web site and assign permissions to users and groups

Yes

Yes

View Web Analytics Data

View reports on Web site usage

Yes

Yes

Create Subsites

Create subsites such as team sites, Meeting Workspace sites, and Document Workspace sites.

Yes

Yes

Manage Web Site

Grants the ability to perform all administration tasks for the web site, as well as manage content

Yes

Yes

Add and Customize Pages

Add, change, or delete HTML pages or Web Part pages, and edit the website.

Yes

Yes

Yes

Apply Themes and Borders

Apply a theme or borders to the whole website.

Yes

Yes

Yes

Apply Style Sheets

Apply a style sheet (.css file) to the website.

Yes

Yes

Yes

Create Groups

Create a group of users that can be used anywhere within the site collection

Yes

Browse Directories

Enumerate files and folders in a website by using SharePoint Designer 2013 and Web DAV interfaces

Yes

Yes

Yes

Yes

Yes

Yes

Use Self-Service Site Creation

Create a website using Self-Service Site Creation.

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

View Pages

View pages in a website

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Enumerate Permissions

Enumerate permissions on the website, list, folder, document, or list item

Yes

Yes

Browse User Information

View information about users of the website

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Manage Alerts

Manage alerts for all users of the website

Yes

Yes

Use Remote Interfaces

Use SOAP, Web DAV, the Client Object Model, or SharePoint Designer 2013 interfaces to access the website

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Use Client Integration Features

Use features that launch client applications. Without this permission, users must work on documents locally and then upload their changes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Open

Enables users to open a website, list, or folder to access items inside that container

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Edit Personal User Information

Enables users to change their own user information, such as adding a picture.

Yes

Yes

Yes

Yes

Yes

Yes

Personal

Manage Personal Views

Create, change, and delete personal views of lists.

Yes

Yes

Yes

Yes

Yes

Yes

Add/Remove Personal Web Parts

Add or remove personal Web Parts on a Web Part page.

Yes

Yes

Yes

Yes

Yes

Yes

Update Personal Web Parts

Update Web Parts to display personalized information

Yes

Yes

Yes

Yes

Yes

Yes

Note: Restricted Read, Approve and Manage Heirarchy Permission are available for Publishing Site only.

Reference:

• https://docs.microsoft.com/en-us/sharepoint/sites/user-permissions-and-permission-levels