Project

General

Profile

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: FIXME
Go to top