Articles about European Sharepoint Hosting Service
Posts tagged cheap europe sharepoint 2013 hosting
SharePoint Hosting – Upload Nested Folder Structure And Files On A SP Online Library
Aug 31st
Hi guys, let’s explore some amazing ways to completely migrate a nested folder structure with lots of different files which is from your local path to a SP online library using PnP PowerShell.
Here is the script to run on Windows ISE Powershell:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
#Function to Copy Multiple Files with Folder structure to SharePoint Online Document Library Function Migrate - PnPFolderToSPO() { param( [Parameter(Mandatory = $true)][string] $SiteURL, [Parameter(Mandatory = $true)][string] $SourceFolderPath, [Parameter(Mandatory = $true)][string] $LibraryName, [Parameter(Mandatory = $true)][string] $LogFile) Try { Add - content $Logfile - value "`n---------------------- File Upload Script Started: $(Get-date -format 'dd/MM/yyy hh:mm:ss tt')-------------------" #Connect to PnP Online Connect - PnPOnline - Url $SiteURL - UseWebLogin #Get the Target Folder to Upload $Web = Get - PnPWeb $List = Get - PnPList $LibraryName - Includes RootFolder $TargetFolder = $List.RootFolder $TargetFolderSiteRelativeURL = $TargetFolder.ServerRelativeURL.Replace($Web.ServerRelativeUrl, "") #Get All Items from the Source $Source = Get - ChildItem - Path $SourceFolderPath - Recurse $SourceItems = $Source | Select FullName, PSIsContainer, @ { Label = 'TargetItemURL'; Expression = { $_.FullName.Replace($SourceFolderPath, $TargetFolderSiteRelativeURL).Replace("\"," / ")}} Add - content $Logfile - value "Number of Items Found in the Source: $($SourceItems.Count)" #Upload Source Items from Fileshare to Target SharePoint Online document library $Counter = 1 $SourceItems | ForEach - Object { #Calculate Target Folder URL $TargetFolderURL = (Split - Path $_.TargetItemURL - Parent).Replace("\"," / ") $ItemName = Split - Path $_.FullName - leaf #Replace Invalid Characters $ItemName = [RegEx]::Replace($ItemName, "[{0}]" - f([RegEx]::Escape([String] '\"*:<>?/\|')), '_') #Display Progress bar $Status = "uploading '" + $ItemName + "' to " + $TargetFolderURL + " ($($Counter) of $($SourceItems.Count))" Write - Progress - Activity "Uploading ..." - Status $Status - PercentComplete(($Counter / $SourceItems.Count) * 100) If($_.PSIsContainer) { #Ensure Folder $Folder = Resolve - PnPFolder - SiteRelativePath($TargetFolderURL + "/" + $ItemName) Write - host "Ensured Folder '$($ItemName)' to Folder $TargetFolderURL" Add - content $Logfile - value "Ensured Folder '$($ItemName)' to Folder $TargetFolderURL" } Else { #Upload File $File = Add - PnPFile - Path $_.FullName - Folder $TargetFolderURL Write - host "Uploaded File '$($_.FullName)' to Folder $TargetFolderURL" Add - content $Logfile - value "Uploaded File '$($_.FullName)' to Folder $TargetFolderURL" } $Counter++ } } Catch { Write - host - f Red "Error:" $_.Exception.Message Add - content $Logfile - value "Error:$($_.Exception.Message)" } Finally { Add - content $Logfile - value "---------------------- File upload Script Completed: $(Get-date -format 'dd/MM/yyy hh:mm:ss tt')-----------------" } } #Call the Function to Upload a Folder to SharePoint Online Migrate - PnPFolderToSPO - SiteURL "https://samplesharenet.sharepoint.com/sites/classictest" - SourceFolderPath "C:\Users\Bharat\Documents\Bharat\General Works for Internal Requirements" - LibraryName "PnPCopytoLib" - LogFile "C:\Users\Bharat\PnPTest\Migration-LOG.log" |
Just enter your own respective details which are highlighted in the above script.
When it starts running, enter your Site Admin/Global Admin Tenant details to start the processing.
You can see the Uploading in Progress on your Windows Powershell ISE Interface. Just wait until it gets finished!
This script copies the contents of a folder to the SharePoint Online document library. It overwrites any existing file in the target SharePoint Online library. It creates a folder if it doesn’t exist on the target site already. We can also use this script to migrate files and folders from network file share to SharePoint Online document library!
Creative Idea
You can have the above script triggered through a Flow/Azure Flow[Logic Apps] to have an automated Copying and include Removal in the Source to establish an Automated Archival Process for your Business needs.
SharePoint Hosting – List All Content Editor Webparts Present In A SharePoint OnPremise Web Application Using PowerShell
Aug 24th
In this article, I will provide information on how to get all the content editor webparts present under a web application using PowerShell.
Below are the components used in this document.
- PowerShell
- SharePoint 2016
Some time ago we get a request to collect an inventory on the current SharePoint environment; including how many content editor Webparts and the number of lists and libraries under a web application. Below is the step by step way to get all the content editor webparts present under a web application using PowerShell.
Power Shell File
Step 1
Create a text file. Name it as “GetTotalCEWP.ps1” file. Note that you will have to change the extension from “.txt” to “.ps1”
Step 2
Insert the below code to get the web application URL as an input from the user.
- [CmdletBinding()]
- param( [Parameter(Position=0,Mandatory=$true,ValueFromPipeline=$false,HelpMessage=“Input the Web Application URL.”)] [string]$WebApp)
Step 3
Insert the below code to load the SharePoint PowerShell snap in.
|
1 2 3 4 |
if ((Get - PSSnapin - Name Microsoft.SharePoint.PowerShell - ErrorAction SilentlyContinue) - eq $null) { Write - Host "Loading SharePoint PowerShell" Add - PSSnapin Microsoft.SharePoint.PowerShell } |
Step 4
Insert the below code to get all the publishing pages and then fetch the content editor webparts from those pages.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
$SPWebApp = Get - SPWebApplication $WebApp - EA SilentlyContinue if ($SPWebApp - eq $null) { Write - Error "$WebApp url is not a valid!" } else { $allsites = $SPWebApp.Sites foreach($site in $allsites) { try { $allwebs = $site.AllWebs foreach($web in $allwebs) { try { if ([Microsoft.SharePoint.Publishing.PublishingWeb]::IsPublishingWeb($web)) { $pubpages = [Microsoft.SharePoint.Publishing.PublishingWeb]::GetPublishingWeb($web) $allpages = $pubpages.GetPublishingPages() foreach($page in $allpages) { GetCEWPFunction - url $page.Url } } } catch {} finally { $web.Dispose() } } } catch {} finally { $site.Dispose() } } } |
Step 5
There might be scenarios where we have added the content Editor webparts inside the List/Libraries forms (edit/view/display). Insert the below code to retrieve the same. We have to insert this code just before the first try/catch ends.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
GetCEWPFunction - url $page.Url } } $lists = $web.GetListsOfType("DocumentLibrary") | ? { $_.IsCatalog - eq $false } foreach($list in $lists) { $allviews = $list.Views foreach($view in $allviews) { GetCEWPFunction - url $view.Url } $allforms = $list.Forms foreach($form in $allforms) { GetCEWPFunction - url $form.Url } } } catch {} finally { $web.Dispose() } } } catch {} finally { $site.Dispose() } } } |
Step 6
Insert the below code to have the function named “GetCEWPFunction “ which would actually count the content editor webpart.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
function GetCEWPFunction([string] $url) { $manager = $web.GetLimitedWebPartManager($url, [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared) $allwebParts = $manager.WebParts if ($allwebParts.Count - ne 0) { foreach($webPart in $allwebParts) { if ($webPart.GetType() - eq[Microsoft.SharePoint.WebPartPages.ContentEditorWebPart]) { if ($webPart.ContentLink.Length - gt 0) { $file = $web.GetFile($webPart.ContentLink) $data = $file.OpenBinary() $encode = New - Object System.Text.ASCIIEncoding $contents = $encode.GetString($data) if ($contents.ToLower().Contains("<script>")) { Write - Output "$($web.Url)/$url (CONTENTLINK)" } break } if ($webPart.Content.InnerText.Contains("<script>")) { Write - Output "$($web.Url)/$url (HTML)" } } } } } |
Step 7
The full file will look as attached with this article.
Step 8
Save your PowerShell File and test it by running below command. It will list down all the content editor webparts present under a web application
.\GetTotalCEWP.ps1 -WebApp http://portal.intranet.com
That is it. I hope you have learned something new from this article and will utilize this in your work.
SharePoint Hosting – Navigation Bar In SPFx With Current User Greetings
Aug 13th
Here we will see how to create a navigation bar using spfx extension. So let’s see how we can achieve this.
md ext2
cd ext2
yo @ microsoft/sharepoint
What is your solution name?: ext2
Which type of client-side como you want to target for your component(s)? SharePoint Online only (latest)
Component to create?: Extension
What is your Application Customizer name? ext2
What is your Application Customizer description? ext description
After the scaffolding run the below command to install the office fabric ui:
npm install @microsoft/sp-office-ui-fabric-core
Then code.
Create a new file named ./src/extensions/ext2/AppCustomizer.module.scss.
Update AppCustomizer.module.scss as follows:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 |
@import '~@microsoft/sp-office-ui-fabric-core/dist/sass/SPFabricCore.scss';.app { .top { height: 60 px; text - align: center; line - height: 2.5; font - weight: bold; display: flex; align - items: center; justify - content: center; background - color: $ms - color - themePrimary; color: $ms - color - white; }.bottom { height: 40 px; text - align: center; line - height: 2.5; font - weight: bold; display: flex; align - items: center; justify - content: center; background - color: $ms - color - themePrimary; color: $ms - color - white; } }.topnav { overflow: hidden; background - color: black; }.topnav a { float: left; color: #f2f2f2; text - align: center; padding: 14 px 16 px; text - decoration: none; font - size: 17 px; }.topnav a: hover { background - color: #ddd; color: black; }.topnav a.active { background - color: #4CAF50; color: white; } |
In the Ext2ApplicationCustomizer.ts
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 |
import { override } from '@microsoft/decorators'; import { Log } from '@microsoft/sp-core-library'; import { BaseApplicationCustomizer, PlaceholderContent, PlaceholderName } from '@microsoft/sp-application-base'; import { Dialog } from '@microsoft/sp-dialog'; import * as strings from 'Ext2ApplicationCustomizerStrings'; import styles from './AppCustomizer.module.scss'; import { escape } from '@microsoft/sp-lodash-subset'; const LOG_SOURCE: string = 'Ext2ApplicationCustomizer'; export interface IExt2ApplicationCustomizerProperties { Top: string; Bottom: string; } /** A Custom Action which can be run during execution of a Client Side Application */ export default class Ext2ApplicationCustomizer extends BaseApplicationCustomizer < IExt2ApplicationCustomizerProperties > { private _bottomPlaceholder: PlaceholderContent | undefined; @override public onInit(): Promise < void > { this.context.placeholderProvider.changedEvent.add(this, this._renderPlaceHolders); return Promise.resolve(); } private _renderPlaceHolders(): void { const topPlaceholder = this.context.placeholderProvider.tryCreateContent(PlaceholderName.Top, { onDispose: this.onDispose }); if (!topPlaceholder) { console.error("The expected placeholder (Top) was not found."); return; } if (topPlaceholder.domElement) { topPlaceholder.domElement.innerHTML = ` <div class = "${styles.topnav}"> <a class = "${styles.active}" href = "https://dronzer.sharepoint.com/sites/Barcelona/SitePages/Home.aspx">Home</a> <a href = "https://dronzer.sharepoint.com/sites/Liverpool">News</a> <a href = "https://dronzer.sharepoint.com/sites/chelsea">About us</a> <a href = "https://dronzer.sharepoint.com/sites/mancity">Find Mentor</a> </div> <span class = "${styles.top}">Hello! ${escape(this.context.pageContext.user.displayName)}</span> `; } // Handling the bottom placeholder if (!this._bottomPlaceholder) { this._bottomPlaceholder = this.context.placeholderProvider.tryCreateContent(PlaceholderName.Bottom, { onDispose: this._onDispose }); // The extension should not assume that the expected placeholder is available. if (!this._bottomPlaceholder) { console.error("The expected placeholder (Bottom) was not found."); return; } if (this.properties) { let bottomString: string = this.properties.Bottom; if (!bottomString) { bottomString = "(Bottom property was not defined.)"; } if (this._bottomPlaceholder.domElement) { this._bottomPlaceholder.domElement.innerHTML = ` <div class="${styles.app}"> <div class="${styles.bottom}"> <i aria-hidden="true"></i> ${escape( bottomString )} </div> </div>` } } } } private _onDispose(): void { console.log('[HelloWorldApplicationCustomizer._onDispose] Disposed custom top and bottom placeholders.'); } } |
Update the serve.json file as
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
{ "$schema": "https://developer.microsoft.com/json-schemas/core-build/serve.schema.json", "port": 4321, "https": true, "serveConfigurations": { "default": { "pageUrl": "enter the site url", "customActions": { "716b612c-e184-4ccc-a24e-604a7c837821": { "location": "ClientSideExtension.ApplicationCustomizer", "properties": { "Top": "DRONZER10", "Bottom": "Nilanjan Mukherjee" } } } }, "ext2": { "pageUrl": "enter the site url", "customActions": { "716b612c-e184-4ccc-a24e-604a7c837821": { "location": "ClientSideExtension.ApplicationCustomizer", "properties": { "Top": "DRONZER10", "Bottom": "Nilanjan Mukherjee" } } } } } } |
Update the package-solution.json file as
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
{ "$schema": "https://developer.microsoft.com/json-schemas/spfx-build/package-solution.schema.json", "solution": { "name": "ext-2-client-side-solution", "id": "8e90fd7b-a799-4834-82c6-d55b530af66c", "version": "4.0.0.0", "includeClientSideAssets": true, "isDomainIsolated": false, "developer": { "name": "", "websiteUrl": "", "privacyUrl": "", "termsOfUseUrl": "", "mpnId": "" }, "features": [{ "title": "Application Extension - Deployment of custom action.", "description": "Deploys a custom action with ClientSideComponentId association", "id": "e53cf4f6-9ca9-4060-8f09-bca3286ecf18", "version": "1.0.0.0", "assets": { "elementManifests": ["elements.xml"] } }] }, "paths": { "zippedPackage": "solution/ext-2.sppkg" } } |
Update the elements.xml file as,
|
1 2 3 4 5 6 7 8 9 |
<?xml version="1.0" encoding="utf-8"?> <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <CustomAction Title="Ext2" Location="ClientSideExtension.ApplicationCustomizer" ClientSideComponentId="716b612c-e184-4ccc-a24e-604a7c837821" ClientSideComponentProperties="{"Top":"DRONZER10","Bottom":"Nilanjan Mukherjee"}"></CustomAction> </Elements> |
You can test the extension in the local workbench using command gulp serve.
For using in sharepoint please package the solution
|
1 2 |
gulp bundle --ship gulp package-solution --ship |
Under the SharePoint folder find the ext-2.sppkg file. Here you can right click and then click on reveal in file explorer.
Upload the solution in the sharepoint app catalog. From the site content page add the solution. After the solution is added successfully, the extension will be visible in the modern page. If you do any enhancement in the solution please go to the package-solution.json file and update the version before uploading it to the Sharepoint app catalog.
SharePoint Hosting – Delete A List In SharePoint Online Using PnP Powershell
Aug 6th
Today, we’ll look at deleting a SharePoint List in Office 365 using PowerShell PnP. First we need to connect the SharePoint Online site using the below command,
Step 1
Open SharePoint Management Shell as an Administrator in your machine.
Step 2
Run the following command to import PnP to install the PowerShell cmdlets,
|
1 |
Install-Module SharePointPnPPowerShellOnline |
Step 3
To use the library you first need to connect to your tenant using the below cmdlets.
|
1 |
connect-PnPOnline –Url https://fortunestrikes.sharepoint.com –Credentials (Get-Credential) |
Syntax – https://docs.microsoft.com/en-us/powershell/module/sharepoint-pnp/remove-pnplist?view=sharepoint-ps
|
1 2 3 4 5 6 |
Remove-PnPList -Identity <ListPipeBind> [-Recycle [<SwitchParameter>]] [-Force [<SwitchParameter>]] [-Web <WebPipeBind>] [-Connection <PnPConnection>] |
Syntax – Remove List item
|
1 2 3 4 5 6 7 |
Remove-PnPListItem -List <ListPipeBind> -Identity <ListItemPipeBind> [-Recycle [<SwitchParameter>]] [-Force [<SwitchParameter>]] [-Web <WebPipeBind>] [-Connection <PnPConnection>] |
Now that we’re logged into the site collection, let’s create our List/document library.
Remove List/ document library
|
1 |
Remove-PnPList -Identity DemoList |
Remove-Pn
|
1 |
Remove-PnPListItem -List "Demo List" -Identity "5" -Force |
Thanks for reading my blog.
SharePoint Hosting – Restore Recycle Bin Items From SharePoint Site Using CSOM
Jul 23rd
A Recycle Bin is a temporary storage location for deleted items from that site.
When we delete an item first it goes to First Stage Recycle Bin and stays there for a short-term period then it moves to second-stage Recycle Bin.
In case of permanent deletion, we need to delete it again from second-stage Recycle Bin.
Sometimes we may require this item again in that case simply we need to restore it back from Recycle Bin. It can be restored by both manually and programmatically.
Here, I am going to explain how to Restore Recycle Bin Items from a SharePoint Site using Client Side Object Model (CSOM).
By using the below steps we can restore all items present in the Recycle Bin section.
Step 1
Retrieve Recycle Bin Items from the site.
Step 2
Restore it.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using Microsoft.SharePoint.Client; using System.Security; namespace RestoreRecyclebinSharepointItem { class Program { static void Main(string[] args) { SecureString pwd = new SecureString(); string Username ="testusera@demo.onmicrosoft.com"; string password = "Password"; try { using (ClientContext ctx = new ClientContext("https://portal.sharepoint.com/sites/Demosite")) { foreach (char c in password.ToArray()) pwd.AppendChar(c); ctx.Credentials = new SharePointOnlineCredentials(Username, pwd); RecycleBinItemCollection recycleBinItems = ctx.Site.RecycleBin; ctx.Load(recycleBinItems); ctx.ExecuteQuery(); //Restore all items from Recycle Bin recycleBinItems.RestoreAll(); ctx.ExecuteQuery(); Console.WriteLine("item restored"); } } catch (Exception ex) { } Console.ReadLine(); } } } |
SharePoint 2013 Hosting – HostForLIFE.eu :: Create SharePoint List Items In Batch Using CSOM
Jul 3rd
Here, we are going to perform the most useful operation which can be performed in SharePoint platform to make our lives easier. We will learn how to create and update list items in batches using CSOM. Using this we can update a huge number of list items in a list. Please follow the below steps to understand the code better.
Step 1
Set the credential by giving input of user ID and Password for SharePoint.
Step 2
Using client context get the web & a list in which we want to update the list items.
Step 3
Using the schema AddFieldAsXML, we can add our custom field as per our requirement. (Here I have created a text field).
Step 4
Now in this step we will create 20 list items in each field present in the list & update the items using the for loop. We are using for loop for the batch update, only we have to change the condition value of ‘ i ’(e.g. here we used i<20).
Now, check the complete code below.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 |
using System; using System.Security; using Microsoft.SharePoint.Client; namespace ConsoleApp7 { class Program { /// <summary> /// This is the main entry function /// </summary> /// <param name="args"></param> static void Main(string [] args) { #region [Variables] string schemaTextField = string.Empty; string password = string.Empty; #endregion #region [SP Variables] ClientContext ctx = null; Web spWeb = null; List spList = null; SecureString securStr = null; ListItemCreationInformation spItemInfo = null; ListItem spItem = null; Field simpleTextField=null; #endregion using (ctx = new ClientContext("https://contoso.sharepoint.com/sites/sitename")) { try { securStr = new SecureString(); password = "Enter the password"; foreach (char ch in password) { securStr.AppendChar(ch); } ctx.Credentials = new SharePointOnlineCredentials("Enter UserName", securStr); spWeb = ctx.Web; ctx.Load(spWeb); spList = spWeb.Lists.GetByTitle("listName"); schemaTextField = "Field Type='Text' Name='MyCustomTextField' StaticName='MyCustomTextField' DisplayName='MyCustomTextField' />"; simpleTextField = spList.Fields.AddFieldAsXml(schemaTextField, true, AddFieldOptions.AddFieldInternalNameHint); ctx.ExecuteQuery(); for (var i = 1; i < 20; i++) { try { spItemInfo = new ListItemCreationInformation(); spItem = spList.AddItem(spItemInfo); spItem["Title"] = "MyNewItem-" + i.ToString(); spItem["MyCustomTextField"] = "My Custom Values-" + i.ToString(); spItem.Updzcate(); } catch (Exception ex) Console.WriteLine("Error:- " + ex.ToString()); } } ctx.ExecuteQuery(); } catch (Exception ex) { Console.WriteLine("Error:- " + ex.ToString()); } } } } } |
After running the code, we can go to our respective List and check for the items which are now created successfully.
For the output please refer to the below image
