| Export-Function |
With the export function data in a table or from a SQL-SELECT query can be exported in the following formats:
- CSV: Export as CSV file (comma-separated-values)
- ODBC-Datenquelle: Any table of a OBDC/BDE data source
- xBase-Tabelle: Export in Clipper, DBaseIII, Dbase IV or FoxPro2 table
- HTML: Save data as table in a HTML document
- XML: Freely selectable XML structure with definable elements and attributes
- Paradox-Tabelle
- SQL-Script: Generation of INSERT scripts
|
| 1st Step: General Parameters |
| In the first export step, general export parameters such as export format, output file, number of records to be exported, export fields and their sequence in the export file/ table are specified. |
| |
General Export Parameters |
| |
| 2nd Step: Format-Specific Parameters |
| |
CSV
- Date/time format: Formatting character sequence for the conversion of date/ time fields into a corresponding character sequence/string (date/time formatting)
- Float format: Formatting the character sequence for the conversion of floating point values into a corresponding character sequence/string (floating point formatting)
- Field-Separator: Field delimiter
- Field-Delimiter: Field delimiter character
- Column-Names: In the first row of the CSV file the column names are exported upon selection
- Encode Base64: All content of the exported field will be encoded in accordance with Base64
|
ODBC
- Destination: Selection of destination data source and destination table
- Export-Mode: Export mode for updating and/or appending new records
- Field-Links: Links the fields between source and destination table
| Select: Adds a new field link for the selected fields in 'Source' and 'Destination' |
| Select by Index: Adds new field links corresponding to the list index in 'Source' and 'Destination' |
| Select by Name: Adds new field links with matching field names for 'Source' and 'Destination' |
| Remove: Removes the selected link from the link list ('Links') |
| Open: Opens saved field-links |
| Save: Saves field-links |
|
xBase
- DBF-Type: Select the exporting xBase formats (Clipper, DBaseIII, DBaseIV, FoxPro2)
|
HTML
- Header: Beginning of HTML document till the first HTML table row with column headings
- Row-Template: Format template for a row of the HTML table. For every field to be exported a table column with a place holder in the form
<td><#fieldname></td> is set
- Footer: Foot of the HTML document with closing HTML tags
|
XML
- Date/time format: Formatting character sequence for the conversion of date/time fields into a corresponding character sequence/string (Date/time formatting)
- Float format: Formatting character sequence for the conversion of floating point values into a corresponding character sequence/string (Floating point formatting)
- Root-Element: Name of the first XML element
- Prolog: XML-Prolog
- Define XML: Call up editor for definition of the XML scheme
 |
 |
New element |
 |
New attribute for the selected element |
 |
Remove element or attribute |
 |
Shift above |
 |
Shift below |
 |
Save export link |
 |
Open export link |
 |
Remove field allocation to element or attribute |
| FieldName: Allocation of a field in the export dataset to the selected element or attribute |
| Name: Name of the selected element or attribute |
| CData: Save field contents in CData segment of the XML element |
| Base64: Encoding of the field contents according to Base64 |
| Constant: Constant value for the element/attribute from the input field |
|
In the example above the following XML code is generated from the export field-link:
|
 |
|
SQL-Script
- Date/time format: Formatting character sequence for the conversion of date/time fields into a corresponding character sequence/string (Date/time formatting)
- Float format: Formatting character sequence for the conversion of floating point values into a corresponding character sequence/string (Floating point formatting)
- Tablename: Table name of the INSERT script
- Postfix: Character sequence/string behind every INSERT statement
|
| 3rd Step: Data-Export |
| The 'Start!' button starts the corresponding export; when error-logging is activated a status report is compiled at the end of the export. |
| |
| Date Formats |
| c | Date in short date format |
| d | Day without leading zero |
| dd | Day with leading zero |
| ddd | Day as abbreviation |
| dddd | Day with complete name |
| ddddd | Date in short date format |
| dddddd | Date in long date format |
| m | Month without leading zero |
| mm | Month with leading zero |
| mmm | Month as abbreviation |
| mmmm | Month with complete name |
| yy | Year as two figure number |
| yyyy | Year as four figure number |
| h | Hour without leading zero |
| hh | Hour with leading zero |
| n | Minute without leading zero |
| nn | Minute with leading zero |
| s | Second without leading zero |
| ss | Second with leading zero |
| z | Mil-second without leading zero |
| zzz | Mil-second with leading zero |
| t | Time in short time format |
| tt | Time in long time format |
| am/pm | 'am' for time of day prior to 12 midday or 'pm' for time of day after 12 midday |
| a/p | 'a' for time of day prior to 12 midday or 'p' for time of day after 12 midday |
| ampm | Employs the symbols for 'am' and 'pm' installed in the system |
| / | Employs the date hyphen installed in the system |
| : | Employs the time hyphen installed in the system |
| 'xx'/"xx" | Characters enclosed in simple or double quotation marks have no influence on the formatting and are displayed as indicated |
|
| |
| Floating point formats |
| 0 | Place holder for a digit with "0" as default value for non-numerical characters |
| # | Place holder parameter/marker for a digit |
| . | Decimal hyphen |
| , | Thousand hyphen |
| E+, E-, e+, e- | Scientific notation |
| 'xx'/"xx" | Characters enclosed in simple or double quotation marks have no influence on the formatting and are displayed as indicated |
| ; | Separates segments for positive, negative and zero values |
|
| |
| << Back |