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:
<importfile>
|
File name, if a file is imported. For example, the item number can be encrypted.
|
<importrequestid>
|
The RequestId, which is stored in the Import-Settings - Extended. (beas 9.2 PL: 01)
|
<import.[columnname]>
|
On a column of the source file directly, if a value has to be filled that is dependent on another column.
if <import.ite#bom#quantity> n> 5 then
setvar=value=A
end if
|
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
|