Kiva Export analysis spreadsheet

logo.png So with the development made by Kiva it is now possible to export an Excel Spreadsheet with all you loans – a great step forward but it did leave a little to be desired, and the format made it hard to analyse…

I have created a spreadsheet (in Microsoft Excel and Calc formats) which will analyse the data further, splitting fields to allow better sorting, and fields that contain numeric information are now formatted as proper currency or date fields.

Basically you just copy a fresh download of your Kiva Export into a ‘My loans’ tab in the spreadsheet – it does all the necessary using functions, formulas and calculations. No macros are used for those worried about security risks.

Continue reading

Changing to NextGEN Gallery

So I took the plunge and decided to change from using myGallery to use NextGEN Gallery. For a while I ran both plugins but in the end I worked out a procedure to exclusively use NextGEN.

I had several hundred images in quite a number of different posts and pages, and I was not looking forward to going through and updating each post so I looked for some “shortcuts” to try on my localhost test site as this is not a procedure for the faint hearted (even with appropriate backups taken)…

Step 1 – After installing NextGEN Gallery I used the myGallery Import:

  • A few odd characters managed to break the import but once I had tracked these down (apostrophises and copyright symbols) all of the images were imported very quickly and easily.
  • Unfortunately the ID number of the images was updated, so I exported both the NextGen and myGallery picture tables and merged the data together so that wp_mypictures id was copied into wp_ngg_pictures pid matching on the filenames (which were thankfully unique across all of the subfolders).
  • Keeping my fingers crossed I then imported the merged data, overwriting what was alreaady in wp_ngg_pictures – it worked!!

Step 2 – Updating the album / gallery pages

  • With only half a dozen pages this was easy to update manually opening each page and changing the tags from [mygal= to to
    Header images

    Images used within the rotating header of the website.

    71 Photos

    Israel - January 2005

    Pictures from my trip to Israel in January 2005, staying in Jerusalem to visit the botanic garden.

    91 Photos

    Kiva Entrepreneurs

    Map and gallery of people who I have made Kiva loans to.

    158 Photos

    Misc images

    Misc images

    142 Photos



    6 Photos

    Coast to Coast

    Pictures from my Coast to Coast walk, May 2007, from St Bees in Cumbria to Robin Hood's Bay in North Yorkshire. Daily posts from the trip.

    168 Photos

    A nice up of tea and...

    Things that go well with a nice cup of tea and a sit down.

    56 Photos


    Photos of all things living on the wild side.

    21 Photos

    Lake District walking weekend - July 2007

    A gallery of images when I gatecrashed a long weekend of walking arranged by the walking club at NIMR - National Institute for Medical Research at Mill Hill.

    22 Photos

    Northumberland trip

    A trip in June 2004 to Northumberland, visiting Alnwick and Cragside Gardens - with a brief stop over to meet the Angel of the North.

    18 Photos

    Merseyside trip

    Driving back from Cumbria in June 2004 I stopped off to visit Ness Botanic Garden and the National Wildflower Centre in Liverpool.

    11 Photos

    Sheffield trips

    Back in 2004 I made a couple of trips to Sheffield, visiting the Winter Garden, a wander around the city centre, and a walk through the Botanic Garden.

    25 Photos

    Santa Barbara 2003

    In June 2003 I visited Rosminah in Santa Barbara, California. We did a whistle-stop tour of some fantastic gardens and nurseries.

    53 Photos

    Sussex Ouse Valley Walk

    A walk though the Ouse Valley in September 2007. 42 miles over 2 days meandering from source to sea (Lower Beeding to Seaford). Also see the post about this walk.

    22 Photos

    South Downs Way

    A walk along the South Downs Way during late September 2007, through the counties of East Sussex, West Sussex and into Hampshire.

    41 Photos

    Kiva Calendar 2008

    From a suggestion, and a whole lot of hard work, through a calendar was developed to promote Kiva. Polls were held to select the photos, and to develop the layout I created.

    Walking the IoW

    In October 2007 I walked around the Isle of Wight, around 65 miles of coastline, inlets, chines, towns and wonderful areas of outstanding natural beauty.

    43 Photos

    East Hoathly Carnival

    Carnival is held on the eve of Remembrance Sunday with a spectacular torchlight parade, inaugurated by the Last Post and one minute’s silence, followed by a bonfire and a spectacular firework display.

    13 Photos

    Dorset 2007

    Spent a week or so in Dorset in mid November 2007. Visited David in Sherborne and Maureen in Charminster, went on a couple of short walks, and met a giant.

    16 Photos

    Walking Pooh country

    A 40+ mile walk over Ashdown Forest, the home of Winnie the Pooh

    11 Photos

    Walking the coast of Kent

    In early 2008 I spent 10 days walking the coast of Kent. While there was a bit of bad weather, which curtailed some walking, I still managed over 150 miles.

    108 Photos


    17 Photos

    Cornwall - 2008

    In early March and again in mid April I spent a few days in Cornwall. I managed a couple of walks and a garden visit...

    78 Photos

    Walking the Wealdway

    Over the Easter Bank Holiday (March 2008) I spent 4 days walking the 80miles of the Wealdway between Eastbourne on the Sussex coast to Gravesend on the River Thames in Kent

    44 Photos

    Brecon Beacons 2008

    In early April 2008 David invited me up to Dyffryn Crawnon for a week, and I took the opportunity to stretch my legs over a bit of the Brecon Beacons

    33 Photos

    Walking the Pennine Way

    In May 2008 I took a leisurely 19 days to walk the 260 or so miles (412km) of the Pennine Way, from Edale to Kirk Yetholm. I was so lucky with only 2 days with poor weather, and many days with hazy sunshine which made the walk all the more enjoyable.

    147 Photos

    Southern Upland Way

    A journey of 212 miles (in 11 days) across the southern uplands of Scotland, from Portpatrick in the west to Cockburnspath in the east.

    123 Photos

    8 Photos

    King Bladud's Pigs in Bath 2008

    King Bladud’s Pigs in Bath was a summer 2008 public art event to celebrate Bath. Over one hundred life-size pig sculptures were on display throughout the summer all around Bath and beyond - at the end of September I found 59.

    69 Photos

    Walking the Vanguard Way

    Walking the 66 miles of the Vanguard Way in September 2009, from East Croydon (London) to Newhaven (on the Sussex coast).

    35 Photos

    Elephants in London

    Elephant Parade London 2010 is a conservation campaign that shines spotlight on the crisis faced by the endangered Asian elephant. The event sees over 250 brightly painted elephants located over central London this summer, each decorated by a different artist or celebrity.

    80 Photos

    Lions of Bath 2010

    A giant pride of 100 individually decorated, life-size lion sculptures took up residence in Bath, I just had to go!

    136 Photos

    Rhinos in Chester

    In the summer of 2010 Chester was in the grip of Rhino Mania! 62 rhinos created by the regions artists, along with 116 mini school rhinos, took up residence.

    103 Photos

Step 3 – Updating several hundred pictures in quite a number of posts and pages

  • Thankfully the way I displayed images within posts was fairly consistent using the thumbnail and linking to the fullscreen version. The only difference was whether they were floated to left or right.
  • Using search & replace within wp_posts I first changed [inspic= to [SinglePic not found] was replaced by ,100,,,left] – and that replaced all of the images floated to the left and I just had to repeat using right instead of left.
  • A quick search for “left,” “right,” and “fullscreen” found a couple of posts with images that did not conform to my usual incorporation of images, but these were easy enough to change by editing the post in the normal fashion.

Step 4 – Cleaning up

  • Deactivate myGallery and have a browse through the site to spot any images that are missing.
  • Delete myGallery tables and options.

Tech / WP

This site is now running on WP2.3, using the Sandbox theme (with my own CSS), with a number of excellent plugins – listed here using WP-PluginsUsed by Lester ‘GaMerZ’ Chan…
There are 39 plugins used: 34 active plugins and 5 inactive plugins.

Active Plugins

Akismet 3.1.5  Akismet 3.1.5
» Automattic (url)
Used by millions, Akismet is quite possibly the best way in the world to protect your blog from spam. It keeps your site protected even while you sleep. To get started: 1) Click the “Activate” link to the left of this description, 2) Sign up for an Akismet plan to get an API key, and 3) Go to your Akismet configuration page, and save your API key.

Chunk Urls for WordPress 2.0  Chunk Urls for WordPress 2.0
» whoo (url)
This plugin shorten urls in comments so that they won’t break your site.

Clean Archives Reloaded 3.2.0  Clean Archives Reloaded 3.2.0
» Viper007Bond (url)
A slick, Javascript-enhanced post archive list generator for WordPress 2.5+.

Cricket Moods 3.7.2  Cricket Moods 3.7.2
» Keith "kccricket" Constable (url)
Allows an author to add multiple mood tags and mood smilies to every post.

Custom Query String Reloaded 2.9  Custom Query String Reloaded 2.9
» Moshu (url)
Change the number of posts displayed when viewing different archive pages, including tags archives, based on WP’s own tag system. Originally by Matt Read – Updated for UTW tags by Andy Beard

Exec-PHP 4.9  Exec-PHP 4.9
» Sören Weber (url)
Executes <?php ?> code in your posts, pages and text widgets.

Flexi Pages Widget 1.6.10  Flexi Pages Widget 1.6.10
» Srini G (url)
A highly configurable WordPress sidebar widget to list pages and sub-pages. User friendly widget control comes with various options.

Genki Announcement 1.4  Genki Announcement 1.4
» Genkisan - i18n patched by Masayan (url)
Display an announcement on your blog

Geo Mashup 1.4.6  Geo Mashup 1.4.6
» Dylan Kuhn (url)
Save location for posts and pages, or even users and comments. Display these locations on Google maps. Make WordPress into your GeoCMS.

Get Recent Comments 2.0.6  Get Recent Comments 2.0.6
» Krischan Jodies (url)
Display the most recent comments or trackbacks with your own formatting in the sidebar. Visit Options/Recent Comments after activation of the plugin.

Google XML Sitemaps 3.2.6  Google XML Sitemaps 3.2.6
» Arne Brachhold (url)
This plugin will generate a special XML sitemap which will help search engines like Google, Yahoo, Bing and to better index your blog.

Guestbook Generator 0.8  Guestbook Generator 0.8
» Andrew dela Serna (url)
Generates a guestbook for Wordpress blogs. Once activated, click on Options > Guestbook Generator.

iMP Download 1.4.1  iMP Download 1.4.1
» Hardi P (url)
Download manager for wordpress user featuring download count, force download, quicktag, members only, widgets, etc. Integrated with search engine to find your downloads easily and pagination on download list.

Inline Google Maps 5.11  Inline Google Maps 5.11
» Avi Alkalay (url)
This plugin shows google maps anywhere on blogpage. Just add a permalink of google map to any text (with images) in a page, set title=”googlemap” and you’re done. Also works with complex multimarker maps and KML-based maps.

Jetpack by 3.7  Jetpack by 3.7
» Automattic (url)
Bring the power of the cloud to your self-hosted WordPress. Jetpack enables you to connect your blog to a account to use the powerful features normally only available to users.

Macro Expander 1.1  Macro Expander 1.1
» Matthijs Hollemans (url)
Replaces user-defined keywords in a blog post with the output from the corresponding user-defined PHP function.

NextGEN Gallery 1.9.2  NextGEN Gallery 1.9.2
» Alex Rabe (url)
A NextGENeration Photo Gallery for WordPress

No Self Pings 0.2  No Self Pings 0.2
» Michael D. Adams (url)
Keeps WordPress from sending pings to your own site.

Pagebar2 2.59.1  Pagebar2 2.59.1
» Lutz Schröer (url)
Adds an advanced page navigation to Wordpress.

Page Links To 2.6  Page Links To 2.6
» Mark Jaquith (url)
Allows you to point WordPress pages or posts to a URL of your choosing. Good for setting up navigational links to non-WP sections of your site or to off-site resources.

Redirection 2.2.10  Redirection 2.2.10
» John Godley (url)
Manage all your 301 redirects and monitor 404 errors

SCF2 Contact Form 0.8.5  SCF2 Contact Form 0.8.5
» Andrew Ozz (url)
A contact form plugin that stores all messages locally, lets the blog admins to reply from the admin page and can send emails to multiple users. Uses the WordPress comments routine for filtering the spam, including Akismet and Bad Behavior (if installed).

Search Unleashed 1.0.6  Search Unleashed 1.0.6
» John Godley (url)
Advanced search engine that provides full text searching across posts, pages, comments, titles, and URLs. Searches take into account any data added by other plugins, and all search results are contextually highlighted. You can also highlight incoming searches from popular search engines.

Shutter Reloaded 2.4.1  Shutter Reloaded 2.4.1
» Andrew Ozz (url)
Darkens the current page and displays an image on top like Lightbox, Thickbox, etc. However this script is a lot smaller and faster.

Simple Tags 2.2  Simple Tags 2.2
» Amaury BALMER (url)
Extended Tagging for WordPress 3.1 : Suggested Tags, Mass edit tags, Auto-tags, Autocompletion, Related Posts etc. NOW Compatible custom post type and custom taxonomy !

Simple Trackback Validation 2.1  Simple Trackback Validation 2.1
» Michael Woehrer (url)
Eliminates spam trackbacks by (1) checking if the IP address of the trackback sender is equal to the IP address of the webserver the trackback URL is referring to and (2) by retrieving the web page located at the URL used in the trackback and checking if the page contains a link to your blog.

Skin Tags 0.8  Skin Tags 0.8
» Billy Halsey (url)
Removes the non-breaking space from the wp_tag_cloud() output generated by WP 2.3+.

Subscribe To Comments 2.1.2  Subscribe To Comments 2.1.2
» Mark Jaquith (url)
Allows readers to receive notifications of new comments that are posted to an entry. Based on version 1 from Scriptygoddess

WordPress Database Backup 2.2.3  WordPress Database Backup 2.2.3
» Austin Matzko (url)
On-demand backup of your WordPress database. Navigate to Tools → Backup to get started.

WP-phpMyAdmin 2.10.3  WP-phpMyAdmin 2.10.3
» Roland Rust, Christopher Hwang (url)
Provides phpMyAdmin from the WordPress admin console

WP-PluginsUsed 1.50  WP-PluginsUsed 1.50
» Lester 'GaMerZ' Chan (url)
Display WordPress plugins that you currently have (both active and inactive) onto a post/page.

WP-RelativeDate 1.50  WP-RelativeDate 1.50
» Lester 'GaMerZ' Chan (url)
Displays relative date alongside with your post/comments actual date. Like ‘Today’, ‘Yesterday’, ‘2 Days Ago’, ‘2 Weeks Ago’, ‘2 ‘Seconds Ago’, ‘2 Minutes Ago’, ‘2 Hours Ago’.

WP Captcha Free 0.9  WP Captcha Free 0.9
» iDope (url)
Block comment spam without captcha.

WP PTViewer 2.0.2  WP PTViewer 2.0.2
» MarvinLabs (url)
A plugin that allows you to easily insert dynamic panoramic pictures inside your posts using ptviewer. You can visit the options page and the help page.

Inactive Plugins

Hello Dolly 1.6  Hello Dolly 1.6
» Matt Mullenweg (url)
This is not just a plugin, it symbolizes the hope and enthusiasm of an entire generation summed up in two words sung most famously by Louis Armstrong: Hello, Dolly. When activated you will randomly see a lyric from Hello, Dolly in the upper right of your admin screen on every page.

Less 1.1  Less 1.1
» Bennett McElwee (url)
Change the (more…) link so it displays the entire post, not just the part after the “more”.

Maintenance Mode 5.4  Maintenance Mode 5.4
» Michael Wöhrer (url)
Adds a splash page to your blog that lets visitors know your blog is down for maintenance. Logged in administrators get full access to the blog including the front-end. Navigate to Settings → Maintenance Mode to get started.

Organize Series 2.4  Organize Series 2.4
» Darren Ethier (url)
This plugin adds a number of features to wordpress that enable you to easily write and organize a series of posts and display the series dynamically in your blog. You can associate “icons” or “logos” with the various series. This version of Organize Series Plugin requires at least WordPress 3.3 and PHP 5.2+ to work. Stats 1.8.5 Stats 1.8.5
» Automattic (url)
Future upgrades to Stats will only be available in Jetpack.

The weather

How could any blog by an englishman not include the weather? Well, up until now I have been trying to figure out how to ensure that I could quickly and easily record the weather, and perhaps explain a little bit more about my travels.

Using Cricket Moods (I was so excited by the name when I spotted it buried in the depths of a plugin list – I so hoped it has something to do with cricket!) and adapted with a set of weather icons I can now include an update about the weather at the end of each post.

SunnyCloudySun & CloudOvercastRainSun & RainStormySun & StormsSleatSun & SleatHailSun & HailSnowSun & SnowThunder StormsSun & Thunder StormsWindyColdIgloo

So today I have been mostly painting, and if you had not already guessed it, procrastinating over painting by updating something here. It has been mostly overcast and raining all day, check out the icons at the end of the post…

Incomplete Panoramas – Chinese Pagola

I think I have cracked making 360 degree panoramas, but I found that Autostitch can make some pretty good pictures which aren’t full panoramas. But how to display them when they can be quite sizable images…

Using Zoomify I have found this is the perfect tool to allow the image to be scrolled around and zoomed. Because it slices the original image and only loads the pieces when required it means some of the pictures can be quite large with good detail.

No more Zoomify, WP PTViewer has come to my rescue for both complete and incomplete panoramas!

Continue reading


I have always liked panoramic pictures, but until now I have found them very frustrating. I have dabbled with iPix, have tried to use various camera software and even tried to understand some of the stuff made available online.

My newest, and at the moment favouritest toys are Autostitch, and to get the images easily only this blog, IImage Panorama WP PTViewer. I would highly recommend both.

After a couple of practices I think I am now ready to post a couple of test panoramas…

Pages: < 1 2 3 >