ExportXLS
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Navigate space

Page Tree Search
Page Tree

Column
 
Section
 

ExportXLS Web Client Plugin

...

  • Tabulates any selected concepts (ontology terms) relevant to (observed on) a set of selected patients.
  • Optionally uses smaller queries of patient subgroups (from the large patient set) iteratively, in place of one single large query of that huge patient set, to reduce risk of overwhelming the server.
  • Optionally uses selected subset of patients from a large patient set, to further reduce risk of overwhelming the server.
  • Provides feedbacks on current progress, elapsed time, and estimated remaining run time.
  • Provides notification & suggestion in cases of paging (query-subgrouping) by the server.
  • Provides termination, indication & suggestion (for recovery) when the server failed.
  • Provides detailed 'HELP' and 'HINT' dialogs in response to corresponding hotlinks strategically placed next to input fields that may need explanations or suggestion.
  • Offers different formats and levels of detail.
    • Optionally returns appropriate 'Observation BLOBs' when 'valuetype_cd' is 'B' and the user has the appropraite access right ("DATA_DEID").
  • Optionally replaces patient IDs with ascending numbers.
  • Optionally adds a selection of demographic patient details.
  • Optionally resolves concept codes and displays their denotation.
  • Optionally includes ontology path of concept codes.
  • Exports tabulated data into a CSV file  (delimiter may be specified, or defaulted to comma) file that can easily be used by Excel, SPSS and other statistics software.

It v.3.3 can be downloaded from the v.3.3 Download Page (at codeplex); v3.4 can be downloaded from the the v.3.4 Download Page (at GitHub)

 Instructions

Refer to this Installation Guide and this User's manual for details.

...

This version (v3.3) is compatible with i2b2 v.1.3-1.7, in particular v.1.7.0.7.

 Version History of this Plugin

1.0

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

June 2011

1.6

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

Jan. 2012

2.0

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, University of Massachusetts Medical School, Worcester, USA; and Mauro Bucalo, Universita' di Pavia, Italy.

Feb. 2012

3.0

Major upgrade; many new features (CSV export, detailed tabulating of all observations, formatting options, paged queries...), heavily re-engineered.
By Axel Newe, Friedrich Alexander University Erlangen-Nuremberg, Germany.

Feb. 2013

3.2

Added options of using a subset of a large patient set; fixed blank 'Birth year' bug; added 'locality' column per request; added more user-friendly feedback (estimated run-time, etc.), help & hint; added server failure termination & notification. (for UMass Med School internal use only)
By Wayne Chan, University of Massachusetts Medical School, Worcester, USA.

Nov. 2013

3.3

Added support of displaying observation blobs (for users with appropriate access) and added several useful columns to the output option of '1 row per observation (detailed, 1 column per observation detail)'.
By PARIS Nicolas, Hôpital Ambroise Paré, Boulogne, France; and Wayne Chan, University of Massachusetts Medical School, Worcester, USA.

Mar. 2014

3.4fixed compatibility issue with the new prototype.js v.1.7.2 (ships with webclient v1.7.0.7), other minor touch-ups, & fixed selected patient subset size and starting & ending patient numbers off by 1 problems. Also added option to select delimeter for CSV export file.
By Wayne Chan, Partners HealthCare.
Dec. 2015

Release Notes

Version 3.3

  • Optionally returns appropriate 'Observation BLOBs' when 'valuetype_cd' is 'B' and the user has the appropraite access right ("DATA_DEID"), for the '1 row per observation (detailed, 1 column per observation detail)' option of tabulation.

...