tag:blogger.com,1999:blog-83132011815216367532024-03-05T04:02:45.643+00:00The SharePoint ShowboatMy name is Phil Izod and I have been working with Microsoft 365 and related technologies (with a lot of SharePoint) since 2005. I thought it might be helpful to the community if I shared some of my experiences. Feel free to leave comments if you wish; it’s great to know whether the information is helpful or not.Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.comBlogger58125tag:blogger.com,1999:blog-8313201181521636753.post-52397630460961401622023-06-09T12:08:00.002+01:002023-06-22T14:00:09.045+01:00SharePoint Document Library Folder Metadata Extract using PNP PowerShellI recently was asked to extract lots of metadata from one of our SharePoint
solutions. The ask was the following: <ul><li>Find all folders within a document library
with a particular content type (folders are always at the root of the library.</li>
<li>For each folder, extract specific metadata fields (ergo get Folder metadata)
including managed metadata fields.</li><li>Export the information to csv</li></ul><div>The main reason I decided to post this was that I couldn't find a good example of extracting custom metadata fields from a Folder Content Type item.</div><div><br /></div><div>This solution is based on PNP. It is fairly crude (no error handling) but does the job.</div><div><br /></div><div><i>Aside, this script works with PnP.PowerShell version </i><i>1.9.0. My colleague tried it with an older version and it was unable to get the Managed Metadata Column labels.</i></div><div><div><br /></div><div><span style="font-size: x-small;">#Folder content type name "My Folder Content Type"</span></div><div><span style="font-size: x-small;"><br /></span></div><div><span style="font-size: x-small;">#Get the following folder fields</span></div><div><span style="font-size: x-small;">#FolderFieldText1</span></div><div><span style="font-size: x-small;">#FolderFieldText2</span></div><div><span style="font-size: x-small;">#FolderFieldManagedMetadata1</span></div><div><span style="font-size: x-small;">#FolderFieldManagedMetadata2</span></div><div><span style="font-size: x-small;"><br /></span></div><div><span style="font-size: x-small;">#########################################</span></div><div><span style="font-size: x-small;">#Set following three variables before run</span></div><div><span style="font-size: x-small;">$siteUrl ="https://mytenant.sharepoint.com/sites/site 1/" </span></div><div><span style="font-size: x-small;">$libraryName = "Documents"</span></div><div><span style="font-size: x-small;">$csvLocation = "C:\FolderMetadataExport.csv"</span></div><div><span style="font-size: x-small;">#########################################</span></div><div><span style="font-size: x-small;"><br /></span></div><div><span style="font-size: x-small;">#Add folder header</span></div><div><span style="font-size: x-small;">$folderHeader = "Path,Title,Folder Field Text1,Folder Field Text2,Folder Field Managed Metadata 1,Folder Field Managed Metadata 2,"</span></div><div><span style="font-size: x-small;">Add-Content -Path $csvLocation -Value $folderHeader</span></div><div><span style="font-size: x-small;"><br /></span></div><div><span style="font-size: x-small;">Connect-PnPOnline -url $siteUrl -UseWebLogin</span></div><div><span style="font-size: x-small;">$items = Get-PnPListItem -List $libraryName -Query "<View><ViewFields><FieldRef Name='FolderFieldText1'/><FieldRef Name='FolderFieldText2'/><FieldRef Name='FolderFieldManagedMetadata1'/><FieldRef Name='FolderFieldManagedMetadata2'/></ViewFields><Query><Where><Eq><FieldRef Name='ContentType'/><Value Type='Text'>My Folder Content Type</Value></Eq></Where></Query></View>"</span></div><div><span style="font-size: x-small;">foreach($item in $items){</span></div><div><span style="font-size: x-small;"> </span></div><div><span style="font-size: x-small;"> $folderInfo = '"'</span></div><div><span style="font-size: x-small;"> $folderInfo += $item.FieldValues.FileRef</span></div><div><span style="font-size: x-small;"> $folderInfo += '","'</span></div><div><span style="font-size: x-small;"> $folderInfo += $item.FieldValues["Title"]</span></div><div><span style="font-size: x-small;"> $folderInfo += '","'</span></div><div><span style="font-size: x-small;"> $folderInfo += $item.FieldValues["FolderFieldText1"]</span></div><div><span style="font-size: x-small;"> $folderInfo += '","'</span></div><div><span style="font-size: x-small;"> $folderInfo += $item.FieldValues["FolderFieldText2"]</span></div><div><span style="font-size: x-small;"> $folderInfo += '","'</span></div><div><span style="font-size: x-small;"> $folderInfo += $item.FieldValues["FolderFieldManagedMetadata1"].Label</span></div><div><span style="font-size: x-small;"> $folderInfo += '","'</span></div><div><span style="font-size: x-small;"> $folderInfo += $item.FieldValues["FolderFieldManagedMetadata2"].Label</span></div><div><span style="font-size: x-small;"> $folderInfo += '",'</span></div><div><span style="font-size: x-small;"> $folderInfo</span></div><div><span style="font-size: x-small;"> #Apend to csv</span></div><div><span style="font-size: x-small;"> Add-Content -Path $csvLocation -Value $folderInfo</span></div><div><span style="font-size: x-small;">} </span></div></div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-59813209047942088192022-09-14T10:03:00.003+01:002022-09-14T10:03:24.290+01:00M365 Fundamentals - Another certification.These posts are few and far between at the moment. It is strange as I have lots of ideas I would like to get down but never get the time to put in to action.
Anyway. Another Cert done last month. This one was the Microsoft 365 Fundamentals. After 18 years working with these technologies I sometimes question if Microsoft exams are really that required but I have to say I did learn a few things from it so worth getting in when I can find the time.
https://docs.microsoft.com/en-us/certifications/exams/ms-900
Thanks allPhilip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-44234429351592550372021-07-15T19:02:00.001+01:002021-07-15T19:02:30.272+01:00Certification timeWell it has been a while since I list did some certifications. Mainly due to being so busy delivering solutions for customers. Hey we have to keep the money coming in right? Anyway I managed to get a bit of time this week and managed to completed two Exams. I even got a couple of badges for it haha.
<div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAbxoSb7DdlDCUrZBbLkH5njxa7XRDo1OUgt41CI5pZ1Rj0R1kUCxFmpBRjJOxvhl9rA3CjjKph6TZdwL4UyO4SZwmI80L9eyLTwea4F_h2-33UYZfvG7Pt4Izzh2Q7FzwecdQb-enig/s600/azure-fundamentals-600x600.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="320" data-original-height="600" data-original-width="600" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAbxoSb7DdlDCUrZBbLkH5njxa7XRDo1OUgt41CI5pZ1Rj0R1kUCxFmpBRjJOxvhl9rA3CjjKph6TZdwL4UyO4SZwmI80L9eyLTwea4F_h2-33UYZfvG7Pt4Izzh2Q7FzwecdQb-enig/s320/azure-fundamentals-600x600.png"/></a></div><div class="separator" style="clear: both;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXuwf207uyPidDA_KTFeEiPIJjxW5sayk0pbprT0nMVbRoSIzIyTmOiqtDQI4tezgjZJlcO5h7PxUaEV1TpHRCDcmfoqF2w1O_z2H9gBlJuXSnzV1D6Byu81vvXjZ5RgfYck9deaJGpw/s600/CERT-Associate-Microsoft365-Teams-Administrator.png" style="display: block; padding: 1em 0; text-align: center; "><img alt="" border="0" width="320" data-original-height="600" data-original-width="600" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXuwf207uyPidDA_KTFeEiPIJjxW5sayk0pbprT0nMVbRoSIzIyTmOiqtDQI4tezgjZJlcO5h7PxUaEV1TpHRCDcmfoqF2w1O_z2H9gBlJuXSnzV1D6Byu81vvXjZ5RgfYck9deaJGpw/s320/CERT-Associate-Microsoft365-Teams-Administrator.png"/></a></div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-61388257523397356862021-06-14T14:00:00.003+01:002021-06-14T14:00:29.724+01:00SharePoint _layouts urlsA handy quick reference to those _layouts pages in sharepoint :)
https://www.concurrency.com/blog/april-2016/helpful-sharepoint-urls#:~:text=Helpful%20SharePoint%20URLs%20%26%20Site%20Locations%20%20,%20%20%2F_layouts%2Fuser.aspx%20%2033%20more%20rows%20Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-79629649500103157012021-01-21T11:53:00.003+00:002021-01-21T11:53:49.309+00:00Visual Studio Team Explorer buttons missing<p>Hello world,</p><div class="separator" style="clear: both; text-align: left;">I had an issue the other day where I was missing options in team explorer when trying to connect to dev ops. </div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">All the fun stuff wasnt there like:</div><div class="separator" style="clear: both; text-align: left;"><ul style="text-align: left;"><li>Branches</li><li>Sync</li><li>Pull requests etc</li></ul></div><div class="separator" style="clear: both; text-align: left;">It looked like this...</div><div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiL9tyFgUXd1asAp0SsTAMDmbNh3HSU1205qEnUTwKpchFDDdvjcqJ4L8Ol4Kc1uj7RSyH7BG-iW8RlKmpvexDH2FZR0k-dOI8TcdDDE7vPuNAeUXvkbTt052NSqd-c6zXYMDs7G9U5w/s675/Azure+Source.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="170" data-original-width="675" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiL9tyFgUXd1asAp0SsTAMDmbNh3HSU1205qEnUTwKpchFDDdvjcqJ4L8Ol4Kc1uj7RSyH7BG-iW8RlKmpvexDH2FZR0k-dOI8TcdDDE7vPuNAeUXvkbTt052NSqd-c6zXYMDs7G9U5w/s320/Azure+Source.png" width="320" /></a></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">If you go to "Tools" then "Options" and search for "Preview features" there is an option for "New git user experince". This must be <b>unchecked</b>.</div><br /><div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrXNttaJ1knPAFL3aM-i9a11Z4eibqAYXhbbpDliww_aYUqkhyphenhyphenB0WpdK4h6gFjdGczPYMOnY787efM0ad_xr2uHdP49n6g55750eDbmgLMQAnGBrGh3EdhebdpmPZ1q57W7ZpViniruQ/s848/Azure+Setting.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="677" data-original-width="848" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgrXNttaJ1knPAFL3aM-i9a11Z4eibqAYXhbbpDliww_aYUqkhyphenhyphenB0WpdK4h6gFjdGczPYMOnY787efM0ad_xr2uHdP49n6g55750eDbmgLMQAnGBrGh3EdhebdpmPZ1q57W7ZpViniruQ/s320/Azure+Setting.png" width="320" /></a></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">Once unselected you will get this:</div><br /><div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDSOioVu-U0GNEjtYojZH_tivdsk5MBNmIYFQHdt_5kRm1r8izW271NgbWWNoGcLPApv4mlLSEyPj0KtYlUqxV2DjrV0jVI4rpppeP2r1UZZtZVqTGLpHSrRjGCIkvJTmJRL54VKRE1g/s684/Azure+result.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="292" data-original-width="684" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDSOioVu-U0GNEjtYojZH_tivdsk5MBNmIYFQHdt_5kRm1r8izW271NgbWWNoGcLPApv4mlLSEyPj0KtYlUqxV2DjrV0jVI4rpppeP2r1UZZtZVqTGLpHSrRjGCIkvJTmJRL54VKRE1g/s320/Azure+result.png" width="320" /></a></div><br /><p></p><div>This took me a while to work out despite it staring me directly in the face so thought I would share :)</div>Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-68464297363008900602020-07-13T13:16:00.001+01:002020-07-13T13:16:53.024+01:00<div dir="ltr" style="text-align: left;" trbidi="on">
This article clearly outlines what the prefered Microsoft approach is with respect to authentication within SharePoint Online....that being to use "Azure AD application registration".<br />
<br />
(Over "SharePoint App only" or any of the legacy approaches using user names and passwords from key vaults or config files)<br />
<br />
One further point to note to perhaps the less experienced out there, is that you must always consider your customer. Just because microsoft have a new way of doing it, that doesnt mean that the customer estate will want you to use that approach. Its important to run these sorts of things past the customer before you build it negate the risk of reengineering it in the future. Obvsiouly you will present the most modern approach but perhaps there are limitations as to why they cant do it. :)
https://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly </div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-89232699611998811192020-06-05T15:06:00.007+01:002023-09-27T14:15:29.559+01:00My Client list to date<div dir="ltr" style="text-align: left;" trbidi="on">
I wanted to create a post which contains the majority of my client work to date so here it is. It doesnt include any of the internal strategy, mentoring or practice development activities out side of paid for work but it is nice to see where I have been hehe.<br />
<div><span style="font-size: small;"><br /></span></div><div style="text-align: left;"><span style="font-size: xx-small;"><span>(July 23 – Oct 23) Microsoft 365 Solution Architect – </span><b>The Environment Agency</b><span> </span><span>- Permit classification system - Microsoft 365 / SharePoint Online / PowerBi<br /></span><span>(May 23 – July 23) Microsoft 365 Solution Architect – </span><b>The Environment Agency</b><span> </span><span>- Permit classification system Managed Service coverage - Microsoft 365 / SharePoint Online<br /></span><span>(Mar 23 – April 23) Principal Consultant – <b>Vehicle Certification Agency</b> - Digital Transform Consultancy- Microsoft 365 / SharePoint Online / Teams / Purview<br /></span><span>(Sept 22 – Feb 23) Microsoft 365 Solution Architect / Team Lead – <b>The Environment Agency</b> - Permit classification system Continuous Improvement Phase 2022 - Microsoft 365 / SharePoint Online<br /></span><span>(July 21 – Jun 22) Microsoft 365 Solution Architect / Team Lead – <b>Quilter Wealth Management</b> - Intranet / M365 Develooment Pracitce Framework - Microsoft 365 / SharePoint Online / Microsoft Teams / OneDrive / Forms<br /></span><span>(Jan 20 – July 21) Microsoft 365 Solution Architect / Team Lead – <b>The Environment Agency</b> - Permit classification System - Microsoft 365 SharePoint Online / Azure <br /></span><span>(July 19 – Jan 20) Solution Architect / Principal Consultant – <b>Air / Rail Accidents Investifation Branch</b> - Document Management solution for Incident Management system - Microsoft 365 SharePoint Online / Dynamics 365<br /></span><span>(July 19 – Dec 19) Technical Architect – <b>Thames Valley Police</b> - Farm installation - SharePoint Server2019 (hosted in Azure)<br /></span><span>(Oct 18 – Jul 19) Solution Architect – <b>Kew Gardens</b> - EDRM - SharePoint Online / Azure<br /></span><span>(Dec 17 – Sep 18) Solution Architect – <b>Surrey and Sussex Police</b> - Intranet - SharePoint Server 2013<br /></span><span>(Jul 17 – Nov 17) Solution Architect – <b>Security Industry Authority</b> - Corporate website / Custom application update - SharePoint Server 2007 - 2010<br /></span><span>(Sep 16 – Jun 17) Solution Architect – <b>Surrey and Sussex Police</b> - Migration - Multiple applications to SharePoint Server 2013<br /></span><span>(Nov 15 – Sep 16) Solution Architect – </span><b>ACAS </b><span>- Document Management / Collaboration - Office 365 (SharePoint / One Drive)<br /></span><span>(May 15 – Nov 15) Solution Architect – <b>Kew Gardens</b> - EDRMS - Office 365 (SharePoint) / Azure<br /></span><span>(Aug 14 – May 15) Solution Architect – <b>Nationwide Building Society</b> - Search Enhancements - SharePoint server 2013 <br /></span><span>(Aug 14 – May 15) Principal consultant – <b>Nationwide Building Society</b> - Design appraisal - SharePoint Server 2013<br /></span><span>(Mar 14 – Jul 14) Solution Architect / Principal Consultant – <b>Department of Energy & Climate Change</b> - EDRM - SharePoint Online<br /></span><span>(Nov 13 – Feb 14) Solution Architect / Principal Consultant – <b>Surrey Police</b> - Migration - OpenText to SharePoint 2013<br /></span><span>(Sep 13 – Oct 13) Solution Architect / Principal Consultant – <b>HM Treasury</b> - Staff Changes HR SharePoint application Enhancements - SharePoint 2010<br /></span><span>(Aug 13 – Aug 13) Solution Architect / Principal Consultant – <b>PepsiCo UK</b> - Migration - SharePoint 2010<br /></span><span>(Aug 13 – Aug 13) Solution Architect / Principal Consultant – <b>Maverick TV</b> - Document Management - SharePoint 2010<br /></span><span>(Mar 13 – May 13) Solution Architect / Principal Consultant – <b>Medimmune</b> - Collaboration platform - SharePoint 2010<br /></span><span>(Mar 13 – May 13) Solution Architect / Principal Consultant – <b>The Electoral Commission</b> - Document Management Archival - SharePoint 2010<br /></span><span>(Jun 12 – Mar 13) Technical Architect / Team Lead – <b>HM Treasury</b> - Staff Changes HR SharePoint application - SharePoint 2010<br /></span><span>(Dec 12 – Feb 13) Principal SharePoint Consultant – <b>Home Office</b> - EDRM - SharePoint 2010<br /></span><span>(Oct 12 – Nov 12) Technical Architect / Senior Consultant – <b>The Electoral Commission</b> - Document Management enhancements - SharePoint 2010<br /></span><span>(Mar 12 - Mar 12) Senior SharePoint Consultant – <b>Mencap </b>- Health check - SharePoint 2010<br /></span><span>(Jun 11 – Oct 11) Senior SharePoint Consultant - <b>Home Office</b> - SharePoint 2010<br /></span><span>(May 10 – Mar 12) Senior SharePoint Consultant / Architect / Team lead - <b>Carbon Trust</b> - Public facing website - SharePoint 2010<br /></span><span>(Apr 11 – Jul 11) Senior consultant / Lead developer - <b>Electoral Commission</b> - Intranet - SharePoint 2010<br /></span><span>(Mar 11 – Jul 11) Senior consultant / architect - <b>Energy Saving Trust</b> - Extranet - Development in SharePoint 2010<br /></span><span>(May 10 – Jul 10) SharePoint Training Consultant - <b>Vehicle Certification Agency</b> - SharePoint 2010<br /></span><span>(Sep 09 - May 10) Technical Architect - <b>Heritage Lottery Fund</b> - Public Facing Website - SharePoint 2007<br /></span><span>(Oct 09 – Dec 09) Senior Consultant - <b>London Pension Fund Authority</b> - Intranet SharePoint 2007 <br /></span><span>(Nov 07 - Oct 09) Lead Developer - <b>ACAS and Central Arbitration Committee</b> - Public Facing Websites - GOSS iCM<br /></span><span>(Sep 07 – Nov 07) Developer - <b>Roffey Park</b> - Public Facing Website - SharePoint 2007<br /></span><span>(Jan 07 – Mar 07) Developer - <b>National Heritage Memorial Fund</b> - Website Development - SharePoint 2007<br /></span><span>(Dec 05 - Jan 07) Developer - <b>Security Industry Authority</b> - Licensing Database - Content Management Server 2002<br /></span><span>(Feb 05 - Dec 05) Junior Developer - <b>Heritage Lottery Fund</b> - Public Facing Website - Content Management Server 2002<br /></span><span>(Sep 04 - Feb 05) Junior Developer - <b>Security Industry Authority</b> - Public Facing website - Content Management Server 2002<br /></span><span>(Jul 04 - Sep 04) Junior Developer - <b>Veterinary Laboratory Authority</b> - Bespoke .net Application </span></span></div></div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-69000083995585693392020-04-14T09:01:00.002+01:002020-04-14T09:09:49.736+01:00Top tips on teams for remote workers<div dir="ltr" style="text-align: left;" trbidi="on">
Some cool pointers to remember on teams from typcial remote users:<br />
<br />
<ol style="text-align: left;">
<li>Using commands in the search box "/"</li>
<li>Utilising multiple cloud storage options including drop box etc.</li>
<li>You can blurr out your background. :)</li>
<li>There are tonnes of app available.</li>
</ol>
<div>
<a href="https://www.zdnet.com/video/microsoft-teams-eight-easy-ways-to-make-remote-work-easier/">https://www.zdnet.com/video/microsoft-teams-eight-easy-ways-to-make-remote-work-easier/</a></div>
<div>
<br /></div>
<div>
#phildoesteams</div>
</div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com2tag:blogger.com,1999:blog-8313201181521636753.post-51843519925899358392020-04-02T15:16:00.002+01:002020-04-02T15:31:50.639+01:00Creating SharePoint Document Library folders with a specific Content Type and metadata<div dir="ltr" style="text-align: left;" trbidi="on">
A script that demonstrates how to create lots of folders in a document library with a specific content type and metadata.
This approach uses pnp.<br />
<br />
#Folder script to provision yearly folders with specific content type and metadata.<br />
#Note this will also update existing folders<br />
<br />
#Connect to tenant<br />
Connect-PnPOnline -url https://mytenant.sharepoint.com/sites/SiteCol -UseWebLogin<br />
$years = @("2020","2019","2018","2017","2016","2015","2014","2013","2012","2011","2010")
<br />
<br />
function Provision-YearlyFolders {<br />
Param($folderName)<br />
#Get folder<br />
$query = "<View><Query><Where><Eq><FieldRef Name='Title'/><Value Type='Text'>"+ $folderName +"</Value></Eq></Where></Query></View>"<br />
<br />
$folder = Get-PnPListItem -List incident -Query $query<br />
<br />
#Create folder if it doesnt exist<br />
if(!$folder)
{<br />
Add-PnPFolder -Name<br />
$folderName -Folder incident<br />
$folder = Get-PnPListItem -List incident -Query $query<br />
}<br />
#Update content type and set year order column<br />
Set-PnPListItem -List incident -Identity<br />
$folder.Id -ContentType "Yearly Folder" -Values @{"YearSortOrder" = $folderName}<br />
Write-Host "Provisioned" $folderName<br />
}<br />
#loop through yearly folders<br />
foreach($year in $years)<br />
{<br />
Provision-YearlyFolders $year<br />
}</div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-8666144916415466952020-01-27T16:27:00.001+00:002020-01-27T16:27:55.521+00:00Gulp sequence for creating a solution<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Its probably a good idea to run these when doing a build.<br />
<br />
<b>gulp clean</b><br />
<b>gulp build --ship</b><br />
<b>gulp bundle --ship</b><br />
<b>gulp package-solution --ship</b></div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-62979037018828959312020-01-14T14:57:00.000+00:002020-01-14T14:57:24.781+00:00The Postman is here<div dir="ltr" style="text-align: left;" trbidi="on">
Just a note to myself really to remember that you can configure Postman for SharePoint online using this post <div>
<br /></div>
<div>
<a href="https://medium.com/@anoopt/accessing-sharepoint-data-using-postman-sharepoint-rest-api-76b70630bcbf">https://medium.com/@anoopt/accessing-sharepoint-data-using-postman-sharepoint-rest-api-76b70630bcbf</a></div>
<div>
<br /></div>
<div>
#RestDevelopment</div>
</div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com2tag:blogger.com,1999:blog-8313201181521636753.post-63667050621635291832019-12-11T14:47:00.003+00:002019-12-11T14:49:54.191+00:00Publishing a SharePoint document using Flow<div dir="ltr" style="text-align: left;" trbidi="on">
Hello there,<br />
<br />
I am still however living the SharePoint dream and have been fully operational since my last post.<br />
<br />
I thought I would share something I created as a prototype as I couldn't find anything out there on the net covering the ask.<br />
<br />
In short, I was asked if it is possible to get a Flow to publish a document. I saw various answers including using content approval and various other things. None of which quite met the need for my customer.<br />
<br />
I found it is possible to get flow to publish a file in sharepoint only that you have to do it via a REST call. Screen shot provided which shows first a check out, then a check in with publishing a major version.<br />
<br />
Let me know if it helps,<br />
<br />
Phil<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimq88hQiLZSnQINeTzvl0hheZ6WKA7DxEP4bP3kjuVXecaEnwdNw17JuVOzZXBm6MW3xYkQWOxctRx-CZg1zmjv6yM6gdBOC19d7XtdB30yE0PF6yR0WdQspbiBRSUApCfc_7eqnudwg/s1600/Flow.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="835" data-original-width="686" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimq88hQiLZSnQINeTzvl0hheZ6WKA7DxEP4bP3kjuVXecaEnwdNw17JuVOzZXBm6MW3xYkQWOxctRx-CZg1zmjv6yM6gdBOC19d7XtdB30yE0PF6yR0WdQspbiBRSUApCfc_7eqnudwg/s1600/Flow.PNG" /></a></div>
<br />
<br />
<br /></div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-53650363716505260472016-08-23T15:34:00.001+01:002016-08-23T15:45:58.565+01:00Intro to Microsoft PowerBI with Office 365<div dir="ltr" style="text-align: left;" trbidi="on">
So I was at a client the other day and they started chatting about PowerBI in Office365. Once again I thought...ah I better get learning again so I have done a quick summary post based on a very helpful video I found online so thanks to the person who created this. A link is available to the entire 1hr video at the bottom of the page.<br />
<br />
If you come from the old Microsoft Business Intelligence world, must of what is in here will seem familiar. The key is that its now in O365 and is much easier to configure. Users are much more empowered to create queries and reports directly in Excel without having to go near SQL or Reporting services. Reports can be stored in the cloud so are accessible from anywhere :).<br />
<br />
Hope you enjoy.<br />
<br />
<b>Excel is at centre of it all and provided a BI Front end</b><br />
<br />
<b>Power Query</b> allows you to pull in data from other sources into Excel by literally searching the net for it (S&P 500 data for example). This is really neat. There are loads of free datasets available for you to import. This list is growing. You can view them in this post: Search public data (Power Query). Can also pull from SQL, SharePoint, another table. All sources available in excel.<br />
<b>Power Query</b> can let merge data from multiple sources. Like them via keys etc. Really nice and easy and available to users who don’t need to know tonnes of SQLServer.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCc9FVRdLU2KO2Xgr7xiypANQzQVcr-x1hWpio5iI-AI-_lWrQxJ6GmJqpItWoZb9OO-Hn-O85X5-LLPMoy8CHl7aF7ZpdJBLr5poyMEc6vFVkpajSjGkWpVhVA6WS1azyceV1zLQI3A/s1600/Powerquery.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCc9FVRdLU2KO2Xgr7xiypANQzQVcr-x1hWpio5iI-AI-_lWrQxJ6GmJqpItWoZb9OO-Hn-O85X5-LLPMoy8CHl7aF7ZpdJBLr5poyMEc6vFVkpajSjGkWpVhVA6WS1azyceV1zLQI3A/s640/Powerquery.PNG" width="640" /></a></div>
<br />
<b>PowerPivot</b> will allow you to manipulate further to do sums, counts and filters etc.<br />
<b>PowerView</b> is a great way to generate reports dynamically.<br />
<b>PowerView</b> allows you to add fields, counts and filters. For example you might have some stats on sales split across country. You can see a map of the sales sizes. This can then be filtered if you want.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGZPRmbKKt537vnDQpKsblAZmFRIJeqCkIdGz7donSMhD7raA_y5aXSoRruWwStB-dBMgVS41ytHCsKIo2upmpAZbua_0Zc_u5NK_3oXnxpns5dyrEFnE4vZYBs1BcgrX3VK-oxBFRiA/s1600/powerview.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="328" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGZPRmbKKt537vnDQpKsblAZmFRIJeqCkIdGz7donSMhD7raA_y5aXSoRruWwStB-dBMgVS41ytHCsKIo2upmpAZbua_0Zc_u5NK_3oXnxpns5dyrEFnE4vZYBs1BcgrX3VK-oxBFRiA/s640/powerview.PNG" width="640" /></a></div>
<br />
<b>PowerMap</b> allows the data to be displayed on a 3d map and view it animated over time. Essentially its a video tour of data. Really cool stuff.<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9F4-MtsXOw6I5Mon2e_B-SmBD7Cfi9EgU9BAjgS_bKcdi6eYc2U5JcFNL6Yu8aG_6dyIm4GaGl3KKMehk0yf1dPJ0akExZV79kB_ITgBxZ07yO9ex__khc2mMaGGb75TlMWlNiZy-BA/s1600/Powermaps1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9F4-MtsXOw6I5Mon2e_B-SmBD7Cfi9EgU9BAjgS_bKcdi6eYc2U5JcFNL6Yu8aG_6dyIm4GaGl3KKMehk0yf1dPJ0akExZV79kB_ITgBxZ07yO9ex__khc2mMaGGb75TlMWlNiZy-BA/s640/Powermaps1.PNG" width="640" /></a></div>
<br />
<b>Power BI Sites</b> is added as an app in a SharePoint site.<br />
<b>Power BI Sites</b> then edit the whole lot in the browser. You don't need the client.<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgS5i5cwdLsjuCHq7sG_wELTInJcPUuN5gCJs57S7lqsQ4wplr-3IuhNoD8CTNuLKYXtOmr8A2T_EQOMbN6rZOPBB1s3E-vKHewVXCbn9l64QTMcScT_ONRSJ31tm2cLSxSkp0m4nh-Hw/s1600/powerviewonline1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="328" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgS5i5cwdLsjuCHq7sG_wELTInJcPUuN5gCJs57S7lqsQ4wplr-3IuhNoD8CTNuLKYXtOmr8A2T_EQOMbN6rZOPBB1s3E-vKHewVXCbn9l64QTMcScT_ONRSJ31tm2cLSxSkp0m4nh-Hw/s640/powerviewonline1.PNG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<b><br /></b></div>
<div class="separator" style="clear: both; text-align: left;">
<b>Power BI admin centre: </b>allows sharing of queries and data sources and the management of gateways etc. A Data Management Gateway (installed on SQL server) allows sql sever to be accessible by power BI. Data Sources can then be created in the BI Admin center online using the connection string. One the admin is configured other people within the organisation can access it through excel and bobs your uncle :)</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="https://www.youtube.com/watch?v=_WprkRAq6BQ" target="_blank">View James Serra's video on Power BI for Office 365</a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<br />
<br /></div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com12tag:blogger.com,1999:blog-8313201181521636753.post-59151840095230896132016-08-23T14:29:00.000+01:002016-08-23T15:18:15.452+01:00First public developer preview of the SharePoint Framework<div dir="ltr" style="text-align: left;" trbidi="on">
Microsoft has lanced the first public developer preview of the SharePoint Framework.<br />
<br />
Key points:<br />
<br />
<ul style="text-align: left;">
<li>Release for developer tenancies.</li>
<li>Some documentation is provided.</li>
<li>Preview will be updated frequently over upcoming weeks / months.</li>
<li>Full support to office 365 tenancies later in the year.</li>
<li>You can start building client-side web parts using modern script development tools and the SharePoint Workbench (a new development test surface).</li>
<li>You can deploy your client-side web parts to classic web part pages in Office 365 Developer tenants.</li>
<li>It Works alongside common scripting frameworks, such as AngularJS, and we’re expanding our tools for these frameworks. For example, you can use React along with components from Office UI Fabric React to quickly create experiences based on the same components we are using in Office 365. </li>
<li>SharePoint Framework client-side web parts are good for projects where code is trusted to run directly within SharePoint pages with broad access to SharePoint data. </li>
<li>Microsoft have also reiterated their commitment to improving the SharePoint add-in functionality. SharePoint add-ins are great for a variety of other use cases, including support for more fine-grained permission and data access controls, responding to remote events and webhooks, and Office Store distribution.</li>
</ul>
<div>
<br /></div>
<div>
If you still find this a little bit confusing it is ok. I do too but it is still all very new and as is typical to MS they drip feed the information to you as they themselves work out what it all means.</div>
<div>
<br /></div>
<div>
Comeplete microsoft post <a href="http://dev.office.com/blogs/sharepoint-framework-developer-preview-release" target="_blank">SharePoint Framework Developer Preview Release</a></div>
</div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com1tag:blogger.com,1999:blog-8313201181521636753.post-77906190531556075852016-08-16T16:25:00.001+01:002016-08-16T16:25:18.409+01:00Office365 Modern SharePoint Lists, Microsoft Flow and PowerApps<div dir="ltr" style="text-align: left;" trbidi="on">
SharePoint Online is continually evolving and I am trying to get to grips with it. Microsoft just released a post on the new SharePoint lists, Microsoft Flow and Power apps.<div>
<br /></div>
<div>
Modern SharePoint lists:</div>
<div>
<ul style="text-align: left;">
<li>New interface on lists makes it easier for users to add columns and do bulk tasks. It is also easier to modify things like properties and metadata. Pretty rapid and will help end users.</li>
<li>When a list renders in the browser, a check is conducted to see how customised the list is. If it is felt the page would break due to compatibility issues (i.e the page is customised and the new modern view cant handle it) the page will revert to the old classic list view. I feel this is most needed and I had heard rumours they were going to do this and stops the change breaking your entire library.</li>
<li>You can create links to things outside the library easily. This could be a YouTube video for example. That's pretty neat.</li>
<li>Custom tool bar actions are still possible like the good old days.</li>
<li>Admins can apparently still default the list to classic view if they want and users can switch back to classic if they choose. I would like to try this out. MS have confirmed they have no intentions of removing classic mode soon. Perhaps they actually listened to their user base :)</li>
</ul>
Microsoft Flow and PowerApps:</div>
<div>
<ul style="text-align: left;">
<li>Microsoft Flow aims to automate data exchange between systems.</li>
<li>An example would be that when an item is added to sales force, something happens in the document library. Its essentially another workflow tool which probably aims to replace SharePoint designer workflow. At face value it looks good and fairly straight forward. Will be interesting to get a good look under the hood.</li>
<li>There are extensions for Exchange, SQL, Dynamics, Salesforce, Google, Mail Chimp, Twitter, Wunderlist and more. </li>
<li>Powerapps helps create apps for lists which work on any device, especially mobile apps. You hace open an app from the desktop on your iphone. Once again this is quite easy and looks really cool. We have to bare in mind that this is all taken from a Microsoft Article.</li>
</ul>
<div>
Defo worth checking out the <a href="https://blogs.office.com/2016/07/25/modern-sharepoint-lists-are-here-including-integration-with-microsoft-flow-and-powerapps/" target="_blank">Microsoft article and video</a></div>
</div>
<div>
<br /></div>
<div>
Have fun and never stop learning.</div>
<div>
<br /></div>
<div>
<br /></div>
</div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com16tag:blogger.com,1999:blog-8313201181521636753.post-29009857496765853092016-08-04T10:49:00.000+01:002016-08-04T10:49:01.181+01:00Office365 SharePoint Online New site content page<div dir="ltr" style="text-align: left;" trbidi="on">
I just found out that there is a new site content page online. It hasnt been rolled out yet but I'm sure the good people at Microsoft will be pushing it shortly. The changed to appear to be as menacing as the ones in the new look document libraries but worth noting anyway.<div>
<br /></div>
<div>
Find the full details at <a href="https://support.office.com/en-gb/article/The-SharePoint-Site-Contents-page-ba495c1e-00f4-475d-97c7-b518d546566b" target="_blank">The SharePoint Site Contents page</a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://support.content.office.net/en-us/media/c9ed0652-b2bd-458e-af1a-016fdd36a730.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://support.content.office.net/en-us/media/c9ed0652-b2bd-458e-af1a-016fdd36a730.png" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
</div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com23tag:blogger.com,1999:blog-8313201181521636753.post-58965874527590569852016-08-03T11:45:00.000+01:002016-08-03T11:46:28.511+01:00Head of Cloud Productivity Tools<div dir="ltr" style="text-align: left;" trbidi="on">
So over the last few years we have been seeing a shift from On-Premise solutions to Cloud solutions. At the same time Office 365 has really been taking off and Microsoft are adding more and more features to their offering as time passes.<br />
<br />
In April 2016 I was promoted to "Head of Cloud Productivity Tools". A grand title in itself however what is it? This is something we are still determining however it means that I have been having to build on my skills a SharePoint Consultant and make them pretty hot as being an Office 365 consultant. With this in mind I am hoping to generate some value adding content to www.sharepointshowboat.com which relates not only to SharePoint but also Office 365.<br />
<br />
Hope everyone is great.<br />
<br />
Phil</div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-46184153233926000612016-07-18T10:44:00.001+01:002016-07-18T10:45:12.266+01:00Office 365 modern document library extensibility.<div dir="ltr" style="text-align: left;" trbidi="on">
Hello there,<br />
<br />
It has been such a long time since my last post but I really wanted to get the ball rolling again and start adding some value. Things have been changing a lot and recently there has been a lot of discussion about the new modern library views in Office 365. We have been concerned that the they break existing customisations and are limited but a statement from Microsoft suggests that they are fully committed to making things work appropriately.<br />
<br />
More inform found at <a href="http://dev.office.com/blogs/update-on-modern-document-libraries-and-extensiblity">Update on Modern Document Libraries and Extensibility</a><br />
<br />
Now if they could only stop releasing these things with bugs in we might actually be on to something.</div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-25138003163024270712015-10-15T15:32:00.000+01:002015-10-15T15:32:31.159+01:00SharePoint O365 Top Tip : Right clicking the "..." on a list item<div dir="ltr" style="text-align: left;" trbidi="on">
I haven't done a blog post in a long time. Something I am disappointed with but we must move forward. Unfortunately this post will not change your life but it might be mildly interesting if you have not come across it. I was a bit surprised I didn't know this but there you go. My theory is that if I didn't know it then there must be others.<br />
<br />
From within a list, if you <b>right</b> click the "..." next to the item, you will automatically be shown the options for Open, download, Delete etc.. This essentially saves you a whole click.<br />
<br />
Perhaps everyone knew this....but perhaps not.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjt1TXKrGa_om-Y2KMHPF8WwE82183tSGwqIZfjid8xyCq0Luwh1TEWLEZSSco_NiMvcwGRDSrrS6uOIuoywPELffxEplZwhXOGjG6b5broRjI-73zz9jTNanVcvQ6iUXLs6LJ3MP5KYg/s1600/TopTip_menu.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="449" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjt1TXKrGa_om-Y2KMHPF8WwE82183tSGwqIZfjid8xyCq0Luwh1TEWLEZSSco_NiMvcwGRDSrrS6uOIuoywPELffxEplZwhXOGjG6b5broRjI-73zz9jTNanVcvQ6iUXLs6LJ3MP5KYg/s640/TopTip_menu.png" width="640" /></a></div>
<br /></div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-12559382558540102442014-05-20T10:59:00.001+01:002014-05-20T10:59:36.937+01:00SharePoint 2013 : “Sign in as different user” has gone<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div>
Hello SharePoint lovers,</div>
<div>
<br /></div>
<div>
This is another one for my own reference really as I know I will use this until I have learn it parrot fashion.</div>
<div>
.</div>
<div>
We used to like the old “Log in as different user” option from within the browser. It was very handy for quickly testing different accounts. This has now gone from the UI in 2013 but it hasn’t actually gone…only the link has gone.</div>
<div>
<br /></div>
<div>
It is still there at http://site/_layouts/closeconnection.aspx?loginasanotheruser=true</div>
<div>
<br /></div>
<div>
Another approach out there is to Right click Internet explorer with shift held down and select “Run as different user”.</div>
<div>
<br /></div>
<div>
It should be noted that this cannot guarantee that everything with the previous user will disappear. I would at the very least hammer shift f5 to clear the browser cache down.</div>
<div>
From my own experience if you are doing stuff with Office then you really need to login to windows as that user to get all the functionality working correctly. However there is still a place for the old “sign in as a different user” for us oldschool geeks.</div>
<div>
<br /></div>
<div>
MS post reference : <a href="http://support.microsoft.com/kb/2752600" target="_blank">"Sign in as Different User" menu option is missing in SharePoint Server 2013</a></div>
<div>
<br /></div>
<div>
Hope to start posting more in general. Been so busy SharePointing recently.</div>
<div>
<br /></div>
</div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com1tag:blogger.com,1999:blog-8313201181521636753.post-26394409169506691072013-11-17T16:41:00.002+00:002013-11-17T16:41:59.974+00:00Document migration from OpenText LiveLink ECM - eDocs R/KYV 9.1 to SharePoint 2010<div dir="ltr" style="text-align: left;" trbidi="on">
One of my recent engagements involved investigating the export of documents from a customised LiveLink ECM system with the intention of uploading the content into SharePoint 2010.<br />
<br />
<b>The Challenge</b><br />
<br />
LiveLink stores documents in an Oracle database with Web site and desktop client UIs.<br />
<br />
Documents are logically stored as nested classes and folders.<br />
<br />
There are two internal path representations for folders in .<br />
<br />
Documents have associated metadata which is stored various tables within the database.<br />
<br />
Both documents and metadata need to be replicated in SharePoint.<br />
<br />
<b>The solution</b><br />
<br />
The solution comprises of multiple components.<br />
<br />
<u>Export application</u><br />
<br />
A custom .net windows application was designed to export the both the documents and metadata from LiveLink. The application takes various parameters, one of which is the root folder path. The application will iterate through each of the sub folder recursively. During this process a physical folder on the local file system is created for each LiveLink folder and each document is download with the metadata captured. The result is a local file system representation of the folders in LiveLink. A custom .net windows application was designed to export the both the documents and metadata from LiveLink. The application takes various parameters, one of which is the root folder path. The application will iterate through each of the sub folder recursively. During this process a physical folder on the local file system is created for each LiveLink folder and each document is download with the metadata captured. The result is a local file system representation of the folders in LiveLink.<br />
<br />
The application utilises System.Data.OracleClient to allow direct communication with the Oracle LiveLink database. This allows the folder and file structure to be determined.<br />
<br />
The document download has been implemented by making SOAP calls to LiveLink where the document ID is passed as a parameter. Having only limited knowledge of LiveLink and any of its APIs made this quite tricky but it is possible. I had attempted extracting the documents directly from Oracle by downloading the files as blobs but there were issues. Specifically the files were corrupted which had the result of MS Word documents losing their formatting. Not exactly what we want from and EDRM export. SOAP calls however allowed for successful download with no issues.<br />
<br />
The metadata is captured in a csv file where there is one row entered per document. The csv file captures the location of the document on the file system, the author, the date and other metadata properties.<br />
<br />
Once the tool has completed running there is a local copy of all the files and folders stored and a csv file containing all the captured metadata.<br />
<br />
<u>Import tool</u><br />
<br />
My initial assumption was that I would use some PowerShell to upload the files into SharePoint. Obviously being a SharePoint geek this is where I wanted to go. However I wanted to give some flexibility to my client so that they were able to do document imports without being reliant on PowerShell knowledge. The <a href="http://en.share-gate.com/" target="_blank">ShareGate</a> migration tool served the need well. This product allows a bulk up load of files and folderd complete with Metadata into SharePoint. Where the genius comes in is that you can specify an MS Excel file to act as a source for the upload. It will go through each line in the excel sheet and upload the file specified in the path with its metadata as specified in the other columns. You can map each column in excel to your column in your SharePoint content type. I have to admit I did think it would meet our need but was extremely pleased when I got it working. As was my client.<br />
<br />
So there you go, it is possible to migrate content from LiveLink to SharePoint 2010....but lets be honest, we always knew it was deep down!<br />
<br />
<br />
<br /></div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com1tag:blogger.com,1999:blog-8313201181521636753.post-63563634539708160372013-08-01T14:19:00.003+01:002013-08-01T14:19:51.083+01:00SharePoint restrict people picker to a specific Active Directory OU Group<div dir="ltr" style="text-align: left;" trbidi="on">
Another note to self here. If you want to restrict what appears in the SharePoint people picker to a specific OU in Active Directory you can using the following command:<br />
<br />
stsadm -o setsiteuseraccountdirectorypath -path "CN=Sales,DC=ContosoCorp,DC=local" –url <a href="http://server_name/">http://server_name</a><br />
<br />
A point of note is that it will not restrict users which are already in the site collection, only new users which are added.<br />
<br />
More command details here:<br />
<br />
<a href="http://technet.microsoft.com/en-us/library/cc263328(office.12).aspx">http://technet.microsoft.com/en-us/library/cc263328(office.12).aspx</a></div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-62428628376809770412013-06-13T17:08:00.002+01:002013-06-13T17:13:48.712+01:00Configure Search Scopes and Site Collection Display Groups with PowerShell<div dir="ltr" style="text-align: left;" trbidi="on">
Note for myself again.<br />
<br />
I wanted to create search scope which returned results from a specific area in my SharePoint site collection. I also wanted this scope to be available in the site collection's "Scopes drop down".<br />
<br />
This code did the trick<br />
<br />
$createdScope = New-SPEnterpriseSearchQueryScope -Name "Specific area" -Description "Project sites" -SearchApplication $searchapp -DisplayInAdminUI $true
$rule = New-SPEnterpriseSearchQueryScopeRule -RuleType "Url" -Url "http://portal" -MatchingString "http://portal/SpecificArea" -FilterBehavior "Require" -UrlScopeRuleType "Folder" -scope $createdScope
$Site = Get-SPSite -Identity http://portal
$searchContext = [Microsoft.Office.Server.Search.Administration.SearchContext]::GetContext($Site)
$scopes = new-Object Microsoft.Office.Server.Search.Administration.Scopes($searchContext)
$displayGroup = $scopes.GetDisplayGroup("http://portal", "Search Dropdown")
$displayGroup.Add($scopes.GetSharedScope("Specific area"))
$displayGroup.Update()
<br />
<br />
<span>This script was created based on the following posts so thanks the authors for pointing me in the right direction:</span><br />
<a href="http://social.technet.microsoft.com/Forums/en-US/sharepointadminprevious/thread/6159b4b5-ec8a-4184-b5e8-1a226eff1cee/">http://social.technet.microsoft.com/Forums/en-US/sharepointadminprevious/thread/6159b4b5-ec8a-4184-b5e8-1a226eff1cee/</a><br />
<a href="http://onlinecoder.blogspot.co.uk/2012/12/powershell-script-to-create-search.html">http://onlinecoder.blogspot.co.uk/2012/12/powershell-script-to-create-search.html</a><br />
<br />
<br />
<div>
<br /></div>
</div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com2tag:blogger.com,1999:blog-8313201181521636753.post-57809344195286910412013-06-13T13:53:00.003+01:002013-06-13T14:01:28.839+01:00Configure Search Crawling with PowerShell<div dir="ltr" style="text-align: left;" trbidi="on">
A note to myself really so that I can find it easily.<br />
<br />
As part of an installation script I wanted to configure an incremental crawl schedule then start a full crawl. The following script met these needs:<br />
<br />
$searchapp = Get-SPEnterpriseSearchServiceApplication "Search Service Application" <br />
<br />
$contentsource = Get-SPEnterpriseSearchCrawlContentSource "Local SharePoint Sites" -SearchApplication $searchapp <br />
<br />
$contentsource | Set-SPEnterpriseSearchCrawlContentSource -ScheduleType Incremental -DailyCrawlSchedule -CrawlScheduleRunEveryInterval 1 -CrawlScheduleRepeatInterval 170 -CrawlScheduleRepeatDuration 180 -Confirm:$false<br />
<br />
$contentsource.StartFullCrawl()<br />
<br />
This script was created based on the following posts so thanks the authors for pointing me in the right direction:<br />
<a href="http://blogs.technet.com/b/heyscriptingguy/archive/2010/09/28/how-to-use-sharepoint-2010-windows-powershell-cmdlets-to-manage-search-crawls.aspx">http://blogs.technet.com/b/heyscriptingguy/archive/2010/09/28/how-to-use-sharepoint-2010-windows-powershell-cmdlets-to-manage-search-crawls.aspx</a><br />
<a href="http://habaneroconsulting.com/en/insights/Setting-crawl-schedules-with-PowerShell.aspx#.Ubm3sfmG3LM">http://habaneroconsulting.com/en/insights/Setting-crawl-schedules-with-PowerShell.aspx#.Ubm3sfmG3LM</a><br />
<br />
<br />
<br /></div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0tag:blogger.com,1999:blog-8313201181521636753.post-90565484221732477032013-04-06T11:07:00.000+01:002013-04-06T11:07:28.443+01:00Disable loopback check with PowerShell<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<span style="font-family: Tahoma; font-size: x-small;">Whilst installing SharePoint 2013 the other day I found a very useful bit of PowerShell which will disable the loopback check.</span><br />
<br />
<span style="font-family: Tahoma; font-size: x-small;">$regKeyPath = "HKLM:\System\CurrentControlSet\Control\Lsa"</span><br />
<span style="font-family: Tahoma; font-size: x-small;">$key = "DisableLoopbackCheck"</span><br />
<span style="font-family: Tahoma; font-size: x-small;">New-ItemProperty -Path $regKeyPath -Name $key -Value "1" -PropertyType dword</span><br />
<br />
<span style="font-family: Tahoma; font-size: x-small;">It should be remembered that disabling the loopback check should only be done in certain scenarios. It is certainly not recommended on Production machines.</span><br />
<br /></div>
Philip Izodhttp://www.blogger.com/profile/12092217261619497093noreply@blogger.com0