Reports Help - Configure Import Settings

Configure Import Settings

The configuration file common_params.conf in /conf directory provides parameters that Upload Tool uses while uploading data. These import settings help Zoho Reports properly understand the data being imported.

The following table lists the import parameters that can be configured in the common_params.conf file for uploading data from your local database.

Note:

You will not find all the below given parameters present in the configuration file (except mandatory ones). In case you do not find them, add them into the file and provide the required value as specified below.

Parameter Possible ValuesDescription
ZOHO_CREATE_TABLE
  • True
  • False

Optional
This parameter specifies whether to create the table or throw error, if the specified table does not exist in the database.

  • True - New table will be created in the specified database with the said name and then the data will be imported. If the table already exists in the database, then the data will be imported into it.
  • False - The data will be imported into the specified table. If the table does not exist in the specified database then it throws an error.

Default value is false.

LINES_TO_SEND 

Optional
Upload Tool splits the data into batches for uploading. This parameter specifies the number of row for each batch.
Default value is 10000.

ZOHO_THOUSAND_SEPARATOR
  • 0
  • 1
  • 2
  • 3

Optional
This parameter specifies the thousand separator for the numeric data.
The following is the list of parameter values and the corresponding thousand separator.

  • 0 - COMMA
  • 1 - DOT
  • 2 - SPACE
  • 3 - SINGLE QUOTE

Default is 0.

ZOHO_DECIMAL_SEPARATOR
  • 0
  • 1

Optional
This parameter specifies the decimal separator for the numeric data.

The following is the list of parameter values and the corresponding decimal separator.

  • 0 - DOT
  • 1 - COMMA

Default value is 0.

SET_EMPTY_FORNULL
  • True
  • False
This parameter is used to specify whether empty value or null should be added in Zoho Reports table when the uploaded database contains null value.
  • True -The null values in the local database server will be added as empty values in Zoho Reports table.
  • False - The null values in the local database server will be added as null in Zoho Reports table.
Default value is false.
ZOHO_CANOVERRIDE
  • True
  • False

Optional
In case another import is triggered when this import is in process you can use this parameter to specify whether the new import can override this import.

  • True - The tool will stop the current import process and overwrite the table with new import.
  • False - The tool will not disturb the current import process and will cancel the new import request.

Default value is false.

ZOHO_ON_IMPORT_ERROR
  • ABORT
  • SKIPROW
  • SETCOLUMNEMPTY

This parameter controls the action to be taken in case there is an error during import.

  • ABORT - In case of any error, the import will be aborted.
  • SKIPROW - In case of any error, the specific row(s) in which error occurred will be skipped and then continue importing the rest of the data.
  • SETCOLUMNEMPTY -. In case of any error, the value of the specific cell(s) in which error occurred will be set to empty and then continue importing the rest of the data.

Default value is SETCOLUMNEMPTY

ON_ERROR
  • 0
  • 1
Optional
This parameter is used to execute the next query, if the current query executed or upload is failed.
  • 0- Tool will abort if any error occur
  • 1- Next query will get executed and upload

Default value is 0

ZOHO_TRUNCATE_COLNAMES
  • TRUE
  • FALSE
Optional
In case the column names exceeds 100 character, then you can use this parameter to specify whether to truncate the column names to 100 character or to abort the uload.
  • TRUE- Tool will truncate the column names to 100 character
  • FALSE- Tool will abort

Default value is FALSE.