Data Management Tool

Introduction

The following tool can have major repercussions on data in both Business Central and your webshop. Please use with caution.

Imagine the following situation: a company creates customer cards in Business Central and publishes these to their webshop using the connector. They require extra data, found on the customer card, to be added to the sync. They have changed the mapping accordingly.

When a new customer is added, or a customer is updated, the additonal fields will be sent.

However, they want all the customers they have published to be updated in bulk. How would they go about that?

Well, Tinx has a solution for that. A flexible report that can be used in a myriad of ways, including the bulk sync of data. The report is called the Tinx Data Management Tool.

How to use

To find the report, head to Setup > Data Mgt. Tool, which will open the page below.

 

 

In Table No. one selects the table to work with. In this case 18.

Once selected, the connector automatically shows you the amount of records that are found within that table. If in the above scenario we'd like to update customers, but only those already published, we can filter for those records as follows.

In the Search Field type in 'publish' to find the Publish to Webshop field in the customer card. Set Field Filter to 1 (i.e. true) and go to Information > Count No. of Records.

The connector then shows the amount of records that fulfill that criterion (2 instead of 7 'total' customers). You can then see the records via Show Filtered Records.

If you'd now like to update only these records, click on Functions > Send Records to Record Queue.

In the above case, only 2 records will then be added, using the new mapping.

Other use cases

You can also use this tool to delete filtered records and/or reset specific values. Obviously, this can have major consequences on the data sync, so be mindful when using this tool.

To reset values, go to Data Manipulation and select the field you'd wish to reset.

Below an example where we would look for field Chain Name and reset all records where a match is found starting with 'tinx'. After filtering, click on Functions > Send Records to Record Queue.

Finally, the Run Table button allows you to see any table in your system. This can be useful when searching for data.