Export and import tables

Besides viewing and editing of the tables, you can export it to other formats. Use Toolbar, "View, Export, Import" tab, "Export" group for exporting tables in other format.

Possible exporting formats are:

* CSV (comma-separated value) - text format where data is separated with comma. As usual, this format is used for data interchange, i.e. for importing to other software.

* PDF (Portable Document Format) - for publishing purposes

* Excel, xlsx

* HTML (HyperText Markup Language) - for publishing purposes

Note: These functions export only currently showed data, not complete table

One of effective ways of interchange data is use of Clipboard. This is the best way for limited volume of data (approximately up to 10 000 rows).

You can use copying data to Clipboard in table editing mode.

Also you can paste table data in table editing mode, or directly paste data to new table (Toolbar, Tables tab, Paste to new table button).

Export to Fixed-width text file

You can export table to Fixed-width text file. Use Operations window, "Script and Data generation" group, "Fixed width text file" button. Before exporting table to fixed-width text file, you will have to specify template of export, that includes name of fields and their width in exported file.

Export to XML

XML (eXtensible Markup Language) is an universal format for data interchange. Simply, XML is tree based data format based on text and tags. It allows to pack any data structure. However XML is not data model, so it (in contrast to Relational Databases) has limited instruments for data manipulation, such as XSLT - eXtensible Stylesheet Language Transformations.

Teide proposes exporting of XML file based on existing XML file as a template, that will be filled by values from database.

You can export data from tables to XML. Use Operations window, "XML and JSON" group, "XML <--> Database" button. Before exporting table to XML file, you will have to specify mapping of export. This mapping can be used for importing data from XML file to database as well.

The mapping includes base XML path, field, path to tag or attribute.

Import data from XML

You can import data from XML to tables. Use Operations window, "XML and JSON" group, "XML <--> Database" button. Two options are possible:

1) One-time import

Load XML file, from that you want load data to table; specify base (repeateable) XML tag; specify link between XML tags and fields of table; load data from XML.

2) Repeateable import

Select section, run import procedure by press "Import from XML".

Before importing table from XML file, you have to specify mapping of import.