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.
Specify in Kettle that input files exported as "Windows (ANSI)" (the default on Windows) are opened as file encoding CP-1252.
Converting vertical tabs¶
var Activities; Activities = replace(Activities,'\v', '\x01');
Note that sometimes I'll want to convert them to newlines instead.