Table monitor

The Export Table Monitor makes it possible to track changes in your database, and let these changes be a trigger to start an export.
This will result in records in the ConnectIT Export Queue, that can be processed and will result in an Export Entry.

The table monitor can be configured from the export definition card on the tab Table Monitors.
After creating the export structure in the definition lines, the export monitor will automatically show the root data item used in the lines.

Here it is possible to set the monitor active and choose which type of changes to monitor.
The monitor can be used to track insert, modify, delete and rename transactions.

There is also an option to only track changes for records that were originally imported with a ConnectIT import definition.

Open

Monitor Inserts

When the checkmark for inserts is on, all new records in the table are logged by the table monitor.

Modifications

For modifications, it is also possible to only track changes for certain fields.
This can be configured by opening the table monitor card.

The tab Monitored Fields will show all fields from the data item that will be monitored for changes.
If no fields are selected, all fields will be monitored for changes.
If there are fields defined, only these fields will be monitored for changes.

It is also possible to exclude fields from the monitor, to use this feature, select the option Exclude Fields. Instead of the tab Monitored Fields, the tab Excluded Fields will now be displayed.

Add fields to exclude from monitoring, meaning that all fields except the fields defined will be monitored.

In the following example all fields from the Customer record will be monitored, except field 53 (Last Modified Date Time) and field 54 (Last Date Modified).

Monitor Delete

If this option is turned on, all records that are deleted will be send with a realtime connection. This will not use the jobqueue.

Monitor Rename

For the rename option the monitor will check all keyfields in the table if there are changes and if this is the case it will also create a realtime export. This will not use the jobqueue.

How this will work for example in Intercompany is dat based on the System ID or Record ID, the key field will be changed in the other BC companies.