DBF
The DBF (DataBase File) is the format to store data and it is used as the standard way to store and pass information. The DBF file consist of a header section for describing the structure of the data in the file. There are several variations on the .dbf file structure.
Information
Only data can be exported to the DBF format, in other words only the components, which are placed on data bands.
Controlling Exports
The following elements can be specified in the Tag field to control export:
DataType [ : FieldLength [ : DecimalPartLength ] ],
ExportType : “FieldName”,
Column: “FieldName” “DataString”.
Several elements should be separated with the semicolon. The “DataType” element should be only one and should be placed first, other elements – if necessary.
Values of the “DataType” element are shown in the table below. If the data type is not set, then the string data type is taken by default. The “FieldLength” element sets fixed width of a data field. If the field width is not set, then the width is taken from the table. For the string type the default width is the longest string. The “DecimalPartLength” element sets the number of characters after comma. If it is not set, then the default number is taken.
| Data type | DBF data type (default size) | Description |
|---|---|---|
| int | Numeric (15 : 0) | Numeric |
| long | Numeric (25 : 0) | Numeric |
| float | Numeric (15 : 5) | Decimal |
| double | Numeric (20 : 10) | Decimal |
| string | Character (auto) | Text |
| date | Date (8) | Date |
Sample of using elements are shown in the table below.
| Type | Description |
|---|---|
| string : 25 | set the column width (25 characters) and cuts all long strings |
| float | converts decimal digit with the length 15 characters, 5 characters after comma |
| float :10 | converts decimal digit with the length 10 characters, 5 characters after comma |
| float :10 : 2 | converts decimal digit with the length 10 characters, 2 characters after comma |
| int :10 : 2 | converts integer digit with the length 10 characters; the second parameter is ignored |
Information
If the integer part of a digit is long and cannot be placed into the specified field, then it is cut, so data are lost. For example, if the write «-12345,678» in the «float:8:3» field, then the «2345,678» will be output.
The “ExportType” element indicates for which export the field name is set. The values can be used: “dbf”, “csv”, “xml”, “default”. The “FieldName” element indicates the field name in the file (for the DBF the is automatically cut up to 10 characters). The own name can be specified to each type of export. If the name for each export is not specified then the name for the “default” type is taken. For example:
DBF : “Describe” ; XML : “Description” ; default: “Default name”
The “Column” element indicates that the additional field is added to the exported data. The “FieldName” element indicates the name of a new field. The “DataRow” element indicates the content of a new field and can be expression. For example
Column: “SortField” “{Products.Categories.CategoryName}”
Export Options
The export parameters of the DBF export are described in the StiDbfExportSettings class. The description of all class properties are in the table below.
| Name | Type | Description |
|---|---|---|
| CodePage | StiDbfCodePages | a code page of a file; by default StiDbfCodePages.Default |