There is a big issue in BC v16 and more :
- We can't import big Excel files with Rapidstart for migration
- more than 65000 lines
- and more 20mo
It is a big issue to be able to integrate new customer on Business Central.
I test again today on last BC v16.1
Comments
I completely agree with the need to support larger files. Further more, I can't even start the process and let it run overnight because Business Central times out. As such, I have to set a timer to click the screen every so often just to keep the process running.
Category: Data Migrations
I have now had numerous customers that have Customer or Item related records that are over 50k records. In one instance I have a record list of 166K+ customer records to bring in..
I have tried Items with 10k in and its taken over 5hrs to import using Configuration Packages! even splitting down the 166K to smaller files (2000 records for example, which take 10-15mins to process) will require 85 different files to be created. This is still going to equate to over 28hrs of Data Import!! then I need to import 160K+ contacts!
There needs to be a faster and more efficient method to bring in large numbers of records.!
Category: Data Migrations
Dear Business Central Team
Then how can we migrate and start customer on Business Central without importing ledger historic data?
This is not a feature but a real issue.
Without that you are blocking all project with data migration...
Which is a nightmare.
Regards,
Laurent
Category: Data Migrations
From several years Excel can have more 65000 lines (now near 1 000 000) then BC must be able to do the same.
On Premise we never had this issue.
Category: Data Migrations
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.
Best regards,
Business Central Team