Skip to content
Import Export PowerTool app iconImport Export PowerToolImport

Two-Step Insert for Microsoft Dynamics 365 Business Central

Some Business Central tables do not accept a complete record in one insert, because logic that runs when the record is created expects the key to exist before other fields are set. Import Export PowerTool offers a two-step insert that first inserts the primary key, then updates the remaining fields from the file. This is a completely free app from Insight Works for Business Central.

How Two-step insert works in Import Export PowerTool

  1. Prepare the import file for the table.
  2. Open Import Export PowerTool, set the Operation to Import, and turn on Do Two-Step Insert.
  3. Allow record inserts, and set validation as needed.
  4. Run the import; each record is inserted by key and then updated with its other fields.

Key capabilities

Key first

The first step creates the record with only its primary key fields, the same way a person creates a record before filling in the rest of the card.

Fields second

The second step updates the new record with the remaining fields from the file, including any fields marked for validation.

One switch

Do Two-Step Insert is a switch on the Import Options section, so it can be turned on for the tables that need it and left off otherwise.

Business Central rules apply

Both steps run through Business Central table and field validation, so a record that breaks business rules still stops with an error.

See Two-step insert on screen

Real screens from Import Export PowerTool, shown with demo data.

Details that matter on the floor

Mirrors manual entry

Two-step insert follows the same order as entering a new record by hand, which is why it helps with tables whose insert logic expects the key alone.

Who uses Two-step insert

Business Central consultants

Load setup and master tables that reject a single-step insert.

Developers

Load data into tables with custom insert logic during testing.

Questions about Two-step insert

When should I use a two-step insert?

When a table does not import correctly in one step. Some Business Central tables need the primary key inserted first and the other fields set afterward.

Does two-step insert work with validation?

Yes. Fields marked for validation in the file are validated during the update step.

Where is the two-step insert option?

On the Import Options section of the Import Export PowerTool page, as the Do Two-Step Insert switch beside Allow Record Inserts and Allow Record Updates.

Import Export PowerTool app icon

Part of Import Export PowerTool

Import, export, update, and delete Business Central data in bulk, for data migration and ongoing data management.

Have a question about Two-step insert?

Send us a note and the Import Export PowerTool team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions