XMLports are used to export and import data between an external source and Dynamics 365 Business Central. Where we can easily map the tables and fields that are available in Business Central as well as the variables and constants to import/export data with XML format or any other format using the separator.
Tag Archives: Export
Dynamics 365 Business Central: How to export all keys in all tables
Today I would like to briefly talk about how to export all keys in all tables.
In AL, a key definition is a sequence of one or more field IDs from a table. You can define keys in table objects and table extension objects, depending on the type of key. There are two types of keys: primary and secondary.
Dynamics 365 Business Central: How to export data from tables to CSV (comma-separated values) file
Today I would like to talk about how to export data from tables to CSV (comma-separated values) file.
A CSV (comma-separated values) file is a text file that has a specific format which allows data to be saved in a table structured format. Anyone familiar with spreadsheet programs has very likely encountered CSV files before, they’re easily consumed by Microsoft Excel, and countless other applications.
How to export all fields/controls in all pages in Dynamics 365 Business Central (Page Control Field)
In Dynamics 365 Business Central, pages are the main way to display and organize data. A page is defined in code as an object composed of controls, properties, actions, and triggers.
Dynamics 365 Business Central: How to export Work Description (Blob) in Sales Documents to excel
Last week I saw a question on the Business Central forum, how to export the Work Description in Sales Documents to excel?
As far as I know, Microsoft added this new field in Sales Documents since NAV 2017. It help users to add more details about Sales Quote or Sales Invoice.
Business Central data exported in Azure Data Lake
Azure Data Lake includes all the capabilities required to make it easy for developers, data scientists, and analysts to store data of any size, shape, and speed, and do all types of processing and analytics across platforms and language
Dynamics 365 Business Central: How to export all Media Contents (bmp, jpg,mp4…) from table 2000000184 “Tenant Media”
Today I would like to talk about how to export all Media Contents from table 2000000184 “Tenant Media” in Business Central.