We experience a bug when importing the resultant CSV file through Raiser's Edge import (we do this for event participants to match the constituent we imported through IOM). The leading ImportID column has special characters in front of it on the CSV side and does not automatically match up to the RE field called ImportID.

Blackbaud was able to reproduce this issue and told us a solution was for IOM to add a dummy column to the resulting CSV before ImportID since this bug only affects the first column in a UTF-8 file. This happens in RE 7.85, and it's uncertain whether this occurs in later versions.

Alternatively, the ImportID field could be appended to the end of the resultant CSV instead of the beginning (or have an option to do so).