Showing posts from 2013

SharePoint 2013 - Displaying Multiple Rows of Links w/ Promoted Links Web Part

If you're like me and needed to have quite a few tiles in your Promoted Links Web Part, this should come in handy.

I've seen options to install custom solutions, and i've seen options to add a javascript file to the web part to force it to go to a new line.

Custom solutions?  meh.

Seperate 76kb javascript file?  meh.

Use what you've been given my friends; and make it simple for your siblings to see how it works.

It's not entirely a simple solution, but when completed I think it is the most elegant/clean solution.  Create two Promoted Links Web Parts underneath each other and use two separate Tile Views to display everything you need.  The only way I could find to create another Tile view was to use SharePoint Designer.

Navigate to list in SharePoint Designer 2013Create new viewCopy CAML Query from original Tile View to new Tile view.  Copy This Bit (Make sure you keep the old view name, display name, url):<XmlDefinition><View Name="{#######-####-##…

SharePoint 2013 - Hide Root Node Link in Global Navigation using CSS

The other solutions I've found regarding this involve javascript/jquery.  Was unable to find any CSS that resolves the issue nicely.

This seems to have resolved the issue for me so far without compromising any other areas of the site.  It hides the initial link and then goes back to displaying the rest of the navigation as per normal:

<style type="text/css">
.ms-core-listMenu-horizontalBox li.static > a{
display: none !important;
.ms-core-listMenu-horizontalBox li.static > ul a{
display: block !important;

Liked this post?  Check out my other posts regarding Global Navigation here:
What Should Be Allowed To Go In Global Navigation?The Best OOTB Cross-Site Navigation Solution for SharePoint 2013/2016/Online

SharePoint 2013 - Responsive SharePoint Design Issues with IE8 and @media tags

UPDATE:  After looking at this again, the answer is yes, I must have been doing something silly.  Guessing the page was not fully refreshing after checking in the Master Page with the changes or something like that, as I haven't changed anything to get it to work, just re-downloaded & re-added the respond.js files.


I've been spending some time with the Responsive SharePoint solution I found on CodePlex here:
and have come across an issue that I am yet to resolve when using Internet Exploer 8 (IE8) to view the page.
Using: Bootstrap-3-server.master
Issue: When using IE8, the top navigation defaults to the mobile view even when full screen (wider than 768px). This is due (i think) to IE8 not reading the .navbar-toggle inside a @media tag, which when wider than 768px, is hidden via display:none. 

Normally, for a solution using bootstrap, to resolve issues with the @media css tag, they a…

InfoPath 2010 - How Do I Deploy InfoPath Forms & Updates to SharePoint

Deploying an InfoPath formOnce you have developed your InfoPath form, most likely you will need to deploy/publish it to SharePoint so that the information can be stored and reported on.  There are different methods for deployment, which are also dependent on whether you are publishing a fresh form, or updating an old form. Two methods of Deploying/Publishing FormsWhen it comes time to deploy your form to SharePoint, there are two different methods with reasons for and against why and when you would use each.  You can publish the form as a Form Library, or as a SharePoint Content Type.
Deployment Method 1:  As a Form Library When you publish a form as a Form Library, it will create the library on the SharePoint Site of your choosing, and a copy of the form template can be found here:  http://rootsite/formlibrary/forms/template.xsn
Use this method when you only require one library for the forms and the forms do not get consumed by BizTalk for some other purpose.  The reason to go with this …

SharePoint 2013 - Responsive Design

       Just a quick note to say if you haven't heard of it already, then you should check out this solution on CodePlex that is absolutely awesome:

What it contains:
- Responsive resizeable Master Pages & Page Layouts for SharePoint 2013 that work with Twitter's Bootstrap CSS.
- Responsive resizeable Master Pages & Pages Layouts for SharePoint 2013 that work with Zurb's Foundation CSS.

I've tried both briefly but so far prefer the Bootstrap version for the font types and colours.  Although I most of us will be making modifications to suit the clients that we are working with, they are a great starting point to Responsive Design for SharePoint that have been designed very well.

If you don't have time to build your own solution from scratch, this is the perfect starting point to build on top of.  Congratulations and thank you to all who have worked on the project so far!

More to come...

SharePoint 2010 - Items Added By Anonymous Users Cannot Start Workflows

On a public-facing website on SharePoint 2010, I was building a simple list to be used as the Contact Us form, so that when an item is added to the list, a workflow will run which sends an email to the owner of the website.

It all worked fine until I tested as an anonymous user that wasn't logged in.  I could create the item fine, but the workflow would not run.  The reason for this is, when an item is created by an anonymous user, the item does not set an author against itself (created by, modified by), which means the Workflow does not know what permissions it should use to run.

Turns out there's really only one way to get around this.  Open up your old mate Visual Studio and create an Event Receiver on the ItemAdded event.  What needs to happen is as soon as the item is added to the list, the event receiver will grab the item, and set the Author value to something generic (I used the System Account), then run the workflow.

(code in text at the bottom of this blog)


Programmers need to KISS

An old teacher once asked me why people think programming is so hard.  Being someone who enjoys it, I couldn't give him a good reason.  

His reply was simple.  
Programming is not hard.  In fact, there are FOUR things you need to understand to be a programmer Programs can run commands sequentially (1 line at a time)They can loop through commands (repeat the same code multiple times)They can handle conditional statements (If, Then, Else)They can transfer controlAnd there are only TWO things that can go wrong Syntax ErrorLogical ErrorSo next time you get stuck on some mind-blowing complex piece of code, just remember... 
Keep It Simple Stupid.

SharePoint 2010 - Calendar with multiple resources and Double Booking prevention

So I know this is an OOTB feature, but I'd been looking for exactly this solution for (let's be honest) quite a while.

A SharePoint Calendar with which you can book items/resources like projectors, laptops, meeting rooms, etc.  A calendar that also checks whether that resource has already been booked on that specific date and time.

Anyway, There is an official Microsoft article at the bottom of this post, but because it took me so long to find, I'm duplicating it:

1.  Activate the 'Group Work Lists' Feature for the Site.
2.  Enable'Resource Reservation' in the Calendar List Settings > Title, Description and Navigation
3.  Ad resources to the 'Resource List' that would have been created when you enabled the Group Work Lists Feature
4.  Use Calendar
5. Profit

Official Article:

SharePoint 2010 - Publishing Site 'Pages Library' no-no

Earlier today I wanted to modify the address of the 'Pages' library on a SharePoint 2010 site.  The reason behind this was to make the naming of the folders more user friendly for our developers who would be deploying reports there.

There wasn't a way to do it from the standard GUI, so I decided to modify it in SharePoint Designer (Hey, if SP Designer allows you to do it via GUI, it's safe right? ... right!?).

Bad move, as there's some behind the scenes magic that must be hard-coded to the Pages URL, which breaks the Navigation Settings page (this one: http://[sitecollection]/_layouts/AreaNavigationSettings.aspx).

'An Unknown Error has Occurred' - Great..

I'm sure there would be a way around it, but for the sake of saving a few hours of investigation, don't change the name of your Pages Library!

Ciao ciao!

SharePoint 2010 - People Picker that is showing the wrong user profile information

Hi again,

introduction to this issue:  Someone has updated information on their MySite but their details have not propagated through to the People Picker, or any list that shows User Information in it.

Why:  This is due to the User Information List, which is used to supply User Information to all the SharePoint functions that use it.  The User Information List only seems to get updated when a user is first introduced to a Site Collection.  Not even a full Profile Sync will fix it. (You can find the User Information List here: http://[rootsite]/_layouts/people.aspx?MembershipGroupId=0).  This issue has been documented before and done very nicely on Gary's blog here:

The difference is between Gary's blog post and mine, is that his shows how to get a script to iterate through every Web Application and update specific fields.  Where as I will be showing how to look for a specific fiel…

Making a jQuery banner from scratch

Woah, hang on a minute...  You mean you want me to build my own jQuery solution from scratch!?  Why would I do that when there are so many pre-packaged jQuery solutions out there?

Good question, if you are only making something very simple, maybe you'd like to optimise the amount of code the browser has to execute, and the pre-packaged solution may have many more features than you need...  Ok, I'll admit that's a bit far fetched for me to use as my own excuse.  I had some spare time, and wanted to see how easy it was.

The answer, as always, is it depends.

I was migrating a website from the early 2000's to a SharePoint site and I just wanted to replace a simple flash banner that faded in/out images & animated text.  Great little project I thought.

Here's how:
First I made a simple HTML page with a div for every image and sentence I wanted to fade in and out.  and an id against every div, so that I could reference them in the jQuery.

<script src=&q…

Entertainment book - Melbourne CBD - 2012-2013

Go to 2 expensive restaurants that do 2-for-1 and you've already made back the money you paid for the book.

Oh wow, now you have 700 other tickets of varied usefulness that can save you cash.

I personally prefer just to use all the restaurant ones as they give you the most value for money and force me to go to new restaurants!

SharePoint 2010 - Copy documents across libraries while keeping Versioning

I've recently been looking into a good Document Management solution using OOTB SharePoint 2010 functionality.  I'll explain my solution that should cover ISO in another post, but here I'd like to explain another issue I had with moving files from one Document Library to another while keeping all the version history.

The only way I've found to keep all the version history is to make both libraries identical, then to open both libraries with File Explorer & move the files to the second Library.  Alternatively, you can use the 'Manage Content & Structure' area to move them as well.

If you are like me, you have some trust issues with Microsoft at times, and don't want to risk moving the files and all their information if it doesn't work!

So here's the easiest (oh god) way I found to do it safely.
Export (Backup) a copy of the Document Library containing all the data you wish to transfer:Export-SPWeb -Identity "http://[servername]/[site]/&qu…

Why we need to stop & think

SharePoint 2010 - When [Today] just isn't your day

Sometimes your SharePoint environment doesn't want to play ball with OOTB features, so if you like me have once had an issue with the [Today] option not working on list filters, here is the slower but successful way of getting it to work:

Create the view using CAML Query in SharePoint Designer 2010.

The CAML equivalent of [Today] is:
<Value Type="DateTime"><Today/></Value>

Or if you want to be a few days ahead or behind today

<Value Type="DateTime"><Today OffsetDays="-31"/></Value>
Cheers, The Baretta

SharePoint 2010 - List View Threshold

Any well utilised SharePoint farm will hit this limit at one point or another, the annoying but not hard to resolve LIST VIEW THRESHOLD ISSUE!!!!!!

If you're on the ball, you'll know to cater for this when first creating a list you know is going to be quite popular with the lads.  This involves creating indexed columns, and creating views that filter on the indexed columns.

But woe to those who wait for the dreadful message to appear, and also to those who prepared for it, but it is still occurring anyway.   WHHHHHHYYYYYYYYYYYYYYYYYYY!!!!!!!!!!!!....


Well it's because when you modify a view using the SharePoint GUI, and you filter on a indexed column and maybe a few others, SharePoint turns your filters & options into a CAML query, and if that query contained a few different column filters, SharePoint occasionally doesn't render the CAML query in a manner that ensures you are always querying less than the List View Threshold!


Oh yes.  If t…

SharePoint 2010 - CSS & JS Across Multiple Web Applications

An issue I came across the other day involved creating a web application with the look & feel as another web application on the SharePoint 2010 Farm.

I decided to link all the CSS from the second Web Application to the first Web Application, which works fine for the majority of functions (background, colours, images, page width, etc).

Here's what was failing for me, and the only workaround was to make a copy of the CSS on both Web Applications:

Certain JQuery & Javascript files failed to renderCustom Markup Styles in the Ribbon failed to appear Moral of the story, Don't point Master pages to another Web Applications CSS & JS files.  Make a copy of them on each Web App

SharePoint 2010 - SQL Server 2012 Reporting Services Integration Steps (Multiple Server Farm)

Most SharePoint customers suffer no issues when integrating SQL Server Reporting Services 2012 (SSRS 2012) with SharePoint 2010 (SP 2010), I however, had quite a bit of trouble.  So for those at home who may also be having some trouble, I thought I'd prescibe you some troubleshooting medicine along with a few spoonfuls of errors.

The official steps you may have read about: - Install SQL Server with Reporting Services Add-in for SharePoint
- Install SharePoint on the Reporting Services Server and connect that server up to the farm (using Configuration Wizard)
- Install the rsSharePoint.msi file provided by Microsoft on all your front-end servers running SharePoint.
- Run these two commands on all front-end servers running sharepoint

Install-SPRSServiceInstall-SPRSServiceProxy - Navigate to Central Administration > System Settings > Manage services on server.  Start the SQL Server Reporting Services Service - Navigate to Central Administration > Application Management > M…