This post covers creating custom reports from SharePoint lists in Excel by joining SharePoint lists together. It specifically addresses the issues with People Picker and Lookup columns returning the row ID rather than the value. Continue reading Creating reports from SharePoint lists
This blog post covers the process you need to follow to accept an invitation to a SharePoint online site when you are an external user, e.g. being invited to your customer portal that we (The Full Circle) provide to our contracted services customers.
Continue reading Office 365 SharePoint Online access by an external user
Part of what we do as consultants is help people from the ground up with software. Nothing is more ubiquitous than Outlook but it is also probably the least well utilised.
Below I’ve disassembled how I setup my Outlook view of my mail. This layout helps me get the most bang for my buck on a 24inch display and helps me organise myself.
There is a logical progression, left to right of: start > email comes in on the left and it is followed through its lifecycle as I flag, reply, familiarise, track tasks against it and schedule my time > end.
It is the result of quite a lot of experimentation but ultimately is my own preference. Feel free to submit your own in the comments :-).
Continue reading How I have my mail view configured in Outlook 2013
We have several customers who use SharePoint 2010 Foundation and are constantly trying to get the most out of the product, envious of what SharePoint standard and enterprise can do, frustrated by Foundations limitations but liking its price tag.
I’ve compiled a list of useful add-on’s here but I’ll come back and keep adding to it as we find more that are note worthy.
Continue reading Free SharePoint 2010 Foundation add-ons everyone should have
I’ve not seen one of these kicking around anywhere so I’ve created one based on the information from the Microsoft web site.
You can download the spreadsheet and filter it based on your requirements and see which SharePoint online plan meets your needs. All the feature names retain their original link back to the Microsoft page for further research into what the feature is and what it does.
Continue reading Office 365 SharePoint Online feature matrix spreadsheet
While reinstalling Search Server Express 2010 for a customer I found there wasn’t a hughe amount of help out there for how to slipstream Search Server Express 2010. The process isn’t really different to SharePoint Server 2010 Standard or Enterprise but does vary a little to Foundation.
Here is a little guidance on how to create slipstreamed installation media for Search Server Express 2010.
Continue reading Create Search Server Express 2010 slipstream installation media
The mysterious case of missing blog post images after migration.
Well, I wish it was mysterious. Actually, it was pretty obvious. The WordPress import tool isn’t exactly what you’d call robust.
Going into the wp-content/uploads folder on old hosting location (GoDaddy) and the new (Azure) showed that the WordPress import tool missed/failed to get the uploads folders from three years worth of blog posts.
So, all that was needed was to sync up the folders. No stress. Here we go.
Getting your FTP username and password for an Azure Web Site.
Thanks to Bertrand Le Roy’s blog post on where to find the user name because what you would consider to be the likely candidates for your login – the deployment user account shows as not set.
1. From your dashboard on Azure for the blog, download the publish profile –
2. the XML file find your FTP user username and passwords –
Copy the missing files between the old and new location
1. Configure Filezilla with the connection to the FTP address listed on the dashboard.
2. Upload the missing years or months media from your old blog, either a local backup like the one I took or directly between the two FTP sites.
Why did it happen?
I’m sure a WordPress expert out there could reveal the mystery in detail, and migrating blogs isn’t exactly my day job – we’ll chalk this one down to “something went wrong but it was easy to fix”.