View Code? Open in Web Editor
NEW
Data Migration Tool into Business Central
dmt's Introduction
DMT - Data Migration Tool
a relative link
- Read structured files (CSV or XLSX)
- Map source columns to target columns
- Import validated data
- Update data
- Replace values before import
- Create a migration processing plan
- Backup & Restore all mappings and settings
- Log processing time & validation issues, the log can easy be exported to excel
- retry migrating records with error
- delete data in the target table with filters on the source data and/or filters on the target data
- count lines in source and target tables to check your migration progress
- max. fieldcontent size is 250 characters
- max. No. of Columns is 300
- no Blob fields
- Open the "DMT Source Files" page and upload your files
- you can upload multiple files in one zip file
- Assign a "DMT Data Layout" to specify column titles an file properties
- Create a "DMT Import Configuration" and set the target table
- Import your data into the generic data buffer
- Map the fields
- Run "Init Target Fields" to create a list of all possible target fields
- Set validation policy
- Use fixed values if required
- Open "DMT Replacement" and up replacements if required for the mapped fields
- compare 1 or 2 fields, if the comparison is a match define 1 or 2 fields with new values
- import all occuring combinations to the compare fields
- values containing Tab, Space or Linebreak characters will be highlighted
- Import Data
- Set up a "DMT Processing Plan" to manage the order of migrations
- setup filters and default values for each step
- Open the "DMT Import Configuration" for the Target Table
- Run "Init Target Fields" if new target fields have been added
- Run "Update Fields" and select all fields you need to update
dmt's People
Contributors
Watchers