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.
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.
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.
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
Today I would like to talk about how to export all Media Contents from table 2000000184 “Tenant Media” in Business Central.
Sometimes it may be useful or necessary to use powershell to read data from SQL Server to export it to other formats This can also be used with older versions of Dynamics NAV which do not have access to the integrated powershell. Using standard powershell commands it is possible for example to read an SQL view and export it to CSV or XML file.
Today we will see how we can data from Business Central table using new data type Text Builder.
To check how this data type work build small program as below which pick up data from customer table and export the data in text file.