RapidStart Import from Excel limitation

(0) Share

Report

Posted on by BorisK

130

I am importing from Excel in a RapidStart profile, the source Excel sheet contains 9 columns and 75K rows, but the import simply stops after importing 9554 records. No errors, just stops.
Max upload size on the NAV server, if it matters, set to 30Mb. The file is only 3Mb.
Is there any other setup somewhere that does it?

*This post is locked for comments

All responses (4)

Answers (1)

Verified answer

BorisK 130 on at

Like (0)

Report

RE: RapidStart Import from Excel limitation

Hi Hasitha

It's a bespoke table - and Microsoft support gave me the answer.

Apparently it has to do with the old Excel limitation of 65536 rows per sheet.

The XML engine doing the import and export in NAV2013 is somehow still affected by it, so only up to 65536 records can be imported or exported.

Oddly if the number of records in the file exceeds 65536 NAV only processes the difference between the number of records and 65536. So if the file contain 65537 records it will only import 1 and then just stop!

In my example the file contained 75090 records, so 75090 - 65536 = 9554 were imported.

Weird.
Hasitha Jayasuriya 645 on at

Like (0)

Report

RE: RapidStart Import from Excel limitation

Hi Borisk,

What is the table you are trying to import ?

Regards,

Hasitha J
BorisK 130 on at

Like (0)

Report

RE: RapidStart Import from Excel limitation

The file looks absolutely fine around row 9554, I tried to cut into two and import each of the halves, and still only imports 9554 records. Stumped.
Amol Salvi 18,694 on at

Like (0)

Report

RE: RapidStart Import from Excel limitation

Check in excel file is there any speacial or junk characters after the row 9554

Or

Try to import the records in multiple parts