Data export

Clicking on the File tab at the top left of the program will open up the “Backstage” view with the “Export Data” item already selected.

There are currently two different ways that you can export data from Experimentor:

Export session summaries

This option will export a high-level summary list of every session into a single Microsoft Excel 2007 file (with the .xlsx file extension).

In this data export format, each session is a single row in the resulting spreadsheet, so the resulting data is basically identical to the high-level session summary information displayed on the application’s Dashboard.

Typically this form of data export happens so quickly that the “Export progress” dialog box shows complete almost immediately and your CSV file is ready for use.

Export all sessions to individual XML files

This export option will export very detailed information about each session into a collection of XML files.

XML is a powerful data-sharing file-format that nicely represents hierarchical data (such as sessions which contain trials which contain phases, etc.).  XML is a “plain text” file format, so it can be easily read by a variety of programs including Notepad.  However, Notepad++ is a much nicer tool and is also free.

In this data export format, each session is saved into a separate XML file.  Thus, clicking on this option asks you to choose a target folder rather than a file, because the data export will write out many files into the directory.

Because this data export option basically exports all of the data in the database this option takes much longer than the “Sessions summaries” export.  To speed up the data export, any existing session XML files in the selected directory will simply be skipped and not be recreated/overwritten.  

SQLite Studio

All Experimentor data is stored in a self-contained SQLite database, which means that you can access the Experimentor database directly – completely bypassing Experimentor!

This is by far the most powerful mechanism for accessing your data, but also the most complex.  You can use the powerful Structured Query Language (SQL) to build your own queries directly against the database to produce your own data extracts in any format you like.

One handy and free tool for doing this is the very elegant SQLite Studio which allows you to view the database schema, see the data inside the tables, and write and execute your own SQL queries against the database.  You can launch SQLite Studio against your currently open database from the Experimentor File menu.

You can learn more about SQL from the W3C and any number of other online SQL tutorials.

You may also find the Experimentor database schema diagram helpful as your build your queries.

More coming soon…

Experimentor is always interested in adding more ways to let you access your data.  Please drop us a line and let us know how you’d like us to export your data!