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.

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 🙂

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.

     

SharePoint Online

Deleting a SharePoint Online Site Collection with PowerShell

A basic one, but today I was asked a question how can I remove a SharePoint Online site collection programmatically – the answer being the ever so powerful PowerShell.

Connect to your SharePoint Online tenant with the SharePoint Online Management Shell (follow the link below to connect to SPO)

http://www.paradyne.com.au/administering-sharepoint-online-with-powershell/

So now you’re connected to your tenant and you now want to remove the Site Collection

So first of all let’s run a Get-SPOSite | select URL this will list all SharePoint Online Site Collections

Now we have all the site collections choose your site collection, in this case I want to remove the site collection https://pddemo3.sharepoint.com/sites/dev
site collection

Remove-SPOSite https://yoursitecollection.sharepoint.com/sites/yoursite

Once that’s completed the Site Collection will be removed and be put in the Site Collection Recycle Bin for 90 days

SharePoint, SharePoint 2013, SharePoint Online

SharePoint 2013(Online) configuring Explorer View

How to configure SharePoint Explorer

A common question and a painful function to have consistently work for the SharePoint user is the ‘open with explorer’ functionality for a document library, a feature that isn’t new to SharePoint but a feature that has always proved troublesome, this blog article will take you through a few common configuration settings to have your users working with the explorer view again.

It’s key to note Open with Explorer functionality is fully supported only in Internet Explorer

So you’ve closed down Google Chrome & Firefox but you’re still having issues with open with explorer and IE? Follow these instructions J

For all versions of IE9/IE10/IE11 these following configuration must be completed to enable this function

  1. When first logging into Office 365 (Login.microsoftonline.com) please check the ‘keep me signed in’ tick box

  2. Make sure the ‘WebClient’ windows service is started

    Start > Run > Services.msc

    This will open the Services MMC, Locate the WebClient and make sure if it’s running if it is not please right click the Service and Start

  3. Add the entry for your SharePoint site to the trusted site zone in Internet Explorer

    In Internet Explorer, Select the Tools menu and click Internet Options.



    Open the Security tab > Trusted sites zone > Sites

    And add the following entries to the list

    https://*.outlook.com

    https://*.sharepoint.com

    https://*.microsoftonline.com

    https://*.lync.com

So you’re running IE10 and still having issues?

A hotfix is required to use the open with explorer functionality for IE10 on Windows 7/Windows 8

Download the hotfix from the bellow link and install to your computer.

http://support.microsoft.com/kb/2846960