dBASE (DBF) User Attributes
Due to limitations in the dBASE specification, attributes are limited to 10 characters.
Readers: For information on the parameters in this dialog that are common to all readers, see:
Writers: For information on the parameters in this dialog that are common to all writers, see:
User attributes for this format are defined below.
Name | The name of the column. |
Type |
char Character types store fixed length strings. Width: Controls the maximum number of characters that can be stored by the field. No padding is required for strings shorter than this width. currency Visual FoxPro currency fields are supported. date This type stores date as character strings with the format YYYYMMDD. See Standard FME Date/Time Format. double FoxPro binary double fields are supported. integer FoxPro binary integer fields are supported. logical This type stores TRUE/FALSE data. Data read or written from and to such fields must always have a value of either true or false. memo Reading and writing of dBASE III, IV, and FoxPro memo fields is supported. null flags (not supported) Visual FoxPro null flags are not supported. FME will attempt to determine if a field should be missing/null and mark it accordingly; however, for binary integer/double, timestamp, and currency fields, this method is unreliable and may produce "ghost" data. Writing to Visual FoxPro may also cause previously null data to revert to a default value: 0 for binary integer/double, timestamp, and currency; or space-filled for other types. number This type stores single- and double-precision floating point values. Width: The total number of characters allocated to the field, including the decimal point and exponent. Precision: The number of characters reserved for decimal places, decimal, and exponent characters. timestamp Visual FoxPro timestamp fields are supported. varchar Visual FoxPro varchar fields are supported on read and will be converted to character on write. |