Source - Target - Link

Displays the target field name. Mandatory columns are displayed in bold.

When you hover over the description, Beas displays more information about the field.

From table: Directly apply type from the source "Import column".

SQL instruction: Execution of the SQL-instruction, which was defined in the "Import column"

Default: The default value was applied directly

No: No transfer

Type table: Field name from the source table or field name in placeholder "<" and ">", for example <description1> <description2>. All default Beas placeholders as well as formatting information are available.

From the right-click menu a source field can be selected directly.

Type SQL: Select-instruction. The field name of the source table may be inserted as placeholder.

Type default: The here entered text, will be inserted directly as a number.

Note on data types:

Numbers

In script, all values are used with the Windows regional settings.

Germany: 300,25

USA: 300.25

It is important to ensure, that these values match the Windows regional settings.

Date

Date should be in the following format:

yyyy/mm/dd

or

yyyy/mm/dd hh:mm

otherwise the import can be incorrect.

Date

yyyy = Year, four digits

mm = Month, two digits

dd = Day, two digits

Time

hh = Hours two digits, 24h format

mm = Minutes two digits
 
If date or number not available in correct format, you can use the conversion field to convert the value

The max. length of a character string can be indicated. Value 0 indicates that there is no maximum value.

Setting the maximum length is usually not necessary, because Beas controls these automatically:

Automatic control:

If the target field is a mandatory field, the maximum length is exceeded, the data row is not applied and an error is reported. For all other fields the exceeding length is cut off.

Beas script can be included, which can change or check the source.

The transfer value is in the value variable and can also be changed.

setvar=value=<today,yyyy/mm/dd>  Returns the date.

If the field is selected and you double-click on an item in "table origin", Beas inserts the field in the conversion field.

The assistant and extended editor helps to define the script.

All existing variables or window information (of the window from which the import is accessed) can be used.

Special variables:

Example: Convert a value

Converts the source to "M", when this is "Y", otherwise this is not changed.

if <value> = Y then
  setvar=value=M
end if

The return value true/false can determine, whether the data row should be applied.

Example: Replace dot with comma

Regional settings: comma is the separator:

tools=globalreplace=value=.=,

10.5 is converted to 10,5

Regional setting: dot is the separator, but at import a comma should be used:

tools=globalreplace=value=,=.

Example: Cancel in case of a certain value

Stops the import, if the value begins with 1:

if <value,left 1> = 1 then
  return failure
end if

All source fields can be accessed. For this, the "<import.[feldname]>" placeholder is used.

Example: Determine item group

The "itemgroup" source field is available.

Material group should be "100", if "item group" is 50, otherwise material group 200 should be used.

To achieve this enter the following in "Material group" field at the test script:

if <import.itemgroup> = 50 then
  setvar=value=100
else
  setvar=value=200
end if