Author Archives: Ben Hamiltonfdsdfsdf
At the MySQL commandline, you can enter show processlist; and see what processes are running. If you’re tracking down some problematic code and you’ve got a query (or set of queries) that don’t end, consume CPU cycles and generally bog everything down to a crawl, it can be helpful to know what time you’ve run […]
I use Day One to journal. There is a service that creates a new Day One entry from the selection, but it didn’t have a hotkey associated with it. So I’ve set one up. First (optional) step is to use to make your CAPS LOCK key useful. Big thanks to Brett Terpstra for that, I […]
I just needed to compress and encrypt some files on Mac OS X. The following command does that: zip -ejr TARGET SOURCEFOLDER This will ask for a password (twice to confirm it), encrypt and compress the sourcefolder and put it into a file named target (and auto add the .zip extension). To unzip it do […]
This is a time limited deal, if you go to Cloudatcost.com and sign up, use the coupon code ‘benhamilton’ to get 20% off your order. I have a VPS hosted with Cloudatcost myself and I know a few others that do as well, so I can vouch for their service.
This article here describes how to get Hazel to run rules in sub folders, very handy. I’m using this to move any screenshots taken on the iPhone out of the photo folder into a separate folder.
Advanced Bash-Scripting Guide. The name says it all.
Here’s how to enable a checkbox to be updated enmasse. First create a new extvardef.php file containing the following: Then put that file into at the following location /var/www/html/custom/Extension/modules/Module_Name/Ext/Vardefs/ Of course, you’d want to check any existing files in the folder to make sure none of them already deal with that field.
From the linux command line, these commands let you backup and restore a SugarCRM database. Update 2016-04-26: Just saw this SugarCRM KB Providing a Backup Without Sensitive Data which is really useful. Thanks Jared. Firstly, for a proper back up of SugarCRM you’ll need two ﬁles, one containing the application ﬁles, one containing the SQL database. […]
For when you’re trying to explain what the load average figure means (which you get from running either top or w from the linux command line) this link will help explain it easily. Easier than spending 10 minutes talking about it.
I wrote up how I’m numbering tasks in OmniFocus, but I’ve now modified the Keyboard Maestro recipe so it’s just a touch faster. Here’s a screenshot: I’ve also since created a separate recipe in Keyboard Maestro for each key Project I have in OmniFocus, each with it’s own .txt file that it refers to. This […]
I’m using OmniFocus 2 on my MacBook Pro and wanting to ‘number’ tasks because at the end of each week, I print a PDF of the tasks completed and outstanding for a particular client. Task numbers make it much easier for the client to reconcile the work I’ve done with the lists they use. The problem […]
Find duplicate contact records, by contact name, in SugarCRM using MySQL.
This snippet of MySQL code shows how to concatenate two fields into one column, also shows how to reverse the concatenation and order by last name then first name.
Working on a SugarCRM dashboard today, and I needed to count how many records had one value and how many records had a second value. I then wanted to know what percentage the first value was of the total. So there’s a bit of MySQL code that helps make this easy to do. SELECT SUM(IF(field_name = […]
I was needing to navigate to a file that was in a ‘hidden’ folder, but the File Open dialog box won’t show the hidden folder. The answer was found here: Press Command, Shift, Period keys together, the hidden folders/files will appear.
Great article over at A List Apart: Can Email Be Responsive. If you do HTML email newsletters, you should go read this.
Just discovered the srm command on *nix systems. srm will securely delete files, dependant on the switches you give it either one overwrite with random data, 7 passes, or 35 passes. Hat tip to practicallyefficient.com.
Just a quick post of some software that I use, that I’ve just discussed with Seth (he knows who he is). ClarifyIT – Create quick screenshot based documents and email them easily. Byword – Markdown text editor. OmniOutliner – Easiest outliner I’ve found. Nozbe – great GTD task manager. 1Password – simplify your password management. Timebar – focused working… :) […]
We all want to achieve. We want the truth, we want justice. But above all, we want our coffee. Coffee is the fuel that powers our quest for truth and justice. Let the world know that you are in pursuit of truth, justice and coffee by ordering your own tshirt by clicking here to order […]