Creating Import Scripts and Integration Scripts

To perform actions that cannot be performed by predefined import expressions, you create import scripts. Import scripts are entered in the Expression column of the field to which they apply.

Rather than importing text files, you can build integration scripts to import ledger data directly from ODBC-compliant data sources. Integration scripts can be run only by selecting Script from the File Type column of the Import Group grid (top grid) of the Import Formats screen

  To create import scripts or integration scripts:

  1. In lower grid of the Import Formats screen, in the preferred field, double-click the Expression column.

  2. Select Build Script.

    The New Script dialog box is displayed.

  3. Click New.

  4. From Script Type, select Import (Data Pump) (to create an import script) or Import (Integration) (to create an integration script).

  5. Enter a name for the script.

    Note:

    Custom scripts do not support multibyte or extended ASCII characters in the script name or in the script parameters.

  6. Click OK.

    Script Editor is displayed.

  7. Create the script.

  8. Click Save.

  9. Return to the Import Formats screen, and follow the instructions in Adding Import Expressions to add the script to the Expression column.