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.