Import Export PowerTool for Data Migration in Business Central

Concerned that installing a data tool might rewrite your carefully configured security? This article explains why the Import Export PowerTool does not overwrite existing Business Central permission sets, how its own two permission sets fit in, and how it still respects every user’s current access rights.

If your export file will not import after you edit it in Excel, missing line endings are a likely cause. This article explains why line terminators can disappear, how to save files correctly, and how to verify both line endings and encoding before importing into Business Central.

Need an audit trail for your data loads? This article explains the logging available with the Import Export PowerTool in Business Central, why the change log is the main record of activity, and how your source files serve as a practical log of what you imported.

Looking to run data loads without manual steps? This article explains how the Import Export PowerTool supports automation in Business Central through published events and a programmatic AL interface, and what that means if you want scheduled or system triggered imports.

What happens when one row in your import is bad? This article explains the Import Export PowerTool error handling in Business Central, why a failure rolls back the entire table rather than a single line, and how commit behavior across multiple tables limits the impact.

Will a description like Tape, 12 inch survive an import? This article explains how the Import Export PowerTool Remove Quotes option treats inch marks and embedded quotation characters, why Excel adds extra quotes, and how to keep your descriptions intact during import.

Hoping to rearrange a configuration package quickly? This article explains what the Import Export PowerTool does and does not change about configuration packages in Business Central, why it leaves package definitions untouched, and how to control the order of fields in your import and export files.

Need to remove items in bulk? This article walks through deleting items in Business Central with the Import Export PowerTool, how to filter and preview the records first, the confirmation safeguards available, and the cautions to observe so you do not leave orphaned or dependent data behind.

Bringing customers into Business Central? This article explains how to import a new customer list with the Import Export PowerTool, how to build the file, which fields to validate, and whether the tool assigns customer numbers for you or expects you to supply them.

Planning a very large data load? This article explains how long the Import Export PowerTool takes to import hundreds of thousands of records in Business Central, why timing scales roughly with volume, and which settings you can adjust to make big imports run faster.