Business central blog
Subscribe to blog and get news about new posts.
Table Data Editor for Business Central
Enhance your data management with powerful, intuitive, and free Table Data Editor.
Table Data Editor is an open-source application for Business Central. This application allows you to easily manipulate data in Business Central tables. Table Data Editor is completely free and open-source, distributed under the MIT license. Anyone can contribute or share their ideas for the development of Table Data Editor on GitHub.
Summer Cleaning
In one of the latest versions of the Table Data Editor, functionality for importing and exporting table data was added. As the simplest and easiest format, I chose JSON. However, I quickly received requests to add Import/Export in Excel format as well. So, I also added the ability to export to and import from Excel.
local procedure TestInlineAssign(a: Integer; b: Integer; Age: Integer; InputInteger: Integer)
var
AgeInfo: Text;
MinNumber: Integer;
begin
MinNumber := a < b ? a : b;
AgeInfo := Age >= 18 ? 'Adult' : 'Minor';
AbsInteger := InputInteger < 0 ? -InputInteger : InputInteger
end;
The Preset functionality was introduced thanks to an idea from Alessandro Pungitore and, most importantly, the full implementation by Daniel Noeth. I am very pleased that the Business Central community is actively developing Table Data Editor, and I strive to keep up. Therefore, I have also added a few new and hopefully useful features.
You can now save and load preset configurations for Table Data Editor. This functionality allows you to easily create multiple profiles for working with your most frequently used tables and filters.
You can now save and load preset configurations for Table Data Editor. This functionality allows you to easily create multiple profiles for working with your most frequently used tables and filters.
Literally copying one column of data to another. Of course, this won't work if your data types are significantly different.
You now have the ability to enable logging of any data changes made by Table Data Editor. By default, this setting is turned off, but you can enable it on the Table Editor Setup page. Please note that when changing a large number of records simultaneously, this functionality may negatively affect performance.
This functionality allows you to export data from a filtered table, with only the fields you have loaded being exported. You can also import this file using the import function. Additionally, you have options for handling existing records during data import. The default behavior is a runtime error, but you can choose to modify the found record or skip it. It is also worth noting that the Validation flag on the Data Editor page is used to determine whether fields and modify/insert triggers need to be validated.
Important: Why don't we add SharePoint App Principal? The thing is, this method will soon be removed. Starting April 2, 2026, Azure Access Control Service (ACS) usage will be retired for SharePoint in Microsoft 365, and users will no longer be able to create or use Azure ACS principals to access SharePoint. Learn more about the Access Control retirement.
https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/retirement-announcement-for-azure-acs
https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/retirement-announcement-for-azure-acs
“
Radio has no future
“
Grouped data are data formed by aggregating individual observations of a variable into groups, so that a frequency distribution of these groups serves as a convenient means of summarizing or analyzing the data. There are two major types of grouping: data binning of a single-dimensional variable, replacing individual numbers by counts in bins; and grouping multi-dimensional variables by some of the dimensions (especially by independent variables), obtaining the distribution of ungrouped dimensions (especially the dependent variables).
- Install Docker
Go to https://www.docker.com/get-started and download docker desktop application. Install it. - Enable Hyper-V
Go to Windows PowerShell, run it as administrator, put command to enable Hyper-V:
Enable-WindowsOptionalFeature -Online -FeatureName $("Microsoft-Hyper-V", "Containers") -All - Install BcContainerHelper
Put command into PowerShell:
Install-Module BcContainerHelper -force
If you got an error just install PowerShell package manager, put command into PowerShell:
Install-Module -Name PowerShellGet -Repository PSGallery -Force - Reboot PC
Reboot is required due to Hyper-V installation - Switch to Windows Docker
Go to Windows right bottom corner, find Docker icon, right-click and select "Switch to Windows containers" - Get Artifact Url
To start BC installation process you must find Artifact Url for your specific BC version, just put command in PowerShell:
Get-BcArtifactUrl -type sandbox -country us -select Latest
-type sandbox or onprem
-country BC localization
-select your specific version or Latest
If you have an error "that script is not signed" you need just to change PS script execution policy by command:
Set-ExecutionPolicy -ExecutionPolicy Unrestricted -force -scope LocalMachine - Download and Install BC image
Put command in PowerShell:
New-BCContainer -includeAL -containerName <SandboxName> -accept_eula -auth NavUserPassword -ACCEPT_OUTDATED -artifactUrl <artifactUrl> -updateHosts -includeTestToolkit -includeTestLibrariesOnly -assignPremiumPlan - Set username and password
In the installation process, you will have a pop-up window where you must type your new UserName and Password. Password must contain lowercase and uppercase, number, and symbol.
So why are there developers who are unhappy with the introduction of the ternary operator in AL? There are several reasons for this, let's consider some of them:
- New syntax inherently increases the cognitive load on the developer.
- Poor developers will abuse ternary operators, which in turn will complicate code reading and debugging.
Table Data Editor
You probably remember the glory days when we had direct access to data in Navision tables. But with the move to Cloud Business Central, we lost that ability. It's probably much safer and more correct, but what if we need to fix some data problem and we know what we're doing? We can write a routine that fixes that problem. But I suggest a better option, this Data Editor extension that allows you to change and delete information from any table in Business Central
Light PDF Viewer (PDF.js)
I have prepared a lightweight ready to use free extension for viewing PDF documents in Business Central. I've heard requests for Microsoft's built-in PDF Viewer on more than one occasion. But since Microsoft is still working on this problem, I found it helpful to make a simplified version. This extension doesn't need any additional servers.
Rich text editor. Summernote WYSIWYG.
One of the frequent requests I hear from users is the WYSIWYG editor. Unfortunately, Microsoft has not added the editor yet. So I decided to integrate some free editor into Business Central. My choice was summernote, a simple and functional WYSIWYG editor. I will also talk about new app updates
Full PDF Viewer for Business Central (PDFObject)
PDFObject is a library that runs the standard built-in PDF renderer in the browser. This means that the rendering in different browsers may be different. This is a very interesting option for displaying PDFs in Business Central, as browser-based PDF Viewers often have powerful functionality.
API Object Generator XML/JSON
The idea of the application is to read incoming JSON/XML files and generate AL basic objects from that information. You can paste JSON/XML direclty to page or application can also make HTTP requests with authorization depending on the settings. At the moment the supported authorization types are: Bearer Token, Basic, OAuth1.0, OAuth 2.0
+
Easy to understand
-
Poor performance
August 2, 2022
Author: Volodymyr Dvernytskyi