I am trying to import a large .csv file into Business Central (BC18, on premise) using either an XMLport or an instream. The size of the file is 50-100 mb, containing 50 columns and up to 1,000,000 lines.
When I import the file into a holding table using an XMLport, I get the following error (note that I increased the Max Upload Size to 2047mb) if done through the web client:
Attempting the import using UploadIntoStream gives a similar error:
This upload works much better when done directly from the app server, but the system will be upgraded to the cloud soon and I'm hoping to get this upload working better from the web client.
I'm considering writing an Azure function to import this file in sections, but I'm wondering if there is something I'm overlooking, since the file size is well below the maximum specified in the error.
Thank you!
