Data transfer - Data source / destination "Text file"

Here you will find the instructions for configuring a data transfer if you selected "Text file" as the type of data source or type of data destination in the first step when creating the connection. Here you will find the requirements for using text files in a data transfer.

Source / destination - text file

A click on "Search" opens a dialog in which the source file or the target path of the export file can be selected. In both cases, the file must be stored in a directory released for the server.

Column separator

Select the character with which the columns in the text file should be separated.

Field separator

Select the character that denotes the beginning and end of the individual entries in the text file.

File contains headers

The first line is not imported here, but used as a column title for the field assignment.

Encoding

You can select the encoding used in the text file.

Time zone

The time zone can be changed here if date values are contained in the text file.

Click "Next".

Source / destination - text file

The column names and data types from the source file are displayed here. The data types can also be changed here. Click on a cell in the "Data type" column to display a selection list for the data types.

Click "Next" to complete the configuration.

Requirements

Text files used as a source or target in the data transfer must have the following format:

  • The names of the data fields have to be in the first row, separated by semicolons

  • A semicolon at the end of the row is not allowed. The semicolon can be replaced with any other separator when it is defined in ""schema.ini""

  • The data is in the subsequent lines. The order of the fields must correspond to that of the first row.

If you want to export data from Intrexx to a text file, you must first create a configuration file. In a text editor (Notepad, for example), create a text file named ""schema.ini"" in ANSI format. For each file in this directory, create a section that describes the properties of the text file as below:

            [table.txt]
ColNameHeader=True
Format=Delimited(;)
MaxScanRows=25
CharacterSet=ANSI
Col1=Feld1 Char
Col2=Feld2 Integer
Col3=Feld3 Float

Line 1: File name in square brackets (mandatory)
Row 2: Column headers present (True) or not (False) (mandatory)
Line 3: Separator (mandatory)
Line 4: Number of lines that are read to determine the data type of the fields
Line 5: Character set
Lines 6 to 8: Names and data types of the individual columns. Permitted values are:

  • Bit

  • Byte

  • Char

  • Currency

  • Date

  • Float

  • Integer

  • Longchar

  • Short

  • Single

For date data types, use the formats:

  • dd-mmm-yy

  • mm-dd-yy

  • mmm-dd-yy

  • yyyy-mm-dd

  • yyyy-mm-dd

Here, mm represents the month as a number, mmm represents the month name. A field that only contains numbers with leading zeros and is to be imported into Intrexx with these must be defined as a char. When importing from a text file (*.txt, *.csv) via the OLEDB interface into an Intrexx application, leading zeros from a field filled only with numbers are not imported even if the assigned target field in the application has the data type "String". This behavior of the OLEDB interface cannot be influenced by Intrexx. It automatically deals with fields filled only with numbers as integer fields, but there is also a configuration file named ""schema.ini"" in the same directory as the text file, which defines the data type.

Further information can be found here.

Transformation - Field selection

If you have selected the "Text file" type as the destination in the data transfer configuration, the "Transformation - Field selection" dialog appears. All information on this dialog can be found here.

More information

Data transfer

Create connection

Target options

Transformation field mapping

Schedule

Subsequent jobs

Data transfer" application