Posts tagged trick SharePoint 2013 Hosting

SharePoint Hosting – Custom RSS SPFx Feed WebPart In Modern UI

Feb 25th

Posted by Peter in European SharePoint 2013 Hosting

A client had a requirement to display the RSS feed on a modern UI page for 40,000 users.

Challenge

The main challenging part is that CORS has an issue with reading RSS feeds (xml). If the RSS feed is in a JSON format then we may use jsonpdataType to resolve the CORS issue.

Modern UI supports out of the box RSS Feed web part. But it has some limitations which are listed below:

This web part is available only for Office 365 Group Enabled team sites.
Users should have Outlook account and it has to be manually added to the Office 365 group.
Only supports 2500 users.

No options were available to alter the format in which information is displayed.

There are custom SPFx solutions available:

spfx-40-fantastics – RSS Feed Reader webpart
URL – https://github.com/OlivierCC/spfx-40-fantastics/wiki/Rss-Reader
This webpart solution is not working at the moment.
Reference – https://github.com/OlivierCC/spfx-40-fantastics/issues/97
SP-Dev-fx Webparts – React RSS Reader webpart
URL – https://github.com/SharePoint/sp-dev-fx-webparts/tree/master/samples/react-rss-reader
This solution uses the below ways to read RSS feed
Direct – This has an issue with CORS policy

3rd party solutions like https://feed2json.org or https://rss2json.com.

https://feed2json.org is open source but has limitations as below

It has to be hosted on a separate server
It does not support CORS.

https://rss2json.com free version has limitations as below

It takes 1 hour to display the updates.
Supports a maximum of only 10,000 requests per day.
Maximum of 25 feeds were allocated per account

Solution

To overcome this we came up with this approach with the help of Microsoft Flow, SharePoint Lists and ReactSharePoint Framework Web part.

Note

Microsoft Flow license is needed.

RSS feeds are generally available in XML file format and contain the URL, title, and summary of each page to display. So we developed a Microsoft recurring flow which reads the RSS feed XML and updates a SharePoint List Column with the XML content.

SharePoint List

We created a SharePoint List with a multi-line text column.

Microsoft Flow

We developed a Microsoft recurring flow.

The explanation of the steps of the flow:

Recurrence – specifies the schedule of execution of flow. We had scheduled it to execute the flow every 30 minutes.

Initialize variable – This initializes a variable to save the RSS url.

Get Item – This reads the RSS Feed url from a SharePoint List (We used a predefined SharePoint List to store the RSS Url. This also provides the facility to the end user to change the RSS Feed URL if needed).

Apply to each – Assigns the RSS url variable with the value for RSS Feed url from the previous step.

HTTP -Make a HTTP call with GET Method to read the text from RSS Feed XML.

Update Item –Updates a SharePoint List multi-line text column with the output of HTTP call made in the previous step.

After all the above steps are completed, the execution of the flow will update the SharePoint List multi-line text column with XML content of the RSS Feed XML file.

React SharePoint Framework Web part

We developed a simple SharePoint client-side web part to display the RSS feed on Modern site page in the same format as the OOTB RSS Web part for Modern pages. Additionally, we can customize the display format for RSS as well with our custom web part solution.

In order to convert XML text to JSON text we used npm xml-js.

The web part directly queries the SharePoint List multi-line text column value using REST API Call. Then converts the stored XML data to JSON text and loops through all the RSS feed data to display it in descending format of Published Date.

Which problem have we resolved?

Now, we are not depending on any third party webparts and third-party API to read RSS feed data, hence we don’t face any request and feed limits.
Resolved CORS issue by directly accessing feed data from already-stored feed using MS Flow.
We can customize the display format for RSS as well with our custom web part solution.

SharePoint 2013 Hosting – HostForLIFE :: Managing Site Storage In SharePoint Online

Feb 11th

Posted by Peter in European SharePoint 2013 Hosting

Overview

With an Office 365 subscription, we get storage space for SharePoint Online based on a number of licenses. As we create SharePoint online sites and start using them by adding our content, we start to consume the assigned storage space. It is important for us to keep a track of consumed and available site storage.

In this article, we will explore the site storage experience in modern SharePoint and its configuration.

Site Storage in SharePoint Online

The modern SharePoint online admin center gives an easy option to create new site collections.

Just a few simple fields to fill in and the site will be ready in a few seconds! But did you notice? We do not have a field to specify the storage quota for our site!

The Active sites page in the SharePoint Online admin center though, shows the storage used for each site. Also, we can see the total storage used and available for use.

Let us see from where site storage can be configured.

Site storage configuration

In the SharePoint admin center, from the left menu click Settings > Site storage limits.

The default storage limit is Automatic. The storage limit can be configured as,

Automatic
The default. All sites get the storage from a central pool. The global or SharePoint administrator does not have to manage the storage per site. It is handled automatically by SharePoint for them.
Manual
The global or SharePoint administrator can have a fined tuned site storage allocated for each of the SharePoint site collection.

Manage site storage for individual sites

If you want to manage the site storage per site, you will have to go with the manual configuration option.

With the manual option, the administrator can configure the maximum storage per site and can also set the notification for site owners when a certain percentage of the site storage limit is consumed.

The site owners or collection administrators can check the storage quota by following the below steps,

Navigate to the site settings page.
Under Site Collection Administration, click Storage Metrics.

Note

The recycle bin counts towards the site quota.

PowerShell support

The site quota can be set with PowerShell,

Set-SPOSite -Identity https://contoso.sharepoint.com -StorageQuota 1500 -StorageQuotaWarningLevel 1400

Summary

With an Office 365 subscription, we get storage space for SharePoint Online based on a number of licenses. It is important for us to keep track of consumed and available site storage. We explored the site storage experience in modern SharePoint and its configuration.

How To Fix SharePoint 404 Error After Content Database Migration?

Feb 2nd

Posted by Peter in European SharePoint 2013 Hosting

Issue Description

If we Google the above text, we will get multiple references for fixing this issue. For this, the traditional ways of fixing are:

The site might have been deleted, request to the site administrator to check the recycle bin.
Do the IIS reset.
Try to access the other layout page like /_layouts/15/settings.aspx(might be default.aspx or home.aspx has some issue).
Clear the timer job cache….etc

None of the above solutions worked for me.

Background of the issue

Let me give some background about the issue. I have migrated the Content DB using mounting from SharePoint 2013 to 2016. All site collections along with their subsites got opened in the browser without any issue but some of the subsites did not get opened in the browser and threw the “404: file not found” error.

If we go to site content structure page, those subsites are available. It looks strange to me! Not getting any clue, I kept on investigating this issue .. I tried to list out the site using SPSite collection PowerShell command. It got listed out, it made me more confused.

Then, I tried to connect one of the faulty subsites using ShareGate There, I saw object reference not set error. Then, I changed the direction of my investigation… I deleted the faulty subsite and tried to recreate it again with the same name manually. Unfortunately, I got the error, “You cannot create a site with this name <IT> as this is a reserved keyword by SharePoint”.

Well, it confused me more on how this could be a reserved keyword? Then, I went to check the managed path for this web application. Yes, I found the solution…The managed path was the issue. There was a managed path with the name IT in that web application, so we cannot create any subsite with that name with the same hierarchy of managed path. If we delete that IT manages path, we can create a subsite and can access IT along with all subsites under this. This is how I have solved this issue…but nowhere did I get any links or clues about this.

This is totally based on my personal experience. For you, the scenario may be different.

Example

Manged path in the web application: IT

I was trying to access the subsite like below.

http://server:1010/IT #here IT is the subsite.

So, if we have to manage path with the name IT, we cannot browse this subsite along with the all subsites under IT.

Solution

Check the managed path and remove the managed path which is causing the issue. Here, I have removed IT managed path, then it worked fine.

SharePoint 2013 Hosting – HostForLIFE :: Downloading A File From SharePoint Online Site Using The SharePoint App

Jan 14th

Posted by Peter in European SharePoint 2013 Hosting

Generally in SharePoint Online, until we provide an O365 license to any user account, it will not be identified by SPO. To do some generic tasks such as downloading files, or reading some list, we try to avoid regular user accounts and try to use generic accounts. But unlike SP on-premise, we need to assign an O365 license to use this account in SPO.

Another approach we can use is by using a SharePoint App concept. With the help of this, we can do communicate with the SPO site and do things such as reading lists, downloading files, etc.

This approach basically generates an access token which will be used by the SharePoint App. This access token will be validated by the SharePoint online site.

I am not explaining how to register an SP app and providing that particular app permission on the SharePoint online site. Comment if you need any assistance on that. I will be happy to include that also.

I have created this simple console application which can be used and modified as per need. Please create a simple C# console application and include this file.

The first thing which we need to do is to generate access toke with the help of app id and app secret.

We need the below variables values to be identified and replaced in the code to work.

tenantID – You can find tenant id from https://portal.azure.com – Azure Active Directory à Properties
strAppID – This is the App Guid which will be created at https://<sitename>.sharepoint.com/_layouts/15/appregnew.aspx
strAppSecret – App secret
strOrgDomain – Your organization domain will be used in “{organisationdomain}.sharepoint.com”;

Once these values are updated, there will be a web request created to get the access token which will be used by the SP app.

Once access toke is generated, we can use .NET’s WebClient class to download the file. Please update the below variables in the code

string webUrl = “Your SPO site url”

string documentLibName = This should be the path of the file. In the given example I have taken ‘Shared%20Documents/test’ where ‘test’ is a folder inside library.

string fileName = “file name with extension”;

You can refer to my Git Repository for the code.

The code is fairly straight forward and I have put the comments for better understanding.

SharePoint 2013 Hosting – HostForLIFE :: How to Copy Item Attachments To SharePoint Library Using PnP PowerShell?

Jan 7th

Posted by Peter in Other Related Post

In this blog, we are going to learn how to copy the attachments from a single list item to SharePoint library using PnP PowerShell. The following snippet helps, you to get the attachments from a list item and uploads to the shared Documents library in a current context site.

$cred = Get-Credential
Connect-PnPOnline -Url https://ktskumartenant.sharepoint.com/sites/dev -Credential $cred

$listitem = Get-PnPListItem -List Employee -Id 2
$attachments = ForEach-Object{Get-PnPProperty -ClientObject $listitem -Property "AttachmentFiles"}

$attachments | ForEach-Object { Copy-PnPFile -SourceUrl $_.ServerRelativeUrl –TargetUrl “Shared Documents/$($_.FileName)”

$cred = Get-Credential

Connect-PnPOnline -Url https://ktskumartenant.sharepoint.com/sites/dev -Credential $cred

$listitem = Get-PnPListItem -List Employee -Id 2

$attachments = ForEach-Object{Get-PnPProperty -ClientObject $listitem -Property "AttachmentFiles"}

$attachments | ForEach-Object { Copy-PnPFile -SourceUrl $_.ServerRelativeUrl –TargetUrl “Shared Documents/$($_.FileName)”

After running the powershell command, it asks us to confirm the sourceurl and target url. If the file already exists in the targeturl, we have to add -OverwriteIfAlreadyExists $true to avoid the file already exists error.

Below is the example copies the two attachments from the single list item to the folder within a SharePoint library.

SharePoint Hosting – Add, Retrieve And Remove The Navigation Node Using JSOM

Dec 23rd

Posted by Peter in European SharePoint 2013 Hosting

Navigation Bar provides us with the infrastructure to add different navigation link options in a site. We can provide the navigation links within “Top Navigation” and “Quick Launch Navigation”.

Here, I am providing the code through which we can manipulate the navigation links both in Top navigation & Quick Launch navigation. I have added two navigation nodes; i.e., TeamSiteNavigation,TopNavigation.

I have used 3 buttons and their corresponding functions. Here, I am sharing the functionalities and their respective functions below.

For add="Add Navigation"(Function Name->addNavNode() )->

1	For add="Add Navigation"(Function Name->addNavNode() )->

First, I have got the current context and web. Then I got the navigation collection of top navigation Bar. You can also get the Quick Launch by using “get_quickLaunch();”

Then I set properties for a new navigation node & created node as the last node in the collection.

For retrieve="Show Navigations Names"(Function Name->checkNavNames())->

1	For retrieve="Show Navigations Names"(Function Name->checkNavNames())->

Here I am retrieving the navigation collection of top navigation.

For remove="Remove Navigation"(FunctionName->removeNavNode())->

1	For remove="Remove Navigation"(FunctionName->removeNavNode())->

Here I am removing the navigation from the navigation collection, which I have provided in the text box.

< script type = "text/javascript"  
language = "javascript" >  
    var navNodes = [{  
        Name: "TeamSiteNavigation",  
        url: "/sites/TeamSite",  
        fromExternal: false  
    }, {  
        Name: "TopNavigation",  
        url: "http://www.google.com",  
        fromExternal: true  
    }];  
var oNavNodeColl = null;  
var nodeCreationInfo = null;  
  
function addNavNode() {  
    var ctx = new SP.ClientContext.get_current();  
    if (ctx != undefined && ctx != null) {  
        var oWeb = ctx.get_web();  
        this.oNavNodeColl = oWeb.get_navigation().get_topNavigationBar();  
        for (var i = 0; i < navNodes.length; i++) {  
            var navObj = navNodes[i];  
            var nodeTitle = navObj.Name;  
            var navNodeUrl = navObj.url;  
            var navFromExternal = navObj.fromExternal;  
            this.nodeCreationInfo = new SP.NavigationNodeCreationInformation();  
            nodeCreationInfo.set_title(nodeTitle);  
            nodeCreationInfo.set_url(navNodeUrl);  
            nodeCreationInfo.set_isExternal(navFromExternal);  
            nodeCreationInfo.set_asLastNode(true);  
            this.oNavNodeColl.add(nodeCreationInfo);  
        }  
        ctx.load(this.oNavNodeColl);  
        ctx.executeQueryAsync(function() {  
            alert("successfully added")  
        }, function(sender, args) {  
            alert('Request failed. ' + args.get_messege() + '\n' + args.get_stackTrace());  
        });  
    }  
}  
  
function checkNavNames() {  
    var ctx = SP.ClientContext.get_current();  
    var oWeb = ctx.get_web();  
    var oNavNodeColl = oWeb.get_navigation();  
    var nodeColl = oNavNodeColl.get_topNavigationBar();  
    ctx.load(oNavNodeColl);  
    ctx.load(nodeColl, 'Include(Title,Children.Include(Title,Children))');  
    ctx.executeQueryAsync(function() {  
        var navNodeEnumerator = nodeColl.getEnumerator();  
        var nodeNames = "";  
        while (navNodeEnumerator.moveNext()) {  
            var oNavNode = navNodeEnumerator.get_current();  
            nodeNames = nodeNames + '\n' + oNavNode.get_title();  
        }  
        alert(nodeNames);  
    }, function(sender, args) {  
        alert('Request failed. ' + args.get_messege() + '\n' + args.get_stackTrace());  
    });  
}  
  
function removeNavNode() {  
    var navName = document.getElementById("Textbox").value;  
    var ctx = SP.ClientContext.get_current();  
    var oWeb = ctx.get_web();  
    var oNavNodeColl = oWeb.get_navigation();  
    var nodeColl = oNavNodeColl.get_topNavigationBar();  
    ctx.load(oNavNodeColl);  
    ctx.load(nodeColl, 'Include(Title,Children.Include(Title,Children))');  
    ctx.executeQueryAsync(function() {  
        var navNodeEnumerator = nodeColl.getEnumerator();  
        var nodeNames = "";  
        while (navNodeEnumerator.moveNext()) {  
            var oNavNode = navNodeEnumerator.get_current();  
            nodeNames = oNavNode.get_title();  
            if (nodeNames == navName) {  
                oNavNode.deleteObject();  
                ctx.executeQueryAsync(function() {  
                    alert("successfully deleted");  
                }, function(sender, args) {  
                    alert('Request failed. ' + args.get_messege() + '\n' + args.get_stackTrace());  
                });  
            }  
        }  
    }, function(sender, args) {  
        alert('Request failed. ' + args.get_messege() + '\n' + args.get_stackTrace());  
    });  
} < /script>   
< input id = "addButton"  
    type = "button"  
    value = "Add Navigation"  
    onclick = "addNavNode()" / >< br / >< div style = "marginTop:20px;" > & nbsp < /div>< input id = "checkButton"  
    type = "button"  
    value = "Show Navigations Names"  
    onclick = "checkNavNames()" / >< br / >< div style = "marginTop:20px;" > & nbsp < /div>< label > Enter navigation name to delete < /label>< input id = "Textbox"  
    type = "text" / >< input id = "removeButton"  
    type = "button"  
    value = "Remove Navigation"  
onclick = "removeNavNode()" >

< script type = "text/javascript"

language = "javascript" >

var navNodes = [{

Name: "TeamSiteNavigation",

url: "/sites/TeamSite",

fromExternal: false

}, {

Name: "TopNavigation",

url: "http://www.google.com",

fromExternal: true

}];

var oNavNodeColl = null;

var nodeCreationInfo = null;

function addNavNode() {

var ctx = new SP.ClientContext.get_current();

if (ctx != undefined && ctx != null) {

var oWeb = ctx.get_web();

this.oNavNodeColl = oWeb.get_navigation().get_topNavigationBar();

for (var i = 0; i < navNodes.length; i++) {

var navObj = navNodes[i];

var nodeTitle = navObj.Name;

var navNodeUrl = navObj.url;

var navFromExternal = navObj.fromExternal;

this.nodeCreationInfo = new SP.NavigationNodeCreationInformation();

nodeCreationInfo.set_title(nodeTitle);

nodeCreationInfo.set_url(navNodeUrl);

nodeCreationInfo.set_isExternal(navFromExternal);

nodeCreationInfo.set_asLastNode(true);

this.oNavNodeColl.add(nodeCreationInfo);

}

ctx.load(this.oNavNodeColl);

ctx.executeQueryAsync(function() {

alert("successfully added")

}, function(sender, args) {

alert('Request failed. ' + args.get_messege() + '\n' + args.get_stackTrace());

});

}

function checkNavNames() {

var ctx = SP.ClientContext.get_current();

var oWeb = ctx.get_web();

var oNavNodeColl = oWeb.get_navigation();

var nodeColl = oNavNodeColl.get_topNavigationBar();

ctx.load(oNavNodeColl);

ctx.load(nodeColl, 'Include(Title,Children.Include(Title,Children))');

ctx.executeQueryAsync(function() {

var navNodeEnumerator = nodeColl.getEnumerator();

var nodeNames = "";

while (navNodeEnumerator.moveNext()) {

var oNavNode = navNodeEnumerator.get_current();

nodeNames = nodeNames + '\n' + oNavNode.get_title();

}

alert(nodeNames);

}, function(sender, args) {

alert('Request failed. ' + args.get_messege() + '\n' + args.get_stackTrace());

});

}

function removeNavNode() {

var navName = document.getElementById("Textbox").value;

var ctx = SP.ClientContext.get_current();

var oWeb = ctx.get_web();

var oNavNodeColl = oWeb.get_navigation();

var nodeColl = oNavNodeColl.get_topNavigationBar();

ctx.load(oNavNodeColl);

ctx.load(nodeColl, 'Include(Title,Children.Include(Title,Children))');

ctx.executeQueryAsync(function() {

var navNodeEnumerator = nodeColl.getEnumerator();

var nodeNames = "";

while (navNodeEnumerator.moveNext()) {

var oNavNode = navNodeEnumerator.get_current();

nodeNames = oNavNode.get_title();

if (nodeNames == navName) {

oNavNode.deleteObject();

ctx.executeQueryAsync(function() {

alert("successfully deleted");

}, function(sender, args) {

alert('Request failed. ' + args.get_messege() + '\n' + args.get_stackTrace());

});

}

}, function(sender, args) {

alert('Request failed. ' + args.get_messege() + '\n' + args.get_stackTrace());

});

} < /script>

< input id = "addButton"

type = "button"

value = "Add Navigation"

onclick = "addNavNode()" / >< br / >< div style = "marginTop:20px;" > & nbsp < /div>< input id = "checkButton"

type = "button"

value = "Show Navigations Names"

onclick = "checkNavNames()" / >< br / >< div style = "marginTop:20px;" > & nbsp < /div>< label > Enter navigation name to delete < /label>< input id = "Textbox"

type = "text" / >< input id = "removeButton"

type = "button"

value = "Remove Navigation"

onclick = "removeNavNode()" >

Follow the below instructions and refer to the corresponding image to perform the Operation,

Click on Add Navigation,

After adding the node,

Click on Show Navigations Names,

Now we can check Navigation name in the alertbox,

Give the navigation node which you want to delete.

I’ve successfully deleted the navigation node.

Posts tagged trick SharePoint 2013 Hosting

SharePoint Hosting – Custom RSS SPFx Feed WebPart In Modern UI

Challenge

Solution

React SharePoint Framework Web part

SharePoint 2013 Hosting – HostForLIFE :: Managing Site Storage In SharePoint Online

Overview

Site Storage in SharePoint Online

Site storage configuration

Manage site storage for individual sites

PowerShell support

Summary

How To Fix SharePoint 404 Error After Content Database Migration?

Issue Description

Background of the issue

Example

Solution

SharePoint 2013 Hosting – HostForLIFE :: Downloading A File From SharePoint Online Site Using The SharePoint App

SharePoint 2013 Hosting – HostForLIFE :: How to Copy Item Attachments To SharePoint Library Using PnP PowerShell?

SharePoint Hosting – Add, Retrieve And Remove The Navigation Node Using JSOM

BLOGROLL

Featured On

Posts tagged trick SharePoint 2013 Hosting

SharePoint Hosting – Custom RSS SPFx Feed WebPart In Modern UI

Challenge

Solution

React SharePoint Framework Web part

SharePoint 2013 Hosting – HostForLIFE :: Managing Site Storage In SharePoint Online

Overview

Site Storage in SharePoint Online

Site storage configuration

Manage site storage for individual sites

PowerShell support

Summary

How To Fix SharePoint 404 Error After Content Database Migration?

Issue Description

Background of the issue

Example

Solution

SharePoint 2013 Hosting – HostForLIFE :: Downloading A File From SharePoint Online Site Using The SharePoint App

SharePoint 2013 Hosting – HostForLIFE :: How to Copy Item Attachments To SharePoint Library Using PnP PowerShell?

SharePoint Hosting – Add, Retrieve And Remove The Navigation Node Using JSOM

BLOGROLL

Featured On

Tags