RKL eSolutions Blog Trends and Insights

Sage ERP X3 Data Import Misplaced Indicators Error

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.

Sage X3 Data Import Screenshot Error Importing Screenshot

It is important that the separators and record separator values match the import definition.

Sage X3 Data Structure Screenshot 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.

Tags: Sage X3
RKL Team

Written by RKL Team

Since 2001, RKL eSolutions has helped growing companies maximize their technology resources and investment. Over the years, we have helped hundreds of small and medium sized businesses as their strategic business partner. We specialize in the needs of Entertainment, Software & SaaS, Professional Services, Manufacturing, and Non Profit organizations. Our experienced consultants have a passion for making every facet of your business successful and are intent on building a long-term relationship with every client.