AF-Pos 8.0 Seite zurück  Index  Seite vor

Export Dialog

Export Dialog

z.B. in Listen - Adressenliste, Artikelliste, Maschinenliste
Icon
TastaturAlt+X



Export der aktuellen Liste.

Formate
MS-Excel
MS-Access
MS-Word
OpenOffice Writer
OpenOffice Calc
RTF
XML
DBF
PDF
Text-Datei
CSV-Excel
DIV-Datei
SYLK-Datei
LaTeX
SQL
Zwischenablage

Über Tools kann eine Konfiguration von Einstellungen gespeichert
und geladen werden.


Export Type

Formats. Use this tab to set the type of the result export file. According to the type you select, the file extension is changed automatically in the Destination file edit field.

Options. Use this tab to set general export options. If Go to the first record is checked, then export starts from the first table record. Set the number of first records to skip, if necessary, in the Skip ... record(s) field. Choose, if all the table records should be exported (Export all records, default) or set the limit of records to export in the Export only ... record(s) field.

Destination file - use this edit field to set the name of the export destination file. You can use button 'Select' to fasten this process.

Open file after export - check this option to view the result file in the appropriate program after export.

Print file after export - check this option to print the result file after export, using your default printer settings.

Save Template/Load Template - use these buttons to save/load to/from template file all export configuration settings, such as: export type, filename, exported field list, formats, and so on.

Fields

Use this tab to select fields for export. Available fields is a list of the source table fields, Exported fields list contains fields, selected for export. To move all the fields from one list to another click the double arrow buttons (>> or <<) or drag and drop fields from one list box into the other (use Shift or Ctrl to select multiple fields). To move only the selected fields click the single arrow buttons (> or <), drag and drop the field from one list box into the other or double-click the field.

Note, that if you don't select any fields for export, then all the table fields are exported default, except BLOBs.


Formats

Standard. Use this tab to define the formats of the exported fields. You can keep the default format values or edit some of them if necessary.
User. Using this tab you can also define your own formats for numeric and Date/Time fields These fields (if there are any in your table) are available in the drop-down list at the top of the panel. Choose one of them, then choose its format from another drop-down list and click 'Add'. The field and its format will be added to the list box below. To edit the field format select the field in the list box and click 'Edit'. To delete one click 'Delete'. To clear the list box click 'Clear'.

This tab is unavailable for DBF export type.

Header & Footer

Use this tab if you want some header or footer text to appear in the result document. You can define this text in the appropriate memo fields of this tab.
This tab is unavailable for XML and DBF export types.

Caption (& Width & Align)

Allow captions - if this option is checked (default), the column captions are included into the result file.

Use grid to set the captions of the result table columns. Default column captions correspond to the database field names.

For some of the export types columns 'Width' and/or 'Align' are also available. In the 'Align' column you can select the text alignment for the certain column (Left, Right or Center). In the 'Width' column you can set the numeric value, defining the width of the result column.

This tab is unavailable for DBF export type.

Specific Options

Excel Options. This tab is available only if the chosen export type is MS Excel.

Data Format. This tab allows you to define a specific format for each data column, header, footer, column captions and aggregate functions. Select the field from the Fields list or select an element of the result Excel sheet (captions, footer, etc.) from the Options list and set its font, borders and fill. All the changes you make are displayed in the sample cell. For data columns you can also define aggregate functions ('Aggregate' tab): AVG (average value), MAX (maximum value), SUM (sum of the values), and MIN (minimum value). The aggregate function is added to the cell under the column. Click 'Reset item' to reset all format setting for the current item, click 'Reset all' to reset format settings for all items.

You can also define repeating styles for data columns or rows on the Styles tab. Click button  to add a style and set its format. After you define all the styles, set the strip style to 'Col' or 'Row' (on this depends if these styles will be applied to columns or rows). To delete a style, use button . To load and save styles use buttons  and .
Advanced. This tab allows you to define headers and footers of the result document pages (the default page footer is page number) and the sheet title.

Word/RTF Options. This tab is available only if the chosen export type is MS Word or RTF. It allows you to define properties of the default document font, row header font and page orientation (portrait or landscape).

HTML Options. This tab is available only if the chosen export type is HTML.

Preview. This tab allows you to define the colors of various elements of the result HTML document, such as: default font color, header font color, table font color, background colors and link colors. To change the color of some element just click this element and set the color you need. You can also use various HTML templates to make the result document look in the way you need. Select a template from the Template drop-down list or click 'Load template' to browse for templates. If you have changed some HTML elements manually and you like the result, you can save it as a template for future using by clicking 'Save as template' button.

Basic. This tab allows you to define the title of the result document and set the mode of the CSS (Cascade Style Sheets) using. The default CSS using is internal, but you can set to external and define your own CSS file in the CSS file name edit field.
         Advanced. On the Body options panel you can set the default font name of the result document and set the document background. In the Advanced attributes edit field you can define any attribute values for the HTML tag <BODY>.

The Table options panel allows you to define such attributed as Cell padding, Cell Spacing and Border. In the Advanced attributes edit field you can define any attribute values for the HTML tag <TABLE>.
        The Multi-file export panel allows you to export your data not to a single HTML document, but to a number of documents. Check option Use multi-file export to enable this mode and define the maximum number of records in each result file in the appropriate edit field.

ASCII Options. This tab is available only if the chosen export type is Text File or CSV.

TXT Options. If option Calculate column width is checked (default), then width of each column in the result file is set automatically depending on the maximum number of symbols in the column cells. Spacing sets the distance (in symbols) between the data columns in the result file.
CSV Options. If option Quote Strings is checked, then all the strings are exported as quotations, and the apostrophes are doubled. Comma defines the symbol, delimiting columns in the result file.

XML Options. This tab is available only if the chosen export type is XML. It allows you to set the encoding of the result XML document and define if the result document will be standalone by checking/unchecking Standalone option.

When you are done, click the 'Start Export' button to begin export or click 'Cancel' to cancel export.

  © 2017 Ralf Stegemann. Seite vor Index Seite zurück