dBase

The dBase export and import are not available in Unicode installations.
Nested register structures cannot be mapped. Only the data associated with object types from one cabinet can be exported. Multi-fields and tables cannot be exported.

Column names have a maximum length of 11 characters in the 'dBaseIII' format, while a maximum of 255 characters are allowed in a cell. If you export longer data, they will be cropped to meet these requirements. These export limitations are also applicable to the 'dBaseIV' and 'dBaseV' formats.

The following names for the columns are used for export, instead of the field names because the column names are limited to 11 characters:

• The database name is used instead of the field name.

  The database name of a field is shown in enaio® editor.

• The name of a folder field has 'A_' prepended to it, the name of register field 'B_', and the name of a document field 'C_'.

• The string will be cropped if the name of a fixed field is longer than nine characters. The name is prepended with 'C_' if document data are exported, 'B_' if no document data but register data are exported, and 'A_' if only folder data are exported.

The columns 'INDEX' and 'ERRCODE' are automatically created. enaio® capture uses the following fields to manage data.

If you are exporting documents, the 'FILES' column will also be created. It contains the path and file name of the exported Document Files.

Example:

INDEX	ERRCODE	A_creator	A_FIELD0	B_FIELD1	C_FIELD0	FILES
		Basic parameters	Folder field	Register field	Document field	File name

A counter will be appended to the file name. If you export the data for multiple object types, one export file per object type will be created.

The OEM or ANSI encoding of dBase files is the same as the configured coding of the OLE DB provider.
This setting is managed using the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Xbase