Highlighter | Pentalogic Technology

Archive for the ‘Highlighter’ Category

How to create progress bars in SharePoint

Date:May 10th, 2011 Author:Stuart Pegg Tags: Highlighter, Progress Bar, SharePoint, SharePoint Development, SharePoint Highlighter
Category: Highlighter, SharePoint Development, SharePoint Free Tools Comments:4 ;

Progress bars are a great addition to any list; making percentage values, target achievement, and progress between dates much clearer. Having included this functionality in SharePoint Highlighter, I’ve tried and tested the various ways this can be achieved and thought I’d share my conclusions.

The main methods for getting a progress bar on your list are:

Client based

JavaScript: Put some JavaScript code into a Content Editor Web Part
Designer: Use SharePoint Designer to create a custom view

Custom Field Type

Free Download: Install a community-supported custom field type
Code it yourself: Make your own custom field type from scratch
Buy: Purchase a pre-made solution

JavaScript

If you need a free solution that doesn’t require farm administrator permissions, then Christophe’s JavaScript progress bar may be what you’re looking for. This uses JavaScript in a Content Editor Web Part along with a calculated column to render the progress bar.

To customise this to suit your needs you need to have some experience with JavaScript. Alternatively, Christophe is very quick to respond to comments, and may be willing to help with minor tweaks or troubleshooting.

Advantages of this method are the flexibility of Christophe’s HTML calculated column, and the low cost (providing you don’t spend too long customising it). Although by far the largest advantage is that most end users will be able to implement this solution without having to contact their IT department.

The main disadvantage is having to implement the CEWP on every page you want to see the progress bar, and the need to change the JavaScript in every CEWP for any future alterations.

Designer

If you’re reasonably familiar with SharePoint Designer, or you’re willing to learn a little, then the Microsoft SharePoint Designer Team Blog has a good article on how to use it to create progress bars: CSS Style Bar Graphs using Data Views

The main advantage of this solution is that it is free (SharePoint Designer is a free download), not counting the cost of the time to create it of course. As with the JavaScript solution, you will need to add the modification on each page you want the progress bars to be displayed.

SharePoint Designer has a chequered history with regards to the amount of power it wields (and hence damage it can cause), and so it is unfortunately often the case that SharePoint site administrators ban or severely restrict its use.

Free Download

If your requirements are quite straightforward, there are a few community supported progress bar custom columns available for download (for example this Codeplex project).

These are single-purpose additions that tend to be low on customizable options (such as conditional formatting), but are good for quickly meeting specific requirements.

These community supported progress bars are usually open source, which allows you to further develop them if you wish. The above example is an exception; being both closed-source and obfuscated. Support for community projects is unfortunately entirely voluntary, and usually forum-based.

Code

If you’re reading this section rather than trying to ignore it you’re probably a developer, or thinking about hiring one. I can tell you from experience that unless you have some very specific requirements or intend to re-use the code for other solutions, it will almost certainly be cheaper to buy a pre-made solution.

This is for the most part due to the rather large overhead of setting up the infrastructure of a working custom field type and the daunting learning curve associated with it. For the sole purpose of creating a progress bar, this investment of time may be disproportionately expensive.

Obviously having a vested interest in you buying our product makes my advice somewhat tainted, so I’ll refer you to the impartial words of Bjørn Furuknap on the subject:

“Looking back I think it would have been easier, and less painful, to eat my own eyes.”

If you’re brave enough to continue down this path, creating your own custom field type allows you to tailor a solution much closer to your needs, limited only by your determination and ability to think sideways. To help you on your way, there is a particularly useful MSDN walkthrough.

Although MSDN as a whole is a gold mine for such a project, there are some rather troublesome areas that are thinly documented.

Buy

There are a number of commercial products on the market that allow you to add visual indicators such as progress bars to lists; one in particular that springs to mind (for some reason) is our own product SharePoint Highlighter.

Many commercial solutions come with additional features that may make the purchase more worthwhile. Rather than throw marketing bullet points everywhere (Synergise ROI!) I’ll simply nod meaningfully towards this comparison matrix.

Enormous professional bias aside, the main benefits of a commercial solution in comparison to the above alternatives are: guaranteed support, more reliability, and user-friendlier configuration. Of course, the glaring disadvantage is having to spend some money up front, rather than the less visible cost of time.

Conclusion

Each of these possible solutions caters to a slightly different problem, and there is no single right answer. Obviously if there was a single correct, reliable, unbiased answer it would be to buy SharePoint Highlighter*.

*Possibly not entirely unbiased

SharePoint Highlighter Released for Sale – See it, Try it, Buy it!

Date:May 6th, 2011 Author:Clare Tags: Highlighter, SharePoint, SharePoint alerts
Category: General, Highlighter, SharePoint Ideas Comments:0 ;

At last we are there!

After months of heated debate, midnight-oil-burning and general blood, sweat and tears, our latest new product, SharePoint Highlighter is released for sale today!

So come on, what are you waiting for? Get those credit cards out! You know you can’t do without the ultimate tool-kit for brightening up your SharePoint lists!

We realise that although Highlighter has been the centre of our universe for the last few months, some of you may have had other things to think about. So, in case you have forgotten Highlighter is a custom column for SharePoint that lets you add:

Highlighting,
Color coding
Icons
Progress bars
Countdowns
And more

Let’s face, it compared to a lot of things we look at on our screen every day – things like the Facebook Wall, or a Google Search, or even an Outlook Calendar – a SharePoint list can look pretty dull. You can easily find yourself staring at a mass of information, wondering “What is exactly is going on here?”, and “What on earth am I supposed to do with this?”

So Highlighter gives you a whole box of tricks to brighten up those lists and libraries, and make them much more user friendly.

You might choose to highlight high priority items in red on an issues list.

Or flag unpaid invoices by color, depending on just how old they are.

Or use color coded progress bars to show where you are in relation to your KPI’s or targets.

Or countdown to a task or event due date.

The possibilities are endless and with Highlighter you have a whole range of visual indicator options, allowing you to mark up your lists exactly as you want them.

We set ourselves two challenges when developing Highlighter:

Give people flexibility, a choice of options within one product.
Keep it simple, and easy to use.

We looked at what was on the market already and we found that although you can buy a progress bar, or a color coding column, or a KPI column for SharePoint, there isn’t anything out there that gives you a whole bundle of these options, all in one tidy product. In fact, to get all the features you will find in Highlighter from anywhere else you would have to go to at least 3 different software providers – and pay more than double the money.

So we think we are there with the flexibility, but what about ease of use – don’t all these choices make for a really complicated set up interface?

Well, hopefully not. The really complicated (and powerful) bit is there, in our “Advanced Rules” section, but lots of people will never have to use this. We have spent time developing the user interface, making it intuitive, so that lots of scenarios are actually set up semi-automatically. When you use the software you will see that what you want to achieve can often be managed in just a few clicks.

So, what’s this all going to cost then? Well just $345 for a Starter Pack and $995 for a single server license – cheap at half the price we think.

Plus, of course our 30 day free trail, which will give you plenty of time to see just how handy Highlighter is.

We hope you will give the product a try, and look forward to hearing your feedback.

Download the 30 Day Free Trial Today.

SharePoint Highlighter – Beta Testers Needed!

Date:April 15th, 2011 Author:Clare Tags: Highlighter, SharePoint
Category: General, Highlighter Comments:0 ;

We’re very nearly there – a couple more weeks and with a fair wind and a bit of luck SharePoint Highlighter should be ready for full public release (i.e. the bit where we actually get to charge people for using it!). But first we need some Beta Testers.

Public Beta testing is the last and maybe the most important stage of the product testing process. This is where we get to find out how people are really going to use the software. Whether we have got it right – or not, nerve-wracking doesn’t really cover it.

So we really want you to get involved.

Let me just remind you what SharePoint Highlighter does.

It’s a custom column for SharePoint that lets you add highlighting, color coding, icons, progress bars, countdowns, dynamic highlighting and more to your SharePoint lists. We think it’s probably the only SharePoint tool on the market that has all this in one easy to use package.

And it really is easy to use now. Our final stages of in house testing saw us making some changes to the user interface, which mean that for the great majority of highlighting you may want to do, you will be able to use our new “automatic” button, and set things up in just a few clicks, and a few seconds. Whilst for those who want to do something a bit more fancy the full power of Highlighters “Advanced” options are just a click away.

So, why be a beta tester? Well you get to be one of the first to play with a brand new SharePoint tool and try to break it. We’ll be really grateful, and we’ll give you a nice discount when the product is released for sale – and it’s fun!

But beta testing isn’t for everyone. There isn’t a full manual yet, so you need to know your way around SharePoint reasonably well. The software is still in development so there may still be bugs. You should never install a beta on a live SharePoint environment; you need a test or development server to play. And we will be looking for lots of feedback, so you are going to need some time to play with the product.

So, now you’ve had a look at all the warning signs, if you still think beta testing is for you we would be really grateful for your help. You can download the beta here.

If beta testing doesn’t sound like your kind of thing you can still pre-register here for the full public release, which we expect to have ready for you at the beginning of May.

SharePoint Highlighter – new product, coming soon.

Date:March 16th, 2011 Author:Clare Tags: SharePoint
Category: General, Highlighter Comments:0 ;

We are delighted to be able to let you know that we are about to add a new member to our family of SharePoint products.

Highlighter will let you bring your SharePoint lists to life with:

Highlighting – duh!
Color coding
Icons
Progress bars
Countdowns
And more …

Why did we feel the world needed SharePoint Highlighter you may ask? Well, SharePoint lists can be a little dull on the visual side. As people get more are more into dashboarding, finding ways of picking out different bits of information easily becomes ever more important.

When we looked at what’s on the market already we realised that though there are quite a few products that will give you one highlighting option – say progress bars, or KPI columns, or some kind of icon, there didn’t seem to be anything out there that would give users flexibility and choice in how they mark up their lists. So we thought we’d have a go.

After all how hard could it be?

“Looking back I think it would have been easier, and less painful, to eat my own eyes.”

Bjørn Furuknap

I’m quoting Bjorn because he kind of became our hero during the product development process. The problems challenges fell into three main areas.

First there was the inevitable SharePoint issue. Everything looks simple on the surface. The examples given look straightforward, then you start digging into SharePoint’s dark and dusty undocumented corners and everything suddenly becomes a lot less clear. Once you get in to custom columns you are heavily into uncharted waters. Which basically means you don’t know what you don’t know – and neither does anyone else. There is very little reliable information around on this area, so we do owe a debt of gratitude to Bjorn Furuknap,his blog and his excellent book: “Building the SharePoint User Experience” (APRESS). Rare beacons of light in our darkest hours!

The second challenge was narrowing down our options. There were so many things we could have put into Highlighter – bells, whistles, flashing lights, Unicorns. The temptation to make it all singing, all dancing was almost overwhelming. But we had to resist. If we had put everything we wanted to in it a) it would have been totally unmanageable, and b) we wouldn’t have released in until 2099. So we narrowed it down to the features that we thought would be most useful. The rest remains on our private list of “Shiny Things” possibly for future releases, depending on how many customers say that really need to have unicorns prancing through their lists!

And finally there was the user interface challenge. Though we have been quite strict with ourselves in terms of the number of features we have put in, Highlighter still does some pretty fancy stuff. So keeping the user interface simple and intuitive was always going to be interesting. What we wanted to avoid was presenting users with so many options at the outset, that they just ran away screaming. What we have come up with is an interactive interface – almost a “wizard” (but definitely not a helpful paperclip!) We think it is pretty easy to use and we hope you will agree.

Highlighter is a bit of departure for us, it’s not a SharePoint web part, it’s a custom column. Every time I go to switch it on I have to remember not to “add a web part” to the page, but to add a column to the list instead. I am a mere marketer and my feeble brain struggles with such changes in routine!

And the other first for Highlighter is that it’s a first as project lead for our new developer Stuart Pegg – new job, new project, new area of SharePoint – we really believe in trial by fire for our people! But Stuart has come through with flying colors and a great product that we think you are going to love.

Highlighter is now in the final stages of testing and will be available in public beta in the next few weeks.

We are inviting you to pre-register for the free trial now – which will mean you will be one of the first to get the product and will qualify for our product launch discount.