| General |
| |
|
File<string>: the name of the file to import. |
|
|
|
Table <unquoted string>: the name of the table to import the data. |
|
|
Start of Record <unquoted string>: the string that identifies the start of the record in the text file. This parameter is coded.
|
|
|
|
End of Record <unquoted string>: the string that identifies the start of the record in the text file. This parameter is coded. |
|
|
|
Field Separator <unquoted string>: the string separator for the elements between Start of Record and End of Record. This parameter is coded.
|
|
| Details |
|
| |
Abort on Error <unquoted string>: defines if the user wants to abort this action in case of error or not. The possible values of this parameter are: Yes, No or dynamic. |
| |
|
| |
Trim Strings <unquoted string>: this parameter defines if the user wants to trim the strings or not. The possible values of this parameter are: Yes, No or dynamic. For more information of this trim action please see here. This parameter allows the user to remove spaces at rigth of the readed value from file, only when the column's type is String. |
| |
|
| |
Replace Duplicates <unquoted string>: this parameter defines if the user wants to replace the duplicate values or not. The possible values of this parameter are: Yes, No or dynamic. |
|
|
Delete Source File <unquoted string>: this parameter defines if the user wants to delete the source file or not. The possible values of this parameter are: Yes, No or dynamic.
|
|
|
| Columns |
|
|
|
Column <unquoted string>: the name of the table column where the data is imported. |
|
|
Type <unquoted string>: the type of the data to be imported. The possible values are: String, numeric, Date, Time, Date Time or dynamic. |
|
|
| |
Mask <unquoted string>: defines if the user wants to apply a mask to the imported values. |
|
|
| |
Length <numeric>: defines the length of the imported data. |
| |
|
| |
Decimal Separator <string>: defines a string separator that is used to separate the numeric values. |
| |
|
| |
Decimal Part Length <numeric>: defines the length of the numeric part. |
|
|
| |
(...) |
| |
|
| |
Nth-Column <unquoted string>: the nth-name of the table column where the data is imported. |
| |
|
| |
Nth-Type <unquoted string>: the nth-type of the data to be imported. The possible values are: String, numeric, Date, Time, Date Time or dynamic. |
| |
|
| |
Nth-Mask <unquoted string>: defines if the user wants to apply a mask to the nth-imported values. |
| |
|
| |
Nth-Length <numeric>: defines the nth-length of the imported data. |
| |
|
| |
Nth-Decimal Separator <string>: defines a nth-string separator that is used to separate the numeric values. |
| |
|
| |
Nth-Decimal Part Length <numeric>: defines the nth-length of the numeric part. |
|
| Default Values |
|
|
|
Column <unquoted string>: name of the column that user wants to save a default value. |
|
|
|
Value <string> or <numeric>: the default value that the user wants to save. |
|
|
| |
(...) |
| |
|
|
Nth-Column <unquoted string>: name of the nth-column that user wants to save a default value. |
|
|
|
Nth-Value <string> or <numeric>: the nth-default value that the user wants to save. |
