Category Archives: General
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 […]
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
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 […]
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.
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 […]
Use powercfg to set Windows power states from a script or command line.
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
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.
Testing 1, 2, 3 Nothing to see, move along.
ACROSS THE SKY – a world record slackline in the utah desert from Camp 4 Collective on Vimeo.
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.