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. Continue reading “How to unpivot in Excel”
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. Continue reading “APM”
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 SPARQL endpoint, and LH-RDF implements a series of alternative RDF schemas. LH-RDF has been deactivated at the moment, but the SPARQL query screen is here; it uses the default rdf feed as a source.
I have errors occurring when using LH-RDF; see the comments to track. Jan 2017
I was looking to calculate if someone was under 27 years old; this can Be quite tricky but excel has just the function, =DATEDIF(). Continue reading “Date Differences in Excel”
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 it to DNS, and then send them myself. Sounds like a job for AWS. Continue reading “My little mail server”
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 this problem by generating three html files, a feed, a source key and an output format key and then including them in the host page. Continue reading “Planet, mingle & wordpress”
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 github, in a repo called ello2rss. Continue reading “JSON to XML”
I finally got a git account. Most people, more recently seem to be there and the download interface is now much easier than sourceforge. Continue reading “git & github”
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. Continue reading “WAMP”
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 it. Continue reading “More wordpress voting plugins”
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 Creating Your Own Maps. A couple of these look very interesting. UMapper and HeatMaps look rather fun. I have also experimented with Tableau Software’s public aka community release. Continue reading “About Maps and Data”
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.
Yes, me. Since version 1.3.4
Params: Anvanced tab: nothing basically. Connection type – auto. UNCHECK “Use Single Sign-On” (!) Otherwise it’ll use your Windows Domain credentials with Reuters network, which is rather incorrect.
(Username is basically derived from the login name by replacing @ to dot and then adding @reuters.net)
Don’t forget that you may have unique password in Reuters network, not the same as your PC/Domain password.
They both tightened up on their SSL management , this page refers.
…..there have been considerable changes to the SSL handling in the NSS module. One part of them seems to be that the default for SSL cipher suites now follows the recommendation to disable known unsecure suites, e.g. that use RC4.
You can change the settings with Tools -> Plugins -> NSS Preferences. On my company account, which is a OCS2007 installation, I needed to enable at least TLS_RSA_WITH_RC4_128_SHA or TLS_RSA_WITH_RC4_128_MD5 before SSL connections went through again.
However, don’t forget to keep your SIPE libraries up to date!
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. Continue reading “Using EXIF on my home IT”