Enter the name of the file type. File Type Name is case-insensitive and must be unique.

Choose a file processing mode. The system will process the files according to the method you specify.

File Processing Mode includes the following options:

"Import the file into the database and copy it to the specified directory": The system will import the file into the PostgreSQL database and copy the file to the directory specified in "Copy Processed Files To".

"Only import the file into the database":The system will only import the file data into the PostgreSQL database for storage.

"Only copy the file to the specified directory":The system will only copy the file to the directory specified in "Copy Processed Files To."

Note: The "Import the file into the database" option is only valid for text files and spreadsheet files (*.xlsx and *.xlsm). Other types of files cannot be imported into the database. The imported data will be stored in your SQLMessenger's PostgreSQL database.

Enter the name of the Sheet to be imported into the database.

Sheet Name is case-insensitive and must be unique.

You only need to set either the Sheet Name or the Sheet Index.

If both the Sheet Name and Sheet Index are set, the Sheet Name will take precedence.

If neither the Sheet Name nor the Sheet Index is set, the system will import data from the first sheet of the file.

This option is not valid for text files.

Enter the 1-based index number of the sheet in the spreadsheet to be imported into the database.

Sheet Name is case-insensitive and must be unique.

You only need to set either the Sheet Name or the Sheet Index.

If both the Sheet Name and Sheet Index are set, the Sheet Name will take precedence.

If neither the Sheet Name nor the Sheet Index is set, the system will default to importing data from the first sheet of the file.

This option is not valid for text files.

Click the button on the right side of the text box to configure the column names in the file. Column names are case-insensitive.

If the "Columns to be Imported" list is set and the "The row at the 'Start Row Index' is the header row" and "Require all columns to be present in data file" option are checked, the system will check whether all the column names configured in the "Columns to be Imported" list appear when processing this type of file. If any column names are missing, the system will stop processing the file and report an error.

You can specify the data type for each column, which can be "Text," "DateTime," or "Numeric." The system will perform different conversions based on the data type of the column during file processing.

If the "Columns to be Imported" list is not set, the system will import all data from the columns after the Start Column Index in the Start Row Index row of the sheet, treating the contents of the first row of the sheet as column names.

Set the starting row for reading data, with a 1-based index. The system will start reading data from this row in the file.

If this field is empty, the system will start reading from the first row.

Indicate whether the row at the Start Row Index in this file is a header row.

If this option is checked, the system will skip the row at the Start Row Index and start reading data from the next row.

If this option is checked and the "Columns to be Imported" field is left blank, the system will use the content of cells read from the "Start Row Index" as column headers.

If the "Columns to be Imported" field is set and the "The row at the 'Start Row Index' is the header row" option is checked, the "Start Column Index" field will be ignored. The system will use the index of the first column in the "Columns to be Imported" as the Start Column Index and read data from this column onward.

If this option is checked, the system will check whether all the data columns configured in "Columns to be Imported" are present in the data file before importing. If any data columns are missing, the system will stop the import process and report an error.

Set the starting column for reading data using a 1-based index. The system will start reading data from this column.

If this field is empty, the system will start reading from the first column.

If the "Columns to be Imported" field is set and the "The row at the 'Start Row Index' is the header row" option is checked, the system will ignore the "Start Column Index" field, use the index of the first column in the "Columns to be Imported" as the "Start Column Index", and read data from this column onward.

Enter the field separator for text file.

This setting is only valid for text files.

The field separator must be a single character and cannot be a double quotation mark.

If this field is left empty, the system will use the "," as the field separator.

Set the character set for text file.

This setting is only valid for text files.

If this field is left empty, the system will use UTF-8 encoding to process the text file.

Enter the name of the task to be executed after the file is successfully imported into the database. Task names are case-insensitive.

When the system initiates this task, it will pass the file's file_id as a parameter to the task to be executed.

If this field is empty, no task will be executed after the file is successfully imported.

Set a directory where the system will copy and store files of this type after processing, e.g., D:\MyData .

If this field is left empty, the file will not be copied.

If the specified directory does not exist, the system will automatically create it.

Exports data as text. This is the default processing method.

Exports data as numbers in the spreadsheet. If the data contains non-numeric content, the export will fail.

Exports data as date and time in the spreadsheet. If the data contains non-date-time content, the export will fail.