Data Migration | Image export and import implemented

Task #10408 | 5056.003

Old Dynamics NAV versions up to and including Dynamics NAV 2016 saved images in the form of a ‘blob’ in ‘5200 Employee’ table. Starting from Dynamics NAV 2017, images have been saved in ‘Media’ format. Since the old ‘Blob’ field disappears with the release of Business Central 2021, Wave 1 (BC18), a solution is needed to migrate images retrospectively, e.g., if a customer wants to upgrade directly from Dynamics NAV 2013 to Business Central 18.

There is already a workaround today

Upgrade to Business Central 14, migrate the images there and then upgrade to Business Central version 18.

In Dynamics NAV 2013 - 2016, you can export images directly via ‘SwissSalary Organization’. This feature exports all images from the blob field in table 5200 from all clients to a ZIP file. A folder is created for each client in ‘Bilder.zip’ file. You can ‘import images’ in Dynamics NAV versions from v. 17 onwards, and again, via ‘SwissSalary Organization’.

IMPORTANT NOTES:

- Only the images of the current client are imported! This means that this import must be carried out separately in each client (technical limitation).

- If an image for an employee already exists, it will not be overwritten.

- After the import, a log is displayed where you can see whether individual images have been imported.