ExportXLS
Space shortcuts
Space Tools

Versions Compared

Key

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

...

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

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.

Version 3.2

  • 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.

Version 3.0

  • Added export of CSV files.
  • Improved tabulating of observations: all observations of a patient are now tabulated (not only the first one).
  • Added flexible formatting of the output table.
  • Added resolving of concept (and modifier) codes to export their denotation.
  • Added inclusion of ontology path of concepts.
  • Added replacing patient IDs by numbers (independently from i2b2 features)
  • Added more flexible selection of demographic data.
  • Added activity feedback for long running queries.
  • Added re-querying of automatically paged results.
  • Added possibility to page queries manually.

...

  • The initial version of 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 following major revision (v2.0) was released as a collaboration between the University of Massachusetts Medical School, Worcester, USA (S. Wayne Chan, Rajani Sadasivam, Thomas Houston, & the rest of the BMI-Core), and the Universita' di Pavia, Italy (Mauro Bucalo).
  • The latest version (v3Version 3.0 ) underwent heavy re-engineering and optimizations, together with the introduction of many new features. It was implemented by Axel Newe, Friedrich Alexander University Erlangen-Nuremberg, Germany with strong support from Wayne Chan and Mauro Bucalo (see above).
  • Version 3.2 added GUI improvements & minor bug fixes, per local requests, and for internal usages only; in the University of Massachusetts Medical School, Worcester, USA (S. Wayne Chan). 
  • Version 3.3 was a collaboration between the Hôpital Ambroise Paré, Boulogne, France (PARIS Nicolas), and University of Massachusetts Medical School, Worcester, USA (Wayne Chan).

Please don't hesitate to contact us concerning any questions or problems.  Thanks.

Copyright 2011-2013 2014 Universita' di Pavia,University of Massachusetts Medical School, Universita' di Pavia & Friedrich-Alexander-University Erlangen-Nuremberg, & Hôpital Ambroise Paré. 

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 7 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.