While doing using the Sage ERP X3 data import process, it is important that the data columns and line feeds match up exactly with what X3 is expecting. If the end of line indicators and/or field separators do not match the import specification, an error similar to below may be encountered.
Importing Screenshot
It is important that the separators and record separator values match the import definition.
Structure Screenshot
Although the file may visually appear to match the template when opening it, there may be issues with the line feeds or separators. For example, when opening the import file from above in Excel, the file appeared to be formatted correctly. The number and type of data columns matched the import template, and the line-feeds appeared to be set properly. If the file was opened with Notepad, however, the line feeds did not appear.
In this particular example, the data file to be imported was generated from a VB script process, and the line feeds were added at the end of each row. The issue was, the text file had a line fedd (ascii char 10), but no carriage return (ascii char 13). The way to resolve the issue above is to make sure the generated file has both a line feed and a carriage return, and the import will process successfully.
Another way to determine the issue is to make sure the import template is also marked as an export. Then do an export from the X3 table, and compare the data in the generated export file to the file trying to be imported to determine where the fields may be mismatched.
