Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

This is the home of the Related Project - ExportXLS space.

About the ExportXLS Web Client Plugin


This plugin provides the following functions:

  1. Tabulates any selected Concepts (Ontology terms) relevant (observed on) to a set of selected Patients.
  2. Optionally displays relevant unidentified Patient data.
  3. Exports aforementioned tabulated data into an Excel spreadsheet file conveniently.


  1. Navigate to the "Specify Data" tab. Then, drag and drop a Patient Set and one or more Concepts (Ontology Term) onto the input boxes.
  2. Check or uncheck the Include Patient Data box if you want to include the relevant non-identifying information for each patient.
  3. Finally, click the "View Results" tab to view the table of the observations.

 Usage Case Suggestion

Currently the resulting table will only include the first observation from the selected concept (among the many possible if a selected concept is very broad) associated with each patient. In other words, if a selected concept contains multiple subconcepts (e.g. Circulatory system), the resulting row, for a patient, will contain only the first observation (e.g. Hypertensive disease), and ignore other observations (e.g. Ischemic heart diseasearterial vascular disease, etc.) that happen to be also observed in a particular patient.

Note that including all possible observations corresponding to a selected concept for a patient may result in rather complicated and confusing data, and may not be too useful.

It's therefore important to exercise prudence, and select finer-grained concepts that may not be related to multiple non-exclusive observations in patients. For example, while a patient set may be for Circulatory system, selecting several concepts like Hypertensive diseaseIschemic heart disease, and arterial vascular disease, etc. would result in more meaningful results than simply specifying a single concept of Circulatory system.

 Browser Compatibilities

  • This plugin works on the following browsers: Firefox (v.4.0.1), Chrome (v.12.0.742.122), Safari (v.5.0.5), and Internet Explorer (v.8.0 & v.9.0.1).
  • The i2b2 Web client itself does not work on the following browser: Opera (v.11.50).

 i2b2 version compatibilities

This version (v.2.0) of this plugin is compatible with i2b2 v.1.3-1.6.

 Version History of this Plugin


Initial release, for i2b2 v1.5. 
By Mauro Bucalo, Universita' di Pavia, Italy.

June 2011


Updated for i2b2 v1.6. 
By Mauro Bucalo, Universita' di Pavia, Italy.

Jan. 2012


Updated for i2b2 v1.3-1.6, Internet Explorer compatibilities; added flexible column exclusion, table title & caption, leading row count column, and other enhancements.
By Wayne Chan, Rajani Sadasivam, Thomas Houston, & the rest of the BMI-Core, University of Massachusetts Medical School, Worcester; and Mauro Bucalo, Universita' di Pavia, Italy.

Feb. 2012

 About Us

  • This plugin was created by Mauro Bucalo, Universita' di Pavia, Italy, June 2011; based on the ExamplePDO plugin, by Nick Benik & Griffin Weber, Sept. 2008.
  • The current version was released as a collaboration between the University of Massachusetts Medical School, Worcester (S. Wayne Chan, Rajani Sadasivam, Thomas Houston, & the rest of the BMI-Core), and the Universita' di Pavia, Italy (Mauro Bucalo).

Copyright 2012 University of Massachusetts Medical School & Universita' di Pavia. 

Terms of Use

This plugin is published under the GNU GPL v3 license

This software is distributed as a plugin to the i2b2 v1.3-1.6 webclient framework, and may be used free of charge. It is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

Recently Updated

Navigate space
  • No labels