Updated almost 8 years ago by Jon Goldberg

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.

Updated by Jon Goldberg almost 8 years ago · 3 revisions

Also available in: PDF HTML TXT

Go to top