Data transfer - data source / destination "OpenOffice Calc Spreadsheet"

Here you will find the instructions for configuring a data transfer if you have selected "OpenOffice Calc Spreadsheet" as the type of data source or type of data target in the first step when creating the connection.

Source / destination - OpenOffice spreadsheet file

Select the file and the time zone here. The file must be stored in a directory that the server has access to.

Click "Next".

OpenOffice spreadsheet settings

Select the table here.

File contains headers

With this setting, the first line is not imported but used as a column title for the field assignment.

Ignore blank lines

Suppresses the import of empty lines.

Cell area

No range

Uses the entire table.

Range specified by coordinates

Enter the number of the first and last column and row, respectively.

More information

Data transfer

Create connection

Target options

Transformation field mapping

Schedule

Subsequent jobs

Data transfer" application