Insert and Update Control for Microsoft Dynamics 365 Business Central
A file meant to correct prices or descriptions on existing items can create unwanted new items if a key is mistyped, and a file meant to add new records can overwrite ones that already exist. Import Export PowerTool gives each import two separate switches, one for inserting records and one for updating them. This is a completely free app from Insight Works for Business Central.
How Insert and update control works in Import Export PowerTool
- Prepare or export the file that holds the records.
- Open Import Export PowerTool and set the Operation to Import.
- Turn Allow Record Inserts and Allow Record Updates on or off to match what the file should do.
- Run the import and review the completion message.
Key capabilities
Insert only
With inserts allowed and updates off, the import adds records whose primary key does not yet exist and leaves existing records alone.
Update only
With updates allowed and inserts off, the import changes matching existing records and does not create new ones. This suits a correction file for data that is already in Business Central.
Insert and update
With both switches on, new keys become new records and existing keys are updated from the file, which suits a full reload of a table.
Works with the other import options
The switches sit beside the two-step insert, validation, and file handling options on the same Import Options section.
See Insert and update control on screen
Real screens from Import Export PowerTool, shown with demo data.
Details that matter on the floor
Decide before you run
The insert and update choice is made on the page for each import, so the same file can serve a first load and a later correction without editing the file.
Primary keys decide the match
Whether a line counts as new or existing depends on the table's primary key fields in the file, so those fields need to be correct.
Who uses Insert and update control
Business Central consultants
Run correction files that only update existing master data during go-live.
Data migration specialists
Reload tables in stages, inserting first and updating later.
Questions about Insert and update control
Can an import update existing records without creating new ones?
Yes. Turn on Allow Record Updates and turn off Allow Record Inserts, and Import Export PowerTool changes only records that already exist.
Can an import add records without changing existing ones?
Yes. Turn on Allow Record Inserts and turn off Allow Record Updates.
How does Import Export PowerTool know a record already exists?
It matches on the primary key fields of the table in the file.
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 Insert and update control?
Send us a note and the Import Export PowerTool team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
