Business Central 2024 wave 1 (BC24): Export, import multiline text with Configuration Packages (Use BLOB type fields in Configuration Packages)

Dynamics 365 Business Central

Hi, Readers.
The public preview for Dynamics 365 Business Central 2024 release wave 1 (BC24) is available. Learn more: Link.

I will continue to test and share some new features that I hope will be helpful.

Export, import multiline text with Configuration Packages:

Business value:
Avoid having to manually export and import multiline text by using an improved configuration packages capability that allows you to do that with efficiency and ease. This feature is especially useful for businesses that deal with large amounts of multiline texts and need to transfer them between different companies or environments.

We have discussed how to export Work Description (Blob) in Sales Documents to excel before.

In BC23.5 and previous versions, if we want to export the Work Description field (BLOB type), some customization is required.

If we use Configuration Package feature to export, the data will be displayed as an asterisk. For example,

Choose Export to Excel.

The value of Work Description is displayed with only an asterisk.

If we add the Work Description field to the Sales Order List page and using the Open in Excel feature.

Same as Configuration Pakcage, just an asterisk.

So we can only customize…….

With this wave, we can now use BLOB type fields, which usually contain multiline text, to import and export data using Configuration Packages.👏👏👏

Simply choose Include Field on the Config. Package Fields page to include fields that contain multiline text, such as the Work Description field, in your package.

Export data by choosing the Export to Excel action in the Config. Package Card page.

Note: In Version: W1 24.0 (Platform 24.0.16743.0 + Application 24.0.16410.16682), when exporting data, only one line can currently be exported. I’m not sure if this is standard behavior or a bug.

Then we can update it in Excel.

Back in Business Central, import the updated Excel file by choosing the Import from Excel action on the Config. Package Card page. After you validate the data, import it by choosing the Apply Package action.

After you apply the package, open a sales document that you updated, such as a sales order, to verify that you imported multiline text to your sales document.

Test video:

Great improvement, give it a try!!!😁

PS: If data other than multiline text is stored in the Blob Type, it cannot be exported. For example, Picture field in Company Information table.


Hope this will help.

Thanks for reading.



Copied title and URL