› File processor › File parsing › Configure file parsing templates

Configure file parsing templates

Some file parsing/processing engine settings are shared for all file parsing templates within a project. You can change these settings, as required.

  1. Start Studio and select Tools > Project settings.

    The Project settings window appears.

  2. In the Configuration settings section, select an option to configure:

    • Parsing engine

    • Parsing manager

    • Template editor

  3. In the Parsing engine section, configure the following options, as applicable.

    • Export Batch Size: The number of records per loading block. The parser collects records and then the filling buffer block saves the results into the StagingDB.

    • Export Job Id Column Name: Column name for Job ID. Each run of file parser has a particular JobId.

    • Export Parent ID Column: When the data file has the hierarchical structure of different records, the parent ID links the child record to a parent record. The property defines the name of the column.

    • Export Primary Key Name: Column name for the Primary Key column (see the Database Mapping tab topic).

    • Export Record Id Column Name: Name of the column where the unique ID of every parsed record is stored.

    • Export String Length: Length of exported string.

  4. In the Parsing manager section, configure the following options, as required.

    • Staging Connection: Connection (data source) to use as the Staging DB.

  5. In the Template editor section, configure the following options, as required.

    • Folder Name for Templates: The name of folder where templates are stored (configured in Admin Console).

    • Preview String Count: Numbers of first lines in the file loads within Smart Preview.

    • Record Samples Count: Number of sample records on the Record tab.