Enter a name for the file type. The 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 SQLMessenger's database, which is a PostgreSQL database installed on your local machine. The database is automatically installed when you install SQLMessenger, and SQLMessenger uses this database to store data.

Enter the name of the sheet be imported into database.

The sheet name is case-insensitive and must be unique within the same file.

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 same 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.

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 same 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.

Click the button on the right side of the text box to configure the column names in the file. Column names are case-insensitive. For detailed configuration instructions, click here.

If the “Columns to be Imported” list is defined and both “The row at the ‘Start Row Index’ is the header row” and “Require all columns to be present in the data file” options are checked, the system will verify that all column names listed in “Columns to be Imported” exist in the file when processing this type of file. If any column names are missing, the system will stop processing the file and display an error.

You can specify the data type for each column as Text, DateTime, or Numeric. The system will apply different conversions based on the specified data type during file processing.

If the “Columns to be Imported” list is not defined, the system will import all data starting from the column indicated by Start Column Index in the row indicated by Start Row Index, treating the first row of the sheet as the column names.

Specifies the starting row for reading data, using a 1-based index. The system will begin reading data from this row in the file.

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

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

If this option is checked, the system will skip the row at the Start Row Index and begin 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 contents of the cells in the Start Row Index row as column headers.

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

If this option is checked, the system will verify that all columns listed in Columns to be Imported are present in the data file before importing. If any columns are missing, the system will stop the import process and display an error.

Specifies the starting column for reading data, using a 1-based index. The system will begin reading data from this column.

If this field is left blank, 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 this field. Instead, it will use the index of the first column in Columns to be Imported as the starting column and read data from there onward.

Specifies the field separator for text files.

This setting applies only to text files.

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

If this field is left blank, the system will use a comma (,) as the field separator.

Specifies the character set for text files.

This setting applies only to text files.

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

Specifies the name of the task to be executed after a 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.

If this field is left blank, no task will be executed after the file is imported.

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

If this field is left blank, files 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.