The Script expression is used to pass field values to FDM script files. FDM uses Script to load and interpret a custom import script that runs against each line of the import file. Script files, which are based on the VB scripting language, enable end users to extend the power and flexibility of the FDM import process.
The following example shows the use of Script to round and remove decimals from values in the Amount field.
Note: | The script file must be located in the <application name>\Data\Scripts\Import\ subdirectory. The name of the script file and the name of the function that the file contains must be the same. This Script expression points to a script file that contains a custom function that is run against each line of the import file. The function accepts one argument, the value read for the field from the trial balance file, and returns the value of the argument after the function operates on it. |