So you bought an Apple computer…

I know two people who have just bought themselves new Apple Mac computers, one a behemoth desktop, the other a 15″ MacBook Pro. Both have been immersed in “Windows World” and are essentially new to the Mac OS (one did have a Mac years ago).

So, where to start?

Here are my initial tips:

  • Be prepared for some frustration. It doesn’t work the way you’re used to. Yes, it’s change. It’s worth it, you’ll be more productive, I am.
  • The keyboard and the trackpad are your friend. More than you know. Learn the ‘gestures’. single tap on the trackpad is a left click, two finger tap on the trackpad is a right click.
  • Get in the habit of pressing the ‘Option’ key. You’ll suddenly find extra options.
  • Use COMMAND-SPACE to start Spotlight. Use Spotlight.
  • Use Google Chrome as your browser.
  • Working with words? do your drafts in ByWord. Power tip: learn Markdown.
  • Working with programming code? use TextWrangler.

That’s a start. I’m sure they’ll have more questions yet.

The five levels of delgation

I’ve been pointed to Michael Hyatt’s site which lists the five levels of delegation.

Level 1: Do exactly what I have asked you to do.
Level 2: Research the topic and report back
Level 3: Research the topic, outline the options and make a recommendation.
Level 4: Make a decision and then tell me what you did.
Level 5: Make whatever decision you think is best.

Interesting read. Now to apply it….

How to resolve a Talend Execution failed due to access is denied error

Have Talend Open Studio running on a Windows server, however, when we run a job, it gives an error similar to the below:

Execution failed : Failed to generate code.
[No .class file created for file org\talend\designer\codegen\translators\processing\TMapMainJava$1.class in C:/Talend/TOS_DI-Win32-r111943-V5.4.1/workspace/.JETEmitters/runtime because of an IOException: C:\Talend\TOS_DI-Win32-r111943-V5.4.1\workspace\.JETEmitters\runtime\org\talend\designer\codegen\translators\processing\TMapMainJava$1.class (Access is denied)

It turns out that the windows file permissions are not set correctly, by giving the Windows Users Full permissions to the file mentioned in the error message, the error resolves. Note that if this is the case there may be a number of files with the wrong permissions.

How to convert UTC time to current timezone in MySQL

Using SugarCRM (this client is using Enterprise 6.5.15) and we want the last two hundred items in the tracker table. The problem is that the `tracker`.`date_modified` field is in UTC time, not the local time zone, which is +10:00.

The solution is to use the CONVERT_TZ MySQL command, as shown in the example below. It will convert between timezones for you.

SELECT `users`.`user_name` AS "User",
`tracker`.`module_name` AS "Module",
`tracker`.`item_summary` AS "Summary",
`tracker`.`action` AS "Action",
CONVERT_TZ(`tracker`.`date_modified`,'+00:00','+10:00') AS "Modified"
FROM `users`
INNER JOIN `tracker` ON
`users`.`id` = `tracker`.`user_id`
WHERE `tracker`.`deleted` = 0
ORDER BY `tracker`.`date_modified` DESC

Remove thousand separator in Integers in SugarCRM

We want to record a ‘Year’ value on a record in SugarCRM, but we don’t have a day and month to do with it, you can’t use a field that is of a ‘date’ type as that requires a full date (year, month, day).

You can use an ‘Integer’ field type tho. The downside is that it displays a thousands separator. i.e. it’ll show 2,014 instead of 2014.

To fix this, tick the Disable Format check box in Studio. This will remove the thousand separator.

Screenshot 2014-02-05 13.05.04