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...
Get Windows 7, 8 of Windows 10 (bootcamp) to Recognize a Thunderbolt-to-Ethernet Adapter
Note: This is a bit off-topic from my usual SharePoint ramblings, but I just needed to archive this information and most likely I'm not the only one with this issue. I use a Mac, but have Windows 10 installed via bootcamp. That is not always without issues and don't...
Update SharePoint groups in all webs in a SiteCollection using PowerShell
Say you have a ton of subwebs in a sitecollection. Each web have unique permissions and unique groups. You would like to update alle membergroups to have Contribute permissions, instead of Edit permissions. If you need to update all ownergroups or visitorgroups, just...
Moving a SharePoint Document library to a new SiteCollection via PowerShell
Case Recently I ran into a typical SharePoint problem. A SharePoint 2010 site exploded in storage usage. Users was uploading like crazy to one single document library and I needed to move the document library and a few lists to a new site on a new SiteCollection. The...
Enable versioning on all SharePoint Document Libraries in a Site Collection
Enabling versioning on all document libraries in a site collection or disabling versioning is often quite useful. [ps] Write-Host Loading the SharePoint Powershell Snapin Load Snapins if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue)...
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] [/xml] Then use the "ddwrt:FormatDate" to show the date i various ways: List of all LCID's :...
SPEndpointAddressNotFoundExecption when publishing SharePoint 2013 workflows
Are you getting this error: (Microsoft.SharePoint.SPEndpointAddressNotFoundException: There are no addresses available for this application.) when publishing SharePoint 2013 workflows? try these steps to fix it: If you use HTTP: Register-SPWorkflowService –SPSite...
Add ContentType to all documents in a SiteCollection using PowerShell in SharePoint 2013
I came across a need to change all existing documents in a Site Collection to another ContentType, but without changing data like, "modified by" or "modified date". Why? I need to attach a column to all documents and it's just not good practise to add columns to the...
Viewing Workflow for item, fails after installing Service Pack 1 for SharePoint 2013
If your workflows are working just fine, but you are unable to get UI-access to the workflows in SharePoint, because if this error: Sorry, something went wrong Method 'StartWorkflowOnListItem' in type...
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] Submit Feedback [/html] Full Code for a Library Item: [html] Upload a Document [/html]...
Create link to new folder and item actions in modal window in SharePoint 2013
Create link to "New Item" Add item Create link to "New Folder" New...
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...
TCP Connection Test Program
TCP Connection Test...
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...
Create folder and copy a file to that folder in SharePoint Designer Workflow
In this Video I will show how you can create a simple project folder and the copy a template file into that folder. The idea came from a comment on this blogpost, that shows more in-depth how to create folders and subfolders. If you like the video or have questions,...
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...
Summer of 2013 updates for Office 365 – It’s pretty much everything
So I'm back from my vacation. And it's all great. I see that Microsoft didn't give it's employees the summer off. Instead they've been wacking out updates like crazy in Redmond. Last time I checked up on updates for the Office 365 platform was in April. But even if I...
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...
