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.
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.
Upgrade to the version 1.0.4. Download from here.
This will help resolve the issue.
This post is about connecting a SharePoint provider hosted add-in deployed on Azure to a Azure SQL DB for performing basic CRUD operations.
- 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.
- Create Azure SQL DB:
- Within Azure portal, click New –> Databases –> SQL Database
- Enter SQL server details.
- 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.
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:
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:
at Microsoft.SharePoint.Utilities.SPIntlCal.GetLocalCalendar(SPCalendarType calType)
- 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.
Sharing a very important industry study on usage of SharePoint and Office 365.