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.
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….
SQL JOINs? Go read the article from the source (Visual Representation of SQL Joins) and it’ll make even more sense.
On a CentOS 6.x linux box, typing the following will show the MySQL version
or if not the root user, then
mysql -u root -p -v
(Which says user the root user, prompt for the password, then get the version).
Act! (now owned by Swiftpage) will have an updated emarketing platform builtin to the next release of Act! 16.1. I know many who will be eager to test this out.
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.
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.
I’m needing to do a sql query to show just the opportunities from the current month, the sql snippet for the WHERE clause to do this is the following:
WHERE MONTH(opportunities.date_closed) = MONTH(NOW()) and YEAR(opportunities.date_closed) = Year(now())
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"
INNER JOIN `tracker` ON
`users`.`id` = `tracker`.`user_id`
WHERE `tracker`.`deleted` = 0
ORDER BY `tracker`.`date_modified` DESC
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…
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.