Are you coming to Office365 Nation?

image

From September 26 to 28 I’ll be in Redmond Washington, USA speaking at the Office 365 Nation conference. What will I will I be talking about? Here’s a list of my sessions:

T106: Coming to Grips with SharePoint Online

SharePoint is the heart and soul of Office 365 and major differentiator from the competition. It is a business that allows solutions to just about any business pain point, but how does it achieve this? Without a solid foundation in the fundamentals of SharePoint you are not going to be able to explain to customers how it solves their business needs. This course will help you understand everything in SharePoint Online, including OneDrive for Business, from the ground up, then how to demo it to clients and build solutions to help their business. If you want to stand out from the crowd then you need to know SharePoint and you need to attend this course.

T107: The Business of Yammer

Social is changing the way that business works today. It is fast becoming the de facto method of working for employees entering the workplace and it is something that is now part of Office 365 via Yammer. However, what is Yammer? What can it do? How do you make the best use of it even for small businesses. This course will take you through the basics and help you firstly understand why implanting social into a business is so important and then how to use the tools and abilities of Yammer via Office 365 to achieve this for clients. Collaborating is key for smart business in the future and this course will arm you with the knowledge to take advantage of this and be an expert in the field.

T108: Level up with PowerShell for Office 365

PowerShell is the THE tool for IT Professionals to administer and a mange Office 365. It provides access to many settings that are not available in the GUI. It provides faster deployment and management of just about all aspect of Office 365, from Exchange to Lync and SharePoint. To truly be a skilled Office 365 professional, you need to know and user PowerShell. This course will provide you exactly this skills. You’ll learn not only how to set up a PowerShell environment to connect to Office 365 but you’ll also learn some of the handy scripts you can use to make administration so much easier. If you want to manage Office 365 better and faster then this is course for you.

T109: Lync: The Red Headed Stepchild

Too often Lync is overlooked when it comes to Office 365. However it is a very powerful service that provides key benefits in Office 365. This course will firstly help you understand what Lync is and why it is so important to businesses large and small. You’ll learn how it is the easiest tool to pitch to decision makers and therefore the key service you should be using to leverage the complete Office 365 suite. If you want to convert more Office 365 stakeholders you must know Lync.

I’m luckily to be speaking at an event with many distinguished and experienced presenters who are aiming to provide IT professionals and business leader key information about how Office 365 and Microsoft cloud products are changing the way that business is conducted and opening unprecedented opportunities.

You can of course still register for the event at:

https://www.regonline.com/Register/Checkin.aspx?EventID=1573788

and to learn more about the conference visit:

http://fall2014.smbnation.com/

so if you are interested in what I believe is some fantastic content I encourage you to register today.

If you are attending the in the area during these dates I always love to catch up with people and understand how they are taking advantage of products like Office 365 and Azure, so feel free to reach out to me and organise a time to meet. It’ll be a packed few days but I’m sure we can squeeze something in.

Hope to see you there.

OneDrive mobile app update coming


With the growth in cloud storage the way that people access that information also changes. Much access, especially for cloud services, is now undertaken away from a traditional desktop and in many cases on mobile devices. With that in mind Microsoft is again updating its mobile OneDrive apps.
You can read the specifics about what is happening in this blog post:
https://blog.onedrive.com/onedrive-gets-smarter-on-your-phone/
One of the enhancements on the Android platform is the ability to access your OneDrive consumer and OneDrive for Office 365 directly from the same app on Android devices. when combined with Office on Android this will make it extremely easy to work with files no matter where you are. Microsoft is crafting the app to ensure that information is easily separated between personal and business. They are also improving access by utilising pin code access.
The rapidly improving features of mobile apps are really beginning to shine light on the power of the cloud as they give people access to their information where ever they are, optimized for the screen they are using. If you are not yet using the OneDrive app for your mobile device download and give it a go. I’m pretty sure you won’t look back. If you already have the app key an eye out for the latest round of updates as they look like some major improvements.

Add the Discover SharePoint app to a Team Site

One of the biggest challenges around SharePoint is end user adoption. I have written about this many times including:

The classic SharePoint migration mistake

SharePoint Online migration – Pilers and Filers

SharePoint Online migration–Start up is key

End user adoption in the SMB space is more of a challenge but I get REALLY frustrated when I see resellers ‘implement’ SharePoint Online by simply copying user files to a single Document Library and then running away screaming that there is no opportunity with cloud services. SIGH.

One of the best sites you can point people to when it comes to learning about SharePoint is:

www.discoversharepoint.com

But I’ll bet you didn’t know that you can embed this content directly into a customers SharePoint Team Site. Here’s how.

image

Navigate to a SharePoint Online Team Site.

image

Select Site Contents from the Quick Launch menu on the left.

image

Select add an app

image

Select SharePoint Store at the bottom of the Quick Launch Menu.

image

If you get this warning select a language in the top right.

image

You should now see the store with apps inside as shown above.

image

Go to the search box in the top right and enter discover and select the magnifying glass to search.

image

Hopefully the first result should be Discover SharePoint BETA. Select this.

image

This will take you to a screen with more details about the app.

Select ADD IT on the right.

image

Select Trust It.

(You may need to use a Microsoft account to complete the purchase if this is the first time you have purchased from the store. These accounts are free. I have a previous post that cover creating such an account this if you need to.)

image

You should now see the Discover SharePoint BETA app listed in the Site Contents. Select this.

image

It will take a moment or two to set up.

image

You should then see the app displayed on the page as shown above.

image

If you select the Cog in the top right of the page you will see a menu as shown above.

image

The Settings option will allow you to determine whether analytics is sent to Microsoft to help improve the product. Note that it is enabled by default.

image

If you select Admin Panel you will be taken to a screen where you can select what content is displayed by the app. Maybe you just want to start simple with a limited amount of information so as to not overload your users, you can de-select what isn’t required initially and then return and add it later when ready.

When complete select the Save Changes at the bottom of the page.

image

You’ll then need to select Exit Admin Panel in the top right of the page.

image

This will return you to the app. To to return to your Team Site select Back to Site in the top left hand corner of the window.

image

On the Team Site you should now find the Discover SharePoint BETA item listed in Quick Launch Menu allowing anyone to access the app directly.

From here the Discover SharePoint BETA is just like any app in SharePoint, you can remove it at anytime if you want.

Don’t forget that the content in this app is being updated regularly so continue to visit it to see what’s new.

So hopefully, there is a nice simply way for you to add some information and training about SharePoint Online to help end user adoption directly into a Team Site.

Creating a sub site in your OneDrive for Business

In a recent post I covered off how to create an additional location for files in OneDrive for Business to overcome some of the current syncing limitations. There is another way that you can store additional files (and other items) in your OneDrive for Business.

Because OneDrive for Business is effectively a SharePoint Site Collection you can create any number of ‘subsites’ under the primary OneDrive for Business site. The default primary OneDrive for Business site basically only allows you to add document libraries as I showed in the previous post. However, by creating a ‘standard’ SharePoint subsite under the default you get all the flexibility that a normal SharePoint site has.

To create a subsite under your primary OneDrive for Business site follow these steps:

image

Firstly, navigate to your OneDrive for Business site.

image

In the top right select the COG and then Site contents from the menu that is displayed.

image

You should now see all the standard apps in your OneDrive for Business site. As the previous post highlighted, you can add an app here if you want.

image

If you however scroll down to the bottom of this page you will find a heading Subsites and a link new subsite. Select this.

image

You’ll now be taken to the familiar SharePoint dialog that allows you to create a subsite. You give the new subsite a name and URL suffix.

image

You then select which template you wish the subsite to be based on. Normally you select Team Site so all the features will be available to you.

image

You generally leave the other settings as default and press the Create button.

image

After a few moments you should see your subsite displayed.

image

You can now go into the Site Contents for this new subsite and add something like a Picture Library which you couldn’t do in the primary OneDrive for Business site.

Unfortunately, the only way that you can sync items in a OneDrive for Business subsite is to select sync manually as mentioned  in the previous post. They will also not automatically appear in any mobile clients.

Thus, another way to divide up the space you have available in your OneDrive for Business apart from adding apps at the top level, is to create subsites off the primary site (just like any Team Site) and place you information there. Unfortunately, if you need to sync these items to your desktop you’ll have to do that manually and they also won’t appear in mobile clients.

An additional file location in OneDrive for Business

image

With OneDrive for Business now having 1TB of space available, more and more people are looking to take advantage of it and reduce the amount of files they have stored locally. However, simply dumping everything from a server into OneDrive for Business is not generally good idea.

The major reason is that OneDrive for Business is a “special” SharePoint site that by default contains a single document library called Documents as you can see above. Now, a single document library has a number of limitations that you will find when you start pumping lots of data in there.

The first is the 5,000 view item limit. You can read about it here:

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

You can certainly have more than 5,000 items in library but above that limit you need to use views to limit the display to less than 5,000.

The second is that there is s 20,000 sync item limit. You can read about that here:

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

Thus, you can sync up to 20,000 items from your OneDrive for Business and up to 5,000 from other SharePoint document libraries.

Now it used to be that you could sync up to a maximum of 20,000 files per site collection with a limit of 5,000 per individual document library. I can’t find any mention of those specifics so I am going to assume that you can keep syncing as many additional document libraries you want provided they are below the 5,000 item limit.

Thus, I am going to assume you can sync:

20,000 items in OneDrive for Business

+ 5,000 items from Document library 1

+ 5,000 items from Document library 2

+ 5,000 items from Document library 3

and so on without a limit on the number of document libraries you can sync.

Another issue once you start getting a lot of files is that the OneDrive for Business desktop sync application does not allow you to select which files you wish to sync. Thus, you have no option but to sync the entire document library.

So how do you handle the situation when you exceed the 20,000 items in OneDrive for Business but still want to sync to your desktop? Here’ s an option that may work.

What you may not appreciate is that you can add additional document libraries to OneDrive for Business.

image

To do that access your OneDrive for Business and select the COG in the upper right corner. From the menu that appears select Add an app.

image

One of the apps you will see here is Document Library which you should select.

Some interesting points to note here is that there are only a limited set of apps that you can add, not like on a normal SharePoint Team Site. Secondly, you can however add apps from the SharePoint Online store!

image

Give your document library a name (here photos) and press the Create button.

image

You’ll now see that library has been added to the OneDrive for Business site. Select it to view its contents.

image

You should see the document library as normal as you can see. However, note that the library appears under the Newsfeed menu item on the top NOT the OneDrive item.

image

If you select OneDrive from the menu you are returned to the initial page and unfortunately there is no link on this page to the document library you just created. If you back to the Newsfeed page you will find it.

If you return to your newly created document library you can upload files to it as you normally can. You can also sync those files to your desktop using the sync client BUT is the limit of that 5,000 because it is an additional document library or is it 20,000 because this library is part of OneDrive for Business? I think it best to assume 5,000.

Unfortunately, from what I can see this newly create document library will not automatically appear on mobile devices using the OneDrive for Business mobile app. The only library that appears is the default Documents one.

image

Now if I sync this newly created document library to my desktop you’ll see that it doesn’t appear under OneDrive for Business it appears synced under the SharePoint document library area as shown above.

Therefore, although creating additional document libraries in OneDrive for Business can help you overcome what appears to be a 20,000 file limit and allow you to overcome the need to sync everything from a single document library, as you can see it still has limitations.

Using Office 365 on demand

The problem with technology is that you get locked into a few ways of doing things and you don’t tend to explore outside your comfort zone. Sometimes it is also matter of not even knowing about some cool new feature.

Given that I spend most of my time using the same few machines everyday I really don’t have a huge need for installing Office on unfamiliar desktops. However, this Office on Demand feature is really very handy if you ever need to have the latest version of the full Office application on a desktop you are using.

Of course, you’ll need an Office 365 subscription that includes Office Pro Plus.

image

Navigate to your OneDrive via the menu at the top of the page.

At the bottom of the left hand side select USE OFFICE ON DEMAND.

image

You’ll then see a list of Office applications as shown above. Simply click on one of these. In this case I selected Excel.

image

Given that Office 2013 is not installed on the current machine and you haven’t used this feature before on this machine, you’ll be prompted to run a program stub as shown above. Allow this to Run.

This will install a small program that will now allow you to run the Office on demand at any time in the future.

image

After that has run, you’ll get a message that Office on Demand is ready to run. Select Close.

image

Return to the browser again and select the Office application you wish to use. Again in this case Excel was selected.

image

You should now see the application streaming to the desktop using the Click-to-Run technology.

image

In a few moments, that application will launch and you will be able to work on it as you would normally.

image

As you can see it is the full features version of Excel running side by side any other existing Office applications.

image

If you look up in the top right corner of the application you will see that you are not signed in as a user, so this instance doesn’t count against your 5 installation (because it is about to magically ‘disappear’!)

image

If you now close the Office application you are using you won’t find it installed anywhere on the desktop. So it is a totally ‘on demand’ version of the application as it says it is!

image

The only real trace that remains is a Microsoft Office on Demand Browser Add-on as you can see above from the Control Panel. This is what was installed the first time that you select the application from the browser. It means that if you return and select another application from the browser it will automatically stream down and open.

So Office on Demand is just one of the options you get with Office 365. Even if you don’t use them all make sure you appreciate all the flexibility that Office Pro Plus from Office 365 provides.

The other options you get with Office via Office 365 are:

– Full Suite install onto 5 desktops (Windows or Mac)

– Office Web Apps (or Office Online as it is called now)

– Office Mobile

All of these version are always up to date as well and cost a few dollars per month. Why would you still be using an old version of Office on just one desktop anyone? Beats me.

Smarter help when editing with Office Online

Here’s something I just learnt that I think is really, really helpful.

image

Click on a Microsoft Office document somewhere in SharePoint Online (Team Site or OneDrive for Business). It will then open that document in a browser using Office Online. If you then elect to edit that document in a browser you’ll see the familiar ribbon as shown above.

image

See that box at the top of the ribbon that says ‘Tell me what to do’?

image

If I type ‘create table’, as you can see that menu option immediately becomes available, allowing me to select and create a table.

image

If I instead type in the box ‘create grid’, Office Online works out that I probably mean table and again shows me the appropriate menu command right there so I can create my table.

This is very powerful as it allows people to find what they are after much quicker and reduces the needs for lots and lots of menus and buttons.

Use it, love it.