General Information

Under "Transfers" you can create/set up the needed transfers of data. One Transfer regards transfer of one table to another.

A Transfer contains the following fields:

Code:

Give the Transfer a unique ID. Use capital letters, underscore and numbers only.

The Transfer code determines the order that transfers are run when they are in a group. Its a very good idea to use a naming convention that keep semilar transfers listed together. We generally use names like "CUST01_NAV_2_CRM_ADD" and "CUST02_CRM_2_NAV_UPD" and "ITEM02_NAV_PRICES_2_CRM".

Description:

Fill in a descriptive text.

The text specified here will be written to the Activity Log and to the screen when running the Transfer from the command line prompt. Make the description as meaningful as possible, so that it is easy to see what the Transfer regards, and if the Transfer includes special features such as Gather, Scatter or a SubTransfer etc.

Group:

If you want the Transfer to be part of a group, you can by pressing the lookup button, choose which one.
 
Source:

Choose which Data Source data should be transferred from.
You can press the lookup button  to choose the Data Source from a list.

Destination:

Choose which Data Source data should be transferred to.
You can press the lookup button  to choose the Data Source from a list.

Source Table:

Specify which table data should be transferred from. When you start typing a table/object name here, rapidi will return a list of tables/objects that matches what you have typed so far.

Destination Table:

Specify which table data should be transferred to. When you start typing a table/object name here, rapidi will return a list of tables/objects that matches what you have typed so far.
 
Enabled:

You can enable or disable the Transfer.
If you mark this field, RapidiOnline will run the Transfer when instructed to do so (for example if the transfer is part of a group and the group is scheduled to run). If you leave the field unmarked, the Transfer will not run.

Update:

If you mark this field, RapidiOnline will update existing records in the destination table.

Add:

If you mark this field, RapidiOnline will add not-yet-existing records in the destination table.

Delete:

If you mark this field, RapidiOnline will delete the records in the destination table that does not exist in the source table any more.

Actions:

If you want to make use of the special feature "Actions" you mark this field.

Move:

By marking this field, RapidiOnline will copy all the records of the source table to the destination table and then automatically delete all records in the source table.

Delete All:

If you use Delete All, all the records of the destination table will be deleted first and then data will be transferred as specified within the Transfer.
Doing this on Transfers where you know that all records in the destination can be deleted, will greatly improve performance on most systems/databases during transfer, when combined with "Disable Dest. Lookup".

Auto Generate Key:

If the Data Source you want to transfer to/from is of the type Navision 3.56, Navision Financials, Navision Attain, MBS-Navision or MS Dynamics NAV, and if the data you want to transfer does not have a primary key, you can have RapidiOnline generate one.
When using Auto Generate Key, it is required that the last field in the primary key on the destination table in question is an Integer field.

The Auto Generate Key feature will then do a lookup in the Destination Table with filter set on all the fields in the primary key except the last field (so you need to have these fields as Dest. Filters or Table Link), then find the last record and take number from that as a starting number. It will by default increment by 1 and default start number is 0 (so that the first record will have number 1). The default start number and increment value can be changed in the Rapidi.CFG file for the RapidiConnector - please contact RapidiOnline Support for help with this.

Auto Generate Key can be used both on main transfers and on Sub-transfers. A lookup for the last (highest) number will be done each time the filters change - typically for each record when used on a main transfer and once every time a sub-transfers is running.

The Auto Generate Key feature can also be used with MS-SQL or MySQL - in this case a unique id (UUID) is generated.

Disable Dest. Lookup:

If you use "Delete All" or you know for sure that the records you are transferring does not exist in the destination table, you can mark "Disable Dest. lookup". This will greatly improve performance since RapidiOnline does not have to check if the records you are transferring exists in the destination table. On some systems/databases this will more than double the performance.

If you are using Salesforce.com as Destination, the Disable Dest. Lookup in combination with Update and Add will trigger the use of the UPSERT facility in Salesforce.com. This allows us to send all records to Salesforce.com and let Salesforce.com decide if its an existing record or a new record. This only works if the Table Link consists on just one field and if this field is marked as External ID in Salesforce.com. Please note that in the statistics in RapidiOnline all records sent like this will show as either Added or Updated - If its an existing record, it will count as an updated record.

Using this facility is greatly recommended whenever possible as it greatly reduces the number of API calls done to Salesforce.com.

All Fields:

By marking this field, all fields with the same name in both Source and Destination will be transferred.

Source Control:

If you want to transfer only the records that have been changed since the last transfer, you can make use of the feature, Source Control.

Actions:

If you want RapidiOnline to perform an update, add or delete on specific records, you can make use of the feature Actions.

Triggers:

Triggers in RapidiOnline are useful when it is necessary to perform some kind of data manipulation on the data that is about to be transferred or after the data has been transferred.