File Import to Table

Kalipso - Form - Actions - Actions Description - Group Files - File Import to Table

Import a text file to a local table.

Action available for the following operating systems:

Parameters

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. This parameter allows the user to remove spaces at rigth of the readed value from file, only when the column's type is String.

For more information of this trim action please see the documentation about the function Trim.

• 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

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

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.

The actions File Open and File Close don't need to be used.