Exporting Filemaker for CiviCRM¶

Filemaker data is obviously a lot less uniform than data from another CRM, but I'm documenting some tips and tricks here.

File encoding¶

Specify in Kettle that input files exported as "Windows (ANSI)" (the default on Windows) are opened as file encoding CP-1252.

Converting vertical tabs¶

Here's a Javascript snippet I use in Kettle to convert them to separation characters:

var Activities;

Activities = replace(Activities,'\v', '\x01');

Note that sometimes I'll want to convert them to newlines instead.