web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • 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 90,514 Super User 2025 Season 2 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 28,409 Super User 2025 Season 2 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 28,409 Super User 2025 Season 2 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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sumit Singh Profile Picture

Sumit Singh 2,707

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,675 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 2,228 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans