Visual Studio not responding when creating new SharePoint Framework project

Issue:

When we install SharePoint Framework extensions to Visual Studio 2017, and try to create a SharePoint Framework project, it keeps on creating the project and goes into Not Responding mode.

Analysis:

This is related to npm package microsoft/generator-sharepoint version.

The scaffolding procedure has changed in this version and it contains now an additional option to choose which type of client-side component you would like to create (WebPart or Extension in preview). This option was not present in previous versions of microsoft/generator-sharepoint package. The generation in Visual Studio stops at this option.

Solution:

Upgrade to the version 1.0.4. Download from here.

This will help resolve the issue.

Advertisements

CRUD operations on Provider Hosted SharePoint Add-In to Azure SQL Database

Hi All,

This post is about connecting a SharePoint provider hosted add-in deployed on Azure to a Azure SQL DB for performing basic CRUD operations.

Prerequisites:

  • Microsoft Azure account.
  • Office 365 account
  • Visual Studio 2015/2017 with SharePoint extensions.
  • A empty provider hosted add-in with ACS mode created and deployed on an Azure web app.

Steps:

  • Create Azure SQL DB:
    • Within Azure portal, click New –> Databases –> SQL Database
    • Enter SQL server details.

1

2

  • Update DB server firewall to allow client IP access to the DB
    • Go to list of DBs in Azure, select the current DB – Select ‘Set server firewall’
    • Hit ‘Add client IP’ and then hit Save button.

3

4

  • Modify Provider hosted add-in to create model  from newly created DB:
    • Within project, go to Project –> Models –> Right click add new item. Select ADO.NET Entity data model from Data tab.
    • Select EF Designer from Database option to choose model contents
    • Provide correct Azure connection details to establish the correct connection with newly created Azure SQL DB.
      5
  • Modify Provider hosted add-in to create controller from newly created DB:
    • Within project, go to Project –> Controllers –> Right click add controller 

      910

  • Next add link in the layouts page for user to click from the application.

11

Next when running the SharePoint App, and clicking Customers link, you should be able to see all the data on the screen as shown below:

12

SharePoint 2013 MySite page opening blank for a single user

Sharing another live project issue that I faced with one of my customers..

A single user when trying to open SharePoint 2013 Mysite page, was getting a blank page. This was happening on some other Mysite pages also.

Also user was sometimes receiving error:

System.ArgumentException: calType
at Microsoft.SharePoint.Utilities.SPIntlCal.GetLocalCalendar(SPCalendarType calType)

Solution:

  • Go to My Site Settings in Central Administration
  • Edit the user profile for the user having the issue
  • The setting for ‘Set your calendar’ would be blank
  • Set this to a value like – Gregorian
  • Save the profile
  • User would be able to access the My site pages.

SharePoint 2013 Quick Edit link disabled

Hi All,

Many times we see that the ‘Quick Edit’ link in the Ribbon is disabled even when we are the Site collection Administrators / Owners.

6

Following could be the reasons why it is being disabled.

  1. Custom Style applied on the view – Quick edit only works with a view set on default style. If you change style to any other than default, Quick edit option will be disabled for everyone.
  2. Quick Edit not enabled for the list in Advanced Settings within List Settings.
  3. Current view of the list has Group By enabled and applied on some field.
  4. Allow individual item checkbox not checked on Tabular view in the view.

It could be any one of these reasons, why Quick edit is showing up as disabled.

Making SP O365 Site collection Read Only

Hi All,

In On-Premise SharePoint version, we do have an option of Site Quota and Locks using which we can make a site collection Read Only.

This can be very useful in the scenario of migration of a site as well.

However with O365 version of SharePoint, we do not have the direct way of making a site collection Read Only, but we do have an alternate approach that includes Creating a Read Only policy, and then applying that policy.

Sharing the same below:

  1. Browse to the site collection that you want to make Read Only
  2. Go to Site Settings -> Site Collection Administration -> Site Policies

1

3. On the Site Policy page, hit Create link

4. Give your policy a Name, Description (Optional), Select the following options:

  • Do not close or delete site automatically
  • Check the option – The site collection will be read only when it is closed
  • Hit OK and the policy will be created.

2

5. This will create a Read only policy that will be applied when the site is closed (temporarily closed).

6. Next step is to close the site after which the Read Only policy will be automatically applied.

7. Go to Site Settings -> Site Administration -> Site closure and Deletion -> Hit Close this site now.

3

8. Once the site is closed, you will see a site Read Only banner (in pink) on top of the site.

4

9. If users browse the site, it will be Read Only. Site Admins can go and re-open the closed site and it will be again available for users to add and update.

Also, there is an option in O365 using PowerShell to set the site collection with No Access to anyone. This may be used to temporarily lock down the site with No Access.

The following PowerShell commands may be used for the same.

5

PS C:\work\CSOM-EnableFeature> Set-SPOSite https://abc.sharepoint.com/
sites/TestSiteTemplate -LockState NoAccess
PS C:\work\CSOM-EnableFeature> Set-SPOSite https://abc.sharepoint.com/
sites/TestSiteTemplate -LockState Unlock
PS C:\work\CSOM-EnableFeature>