Call

Symbol

This opens a function. Functions can be internal functions or functions from a Assembly.

All the parameters necessary for the function can be defined in the Call area.

The available parameters will depend on the selected function.

'Input help' area

Source alias

This is the database alias for the data source specified in the main node (transfer).

 

Changes made here will be reflected in the Transfer main node.

Target alias

The database alias in the main node (Transfer) for the target is shown here.

 

Changes made here will be reflected in the Transfer main node.

'Call' area

Function

Select a function here. Internal functions and functions from an Assembly are available.

Internal functions

The following internal functions are available in the Transfer for the Call function:

Replace.CaseInsensitive

Find and replace text without regard to character case (case insensitive).

The necessary values (varReplace, varSearch and varText) can be defined using constants, fields, etc. and then saved in a variable.

varReplace

A variable is expected here in which the text for replacement is saved. The variable can be filled using a field, constant, etc.

varSearch

A variable is expected here in which the text to be searched for is saved. The variable can be filled using a field, constant, etc.

varText

Enter the variable here in which the field name for the search has been stored.

Replace.CaseSensitive

Find and replace text taking account of the character case (case sensitive).

The necessary values (varReplace, varSearch and varText) can be defined using constants, fields, etc. and then saved in a variable.

varReplace

A variable is expected here in which the text for replacement is saved. The variable can be filled using a field, constant, etc.

varSearch

A variable is expected here in which the text to be searched for is saved. The variable can be filled using a field, constant, etc.

varText

Enter the variable here in which the field name for the search has been stored.

Replace.RegularExpression

Find and replace text. Regular expressions (RegEx) can be used.

The regular expressions can be specified through a constant and then saved in a variable. The variable can then be accessed in the function.

varReplace

A variable is expected here in which the text for replacement is saved. The variable can be filled using a field, constant, etc.

varSearch

A variable is expected here in which the regular expression is saved. The variable can be filled using a field, constant, etc.

 

Regular expressions (RegEx)

You can find information about regular expressions under https://www.regular-expressions.info

varText

Enter the variable here in which the field name for the search has been stored.

Assembly functions (ESTransfer.ESO.dll)

If the Assembly ESTransfer.ESO.dll is embedded in the Transfer, the following functions will be available.

ESoffice.GetNetNum

Draws the next free number from an esoffice number range.

ESoffice.GetImage

A directory path or an  URL can be applied to this function by means of a variable.

The ESOffice.GetImage function opens the images and converts the images (possible formats: jpg, jpeg, png, bmp, tif) into a database format valid for esoffice and enables import of these images.

ESoffice.ExtractPNG

You can convert images saved in the esoffice database in esDBImage format into PNG image files (*.png) that can be read by all systems.

Also see esDBImage to png using Transfer