Exporting Filemaker for CiviCRM » History » Version 2
Jon Goldberg, 03/20/2016 02:17 AM
| 1 | 1 | Jon Goldberg | h1. Exporting Filemaker for CiviCRM |
|---|---|---|---|
| 2 | |||
| 3 | Filemaker data is obviously a lot less uniform than data from another CRM, but I'm documenting some tips and tricks here. |
||
| 4 | |||
| 5 | 2 | Jon Goldberg | h3. File encoding |
| 6 | |||
| 7 | Specify in Kettle that input files exported as "Windows (ANSI)" (the default on Windows) are opened as file encoding CP-1252. |
||
| 8 | |||
| 9 | h3. Converting vertical tabs |
||
| 10 | |||
| 11 | Here's a Javascript snippet I use in Kettle to convert them to separation characters: |
||
| 12 | |||
| 13 | <pre> |
||
| 14 | var Activities; |
||
| 15 | |||
| 16 | Activities = replace(Activities,'\v', '\x01'); |
||
| 17 | </pre> |
||
| 18 | |||
| 19 | Note that sometimes I'll want to convert them to newlines instead. |