Import CSV with long (length > 1024) text fields - 2013 R2

azatoth

Hi,

I need to import CSV files which has one or more fields with unlimited length.
Unfortunately the XMLport is unable to import because of the 1024 max text length limitation (which is strange because i'm using 2013 R2)

Any ideas?

Build a codeunit using streams? In this case I need to handle the field separators, text qualifiers, line endings etc.

Thanks in advance!

SOLVED

ara3n

There is a property called TextType on the xmlport line that you can change from text to bigtext.

azatoth

Thank you ara3n

I've solved/tried to solve the issue to import the data into SQL and process from NAV but this "official solution" is better.

Have a nice day