eeRis Sprinkler v.19.4
for Microsoft Dynamics 365 Business Central v.19.x

Data Distribution Import Setup

On this page you have to specify the changes you want to import in a database, when coming from a remote Peer.

Functionalities

Normally you wouldn't import every information coming from a remote Peer: as a security measure, the import is disabled by default. Sprinkler will allow you to configurate the following behaviours:

• Import data from homologous tables (ex. from remote source Table 18 [Customer] to local target Table 18 [Customer])
• Import data from not homologous tables (ex. from remote source Table 18 [Customer] to local target table 50000 [Partner's Customer])
• Import all (received) fields from remote source table, or only a subset of them
• Import some specific source table's field into specific fields of the target table, for example if tables have a different schema.

The available fields are:

• ID / Remote Table No. – Identifier of the remote source table.
• Translate to Local Table No. – Shows the identifier of the target table.
• Table Caption and Field Caption are automatically filled with corresponding values from target's table.
• Fields Import Configuration – If the value is All Fields, it means that all fields are imported for this table; if the value is “Some Fields”, only the explicitally configured fields; in this case, AssistEdit will open the details page Fields Selection.

WARNING: although such a configuration is technically permitted, we suggest to not translate the fields that are part of the key of a table: this translation is made in a more complex way than other translations, and it is very time-consuming.