<HTML><H3>Data Distribution Import Setup</H3></HTML>
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.