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.
[The four horsemen of mediocrity](http://sethgodin.typepad.com/seths_blog/2014/01/the-four-horsemen-of-mediocrity.html)
Find duplicate records in SugarCRM version 6.5 and version 7.1.
I’m using GeekTool to display some key time zones on my wallpaper, which happens to include world map.
The key to this is to add Shell Geeklets using a command similar to this:
env TZ=Pacific/Auckland date +'%l:%M %p %A'
Use the appropriate timezone code and the date string formatting codes to display the time and date the way you want.
I was just sent a link to this (source). Funny :).
Simple test to see if a field is null. I’m using this in Talend to determine if I copy the value into a new note field. You could use a length test, but if the field is a date, then you need to do it this way.
row1.field1 != null ? do_this_if_true : do_this_if_false