web
You’re offline. This is a read only version of the page.
close
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
I have the same question (0)
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 31,481 Super User 2025 Season 2 on at
    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.  
     
  • TB-30081649-0 Profile Picture
    TB-30081649-0 38 on at
    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 31,481 Super User 2025 Season 2 on at
    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
    yes - the fields are in the same order. 
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,729 Super User 2025 Season 2 on at
    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
    thank you Yun Zhu - i'll give that a try

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

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 November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans