Supported files
Supported file types The following file types are supported by the latest version of Omniscope for import and/or export of cell data. Also see: Supported databases (includes OLAP) Supported feeds Extension | Description and notes | Capability | IOK | Omniscope file containing data, tabs, views, settings, formulae, etc. Can be considered a "project file" or a "report". Unless secured otherwise, can be opened and explored in the free Viewer. | Open, save | IOM | As per IOK, but cannot be opened in the free Viewer. Requires a licensed edition of Omniscope Desktop or Server to open. | Open, save | CSV, TSV, etc. | Delimited text file, such as comma, semicolon or tab separated. By default, CSV files are imported following the same rules regarding separators, delimiters and special character escaping as Excel. Any text file containing delimited data, regardless of filename extension, can be configured for import. | Import, export | TXT, etc. | Fixed-width text file, with columns of data padded with spaces. Any text file containing fixed-width data, regardless of filename extension, can be configured for import. | Import, export | XML, etc. | XML text file, with data in the Visokio XML data schema. XML data in other schemas can be converted into the Visokio schema using an appropriate XSL transformation file, which Omniscope can be configured to apply for you, allowing other schemas effectively to be imported directly. XSL translation is only supported for importing. When exporting, only the Visokio XML data schema is supported. Any text file containing XML data in the correct schema, regardless of filename extension, can be configured for import. | Import, export | XLS, XLSX, XLSM, XLSB | Microsoft Excel workbook containing multiple worksheets (supporting Excel versions 97 and higher). Omniscope supports importing a single worksheet, or multiple worksheets appended together. Only the displayed values are imported; styles and formulae are not imported. | Import, export | MDB, ACCDB | Microsoft Access database file containing multiple tables. Omniscope supports importing either single tables or multiple tables using either an SQL join or by merging multiple Access sources in Omniscope. In Omniscope 2.6, MDB/ACCDB files require Microsoft Access to be installed (version 2007 or greater for ACCDB files), and require Omniscope to be running under the same architecture as Microsoft Access (so if Omniscope is 32-bit, Access must be 32-bit; if Omniscope is 64-bit, Access must be 64-bit). In Omniscope 2.7, MDB and ACCDB files can be imported without any requirement to have Microsoft Access installed, so is available on 32-bit and 64-bit Windows, and Mac. Omniscope treats MDB and ACCDB files as database connections, allowing arbitrary SQL on import, and exporting to a single table using insert/update. Other supported databases | Import, export (via SQL SELECT, INSERT/UPDATE) | PST, OST | Microsoft Outlook data file ("Personal Storage Table" / "Off-line Storage Table" / Personal Folder File) containing emails, notes, calendar entries, contacts, etc. | Import | QPW | Quattro Pro spreadsheet | Import, export | LOG | Web Access log containing a web server's HTTP request access log data, in either the common or extended log formats. | Import |
|