Hey,
I have this issue where I can only import 4734 lines from an excel file that is 70000 lines long. I don't receive the error message like other users have "File is to big".
What I've tried (without any change to the amount of lines that are imported):
1) Change Max Upload Size in Administration
2) Change Data Cache Size in Administration
3) Change MaxNoOfXMLRecordsToSend in the ClientUserSettings file
What I've tried (and this did change the amount of lines that are imported):
1) I removed lines from the Excel so that I only had 5000 > He imported 5000 lines no problem. But telling my customer to find the sweet spot with trial and error is not a solution for me.
2)I converted the file from xlsx to xls. Suddenly I could import 65533 lines! Still my file is bigger than this so not a final solution imo.
The customer is using NAV2015_SP2.
Any thoughts would be greatly appreciated.
0
Answers
I have the same problem in NAV 2017 and I've also tried to change the service parameters as Kraver.
Any help ?
Thanks
Rui