TitleEngTAG 


<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.


{{DataDistributionSetupIN.png}}

**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 [[InFieldSelection|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.