Posts tagged cheap europe 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 :: 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.

SharePoint Hosting – Change SharePoint Online List Or Library Internal Name

Dec 17th

Posted by Peter in Other Related Post

Recently we have provided a build and guideline document to our client and by mistake they have set up a library with the wrong internal name. In the beginning it worked well but as the additional functionality was added, it broke. As the users have started working on that, we needed to fix the internal name anyway.

Our library internal name is “TrainingDocuments” and display name is “Training Documents”. While Client has set up “Training Documents”

Solution

Initially we thought it might be not possible. But then we found 2 ways to do it,

Approach 1 – Using SharePoint Designer 2013

Follow the below steps to fix this using SharePoint Designer 2013,

In SharePoint Designer, Open your site.
Navigate to All Files navigation node (not List and Libraries node),
Note
you will need “Site Collection Administrator” permission in the site collection to see “All Files” option.
Find your list there
Right-click list
Rename.

Approach 2 – Using PNP PowerShell

In case you are not able to connect the site in the SharePoint designer or you do not have it installed in your machine, you can do this using PNP PowerShell as well.

PowerShell to change Library Name,

#Set Parameters  

$<span class="attribute">SiteURL</span> = <span class="attribute-value">"Site URL"</span>  

$<span class="attribute">ListName</span> = <span class="attribute-value">"Library Internal Name"</span>  

$<span class="attribute">NewListURL</span> = <span class="attribute-value">"New Library Name"</span>  

    
#Connect to PNP Online  

Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)  

   

 #this will change URL  

#Get the List  

$<span class="attribute">List</span>= <span class="attribute-value">Get</span>-PnPList -Identity $ListName -Includes RootFolder  

   

#sharepoint online powershell change list url  

$List.Rootfolder.MoveTo($NewListURL)  

Invoke-PnPQuery  

  

#this will change library title  

Set-PnPList -Identity $ListName -Title $NewListURL

#Set Parameters

$<span class="attribute">SiteURL</span> = <span class="attribute-value">"Site URL"</span>

$<span class="attribute">ListName</span> = <span class="attribute-value">"Library Internal Name"</span>

$<span class="attribute">NewListURL</span> = <span class="attribute-value">"New Library Name"</span>

#Connect to PNP Online

Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)

#this will change URL

#Get the List

$<span class="attribute">List</span>= <span class="attribute-value">Get</span>-PnPList -Identity $ListName -Includes RootFolder

#sharepoint online powershell change list url

$List.Rootfolder.MoveTo($NewListURL)

Invoke-PnPQuery

#this will change library title

Set-PnPList -Identity $ListName -Title $NewListURL

PowerShell to change List Name

For list, we don’t need to execute command for root folder changes. So, the updated powershell is as follows:

#Set Parameters  

$<span class="attribute">SiteURL</span> = <span class="attribute-value">"Site URL"</span>  

$<span class="attribute">ListName</span> = <span class="attribute-value">"Library Internal Name"</span>  

$<span class="attribute">NewListURL</span> = <span class="attribute-value">"New Library Name"</span>  

    

#Connect to PNP Online  

Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)  

Set-PnPList -Identity $ListName -Title $NewListURL

#Set Parameters

$<span class="attribute">SiteURL</span> = <span class="attribute-value">"Site URL"</span>

$<span class="attribute">ListName</span> = <span class="attribute-value">"Library Internal Name"</span>

$<span class="attribute">NewListURL</span> = <span class="attribute-value">"New Library Name"</span>

#Connect to PNP Online

Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)

Set-PnPList -Identity $ListName -Title $NewListURL

SharePoint 2013 Hosting – HostForLIFE.eu :: File Server Migration To SharePoint Online Using SPMT PowerShell

Dec 10th

Posted by Peter in European SharePoint 2013 Hosting

Recently we had a project where we needed to migrate file server to SharePoint Online. So, we decided to go with SharePoint Migration Tool (SPMT). But we had 50 plus folders and all were needed to migrate to different site document libraries. As it takes long time to migrate using tool due to creating connection, we decided to use the PowerShell version.

Issue

We faced the below issues in this requirement,

The documentation for this is not that accurate or in single place. We need to search here and there for things.
SPMT tool migrates file server child items directly but when you use PowerShell, it migrates parent folder. Due to the curse of first point, it took some time for us to find the hidden solution. Go through this post to see that hidden gem.
The last but not least is permission migration. SPMT has all this functionality but as I said earlier it is not documented well.

So, we will try to explain all our knowledge in detail here.

Solution

First, we need to prepare a csv which will be read by PowerShell and It will have connection details of source and migration.

Important notes for preparing csv,

Do not include a header row in your CSV file.
Remember to account for all six columns in the file, even if you are not needing a value for a given field.
If you use the standard out-of-the-box Document library (“Shared Documents”), you must use the Display name “Documents” as the placeholder value for the Target Document Library in your CSV file. If you enter “Shared Documents” in that column, you will receive an “invalid document library” error.

Note

If the language of the destination SharePoint site is other than English, check the Display name of the “Shared Documents” Document library by browsing to Documents library.

The format of csv is as below,

Source,SourceDocLib,SourceSubFolder,TargetWeb,TargetDocLib,TargetSubFolder

1	Source,SourceDocLib,SourceSubFolder,TargetWeb,TargetDocLib,TargetSubFolder

As we are migrating from file server, we will not pass the “SourceDocLib” & “SourceSubFolder” details. So, our csv detail will look like below,

File server path,,, TargetWeb,TargetDocLib,TargetSubFolder

For example,

C:\MigrationTests\testfiles,,,https://contoso.sharepoint.com/sites/Sample/,DocLibraryName,DocLibraryName_subfolder

In case you don’t want to migrate it to sub folder, the subfolder part will be blank.

File server path,,, TargetWeb,TargetDocLib,

For example,

C:\MigrationTests\testfiles,,,https://contoso.sharepoint.com/sites/Sample/,DocLibraryName,

In next blog we will use this csv in the PowerShell.

Posts tagged cheap europe sharepoint 2013 hosting

SharePoint Hosting – Custom RSS SPFx Feed WebPart In Modern UI

Challenge

Solution

React SharePoint Framework Web part

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

SharePoint Hosting – Change SharePoint Online List Or Library Internal Name

Solution

Approach 1 – Using SharePoint Designer 2013

Approach 2 – Using PNP PowerShell

SharePoint 2013 Hosting – HostForLIFE.eu :: File Server Migration To SharePoint Online Using SPMT PowerShell

Issue

Solution

BLOGROLL

Featured On

Posts tagged cheap europe sharepoint 2013 hosting

SharePoint Hosting – Custom RSS SPFx Feed WebPart In Modern UI

Challenge

Solution

React SharePoint Framework Web part

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

SharePoint Hosting – Change SharePoint Online List Or Library Internal Name

Solution

Approach 1 – Using SharePoint Designer 2013

Approach 2 – Using PNP PowerShell

SharePoint 2013 Hosting – HostForLIFE.eu :: File Server Migration To SharePoint Online Using SPMT PowerShell

Issue

Solution

BLOGROLL

Featured On

Tags