OpenData - How do I export Table Data from the OpenData dashboard?

Exporting Table Data

You can export data from a number of the DCiM EE tables, in a variety of formats. If you see the following at the bottom of a table, then the data in that table can be exported:

​

Click on an export option icon in the Export options menu attached to a table.

Note: In Internet Explorer 6, file extensions need to be changed to the file type you have chosen to export when saving, or opening, the exported file. Currently the extension shows as .action changing that to the correct extension i.e. .CSV will make the file readable.

• Related Articles

• Reports - Data Source String

  This is what the Report Data Source string should look like. Data Source=localhost;Initial Catalog=EEDB

• SQL Server - Resetting the Dashboard Admin User Password

  If the Admin user password is changed from default and lost you can reset it through SQL server. Reset Admin password to EE dashboard login 1) Open SQL Management Studio and run the following query. select * from eg.sysuser, 2) Look for the ...

• About OpenData Device Templates

  Each device has a set of attributes that can be monitored. OpenData comes with templates for monitoring the attributes for many manufacturers’ devices. Templates are the easiest and fastest way to start monitoring your devices. Modius templates ...

• What is the OpenData Collector?

  is the Windows based data collection application that provides communication with devices, normalizes the data and reports the data back to the main OpenData application. Communication with the main application database is encrypted. (Blowfish) ...

• OpenData - Services used by OpenData

  Installation of OpenData on a server will include three services: Apache Tomcat Modius - More info in this FAQ: What is Apache Tomcat? Event Manager Service Wrapper ModiusBroker OpenData also makes use of Microsoft SQL Server. This must be installed ...