Skip to main content

Notifications

Announcements

No record found.

Data Support Tool

Disclaimer.

The bad use of this tool can make lots of damage in the data. Be careful and always know what the side effects of your data changing are. This tool is not a Microsoft tool, and open possibilities that nobody will support and fix. Do not allow access to it to final customers, and you will sleep better.

Background

Previously we got tools to correct data manually, most of times the Object designer, table running and edit data. Nowadays in SAAS Business Central, we cannot edit the data unless you make a new page and publish it in an application each time you need to correct data. Even you cannot access to SQL Database.
I am not very proud of it, but I did it a tool to able the same kind of botched jobs. I don´t like it to promote this kind of handmade data fixes and likely somebody else will use it before me, because I haven´t used the tool yet in a production environment. My motivation is to be ready and learn lots of things about Recordref, Fieldref that I will talk about in other post. I think nobody did a tool that do the same before, but not sure.

Features:

After install the extension in your BC tenant you can find it typing in search “Data support”, “Dangerous Data modification” or ”Modify all data without related page”:
3857.Dats0.png
You can follow these steps to use the data support tool:
  • Select the table to modify.
  • Select in the part bellow the fields to edit and filter.
  • Push action “Edit Rows” so show and edit the select rows.
  • If you need edition in other columns (the limit of grid is seven columns) you can edit all fields with the action…….”Edit All Fields”.

Step 1. Select the table to modify.

3666.DataS1.gif

Step 2. Select fields to edit and filter:

7103.DataS2.gif

Step 3: Push action “Edit Rows” to edit the selected rows.

4353.DataS3.gif
After push “View Rows” you can edit the seven default columns you have selected in step 2:
7026.DataS4.gif
If you need edition in other columns you haven´t selected in step 2, you can edit all fields with the action…….”Edit All Fields”:
6281.DataS5.gif

Remarks:

Delete is made with trigger execution true. This way we avoid deleting without validations.
Field assign is made with validate statement for the same reason as above. This way you can avoid data misleading, fields without relations, and change closed records.
If you need help for editing filters and field values you have a kind “lookup”: if the field is an option it shows the possible option values. If the field has a relation it opens another window with the table. You cannot select values in “lookup style”, but this help can help you edit the right value.
I didn´t leave it in Appsource, is in my Git repo. According of the spirit of the tool, I leave the app file in the repo ignoring all guidelines that told us not to put binary files in Git:
As I previously said be careful, and I wish you to never use this tool!!

Comments

*This post is locked for comments