Skip to main content Skip to complementary content

Setting advanced options

In the Advanced tab, the following options are available.

Advanced tab settings
Option Description

File preprocessing command

The source file must be in delimited text format. If your source files (Full Load and/or Change Files) are not in delimited text format, you can use your own program to convert them to the required format.

Before the Full Load task starts, the program will be executed on Location of full load data file(s). Then, during Change Processing, it will be executed on the files specified in the Change File location.

The command should be specified as in the following example:

c:\temp\files\convertfile.exe

Information note

The path is only necessary if the conversion program’s location is not defined in the "Path" system variable

For a detailed explanation, see Setting up a File Pre-processing Command.

Check for changes every

Specify how often to check the Change Files for updates.

Change Processing Cleanup

Select one of the following cleanup options to determine what Replicate should do with the processed Change Files/Reference Files:

  • Do nothing - to leave the file(s) in the original location.
  • Delete files - to delete the file(s) from the disk.
  • Archive files to folder - to archive the file(s) to the specified location.

    Information note

    In the case of Reference Files, the Delete files and Archive files to folder operations will only be performed if there are multiple reference files.

Setting up a File Pre-processing Command

Your program will be executed on each of the input files, and should accept the following parameters:

  • The location of the input file(s) (as specified in the Location of full load data file(s) and/or the Change File location)
  • The full path of the output file

    The output file(s) will be written to the following location:

    PRODUCT_INSTALLATION\data\tasks\TASK_NAME\trans_files\OUTPUT_FILE_NAME(s)

    Where OUTPUT_FILE_NAME(s) are determined by your program.

Example:

Let's assume the following:

  • The following files reside in the Change File location:

    c:\temp\cdc\table1.txt

    c:\temp\cdc\table2.txt

  • The following program is specified in the File preprocessing command field:

    c:\temp\convertfile.exe

  • Both the Full Load and Apply Changes replication options are enabled.

In such a scenario, Replicate will execute the following commands in sequence:

Before Full Load Starts:

c:\temp\convertfile.exe c:\temp\fl\table1.csv <PRODUCT_INSTALLATION>\data\tasks\TASK_NAME\trans_files\table1.csv

c:\temp\convertfile.exe c:\temp\fl\table2.csv <PRODUCT_INSTALLATION>\data\tasks\TASK_NAME\trans_files\table2.csv

During Change Processing:

c:\temp\convertfile.exe c:\tempcdc\table1.txt <PRODUCT_INSTALLATION>\data\tasks\TASK_NAME\trans_files\table1.txt

c:\temp\convertfile.exe c:\tempcdc\table2.txt <PRODUCT_INSTALLATION>\data\tasks\TASK_NAME\trans_files\table2.txt

Internal parameters

Internal parameters are parameters that are not exposed in the UI. You should only use them if instructed by Qlik Support.

To add internal Qlik Replicate parameters:

  1. Click the Internal Parameters link.

    The Internal Parameters dialog box opens.

  2. In the edit box, type the name of the parameter you need to add and then click it.
  3. The parameter is added to the table below the search box with its default value.
  4. Change the default value as required.
  5. To reset the parameter value to its default, click the "Restore default value" icon at the end of the row.

More options

These options are not exposed in the UI as they are only relevant to specific versions or environments. Consequently, do not set these options unless explicitly instructed to do so by Qlik Support or product documentation.

To set an option, simply copy the option into the Add feature name field and click Add. Then set the value or enable the option according to the instructions you received.

Settings summary

You can view a summary of your settings by clicking the Setting Summary link. This is useful if you need to send a summary of your settings to Qlik Support.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!