Creating a dashboard using a SharePoint list (part 4): bringing it all together

This week has been a bit of a SharePoint-fest as I’ve walked through the stages of creating my SharePoint dashboard. For obvious reasons, I can’t share the version I use at work, so I’ve created a mockup using the SharePoint site that comes with my Office 365 subscription. Feel free to take a look…

The three posts that explain how I built this dashboard can be found below:

As the code examples I gave use quite a lot of SharePoint formulas for calculated values, I thought it might also help to link to Microsoft’s formulas and functions documentation as well as their examples of common SharePoint formulas.

Right, that’s enough SharePoint for now… next week will be back to the usual mix of tech, marketing, photography and whatever else I stumble across…

Creating a dashboard using a SharePoint list (part 3): indicating several states of progress

Yesterday’s post looked at using ticks/crosses on my SharePoint dashboard to track progress on activities. I was quite happy with this, but my manager wanted to show progress, rather than a simple binary done/not done – and I wanted it to be visual, not text-based.

We settled on a system using a series of circles with various stages of “filling-in” (none, quarter, half, three-quarters, full) to show how far an activity had progressed, and I amended the code that I used for the ticks and crosses.

Using the same principle as with the ticks and crosses, this time the font changed from Wingdings to Arial Unicode MS, which includes the appropriate shapes under the block elements and geometric shapes subrange:

First of all, I changed my column to indicate progress from a Yes/No to a Choice with radio buttons for Not Started; Started; Additional Information Required; Almost Complete; Complete and Not Applicable.

Next I needed to adapt the formula used to calculate the correct HTML code for the display column by nesting repeated iterations of

IF([Task Progress]=”Started”,”

?
“,”
?
“)

Eventually this ended up as:

=IF([Task Progress]=”Complete”,”

?
“,IF([Task Progress]=”Started”,”
?
“,IF([Task Progress]=”Additional Information Required”,”
?
“,IF([Task Progress]=”Almost Complete”,”
?
“,IF([Task Progress]=”Not Applicable”,”
“,”
?
“)))))

The code is not pretty, but it seems to work, and the result is something like this:

Creating a dashboard using a SharePoint list (part 2): tick/cross status indicators

In my last post, I wrote about how I used a script I found on the Internet and a couple of calculated columns to show a Red/Amber/Green (RAG) status on a list in SharePoint. I also wanted to clearly indicate which items in my list were complete, and which were still ongoing.

My inspiration for this came from Chris Bell’s posts on displaying tick marks in HTML, combined with the same code that converts my text RAG Status to HTML.

This time, I converted a Yes/No Checkbox (actually, it’s TRUE/FALSE) to HTML code for a tick or a cross in another column, using the following formula:

=IF([Task Completed]=TRUE,”

ü
“,”
û
“)

The end result is something like this:

It needs the Wingdings font to be installed, but everyone who needs to access this list is using a Windows PC – feels like a bit of a fudge but it works for now… and can always be replaced with a graphic (as I did for the KPI indicators on the RAG status).

Creating a dashboard using a SharePoint list (part 1): colour coded status indicators

I’ve been having some fun over the last couple of weeks, developing a dashboard in SharePoint to track a number of activities that I’m co-ordinating.

Within our company there are some people who criticise SharePoint as a platform, largely because of some of the confusing messaging around some of the collaboration features and the way in which it gets mis-used as a document store (complete with folders!) but, whilst it can certainly be infuriating at times, I have worked on quite a few sites over the years where it’s struck me just how powerful the concept of a list is (I should know that really – I remember spending quite a bit of time discussing linked lists in my Computer Studies degree, but that was 20 years ago…).

I wanted to create a list with a red/amber/green status for each item – but I didn’t just want the words – I wanted colour to jump out of the page and say – this is the stuff that’s on track… and this isn’t…

Some calculated values and a script to generate HTML from text

A bit of digging around on the ‘net turned up a method that works for me – and the details are in Anjali Bharadwa’s post on colour coding custom lists and tasks:

Firstly, I  interrogate the contents of my text column (in my case this is called RAG Status, with pre-defined choices or Red, Amber and Green) and convert that to an HTML colour code in another column (called Color). The formula is  as follows:

=IF([RAG Status]=”Red”,”red”,IF([RAG Status]=”Amber”,”orange”,”green”))

I created a page that includes a Web Part that displays a view on my list and used a hidden Content Editor Web Part below this, containing Anjali’s script (there’s an alternative script available from Christophe Humbert at PathToSharePoint but the download link wasn’t working on the day I needed it…), to read this and to generate HTML in another column with a calculated value (called RAG).  For SharePoint 2007, the script can be included within the HTML source for the webpart but, for SharePoint 2010, it’s necessary to link to a separate file (Adam Preston explains how to do this in his post on inserting JavaScript into a Content editor Web Part) in the This time, the formula is:

=”

n

Using a particular font is risky (how do you know that everyone has it?) but in this case I could be sure that all of my audience would be running our corporate build with Windows and Internet Explorer. I later changed the formula to use a different symbol:

=”

?

Sorting the RAG status

One annoyance with this approach was that the list was sorted based on my RAG Status column, but I wanted Red-Amber-Green and the alphabetical order was Amber-Green-Red. My fix for this was to change the RAG Status choices to include a number so they become: (1) Red; (2) Amber; and (3) Green.

I also tweaked the calculated value for the Color column:

=IF([RAG Status]=”(1) Red”,”red”,IF([RAG Status]=”(2) Amber”,”orange”,”green”))

With this change in place, my column ordering works – and it gave me the opportunity to change the way I represent the status too…

Alternative visualisations

Path to SharePoint has some ideas for alternative visualisations for colour-coding (and a follow-up post). I particularly like the KPI indicator version, which is based on some of SharePoint’s standard images:

_layouts/images/kpidefault-0.gif
_layouts/images/kpidefault-1.gif
_layouts/images/kpidefault-2.gif

To use these, I changed the formula for my RAG column to:

=”

This change also means that the Color column is redundant, although I’ve left it in place in case I want to go back to it later.

What next

So that’s my RAG status sorted. In the next post, I’ll explain how I used this method to show ticks and crosses to indicate activity completeness.

Registering MSCOMCTL.OCX on Windows 7 (x64) to run the FLAC Front End

I’ve mentioned before that iTunes mangled my MP3 library and then a multiple disk failure on my ReadyNAS took it away completely and, eventually, I will re-rip the hundreds of CDs that (thankfully) I still have in my loft…

In the meantime, I’ve been researching (aka asking followers on Twitter) what’s the best way to re-rip my music and the general consensus was to rip as Free Lossless Audio Codec (FLAC) and then convert to MP3 as required:

[blackbirdpie url=”https://twitter.com/GarryMartin/status/194536609302052865″]

A couple of weeks ago, I downloaded FLAC from Sourceforge but the installer gave an error message, complaining that it failed to register MSCOMCTL.OCX (on my Windows 7 x64) system.

Neil C. Obremski describes the problem in his 2008 blog post and the problem file is a Visual Basic 6.0 control which, not surprisingly, Microsoft no longer ships with Windows. Whilst there are unofficial downloads available, Microsoft also makes the Visual Basic 6.0 Common Controls (MSCOMCTL.OCX and COMCTL32.OCX) available as free downloads but they are contained in a .EXE file that didn’t want to play ball either.

No problem, 7-Zip opened the .EXE and I successfully extracted the file I wanted, copying it to C:\Windows\SysWOW64 on my machine.

Following this, I dropped into a command prompt (running as an administrator) and typed:

regsvr32 mscomctl.ocx

With the OLE control extension (.OCX) registered, I was able to run the FLAC front end (although I actually used dBpoweramp instead… it’s tremendously powerful and the CD ripper setup guide helped me to get going).

Calculated value based on today’s date in a SharePoint column

One of my current projects involves developing an internal system to keep track of the technologies that are approved for use in our solutions.  As part of that, I’d like to set a flag on each entry so that it is regularly reviewed – for example every 90, or 180 days.

I had hoped to use a calculated column for this (i.e. today’s date plus x days) but it’s generally recognised that calculated fields only work on data entered by a user, and not from the system. Indeed, Microsoft’s own documentation for the TODAY function says:

“[…] You can use the TODAY function only as a default value; you cannot use it in a calculated column.”

Even so, I’ve had some success (with Microsoft Office SharePoint Server 2007) in setting a column type of Date and Time, in Date Only format, with a Calculated Value of =Today+90.  I’m not sure how/why this is working, given Microsoft’s statement above, but it may be worth considering.  Just be aware that your mileage may vary…

(Christophe Humbert has more information and another approach over at Path to SharePoint)

Towbar 101

A few months ago, I mentioned that my new car had been delivered, complete with factory-fitted towbar (incidentally, the instructions to release/retract it are in the handbook, just not under any index heading that might help, such as “towbar”).

Since then, I’ve been having fun with my new 4-bike carrier on the back of the Tig’ (no more piggyback carriers scratching the bikes and the car…) but I did go through a pretty steep learning curve, so I though this post might help other “towing virgins” (except perhaps caravanners).

Firstly, I should clear up that I have no aversion to caravanning (well, actually, I do – particularly when trundling along  behind them on single carriageway roads on a summer Saturday – but that’s not the point here) however, I understand that caravans need extra electricity or something (for fridges, etc.). I was advised at order time that the factory-fit towbar on my car has “single electrics” and so that might be a consideration for those who use a caravan (sadly at least one Skoda-driving-caravan-owner was not given the same advice).  As I have no intention of joining the Caravan Club any time this side of… ever… that’s not a big issue for me but I appreciate that for many it would be…

A trailer might be useful sometimes though, and I already mentioned that my use of the towbar is to carry several bikes on the back of the car (the roof would be another option – but more expensive, and more difficult to lift them on/off).

One thing I quickly found was that, in common with many older trailers, my carrier had a UK-style 7-pin “N type” plug (cf. the 7-pin “S type” used for caravan wiring) and that my car had a 13-pin Euro socket (albeit with just 10 live pins). Halfords sell a suitable converter for under fifteen quid and that did the trick nicely, although I struggled to get it on the first time, it’s become easier over time (full marks to the guys in Halfords, Wellingborough, who were really helpful).  Unfortunately I can’t leave it on the car when not in use as it prevents me from retracting the towbar (no great shakes really).  Those who do have a full set of electrics and who need to tow a house on wheels might find a “spider” adapter useful to split the 13-pin Euro connection into two 7 pin connections (one N and one S, confusingly known as 12N and 12S!).

I found it interesting that the wiring on my car is intelligent enough to disable the rear parking sensors (the display shows a picture of something being towed) and will also sound the alarm if disconnected when the car is locked.  It should also disable the vehicle’s fog lights in preference to the trailer/trailer board’s lights, although I haven’t tested that.  Whilst I sometimes wonder if it might have been less expensive to have an after-market towbar, features like this are a useful side-effect of using a factory-fitted model.

Of course, towing something generally obscures the rear registration plate so I needed to get an extra one (the dealer who supplied the car was happy to oblige there – thanks to Citygate Volkswagen’s fleet sale department) but I needed to drill holes in the plate to mount it on my bike rack.  A few tips that might help here (I picked most of these up from a forum for Vauxhall Vectra enthusiasts):

  1. Start with a small drill.
  2. Use a slow speed (turn town the speed if your drill is variable).
  3. Leave the protective plastic cover on (I started from the front side) until the holes have been made.
  4. Drill through onto a block of wood.

Finally, I got a bit nervous with the bikes on the carrier using just the supplied straps (they are OK for a few miles but I’d be concerned using them for long distance at motorway speeds).  I picked up a 5m ratchet strap (again, from Halfords) and I use this for extra security.  For those who aren’t used to ratchet straps, they can be difficult to get used to but there is a great video on YouTube that might help.

So that’s my top tips for towbar newbies. It’s not complicated, but there was definitely a learning curve involved. If you’ve any tips to add, please leave a comment, although I can’t really support people with their towing questions (especially when it comes to caravans!).

Consumerisation think tank panel at Dell Technology Camp 2012 (#DellTechCamp)

Yesterday afternoon, I took part in a panel discussion on the evolution of consumerisation as part of a Dell Technology Camp and in advance of the publication of the third part of Dell/TNS Global’s Evolving Workforce research.  It was the first time I’ve taken part in an event like this and I have to admit I was pretty nervous but it was also an enjoyable experience – particularly given the wonderful surroundings of the Saatchi Gallery in south-west London.  I only wish I’d been able to tweet during the event (I did scribble some notes but was focusing so much on the conversation that tweeting would have been a step to far for this Gen-Xer who isn’t so great at “partial attention”!)

Evolving Workforce Think Tank @ #DellTechCampChaired by Stephen O’Donnell (@stephenodonnell), the discussion examined a number of topics related to consumerisation, including: the generational divide myth; recruiting and retaining talent; new working practices; technology choices; security;controlling costs and driving profit; and the impacts of geography and market sector on progress.

Dell have produced a Storify story about the whole day (not just the panel discussion) – and you can catch the recording of the live stream – but, for those who don’t have a couple of hours to spare, I thought I’d blog the highlights… I guess you could think of them as the tweets that never were:

  • Stephen Yap, TNS UK: It’s a myth that only generation Y gets “social” and consumerisation; TNS’ research finds that older generations are more accepting of IT as a transformation agent (and younger people are more sceptical).  [Something that one of my Baby Boomer colleagues, Vin Hughes, suggested over a year ago in a blog post about the digital world and generational labels.]
  • Alexis Lane, The Head Partnership: Organisations need a element of control to stay within the law, including open communication of policies.
  • Stephen Yap: IT is not just a utility – get it right and it can be a motivator for employees.
  • Mark Wilson (@MarkWilsonIT): The IT department is just a provider of “stuff” in our personal clouds – just like our bank, supermarket, email provider, etc. [Credit is due to Joe Baguley (@JoeBaguley) for that one… also see my post on the rise of the personal cloud, inspired by David Gentle (@DaveGentle).]
  • Helen Calthrop-Owen, Axicom: Consumerisation is part of a bigger change regarding how people work together.
  • Tim Weber (@Tim_Weber), BBC: Policies alone are not enough – citing Joshua Klein (@JoshuaKlein) he says that we need to “hack our work“, noting that it could get you fired, or you could be a big winner.
  • Bryan Jones (@BryanAtDell), Dell: It’s not “lazy IT” that holds us back so much as cultural challenges – the key is to create “competitive differentiation”.
  • Mathias Knöfel (@MathiasContext): Consider the cost factors and end user benefit – given a choice users will pay for flexibility.
  • Mark Wilson: Get under the surface of BYO and you’ll find it’s more about choice – giving users the ability to trade up to a “sexier” device [credit due to Garry Martin (@GarryMartin).]
  • Stephen Yap: Emerging markets see employer-provided devices as attractive (they tend not to have PCs at home); meanwhile in the US/Canada it’s about Bring Your Own Cloud [what I called the personal cloud] – questioning the need for corporate IT. Not so much about the choice of device but working in the way in which we have become accustomed to.
  • Alexis Lane: Increasingly difficult to draw lines of ownership (intellectual property and corporate data vs. life) – often old questions arise in a new context (e.g. the ownership of a contact database cf. LinkedIn profile).
  • Stuart Collingwood, Nivio: Enterprise-grade social media does exist; devices are more emotional and entitlement can create friction (i.e. who is entitled to what); light touch integration is required for end users to access corporate IT.
  • Bryan Jones: There is no silver bullet (in terms of technology); what’s required is a “portfolio discussion” about on premise IT; extrenal service provision (e.g. cloud) and how to bridge the gap.
  • Stuart Collingwood: Employee expectations for IT performance are “brutal”; tolerance of “corporate lethargy” and inflexible applications has dropped.
  • Tim Weber: Users tend to blame devices or applications but may be other issues; legacy holds us back (e.g. network performance).
  • Mark Wilson: Returning to issues of cost – tax implications with benefits in kind – need clearer advice from government.
  • Bryan Jones: The consumer knows what is possible – consumerisation is not solely an IT issue but raises business functional questions. The trick is to simplify IT, to become more responsive – and innovation is occurring whether we like it or not – there’s an opportunity to embrace it and to listen across the organisation, not just to IT.
  • Stephen Yap: There’s a shift towards outcome-based working with an unspoken contract between freedom and blurred boundaries [i.e. no more 9-5] and digital natives find this easier to understand.
  • PJ Dwyer, Dell: Flexible working is popular, but some employees dislike the remoteness/don’t feel part of the team.
  • Tim Weber: In addition to recognition issues, some roles require collaborative working and presence; interesting to see that Twitter (distributed by nature) has triggered Tweet-Ups – the Human Being is a social animal and companies are social organisations; consider team dynamics (e.g. in a large team, others suspicious that they are carrying the load) – management becomes a task of ensuring everyone knows what their colleagues are doing.
  • Marie-Christine Pygott, Context: Communications occur in many ways – if employees are not present, they are not on the mind of others (you can’t walk over to their desk for a chat).
[blackbirdpie url=”https://twitter.com/TNS_UK/status/208204232141193216″]
  • Stephen O’Donnell: We need a virtual watercooler, do we need to use social media to highlight work milestones [or even, “I’m taking the kids to school, I’ll be back in 20 mins”]?
  • Stuart Collingwood: Expect to see that scenario become more common as future generations enter the workplace (and we’re already seeing changing literacy styles, such as use of “text speak” in written English).
  • Carly Tatum, Dell: Communications work in different ways; bringing people into a group situation from social media context can induce a different dynamic [one that doesn’t always work].
  • Mathias Knöfel: Often, meeting people face to face changes the relationship from that point onwards.
  • PJ Dwyer: Emerging markets have different perspectives, due to different stages of development.
[blackbirdpie url=”https://twitter.com/GStudentAgain/status/208209245735366656″]
  • Stephen Yap: In BRIC, for example, skipping PCs and moving straight to smartphones; also leapfrogging legacy in the workplace – not as encumbered.  It will be interesting to see the change as security, etc. become bigger issues in developing nations. Also cultural differences as in some geographies work and technology may act as motivators.
  • Alexis Lane: When talking about the security of information, we need to understand what it is we are protecting. It’s not realistic to say “everything” – what can we be more relaxed about?
  • Tim Weber: The “castle/moat model” makes less sense as we become more mobile and blast more holes in the walls – need to look at data level and see what can be done to protect it; requires clever thinking, supported by technology, to understand how to protect the things that are critical to your company.
  • Stuart Collingwood: We have to think differently about how we build systems – it’s hard (and expensive) to retrofit so we need to re-architect from the ground up.

Graphic Recording from Evolving Workforce Think Tank at #DellTechCamp

Key takeaways

For those who find even that list too much to work through – here are the key takeaways from around the table:

  • Stephen O’Donnell: Consumerisation is happening, it won’t stop – indeed it will accelerate; employees like it, it frees them up from coming to the office as well as from Victorian-style employment contracts; work is becoming more outcome-based; difficult to draw line between work and home; requires serious management – need to think, plan and come up with new ways of thinking.
  • Tim Weber: There is no single solution; every company needs to look at legacy – not just productivity and happy employees but the underlying stategic business model – suss that out and have clarity of thinking to drive company forward; remain flexible as things will constantly change on the roadmap.
  • Mathias Knöfel: BYOD gives opportunities for flexibiity with the right incentives but also risks that need to be thought through more carefully (e.g. legal/risk).
  • Mark Wilson: From an end-user perspective, don’t just think about the “Digital Natives”, also consider “Digital Pioneers” who have seen previous waves of IT transformation and those with no time/inclination too (Digital Luddites); from a management standpoint we need to develop new attitudes to work – become more trusting and results oriented; and the IT department needs to address issues around legacy, removing barriers through innovation and avoiding stagnation; finally, we can’t close lid on this box!
  • PJ Dwyer: It’s happening now; organisations need to be proactive and it affects not just IT but also HR, legal – indeed the whole business. Flexibility and choice are key to success and aspirations vary by market and geography.
  • Marie-Christine Pygott: There are pros and cons to consumerisation – it changes the dynamic of an organisation – the way people work, their flexibility, work/life balance but also who teaches whom – employees suggest more about the technology used; there is no single solution and we need need integrated strategies; communication is vital; also differentiation in different parts of the world.
  • Stuart Collingwood: Consider company culture – not just policy and structural issues – need to instil communications protocols, sensitivities and context within company culture – requires a top down approach.  Culture is safety net and policy handbooks are not enough. People will use technology more responsibly than you might give them credit for.
  • Alexis Lane: Embedding culture of the organisation and taking a decision as to what the company needs to be is important. It’s exciting to consider technology as a motivation – and from a legal perspective we need to get to heart of data issues.
  • Bryan Jones: Not just a technology discussion – people and process too; competitive advantage downstream is enormous; culture is critical to changing the dynamic in a company; it permeates, into how we communicate internally and how we interact with customers.
  • Stephen Yap: Enterprise IT has ever been more exciting than now; we’re at a tipping point, elevating the significance of IT within the organisation and to our lives; not just about IT professionals but it makes a difference to all – in how we work and how we live; not just happy and motivated workers but new business models, new ways of doing things. And the conversations that we’re having are more strategic than 10 years ago; IT is making a bigger difference than ever before.

tl;dr view

Stephen O’Donnell’s summary: there is an enormous opportunity for businesses to adopt and drive the socialisation and consumerisation of IT; to really make a difference in driving down costs, improving agility and improving employee/customer communication. On the other side, there is a risk that we “throw the baby out with the bathwater”, that we don’t follow the processes because it’s all new, that we under manage employees, don’t deal with security appropriately, don’t invest in the underlying infrastructure and so don’t achieve the benefits.

Image credits – Dell’s Official Flickr Page, licensed under Creative Commons Attribution 2.0 Generic (CC BY 2.0). Visual communication/storytelling by Creative Connection.

Useful Links: May 2012

A list of items I’ve come across recently that I found potentially useful, interesting, or just plain funny:

DSLR sensor cleaning hints and tips

I started to write this post back in September 2010 but it’s been sitting in my drafts folder since then, waiting for me to check my facts.  Even so, as I found myself taking up more of my friend Andy Gailer’s time than I suspect either he or I would have liked (as he helped me to clean the sensor on my DSLR a couple of nights ago), I knew it was time for me to finally put pen to paper (or fingers to keyboard) and finish this off…

It’s a fact of life that, the more often a lens is changed on an SLR camera, the more likely it is that some dirt or dust will find its way into the chamber. Back in the days of film it was easy – grit would scratch your negatives, but a few specks of dust were rarely a problem (indeed, the action of winding on the film moved the dust/dirt away from the active area). Ask anyone with a DSLR though, and they will almost certainly regail stories of frustration as they try to remove dust spots from their sensor (or at least the low-pass filter immediately in front of the sensor).

This post has a few hints and tips that might help you if you have ugly spots appearing on your images. I also recommend reading Thom Hogan’s excellent article on cleaning sensors.

Dust off reference image

I use a Nikon DSLR and it includes a feature called teh dust off reference image. The idea behind this is that, by taking an image that shows the dust spots, this can be compared with others and changes made automatically. It’s a nice idea, but it requires the use of Nikon’s Capture NX software. I don’t use Capture NX (I use Adobe Lightroom), so this feature doesn’t help much… I’m not sure what Canon (and other manufacturers) do, but probably something to be aware of if you have a Nikon DSLR.

In camera sensor cleaning

My Nikon D700 has the ability to clean its own sensor at startup/shutdown but I’m not sure how effective this is.  Even so, it’s probably worth leaving the option enabled – it won’t do any harm.

Arctic Butterfly

One tool in my friend Andy’s arsenal is his Arctic Butterfly. Basically a selection of brushes with a motor to spin off any dust, this kit allows skilled operators (i.e. not me!) to lift away dust by breaking the static bond that is attaching it to the sensor. You’ll need to lock up the mirror (the camera will usually have an option to do this in its firmware) in order to access the sensor.

It’s a useful tool and on at least two occasions now Andy has helped me to clean away most of the dust (there’s always some left behind). The downside is that the Arctic Butterfly is quite an expensive piece of kit.

Rocket blower

I spent at least half a day working through a multitude of boxes, drawers and even some more unlikely places hunting high and low for my Giottos air blower but I can’t find it anywhere.  If it doesn’t turn up soon, I’ll almost certainly replace it as it’s an excellent investment for blowing loose particles away.  The trick is to hold the body with the lens mount facing down, then blow upwards (so that any dirt falls away from the camera and towards the ground). If you’re lucky, this is all you need to do to clear away the dust, but never use compressed air blowers (the propellant can sometimes get squirted onto the sensor) and, certainly never be tempted to blow with your mouth! I found, to my cost, that even a dry mouth will result in saliva on the sensor… which leads me onto the next tip…

Sensor swabs

Sensor swabs can be used for removing stubborn stains (like saliva… or grease).  Available in specific sizes to suit full frame 35mm or APS-C sized sensors, I have used the Photographic Solutions Sensor Swabs Pro product previously, but my swabs seem to have gone AWOL with my rocket blower…

As it happens, Andy had some swabs from Visible Dust that probably did a better job – the main difference was that they needed to be  moistened with a special fluid instead of being pre-moistened and sealed in a foil packet.

Checking for the presence of dirt on the sensor

Regardless of the technique(s) used to clean the sensor, it’s necessary to check for the continued presence of dust/dirt on the sensor.  Some spots will be too small to view with the naked eye but, thankfully, it’s relatively straightforward to take a photograph that will show any problems.

  1. Take a picture of a plain object (e.g. a sheet of paper) from about 10cm away in good light. Make sure that you use the following settings:
    • A narrow aperture (e.g. f22) for maximum depth of field.
    • Zoom in as far as possible.
    • Focus to infinity (you may need to do this manually).
    • Some people suggest setting the exposure to +2.0EV but I tend not to do this as the dirt will still be visible on a grey image and over-exposing may blow out the image leaving no dust spots visible.
  2. View the image at 1:1 scale in your favourite image editing software. It may take a while to view the whole image (with several scans across and up/down) but it should be possible to see if there are any remaining dust spots. If the largest ones have gone and there are only a few left (especially at the edges), it may be advisable to cut your losses and leave them there…

Disclaimer: I feel the need, in today’s increasingly litigious society, to point out that this information has been given in good faith but that I can’t be held responsible for any damage to equipment as a result of following the advice on this website.