Exporting Filemaker for CiviCRM » History » Revision 2
Revision 1 (Jon Goldberg, 03/19/2016 10:26 PM) → Revision 2/3 (Jon Goldberg, 03/20/2016 02:17 AM)
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 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. * Vertical tab conversion: FIXMEGo to top