Data Export/Import
Data Table Editor has embedded support for data exporting/importing from a number of commonly-used file formats.
Supported Formats
Extension | Description | Export Supported | Import Supported | Notes |
TBL | Iotellect Native Format | Yes | Yes | Data Table is encoded according to Data Table Encoding standard and written to a file. |
XML | Extensible Markup Language | Yes | Yes | Data Table is encoded according to Data Tables XML Encoding standard and written to a file. |
HTML | Hypertext Markup Language | Yes | No | Data Table is exported as an HTML-formatted table. |
CSV | Character Separated Values | Yes | Yes | User is prompted to specify a number of CSV encoding/decoding options before export/import takes place. |
XLS | Microsoft Excel | Yes | No | Data Table is exported as an Microsoft Excel formatted table. |
Import
During import operation, data read from a file is not inserted into Data Table Editor as-is. Instead, it is merged with the data currently contained in the Data Table Editor using a Data Table Smart Copy operation.
 | Properties import procedure cannot just override values contained in the editor with ones read from a Excel file because they may have different format. But in any case the best efforts are made to import as much data as possible. |
| Values of read-only fields are not imported. Therefore, prior to import you might need to remove records with read-only fields that need to be modified. |
When importing data, it is possible to choose what fields will be imported. You can only import fields that exist both in the imported Data Table and Data Table currently being edited, and are writable in the table being edited.
If a CSV file is being exported/imported, CSV encoding/decoding options will be requested during the operation.
Export
Before export operations, the user is prompted to specify a number of parameters to determine the format and content of the export:
Field | Type | Description |
|---|---|---|
File Extension | String | Dropdown menu, allowing the user to choose the format for the export file. |
Export Only Visible Fields | Boolean | When selected, only visible fields (columns) will be included in the export. Columns which the user has hidden, or which are hidden by the table view, will not be exported. |
Export Value Descriptions instead of Values | Boolean | Indicates that export results should contain descriptions of values visible in the Data Table Editor rather than raw values. Such descriptions could be:
|
File Name | String | Allows the user to indicate the name of the exported file. |
Was this page helpful?