Kiva Export analysis spreadsheet

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

    no images were found

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 We cannot display this gallery 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 40 plugins used: 35 active plugins and 5 inactive plugins.

Active Plugins

Akismet Anti-Spam 4.0.2  Akismet Anti-Spam 4.0.2
» 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: activate the Akismet plugin and then go to your Akismet Settings page to set up your API key.

Better Search Replace 1.3.2  Better Search Replace 1.3.2
» Delicious Brains (url)
A small plugin for running a search/replace on your WordPress database.

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.7.3  Flexi Pages Widget 1.7.3
» 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.1  Genki Announcement 1.4.1
» Genkisan (url)
Display an announcement on your blog

Geo Mashup 1.10.2  Geo Mashup 1.10.2
» Dylan Kuhn (url)
Save location for posts and pages, or even users and comments. Display these locations on Google, Leaflet, and OSM 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 4.0.9  Google XML Sitemaps 4.0.9
» Arne Brachhold (url)
This plugin improves SEO using sitemaps for best indexation by search engines like Google, Bing, Yahoo and others.

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 5.8.1  Jetpack by 5.8.1
» 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 2.2.33  NextGEN Gallery 2.2.33
» Imagely (url)
The most popular gallery plugin for WordPress and one of the most popular plugins of all time with over 18 million downloads.

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

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

Page Links To 2.9.9  Page Links To 2.9.9
» 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 3.1.1  Redirection 3.1.1
» 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.5  Shutter Reloaded 2.5
» 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.4.7  Simple Tags 2.4.7
» Amaury BALMER (url)
Extended Tagging for WordPress : Terms suggestion, Mass Edit Terms, Auto link Terms, Ajax Autocompletion, Click Terms, Advanced manage terms, etc.

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.3  Subscribe To Comments 2.3
» Mark Jaquith (url)
Allows readers to choose to receive notifications of new comments that are posted to an entry.

WordPress Database Backup 2.3.3  WordPress Database Backup 2.3.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.51  WP-RelativeDate 1.51
» 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.5.7  Organize Series 2.5.7
» 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.4+ and PHP 5.2+ to work. Stats 1.8.6 Stats 1.8.6
» 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 >