web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Importing 40k items
Small and medium business | Business Central, N...
Answered

Importing 40k items

(0) ShareShare
ReportReport
Posted on by Robert-Jan Walet 34

Hi,

Currently i am working on a project on which we also are doing the data migration from NAV 2009 to Business Central SaaS. The customers, vendors and all other records have been transferred to BC, although I do have issues with the items, as there are in total 40.000 items that need to be imported in Business Central. When I try to use the configurations packages from this, the loading takes way to long and sometimes even times out. 

Is there perhaps a better way to import all these items, the mapping between NAV and BC has been done, so its just a matter of getting the data into Business Central. I am open to any workable suggestions!

Thans in advance,
Robert-Jan 

I have the same question (0)
  • Robert-Jan Walet Profile Picture
    Robert-Jan Walet 34 on at

    For future refferences, I ended up with splitting the file in chunks of 10k items, just based of item number. Importing and applying took about 1,5h that way which was manageable.

  • Verified answer
    Robert-Jan Walet Profile Picture
    Robert-Jan Walet 34 on at

    HI all,

    Thanks for all the replies, I definitely have something to work with! Will first try to split the file up if that doesnt work, I will ask dev to make an XMLPort.

    Have a great day :)

    Robert-jan

  • Suggested answer
    JAngle Profile Picture
    JAngle 137 on at

    If you want to avoid doing the DEV work try this: https://www.hougaard.com/bccl/

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

    I would suggest to develop XMLPort. It is way much faster than Config Package. The time spent to develop it will be less than trying to import using Config Package.

  • Suggested answer
    Muhammad Zaid Profile Picture
    Muhammad Zaid 286 on at

    Hi,

    I suggest you break items master data files into multiple files. You can segregate the data based on item categories or item numbers as you want.

    We also did a migration of 60K items for one of our clients. I did the same and create multiple sheets of item data by item category.

    I hope it helps.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,251 Super User 2025 Season 2 on at

    You can import them using the XmlPort, but you need to develop it and it is fast compare to a regular rapid start.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,476

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 789 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 719 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans