Hi all,
I made a configuration package for table 225 Post Code. Then I try to import an Excel sheet with 463000 rows...
After import only the first 4681 rows are imported!? What do I need to change to import all the rows?
(I already tried to change the Max Upload Size)
*This post is locked for comments
@MM V
I'm not getting an error (otherwise I could debug it) and there is no special character! As already mentioned I also copied rows 1-1000 to 4000-5000....
@Khoa
There is no data missing... Thanks for the offer with the text file, but I'm a NAV consultant/developer for almost 15 years now.. I already imported it as a csv file, but I still do not understand the problem with the Excel file!
Hi Dennis,
Are you getting any error or is the system hanging? Please check whether you are having any special character at row number 4682 or 4683.
I had uploaded 590000 records in a single file. I had an issue after uploading 485000 records and it was due to ("") in one of the text fields, because the field delimiter was (""). I corrected the data and it worked well.
Best Regards,
MMV
Hi Dennis,
It may due to:
- Missed Country/Region Code
- Excel license (community.dynamics.com/.../149936.aspx). If you would like, I can support you try with text format.
Khoa,
I forgot to mention that I also modified the MaxNoOfXMLRecordsToSend to 500000....
I also take a close look at lines 4679-4685, but nothing strange there... I also copied lines 1-1000 to 4000-5000, but the routine still import 4681 rows!
Twilight-zone-bug:)
Hi Dennis,
There is another setting at client side, MaxNoOfXMLRecordsToSend in ClientUserSettings.config file (%AppData%\Microsoft\Microsoft Dynamics NAV\[NAV Version]). Besides, is there any special character in data for rows around 4680 and 4682?
Sorry... this is not a solution, it's a workaround!
In this case I must split the file in 100 separate files.......
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (