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
- Prepare the import file for the table.
- Open Import Export PowerTool, set the Operation to Import, and turn on Do Two-Step Insert.
- Allow record inserts, and set validation as needed.
- 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.
Related Import Export PowerTool features
All Import Export PowerTool features →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.
