Requirements for source files - Smart.XChange

Read errors due to special characters

If fields in the source file contain special characters and these are the same as the pre-set separator characters, Smart.XChange is unable to distinguish between the separator characters and special characters. This causes the fields to be split and the column assignment disappears. Avoid using special characters in the source file fields. If you need to use special characters, you can mask them.

1. Open the source file.
2. Add quotation marks to the start and end of the field which contains the special character.
3. The field will look like this: "Content; with special character"

1. Masked special characters are omitted during import and have no impact on column assignment.

Character length for fields

There is a limit to the number of characters permitted in the LSM database fields. If the fields in the source file contain more characters, the excess characters are discarded on import.