4 Jun’19

D365 Business CentralReview Data Imported From Excel To Configuration Package using Configuration Import Preview

Introduction:

  1. The Import from Excel on the Configuration Package page is used to import data from excel.  It can be used to even before a configuration package is created.
  2. To avoid confusion and unnecessary retries when using these actions, you can now use the Config. Package Import Preview page to get an overview of the Excel file content to be imported.
  3. The page opens when you choose the action and shows the list of configuration packages and tables, organized on different sheets, in the Excel file that you are trying to import. The page also explains if the Import from Excel action will create a new configuration package or update the existing one, and if the action will create new configuration package lines (tables) or update existing ones.

Pre-Requisites:

  1. Microsoft Dynamics 365 Business Central

Steps:

To import the Purchase Order Data :

  1. Open the Config. Package Card page.
  2. Select the table for which you want to import data, and then, on the Tables tab, choose the Import from Excel action.

3. Locate and open the file that you want to import data from.

4. On the Config. Package Import Preview page, review the content that will be imported.

The Config. Package Import Preview page provides an overview of the Excel file content to be imported. It also indicates if a new configuration package is created or the existing one is updated, and if new configuration package lines (tables) are created or existing ones are updated. Choose the Import Action.

5. A new Package is created on the List page and the data in the configuration package can be viewed by clicking on the package.

Conclusion:

Thus, this way the data from the Excel is now imported into configuration package and with the help of Configuration Package Review page the data that is imported can be reviewed and checked.

Written by

Team Member

CloudFronts

Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • How to create Dynamics 365 Finance & Operations (formerly Dynamics AX) connection in SSIS

    12 December’ 2019

    Introduction: Creating a Connection is one of the first Steps during the integration of data. While performing Integrati...

    Read more
  • How to create AX (D365 F&0) Connection in SSIS

    12 December’ 2019

    Introduction: Creating a Connection is one of the first Steps during integration of data. While performing Integration w...

    Read more
  • First cut review of new D365 Project Service

    12 December’ 2019

    The new Project Service coming up is a much-advanced version of PSA. Even more, than it will be called as Project Servic...

    Read more
  • Business Central Wave 2 Features – Section 4

    11 December’ 2019

    Introduction: In this blog, I will be attempting to provide information about the new Modern Client features of Business...

    Read more
  • Business Central Wave 2 Features – Section 5

    11 December’ 2019

    Introduction: In this blog, I will be attempting to provide information about the new Modern Client features of Business...

    Read more

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close