Volodymyr Dvernytskyi
Personal blog about Navision & Dynamics 365 Business Central
results count:

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-editor-cover

Features

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.

icon

Literally copying one column of data to another. Of course, this won't work if your data types are significantly different.

icon

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.

icon

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.

icon

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.

icon

You can filter the received data in the same way as usual.

icon

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.

icon

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.

icon

Extension also supports changing ENUMs and Options. Just click on them and you will be presented with a list to choose from.

icon

You can also delete records from tables.

icon

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.

icon

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.

icon

Since FlowField's are almost always uneditable, you can exclude them from loading for better performance.

icon

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 '' 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'
icon

You able to insert new record into opened table.

icon

Now you can filter the list of fields before table is loaded.

icon

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.

icon

The function allows you to update the value of the selected field for all records.

icon

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.

icon

Remember that editing tables directly can be risky, and it’s best to avoid doing so in Production or without a clear understanding of what you’re doing!

Back to top