Kinamu Reporter is a reporting tool for Sugar CRM. It supports basic reports and allows the data to be exported to Excel. The problem I was having was that some values stored in Sugar come out as numbers (integers). That was fine until the report was exported to Excel. Once Excel got the numbers, it […]
Author Archive | Jason Judge
Virgin Broadband MySQL Connection Proxy
This one had me scratching my head for a while. I was attempting to access a MySQL database through my home broadband service. The MySQL database had a control panel where remote IP addresses that can access it could be entered. My broadband IP address was there, but I still could not connect to the […]
Jasper Reports overview
Having scratched my head over how all the parts fit together in a new Jasper reporting system for SugarCRM, I finally came across this article: http://jasperforge.org/uploads/publish/ireportwebsite/IR%20Website/ir_getting_started.html The first couple of paragraphs explained what all the parts are, in a way that the deliverer of the system simply could not. Jasper Reports is the central report […]
git mv “permission denied”
Running git command line under Windows 7, I was finding that “git mv” to move a directory to a new location was not working. Some folders would move, and some would not, giving me this error instead: $ cd foo $ git mv my_folder new_parent_folder/ fatal: renaming ‘foo/my_folder’ failed: Permission denied I noticed that […]
MySQL – finding counts of data by columns
Okay, the title may not be clear, but this is basically what I was trying to do, and I present here the script that achieved it. During a data migration of a legacy Access database (actually, nine Access databases) to Sugar CRM, I wanted to be able to find any data that was missing. Looking […]
Hallowe’en Background Ambience Sounds
Since this was a last minute job for my daughter this Hallowe’en, there was no time to post this up then, so just consider it an early post for next year. I’m thinking of late 2011 already, and it’s not even Christmas yet. This MP3 is just a couple of minutes long, and contains a […]
Silencing a DES-1228P Switch
Well, not quite silencing, but they can be made a lot quieter. First a brief introduction. The D-Link DES-1228P network switch is D-Link’s attempt to get into the corporate world. I’ve never much liked D-Link equipment purely because of reliability issues, Netgear being my consumer choice. I gave this one a chance for a client […]