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... / RapidStart - What is t...
Small and medium business | Business Central, N...
Unanswered

RapidStart - What is the default behavior when importing blank fields when the existing field is filled?

(0) ShareShare
ReportReport
Posted on by Jan-Willem van der ... 10

I exported and imported a large list of Items from one database to another using RapidStart. The packages were set up as follows:

Source DB: only certain fields exported.

Target DB: all fields selected.

The Excel file of course only had the selected fields as columns. Yet, all other fields have been made blank in the Target DB.

I had not expected RapidStart to do anything to the fields not present in the Excel sheet. I also did not expect RapidStart to make fields blank, I seem to remember that RapidStart makes no changes if a field is blank in the Excel file.

Is this default behavior? Does it change per NAV version? Could it be customization?

I have the same question (0)
  • Verified answer
    Brian Wick Profile Picture
    Brian Wick on at
    RE: RapidStart - What is the default behavior when importing blank fields when the existing field is filled?

    Hi Jan-Willem,

    If the same items exist in the Target db and more fields are selected in the configuration package you are using to import, the editable fields that are BLANK (not included in the spreadsheet) and listed in the configuration package data will modify the existing data and clear the populated values out.  The system thinks you are modifying those values.  

    As a general rule it is best to use the same config. package for the export & import so the same fields are used or create the new config package with the same fields.  I tested in BC 14 on-prem importing into table 27 and I received the same result.  I exported 6 fields and imported using a different config. package that contained all of Table 27's fields.  In the Configuration Package Data, there were editable fields that were blank, and those fields were updated from populated values to blank values after applying the data.  

    Thanks-

  • Jan-Willem van der Linden Profile Picture
    Jan-Willem van der ... 10 on at
    RE: RapidStart - What is the default behavior when importing blank fields when the existing field is filled?

    Thank you for confirming this.

    I really thought RapidStart would not clear values but my memory must have failed me.

  • Brian Wick Profile Picture
    Brian Wick on at
    RE: RapidStart - What is the default behavior when importing blank fields when the existing field is filled?

    To be honest I couldn't 100% remember how it behaved either until testing through a couple of versions.  The modification of data was always based off of what was included in the Config Package Records page.  If an editable field is included and it is blank, chances are it will update the underlying table record.

    Take care.

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

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,202

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,248

#3
Sumit Singh Profile Picture

Sumit Singh 2,893

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans