The Import preferences panel is opened from menu . Here you can configure how empty values and null values are handled when they
are encountered in an imported database tables or Excel sheets. Also you can configure here
the format of date / time values that should be recognized in the imported database tables or
Excel sheets.
The XML Import Preferences Panel
The import preferences are the following:
- Create empty elements for empty values - If checked, an empty value
from a database column or from a text file will be imported as an empty element.
- Create empty elements for null values - If this checked, a null
value from a database column will be imported as an empty element.
- Add annotations for generated XML Schema - If checked, the
generated XML Schema will contain an annotation for each of the imported table's columns.
The documentation inside the annotation tag will contain the remarks of the database columns
(if available) and also information about the conversion between the column type and the
generated XML Schema type.
The section Date / Time Format specifies the format used for importing
date and time values from Excel spreadsheets or database tables and in the generated XML
schemas. The following format types are available:
- Unformatted - If checked, the date and time formats specific to the
database will be used for import. When importing data from Excel a string representation of
date or time values will be used. The type used in the generated XML Schema will be
xs:string.
- XML Schema date format - If checked, the XML Schema specific format
ISO8601 will be used for imported date / time data (yyyy-MM-dd'T'HH:mm:ss for
datetime, yyyy-MM-dd for date and
HH:mm:ss
for time). The types used in the generated XML Schema will be
xs:datetime, xs:date and xs:time.
- Custom format - If checked, the user can define a custom format for
timestamp, date, and time values or choose from predefined formats. A preview of the values
is presented when a format is used. The type used in the generated XML Schema is
xs:string.