PT Commons

{{lastupdated_at}} by {{lastupdated_by}}

h1. 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.

h3. File encoding

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

h3. Converting vertical tabs

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

<pre>

var Activities;

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

</pre>

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