Skip to main content

Notifications

Announcements

No record found.

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... / Excel Data Import Issue
Small and medium business | Business Central, N...
Suggested answer

Excel Data Import Issue

(1) ShareShare
ReportReport
Posted on by TB-30081649-0 38
Hi All -
 
I am trying to import a subset of new items from the production environment into a sandbox environment.  I exported the item list via a configuration package, deleted the records i didn't want to import, created a config package in the sandbox and then imported the excel file.  After importing, i selected "apply."  When i check the items, only the item number has been imported.  I checked and all of the fields for the table are selected for export and import.
 
Do any of you know why the other fields aren't populating?
 
thanks!
Categories:
Dynamics 365 Business Central
  • TB-30081649-0 Profile Picture
    TB-30081649-0 38 on at
    Excel Data Import Issue
    thank you Yun Zhu - i'll give that a try
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 78,034 Super User 2025 Season 1 on at
    Excel Data Import Issue
    Looks like an Excel problem, are these actual values? I mean, they're not formulas?
    I suggest exporting the template from Sandbox, then adding a new item using this template, importing it, and seeing if there is any problem.
    If that's OK, then something might have gone wrong while copying the value.
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • TB-30081649-0 Profile Picture
    TB-30081649-0 38 on at
    Excel Data Import Issue
    yes - the fields are in the same order. 
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,349 Super User 2025 Season 1 on at
    Excel Data Import Issue
    You stated you manually created the same configuration package in the sandbox environment. Are the fields in that config. package in the same order as in production? That could be another reason. 
  • TB-30081649-0 Profile Picture
    TB-30081649-0 38 on at
    Excel Data Import Issue
    Valentin -thank you for your reply.  I followed the procedure as you explained and there are no errors, but for some reason the fields still aren't being populated. 
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,349 Super User 2025 Season 1 on at
    Excel Data Import Issue
    It looks like you have errors in your configuration package. If you have errors, the system doesn't import all the data but it only creates the records with the number field populated. You can check in the configuration package what the error is. I wrote a blog post about configuration packages and have a section on handling errors here.  
     

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans