Office 365 HQ Blog – Archive

Unable to open any documents in SharePoint

You cannot open documents via the Office WebAccess (OWA). The documents are fine and downloading them and the opening them works just fine. If there is no other errors and you are not trying to open documents, while loggin in as a system account, assume that the OWA install works fine. You are most likely experiencing problems with workflows as well. If you try and publish workflows in SharePoint 2013 you might get errors

Moving day

As you've might have noticed, if you are a regular reader. The site has moved. During the weekend I've done some consolidating work. that means that getinthesky.com is now a part of the english part of 365hq.net. For now the site is using the Divi theme from...

DateDif in SharePoint

The function for calculating the difference between two dates in a calculated column in SharePoint, without counting the weekends: =(DATEDIF([Start Date];[End Date];"D"))-INT(DATEDIF([Start Date];[End Date];"D")/7)*2-IF((WEEKDAY([End Date])-WEEKDAY([Start...

Office 365 public website – going down

I've blogged about the discontinuing of public websites a while back and I promised that I would write an update, when there was something to update on. And guess what! Somethings updating. When the changes was announced, there was a small outcry from a few partners,...

Office 365 shuts down public website feature

Using Office 365 for a public website have always been a simple but not so sweet ride. Microsoft never got that one right and most likely, that is why they are discontinuing that part of Office 365. According to this support document existing websites will have two...

Formatting dates in Itemstyle.xsl

Insert this line at the top xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" That will give you a header looking like this: [xml] <xsl:stylesheet version="1.0" exclude-result-prefixes="x d xsl msxsl cmswrt"...

Office 365 Summit in Copenhagen is well underway

I am sitting here in Cinemaxx. For a brief moment, I managed to get some of the room to myself. Otherwise it's pretty packed with around 600 IT-people. All which are interested in Office 365, Lync, Project, SharePoint, Sales etc. And so far it's going great. The...

SharePoint Image Gallery that doesn’t suck in 7 easy steps

[Update] I got an e-mail from Robert, who has refined the solution. Thank you for sharing Robert. Hi Ulrich, hi Joe, first I want to thank Ulrich for his great work and sharing it with us! I also don't have the problem with more than 40 pictures in a picture gallery...

Pop-up modal window SP2010

Code for adding pop-up links to list items and to Library items. Full Code For a List Item:  [html] <a onclick="javascript:NewItem2(event,...

Pop-up modal window SP2013

Simple javascript command to open the dialog modal form function OpenPopUpPage(url, callback, width, height) function OpenPopUpPageWithTitle(url, callback, width, height, title) function OpenPopUpPageWithDialogOptions(dialogOptions) DialogOptions supports:...

PowerShell – Create multiple SPWebs

I often find myself in need of building a structure of SPWebs for demo purposes or for custom migrating scenarios. In order for me to build the structure fast, test it and then tear it down or extend it, I use PowerShell. Just extend the $url and the $name so they...

PowerShell – Create MySites for all users

I found this script to be the most effective for creating MySites in advance for all users. [ps] #--------------------------------------------------------------------------------- #The sample scripts are not supported under any Microsoft standard support #program or...

Clear SharePoint Designer Cache

It can happen that SharePoint Designers local files gets out-of-sync. For some reason hitting the update button won't help. Easy fix: Delete the local cache by deleting the contents of these two folders: %APPDATA%\Microsoft\Web Server Extensions\Cache...

Import user profile pictures to SharePoint using PowerShell

Best solution to create Automatic UserProfile Import to SharePoint Create folder "ImportProfileImages" Create subfolder "ProfileImages" Create "c:\SPSolutions\ImportProfileImages\UpdateUserProfiles.ps1" with the code from SharePoint Use Cases [ps] cls if((Get-PSSnapin...

Force InfoPath to open in browserview

A normal link to an InfoPath template could be /FormServerTemplates/template.xsn But in order to get pageviews in InfoPath to work in IE11, you have to add the domain in Compatibility View Settings, thus breaking the function of starting a new form in the browser,...

Hide a text field in a SharePoint form using jquery

If you have several SharePoint Forms, where you want to hide the input field and using SharePoint Designer to create a custom form is not an option. Here is my collection of jQuery you can insert, using the ScriptEditor webpart. Edit the "view" of a ListItem...

Force batch file to answer yes to prompts

A little while ago, I came across this issue at one of my clients. They needed the SharePoint Instance of the MSSQL server to restart at 5 am every morning. That seemed like a fair task to fix pretty easily. It turns out though, that the prompt, asking the user, if...

Upgrade Your Office 365 Site Collections by April 1st 2014

In case you've missed it. Microsoft have been upgrading SharePoint Online on the Office 365 platform since late 2012. That means that they are now finished upgrading all the SharePoint Farms. Or at least in the European Datacenters, where I am seated. The announcement...

InfoPath is Dead! Long live the new InfoPath!

Microsoft has announced on their Office blog, what the rumour mill have been buzzing about for quite a while now. InfoPath Forms and Services will be discontinued. That means that there is no new InfoPath Forms services in the next edition of SharePoint. Something new...

Ontolica Fusion bootcamp

Today was the second of three bootcampdays at SurfRay campus i Herlev, Denmark. Along with Steen and Anders I have been testing SurfRays new product "Ontolica Fusion". Today we dived right into migrating and synchronizing data to and from databases. I'm still in the...

3 brief Office 365 news

Microsoft supports migrating between Office 365 plans This is something I have been looking forward to, for a very long time. All in all I have always felt that Microsoft really pushes the limit on their various Office 365 - plans.  It is a mystery to me how it is...

Yammer App is heading towards the App-graveyard

Microsoft has announced that the Yammer Desktop AIR App is getting a permanent spot in the old App-retirement home. Come mid-april it's Lights Out for the Yammer App. This is set to happen on April 15, 2014. Not only are the App being retired, the users ability to...

SharePoint Issues when you use Internet Explorer 11

[Updated: 2014-02-05] IE11 or Internet Explorer version 11, have some serious issues when you use it to work with SharePoint. It feels like, Microsoft, missed a step in the testing process when they launched that browser. Most things that IE11 breaks can be fixed by...

Welcome to Notes and so long 2013

Today I've started a new section of my site. I call it "My Notes". I keep a OneNote notebook handy at all times, to gather notes about SharePoint, JavaScript, PowerShell etc.. For a while I have been thinking about sharing these notes. These notes are unedited and...

SharePoint sites you need to follow

Here’s a list of SharePoint sites and blogs about SharePoint related tech. If you run a site, that I’ve missed, please post a comment or contact me to get listed. The list: (In no particular order) Randy Drisgill SharePoint Branding and Design From The Field...

Office 365, Should I Stay or Should I Go?

I'm getting more and more projects on the SharePoint platform. As a consultant, I'm doing more and more in the Cloud. Hence the title of the blog. I don't belive in selling anything, if it's not the right solution for my Client. My income is directly related to the...

August 2013 updates for Office 365 – Things just got bigger

I have a hunch that Microsoft is sitting in  Redmond just thinking something along the lines of, "Let's just give our customers more storage". And so they did. The Office 365 is really starting to blow out the competition one-by-one. It will be interesting to see if...

Javascript to create “New Page” like the one from Site Actions

To create a link manually that have the same features as the one where you click on SiteActions and then "Create New Page", you need some Javascript and some ModalDialog functions. How to use the links the Site Actions menu, is not all that documented. I actually had...

Disable Mobile Redirect for SharePoint 2010

SharePoint has always had a bit of a "Design Issue". Let's be honest. SharePoint has never been accused of being the hippest kid in the classroom. But the built-in design for displaying content on mobile devices is downright miserable. As a consequence I always...

SharePoint 2013 Error When Trying To Create New Page

I've been messing around with the new Design Manager in SharePoint 2013 lately in an effort to see if I could brand SharePoint the way Microsoft tells me, is the new black. So I created a design package and then deployed that package onto my test site. That went well....

Mapping a networkdrive from SharePoint Document Library, finally fixed

[[UPDATE: Links updated, thank you Saiful for pointing that out]] For months, it's been a severe problem for the bulk of SharePoint Online (Office 365) customers. If you are running on Windows 7, while using the latest and greatest Internet Explorer (IE 10), you would...

Error while executing web part

Do you get this error in your ULS-log when visiting a page with a DataViewWebPart that's been changed via SPD? Error while executing web part: System.NullReferenceException: Object reference not set to an instance of an object. Try and uninstall the Update: KB2844286...

SharePoint Backup Best Practice

When it comes to SharePoint Backup, you should take a break from work and do some serious thinking. It's really not all that easy as Microsoft makes it look. Don't count on built-in backup to save your bacon. There is no Best Practice for backing up your SharePoint...

Office 365 – Fails and Success

I work with SharePoint On-Premise and SharePoint Online (Office 365) every day, due to the nature of my job as an SharePoint Consultant. I love what I do and I love working with SharePoint as a platform. I use a mix of Apple and Microsoft technologies, whatever gets...

April 2013 updates for Office 365 – It’s all Skype and Lync

Windows Live Messenger Transitions to Skype Microsoft is killing off Messenger. Even better. Microsoft is moving all Messenger Users to Skype. Starting up yesterday, the Messenger users will see themselves being migrated to Skype, whenever they sign-in. Most likely...

SharePoint Group By Date using the CQWP in 4 Simple Steps

If you have ever messed around with the XSL Itemstyles for use with the CQWP in SharePoint, you know how valuable they can be. Also how frustrating they can be from time to time. This is not as tricky as it may sounds. Out of the box, the Content Query WebPart (CQWP)...

Backup to Amazon Glacier with FastGlacier for free

I own a QNAP TS239 TurboNAS. I use it for a variety of things. One of those things is just plain storage of the Family's documents. From invoices, to Insurance policies, I scan and archive everything. It's a project of mine, to see how much paper binders I can...

Bye bye 2012 – Look out 2013

It's time for the yearly looking back at the past year and looking ahead at the next one. I know. I'm a little behind. But better late than never. so here is my recap of 2012 and a plan for 2013. I've been off the grid for a few weeks now. The site has been hurting a...

6 SharePoint Advices from the winners of the Best Intranets 2013

The Nielsen Norman Group publishes a report each year, in which they pick out the top 10 Intranets of the year. Now it's time for the Best Intranets 2013. This year the trend is pretty clear. 70% of the winners use SharePoint to drive their intranet. I haven't even...