CSV File Formatting

Currently, EverTrue only accepts CSV (comma-separated values) files. Tab or pipe delimited files are not accepted. 

File Formats

• File must be CSV (comma-separated values)
  • See Comma Separated Values
  • We adopt the RFC 4180 standard
    • Fields containing line breaks, double quotes, and commas should be enclosed in double-quotes. 
    • If double-quotes are used to enclose fields, then a double-quote appearing inside a field must be escaped by preceding it with another double quote. 
• File must use CRLF or LF newline EOL markers (unix standard or MS-DOS)
• File must be UTF8 encoded.
  • Encoding a file is different for every database.  For most databases, it is possible to set the encoding of your file when you are exporting. It can be selected as a setting, along with the file type.  In other instances, this may require additional programming to set the encoding or manual tweaking after the fact.  Unfortunately, there are a few databases that do not allow this type of encoding, but most of the time it can be done post-export.
• File can be compressed when using SFTP.  We support zip or gzip compression (.zip or .gz), and recommend compressing all files before uploading.