The need to unpivot data is a common requirement. There are a number of reasons as to why. I and my customers are primarily using Excel on Windows and so the examples below are shown in excel and rely on excel functionality.
Read more
APM
Seems like the Applications Performance Monitoring landscape has changed since last time I looked, here’s some links, including a route to the Gartner Report.
Read more
Web Site Testing with MaxQ
MAXQ is a web proxy with recording and replay features. It is designed to capture and replay tests. They are quite keen that one understands the terms of use of target sites since many prohibit automated access and these days it would seem defend themselves against it. This article documents how to run MaxQ and…
Read more
SPARQL on WordPress
For various reasons I needed to look at SPARQL again. What’s the easiest way to put it up?, Here! I’ve been working with LH-Tools which is commented on at its authors site, and LH-RDF. I did not get this to finish satisfactorily, mainly based on my lack of SPARQL skills. May 2015 LH-Tools implements a…
Read more
Date Differences in Excel
I was looking to calculate if someone was under 27 years old; this can Be quite tricky but excel has just the function, =DATEDIF().
Read more
Disqus and Ghostery
Disqus needs to be whitelisted in Ghostery for it to work properly. (I have white listed the site rather than approved the specific cookies/trackers). It can stop you performing the login.
Read more
My little mail server
What a pile of poo! I have access to four smtp servers and they all have limits on the distribution list size! (They are all about the same size of 100). Google will allow 2000 per list but only if you use one of their clients. Let’s try and bring up an SMTP server, connect…
Read more
Planet, mingle & wordpress
While developing the new web site, I had a look at how my mingle was organised. The current regime has a conversion rules file for each output format and one for HTML. I need to incorporate the HTML output in a wordpress page and also apply the wordpress style rules to the HTML. I solved…
Read more
JSON to XML
In order to export the ello.co feed, I need to convert the JSON to XML. This isn’t the first time I have needed to look at this sort of problem and so I have created a page to hold my notes. I have put these things together in a python script, and posted it to…
Read more
WAMP
I needed to install WAMP on my PC, to support some Amazon developments; I needed a screen interface to my database. Here are some notes and links. I talk about installation, and port conflicts. I might expand the install notes to include advice on mysql security.
Read more
More wordpress voting plugins
I have been using Vote it up on my blog for a couple of years, although no-one else has, I think I received one vote that wasn’t me and they also commented. I noticed during the Autumn of 2014 that it seemed a bit broken. So I had a little look and decided to replace…
Read more
About Maps and Data
This is an omnibus article on data visualisation using maps. I went back to map visualisation solution in the autumn of 2014. This maps tag retrieves the the articles on this wiki. My current interests is in web hosted maps visualisations and thus in wordpress. I have also found this article, 10 Free Tools For…
Read more
Pidgin & TRM Runes
While trying to configure pidgin to act as a console for TRM once known as Reuters’ Messenger, I came across this page at their sourceforge site which documents the magic runes, critically the User Name.
Read more
Bags of Words
We have been looking at Text Mining, which takes me to the concept of Bag of Words & Carrot2.
Read more
Using EXIF on my home IT
I need to write a script that installs author and copyright facts into my pictures. The EXIF libraries are what I need. I’ll also need a scripting language; I used cygwin bash as my prototyping environment.
Read more