To work with the tool in Foresight Analytics Platform 10, use the new interface.

In this article:

Basic Properties

Export Options

Error Handling

Edit Input

Edit Output

Excel

The Excel connector is an object that is used to export data to Microsoft Excel files (*.xls or *.xlsx).

After adding the connector to the ETL task working area, set basic properties and export options. The connector input and output can also be edited, and error handling parameters can also be set.

Basic Properties

The basic properties are used to set object name, identifier and comment.

Export Options

The Export Options page is used to specify a file for data export.

Export to XLS file

Export to XLSX file

Error Handling

The Error Handling page determines behavior of the object on error occurrence.

NOTE. The page is common for all data consumer connectors, except for XML, Text, JSON and User Consumer. Consider setting up error handling parameters using the example of the Repository data consumer editing wizard.

Set parameters:

A file that is used to store skipped records can be specified on selecting the Skip Only Incorrect Records or Skip All Records In One Transaction actions.

NOTE. If on export there were no skipped records, the text "??" is written to the file. This means an empty Unicode file with the Win encoding.

    • Rows separator: {Carriage Return}{Line Feed}.

    • Fields separator: ; (semicolon).

    • Text qualifier: "" (double quotes).

NOTE. The following file name is formed by default: <consumer identifier>_skipped records.csv.

Each skipped record is registered in the ETL log as a single record containing the number of skipped record, error text and error field information. If all records within transaction are skipped because of one error record, the log displays this reason in the Description field.

NOTE. If it is not required to distribute records by transaction, specify the number of records equal to zero. In this case, all records from the source are loaded one by one. This setting is applied only if the Stop Task Calculation or Skip Only Incorrect Records actions are selected in the Action Executed on Error Occurrence drop-down list.

After executing the operations, the export object behavior is specified in case of error situations on data loading.

Edit Input

To set a list of fields and link to input, use the Edit Input page.

The following parameters are available on the page:

Identifier

Link to object

Fields

NOTE. The screenshot represents edit wizard for the Repository data consumer.

Edit Output

The Edit Output page enables the user to set links to the consumer object, to which data on executing ETL tasks is loaded.

NOTE. The page is common to all data connectors and transformers, except for the Split and User Algorithm transformers. Consider setting up a list of fields and output links using the example of the Repository data source editing wizard.

The following settings are available on the page:

Identifier

Link to object

Fields

See also:

Getting Started with the ETL Task Tool in the Web Application | Data Consumers