When preparing a comma-separated values (CSV) file for import into SAP Emarsys, it's essential to adhere to specific formatting guidelines to ensure data integrity and successful import processes.
B. Always use a period as the decimal separator.For numerical data, especially floating-point numbers, SAP Emarsys mandates the use of a period (.) as the decimal separator, regardless of regional or locale-specific conventions that might use a comma (,). This standardization ensures consistent data interpretation across different systems and regions.
D. Imported files must have a newline control character in the first 265 KB.To prevent the accidental upload of binary files and to ensure proper file processing, SAP Emarsys requires that imported CSV files contain a newline control character within the first 265 kilobytes (KB) of the file. This requirement helps the system recognize and validate the file format before processing the entire content. help.emarsys.com
Incorrect Options:
A. UTF-8 4 byte characters are allowed.This statement is incorrect. SAP Emarsys supports UTF-8 encoding for CSV files; however, it does not allow UTF-8 4-byte characters, such as emojis. Including such characters can prevent the successful import of files. help.emarsys.com+5help.emarsys.com+5help.emarsys.com+5
C. Values are not case sensitive.This statement is also incorrect. In SAP Emarsys, values within CSV files are case sensitive. For example, the email addresses "example@address.com" and "EXample@address.com" would be treated as distinct entries. help.emarsys.com
Adhering to these guidelines is crucial for the accurate and efficient import of data into SAP Emarsys, ensuring that your marketing campaigns and data analyses are based on reliable information.