SQL JOINs? Go read the article from the source (Visual Representation of SQL Joins) and it’ll make even more sense.
The Perfect Web Development Environment for Your New Mac. Great set of instructions, worked for me.
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.
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.
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'
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
On Mac OSX (Mavericks) you can find your ‘iCloud’ documents in the relevant application folder like this:
Each application keeps its own documents in a sandboxed folder.
You can make an alias for a file and then move that to an appropriate folder, for example, I’m using Byword on the Mac, iPad and iPhone, thus I want my ‘List.md’ file kept in iCloud. Putting an alias to it on the desktop makes it easy to edit on the Mac. Using GeekTool I can have it automagically display the contents of ‘List.md’ on the desktop, essentially a ‘live’ file no matter where I edit it, even from iDevices.
This is how to use Talend to concatenate multiple columns (fields) into one field neatly.
Say we have three fields, row1.field1, row1.field2, row1.field3 that we want to insert into a output.notes column.
In the tMap component, use the following expression:
(StringHandling.LEN(row1.field1) > 0 ? "Field 1: "+row1.field1+" " : "")+(StringHandling.LEN(row1.field2) > 0 ? "Field 2 "+row1.field2+" " : "" )+(StringHandling.LEN(row1.field3) > 0 ? "Field 3 Address: "+row1.Address+", "+row1.Suburb+", "+row1.State+", "+row1.Pcode+" " : "")
What this does is check to see if field1 has anything in it (i.e. has a length longer than 0), if it does, it adds the field and a space after it to buffer it against the next field. If it doesn’t, then it doesn’t insert anything. It then does the same for fields 2 and 3.
Updated 2014-01-30 12h49m to put the code in a html code block and fix the double quotes which had been ‘smartly’ but wrongly changed.