XMLPorts and text files

Rob_Hansen

Has anyone had issues with XMLPorts not parsing tab-delimited (or any delimited) text files properly? We created an XMLPort to import a large historical file for a new implementation. We've tried several different file extracts, which are all large. We got past the problems with the file being too large to handle (Upload size limit in custom settings), but even after that we have the following issues:

1. The RTC completely crashes half the time...so it takes 2-3 attempts to get it to read the file
2. At some point in every file, the XMLPort fails to handle the field delimiters properly and we end up with an overflow (as it tries to bring 20 or so field values into a single field)

We've tried tab delimited, as well as other "unique" delimiting characters (such as a "|~|" string), but the import always fails at some point in the file.

I quickly translated it to a classic dataport (this is NAV 2009) and it works fine. So, we're okay for this time around (since the import won't be run by users on an ongoing basis), but in NAV 2013 we'd be SOL.

Has anyone else hit these kinds of issues?

ddlarsc

In NAV 2013 part of the XMLPORT have been refactored to handle the bad performance and client crashes that happend in 2009 which is a known issue when working with big text files.