Ben Hamilton

Category Archives: General

Excel DATEVALUE Function

When a Microsoft Excel spread sheet has a column of date data in this format: Nov 24 1995 Then the Excel function you’ll find useful is DATEVALUE DATEVALUE function. This formula here: =DATEVALUE((TRIM(MID(R2,5,2))&”-“&TRIM(LEFT(R2,3))&”-“&TRIM(RIGHT(R2,4))) Basically grabs the Day, then the Month, then the Year from the column, then converts it to a serial number that Excel […]

| Tagged | Comments Off on Excel DATEVALUE Function

Find JIRA Issues with Attachments

When you just know you’ve attached a file to a JIRA issue, but can’t find it, this is the search to do in Issues in JIRA Replace PKEY with your project key.: project = PKEY AND type != Epic and attachments is not EMPTY ORDER BY Status ASC

| Tagged | Comments Off on Find JIRA Issues with Attachments

SSH and Private Key usage on Mac OS X

It’s very important that your private keys are kept secure and away from prying eyes. A good place to keep your private keys is in the folder ~/.ssh as this makes it easier to manage (this is a subfolder of your home folder). You then want to set the permissions of the private key file […]

| Tagged | Comments Off on SSH and Private Key usage on Mac OS X

Tufte WP Theme

I’m currently testing This is a test side note. (as at Thursday 19 May 2016) a WordPress theme Naturaily/tufte-wp-theme that uses the CSS from edwardtufte/tufte-css. You can read more about it This is a second test side note. from Dave Liepmann.

| Comments Off on Tufte WP Theme

Olixar Universal Bike Phone Mount

I commute to work every day on my motorcycle, it’s a 52 kilometre trip each way. Wearing my headphones, Waze lets me know of any accidents or hazards ahead but because the phone is in my jacket pocket, I only hear such warnings, I don’t see them. It would be nice to see the Waze […]

Also posted in Hardware | | Tagged , , , , | Comments Off on Olixar Universal Bike Phone Mount

Set Windows power states from the command line

Use powercfg to set Windows power states from a script or command line.

| Tagged , | Comments Off on Set Windows power states from the command line

Location of the SugarCRM log file

By default it’s in the same base folder as the SugarCRM application files. But on occasion we’ll move it. Quickly find it’s location by looking in the config.php file. The two relevant lines are: ‘log_dir’ => ‘/var/log/sugarcrm/’, ‘log_file’ => ‘sugarcrm.log’, If you’re at the command line, then this makes it easy: grep ‘log_dir’ config.php

| Tagged , , | Comments Off on Location of the SugarCRM log file

Find a file on a linux server

From the command line find / -name ‘index.html’ 2>/dev/null This will find and display all occurances of index.html and all the errors will not display.

| Tagged | Comments Off on Find a file on a linux server

Testing 1, 2, 3

Testing 1, 2, 3 Nothing to see, move along.

| Tagged | Comments Off on Testing 1, 2, 3

Offtopic: Slackline World Record

ACROSS THE SKY – a world record slackline in the utah desert from Camp 4 Collective on Vimeo. 

| Tagged , | Comments Off on Offtopic: Slackline World Record

The Expert

The Expert is a short youtube clip that illustrates what being billed as the “the expert” can feel like sometimes. Fortunately it’s not a common occurrence.

| Tagged , | Comments Off on The Expert

synergy has been updated

Synergy has just been updated. It is a free and open source software for sharing one mouse and keyboard between multiple computers. Works on Windows, Mac OS X, Linux, Android and Apple iOS.

| Tagged , | Comments Off on synergy has been updated

The Mac Malware Guide

The Mac Malware Guide.

| Tagged , , , | Comments Off on The Mac Malware Guide

Emergency + is a smartphone app for Australian emergencies

In Australia we dial 000 for emergency services. This smartphone app (iOS and Android) shares your location with emergency services as well. Get it here: Emergency +.

Also posted in How to | | Tagged , | Comments Off on Emergency + is a smartphone app for Australian emergencies

Full stack startups

Good insight. Full stack startups.

| Tagged , | Comments Off on Full stack startups

MkDocs

MkDocs is a fast, simple and downright gorgeous static site generator that’s geared towards building project documentation. Documentation source files are written in Markdown, and configured with a single YAML configuration file.

| Tagged , | Comments Off on MkDocs

Everything Bill knows about business in one minute

“Everything I know about business in one minute.” – Bill Drenttel. Via John Gruber.

| Tagged , , , | Comments Off on Everything Bill knows about business in one minute

Backup WordPress to Dropbox

Backup your WordPress site to a Dropbox folder.

| Tagged , , | Comments Off on Backup WordPress to Dropbox

Australian Privacy Law Reform Changes

There are changes to the Australian Privacy Laws. Details here: www.oaic.gov.au. This does raise some questions around where you’re hosting data. If you’re using the ‘cloud’ (Google Drive/Apps, hosted CRM, Virtual Servers etc) then you may want to read up and make sure you’re not setting yourself up for a problem.

| Tagged , , , , , | Comments Off on Australian Privacy Law Reform Changes

Digital email signatures

Get a digital email signature from Comodo. …digitally signing allows them to confirm you as the sender and verify the message was not tampered with en route…

| Tagged , , , , , | Comments Off on Digital email signatures