Exchange Online, SharePoint, SharePoint 2013, SharePoint Online

Overlay an Exchange Online calendar to a SharePoint Online Calendar

Back in SharePoint 2010 Microsoft introduced the capability to display an exchange calendar over the top of a SharePoint calendar.

The exchange calendar has always had it’s limitations. But here is another I recently discovered.

If you are looking to configure a SharePoint online calendar to consume an exchange online calendar as an overlay, the short answer is you can’t do it! Why?

It was not an easy explanation from Microsoft to find. But see below a snippet and link to a support article from Microsoft.

“This issue occurs because the ability to use the calendar overlay in a SharePoint Online calendar that is retrieved from Exchange Online isn’t supported.

https://support.office.com/en-us/article/Overlay-a-SharePoint-calendar-with-a-calendar-from-Exchange-or-SharePoint-4CAEBE59-3994-4A94-9322-B31ABB8A5E9A

If you were to try to complete the calendar overlay following microsoft’s support guide you would receive an error

“The HTTP request is unauthorized with client authentication scheme ‘Ntlm’. The authentication header received from the server was ‘Basic Realm=””

It is a little disappointing that this cannot be completed, perhaps the introduction of Office 365 Planner & Groups will see this change in the near future.

Advertisements
SharePoint 2010, SharePoint 2013

Removing a SharePoint Server that no longer exists.

I was recently tasked with removing a server from a farm where the virtual server no longer existed, I knew that the best practice was to Disconnect the Server and uninstall SharePoint on the server itself. But what happens if  there’s a catastrophic failure on the server and you can’t follow that process? Simple.

The following applies to SP 2010/SP 2013

Browse to Central Administration > System Settings > Manage Servers in this farm  On this page you will see a list of the servers in the farm ServersInFarmClick Remove Server You will receive a prompt but as the server is no longer available the only choice to remove the server is to click OK. What’s really important here is that Best Practice is not to do it via this method but because your server has been removed you have no choice but to remove the server in such a way. RemovalMessagePrompt

It is recommended that you uninstall SharePoint Products from the server, rather than removing the server from this page. Because the Remove Server operation does not delete information from the server, such as any registry keys that were set, use this operation only when the server is no longer available.

Click OK Refresh the page and the server will be removed. Voila done! Easy as.

Office 365, SharePoint Online

Using Office 365 Video for the first Time

Microsoft Office 365 have recently added the Video Functionality to their subscriptions a cool new set of features indeed, but a new adventure of learning that is needed – hopefully this blog post can assist with the learning.

Depending on your Preview status options in your Microsoft Tenant you may not have the Video feature available to you:

To turn on the Preview option please follow this blog post:

Expand the new Top Nav display button and click Video , if you click the elipses button (…) you can pin to nav bar !

VideoLink

 

Your video page will start to load for the first time so this may take a while (Up to 10minutes)

 

LoadingVideo

 

 

Once Completed you will receive this nice Welcome Message , click Let’s go

WelcomeMessage

One of the first things to note is the URL of the Video Portal

https://yourtenant.sharepoint.com/portals/hub/_layouts/15/videohome.aspx

BlankVideo

 

So let’s create our first Channel

Click the Create Channel Button , Give your channel a name and color:

Click Create

startachannel

Once created you can now upload videos and share with your Security Groups, SharePoint Groups or even unauthenticated users(everyone)

Which I will take you through in my next blog post.

 

Additionally,  I found the below link an informative look into the new Video Portal

https://www.youtube.com/watch?v=HXSZ0jYBKlM&feature=youtu.be

 

Office 365, SharePoint Online

Hide OneDrive link from Navigation

A common question that I am asked on a daily basis is how can we hide ‘One Drive’ or ‘Newsfeed’ from the Top Navigation bar?

Well Thanks to an update a few month’s back it’s now extremely simple to do so:

Browse to:

https://companyname-admin.sharepoint.com/_layouts/15/online/TenantSettings.aspx

 

HideOneDrive

Scroll down to the bottom of your page  Save your changes and you are done

Office 365, SharePoint 2013, SharePoint Online, Uncategorized

Bulk updating a column in SharePoint Online

Ever had this situation where you need to bulk update a specific column in a list or library, you have 100’s or even 1000’s of items and need to set the same information for all the items, although rare I’ve seen it needed and while there may be a couple of way’s to do it here is a little application I have put together to do so.

I have this test library in my site collection, I’d like to update the title column to all be the same, let’s now use the Bulk Updating Column Console App to do so.

You can find the Application uploaded to the TechNet Gallery here , which has the source code for those wanting to see the nuts and bolts to it all ( there isn’t whole lot to it!

Please note you will need the SharePoint Online Management Pack installed or else the App will error

ExampleLibrary

 

 

1. Open the Console Application Executable;

2. Enter in the following info:

  • Your site collection URL
  • Your username
  • Your Password
  • The List Title you would like to interact with
  • The Column Name you would like to update
  • The columns new valueConsoleFirstScreen
    ConsoleAppScreen2

The App will begin to run and update the specified column for all List Items,

RunningofApp

The Application will run and  update the Column accordingly –

Title-Demo1

And we’re done 🙂

PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013

Find your Application Pool username and password

In IIS when you select Application Pools, IIS will display all the application pools with their names and the Account associated to the Application Pool for those Engineers out there wanting to retrieve the application pool service accounts password follow these easy instructions… easy as 123

1. Open up Powershell as Administrator

2. type cd C:\Windows\System32\inetsrv

3. Type the following:

.\appcmd.exe list apppool “Application Pool Name” /text:*

be sure to change “Application Pool Name” to your Application pool you are after

This will give you a long list of output, scroll down a little and you will see the Password field.

Enjoy 🙂

Office 365, SharePoint, SharePoint Online, Uncategorized

Setting up Record Management in SharePoint Online Part 1

Aa

In order to setup records management and the ability to create send-to connection and rules there is a few steps you will need to follow, it can be confusing initially but once you wrap your head around the different configuration location it starts to make sense.

 

  1. Activate the Content Organizer site feature, the Content Organizer feature is a very important feature that should be enabled on any site where Send to connections are to be used, without this feature enabled any attempt to create the send to connection will fail with a correlation ID which on SharePoint Server is easy to work out but a little more difficult to work out in SharePoint Online.

Be sure to activate this feature not only at the from location but the destination as well as the send to connection will error if it is not enabled.

 

  1. Once the feature is activated you will need to head to your Site Admin page for those new to O365 and SharePoint online it’s https://yourtenantname-admin.sharepoint.com

 

  1. Select Records
    Management

     

  2. Once you are on the Send to connection page you will need to fill in a few of the details necessary to start routing the documents

     

    Display Name – is the field that on the send to connection in the SharePoint ribbon this will be seen to the end user

     

    Send To URL – this field is very important to enter in correctly you must enter the site url along with “/_vti_bin/officialfile.asmx” or else the send to connection will error on creation.

    e.g. https://diblasi.sharepoint.com/sales/_vti_bin/officialfile.asmx

     

     

  3. Click Add Connection

     

  4. Now when I select a document in my document library my newly created send-to connection comes available as shown below, so what happens if we try to move this document now?

     

    The Page will refresh with Operation completed successfully message along with the new url of the document, by default the documents are routed to the ‘Drop off library’ in Part 2 I will take you through setting up rules to have the documents moved to a specific document library at your selected destination site.