|
Every database table has a control file that has the same name as the database table. The file extension is
.INI.
It is possible to use the control file to influence how database tables are imported and exported.
Import
Import
The general properties of the import file are described here.
FieldSeparator
|
Character that separates the individual fields from each other.
The default is ;.
|
DecimalSeparator
|
Decimal separator.
The default is ,.
|
TextSeparator
|
Character used to enclose text fields.
The default is ".
|
Headline
|
Number of headlines read during import.
The default is 0.
|
Export
The following parts of the INI file are read.
FieldSeparator
|
Character that separates the individual fields from each other.
The default is ;.
|
DecimalSeparator
|
Decimal separator.
The default is ,.
|
TextSeparator
|
Character used to enclose text fields.
The default is ".
|
Headline
|
0 or 1.
The default is 1.
|
ExportColumns
|
The names of the columns are listed here.
1
Name
..
N
n-th entry
|
ExportMap
|
Allows you to define column names for the file that deviate from those of the database table.
|
ExportDefaults
|
Allows you to define default values for columns. The default values are then always used when we are dealing with an additional column, or a value is not entered.
|
ExportLimits
|
Allows you to specify maximum values for the field length. If the field has the data type "numeric", it is possible to specify two lengths, otherwise only one. The field values are adapted to the specified lengths.
|
ExportTypes
|
It is possible to define the data type of a field here. If no data type is specified, all the fields will be regarded as text fields. Text fields are written with text separators into the export file. Currently only the type
"numeric" is available.
|
Example
Database: Example.btd
INI file: Example.ini
Contents of the INI file
[Export]
FieldSeparator=;
DecimalSeparator=,
TextSeparator="
HeadLine=1
[ExportColumns]
1=Name
2=Status
3=Additional field
4=Time
[ExportMap]
Name=SAP designation
Time=te
[ExportDefaults]
Additional field=xxx
[ExportLimits]
Time=3 3
[ExportTypes]
Time=Numeric
|
