Alert: Exports Excluded

Issue

The following alert appears during a sync:

Exports Excluded

Environment

Connector: Anaplan

Resolution

To resolve this issue, do the following:

1. Open the export file in a plain text editor, without applying the .csv extension.
2. Locate and remove any newline characters within the export contents.
3. Save the file and re-run the sync.

Cause

This issue occurs when newline characters are present in the export contents. These characters cause a schema mismatch and deserialization errors. To prevent hidden data discrepancies, we don't alter or skip individual rows. Instead, we exclude the affected export and display the above alert.