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.
Table Data Editor 3.0 Features
It's been quite some time since the last major update, Table Data Editor 2.0. I am pleased to announce that the time has come for a new major update: Table Data Editor 3.0! Moreover, part of this significant update was made possible by open-source contributions.
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.
Features
By simply opening the Data Editor from the search box, you can load any table. If you enable the "Without Validation" field then all OnDelete/OnModify/OnValidate triggers will be disabled.
You can filter the received data in the same way as usual.
You can change the data in the tables, and depending on the type of field you get a pop-up window with the same type of data. For example, if you try to change a field with the type Date, a pop-up window will open with the date that you can change. Code and Text data types can be changed without opening a pop-up window.
If you want to change a field that contains a simple Table Relation, you will also have a lookup available. For example, you don't have to manually write Sell-To Customer No. on the Sales Line, you can select it from the list.
Extension also supports changing ENUMs and Options. Just click on them and you will be presented with a list to choose from.
You can also delete records from tables.
Sometimes we don't need to load the whole table in order to change some specific entries. That's why I added the ability to filter the records before loading them. You can add any field and any number of filters. In addition, the Number of Records field will display the actual number of records, taking into account the filtering.
The application now supports changing primary key values. Currently, support for up to 15 values in PK has been implemented. Why 15? I'll write about that later :) Renaming has its known limitations(see remarks section), for example you can't change Enum/Option to 0 or from 0 to another value.
Since FlowField's are almost always uneditable, you can exclude them from loading for better performance.
Sometimes it is necessary to open a table directly through a link. For such cases, your link will look like this:
- <base_bc_url>&page=81003&filter='Table Number' is '<TableNo>' and 'Exclude FlowFields' is '<0 or 1>' and 'Without Validate' is '<0 or 1>'
- http://localhost/BC/?tenant=default&page=81003&filter='Table Number' is '18' and 'Exclude FlowFields' is '1' and 'Without Validate' is '0'
You able to insert new record into opened table.
Now you can filter the list of fields before table is loaded.
It is now possible to sort the record by any available key. Since Table Data Editor uses text fields in the buffer, sorting in the UI may not be correct for fields with non-text data type.
The function allows you to update the value of the selected field for all records.
Find & Replace page allows you to find and, if necessary, replace all fields by filter. In addition, it is possible to change a specific value for a specific entry.