Flickr/Yahoo! UX Failure

A long time ago I had a Flickr account. Then things changed and I no longer used, a lot of time has passed. But today, I decided, I could use a Flickr account.

So I go to Flickr, go to create an account. It directs me to Yahoo as you need a Yahoo account to do Flickr it seems. I create a Yahoo account. I’m redirect back to Flickr and asked to sign up.

I bailed.

This is bad UX. Needing an account with one service so you can create an account at another service is bonkers. I thought I was going to use the newly minted Yahoo details to login to the new and improved, revamped, worthy of my attention Flickr. But no.

Somewhere, there is at least one engineer silently weeping, perhaps more than one.

Elsewhere some manager is thinking they’ve made the world a better place.

One of them knows the truth.

Here is the truth: Make it easy for your users/community/tribe to love you. Else you lose them.

PS. Then I had to google how to delete a yahoo account.

Smart Folder – Flagged or Unread in Outlook for macOS

Just had to setup MS Outlook 2016 on a Mac, and wanted a smart folder (aka saved search) that shows only emails that are either unread or flagged.

To do this, click into the search box in top right of the Outlook window. The search toolbar will appear, select Advanced.

The raw query to use is:

(com_microsoft_outlook_flagged = 1) || (com_microsoft_outlook_unread!=0)

Then save the search.


Review: Atomic Habits

I’ve bought the book Atomic Habits and written a short review of it.

Atomic Habits: An Easy & Proven Way to Build Good Habits & Break Bad OnesAtomic Habits: An Easy & Proven Way to Build Good Habits & Break Bad Ones by James Clear

For me, there have been two items in “Atomic Habits” that have immediately made a difference in my life.

The first is in Chapter 6, under the heading “The Context Is The Cue”, the understanding and the realisations following my reading that our habits can be associated not with just one single ‘trigger’ but with the ‘context’ that surrounds a behaviour, have changed my day to day actions.

The second is in Chapter 7, on how ‘disciplined’ people structure their lives in such a way that they do not require huge amounts of willpower and self-control; has caused me to change a number of small things, and this has made a large impact for me.

Implementing these two things into my life have not required any ‘rocket science’ on my part, just some simple changes. Those simple changes have made an immediate, positive difference in my life.

James explanation of these two things, the examples he uses, have made sense of why, in the past, some habits have stuck for me, why others haven’t, and why certain habits I’ve tried to change or remove haven’t changed or been removed.

Thanks James!

PS. rest of the book is great, but those two things are what made the difference for me.

See my goodreads profile/review.

Concatenate Fields via ODBC Query

Today I wanted to concatenate some fields with some text. We are pulling some data from MYOB for import against a client record in SugarCRM and want to tidy it up as we go.

however, using concat didn’t work.

Thus this Stackoverflow answer came to the rescue with using {fn concat('some text', 'with more text')}

I’ve then nested it a little as this function only takes two arguments.

  {fn concat (TermsOfPayment.Description,  
    {fn concat (' (',  
      {fn concat (Terms.BalanceDueDays, ' days)')}  
  )} as TradingTerms  
  join Terms on Terms.TermsID = Customers.TermsID join  
  TermsOfPayment on TermsOfPayment.TermsOfPaymentID = Terms.TermsOfPaymentID;

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:


Basically grabs the Day, then the Month, then the Year from the column, then converts it to a serial number that Excel recognises as a date. Then format this to display however you want it to.

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

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 to 600.

chmod 600 ~/.ssh/privatekeyfile.pem

Then you can ssh to the server from the command line using:

ssh -i ~/.ssh/privatekeyfile.pem.pem root@fqdn -p 22

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 screen.

I was talking with the folks over at MobileZap, who said I should try out a Olixar Universal Bike Phone Mount on the bike. So for the last month I’ve been quite happily riding around, able to see the screen with an easy glance. An added side benefit is that when I’ve received a phone call, I can see who it is and decide if I’ll pull over and talk or not. Previously I’d just ignore all phone calls whilst riding.

photo of the Olixar bike phone mount

The holder itself I thought looked a bit flimsy, however it has held up really well while I’ve ridden through both really hot days (34°C) and heavy rain.

After placing the phone between the two grippy holders, simply squeeze them together and the phone is securely held. I’m using an iPhone 6 in an Otterbox Defender case and it accommodates the larger case quite well. There is a small fold-out piece at the bottom if you’re worried about it falling out the bottom, but I’ve found I don’t need it, the phone doesn’t slip or move while in the holder at all.

To release the phone, there is a small button on the lower right hand side, pressing it causes the two holders to release their grip. Although I was concerned initially that it wouldn’t hold my phone securely, it turns out that it does hold it really well, I’m now quite confident that the phone won’t come loose and fall out while I’m riding.

If you’re looking for a phone holder to fit to your road bike, I can happily recommend this one.

Thanks to MobileZap for providing this product for me to test out.

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