18
Hi
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
STATUS DETAILS
Needs Votes
Ideas 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

Comments

L

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

L

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

L

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

L

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