When importing contacts from CSV data, you may want to import more than one email into a contact. The default SugarCRM CE supports the import of two email addresses: a primary email address and one tertiary email address. More can be added manually later. The primary email address is imported from column “Email Address” and [...]
Convert GoToMeeting video files to another format
Video files downloaded from GoToMeeting, GoToWebinar or similar services use a special codec in order to play them. On the plus side, the videos are well compressed and optimised for this kind of use, but on the downside, the codec is not a “standard Windows” codec that can be used by other players such as [...]
Recovering Windows Password – Sticky Keys Technique
The “sticky keys” technique for resetting the password on a Windows system is described in many places around the web, but all tend to over-complicate the steps. I’m describing it here for my own reference, so I have a reminder of how it works. The technique basically provides access to a command prompt from the [...]
New WooCommerce site now live
The www.relaxtimeout.com website was launched over Christmas. It is my first foray into WooCommerce, the free WordPress e-commerce plugin from WooThemes. Although this free shop is designed to hook you into purchasing themes and plugins, it really is a complete product just as it is, and functions well out of the box. I wanted to [...]
Kinamu Reporter – set datatypes for exporting
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 [...]
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 [...]
Follow @judge99 on Twitter
