ExportXLS
Space shortcuts
Space Tools

Versions Compared

Old Version 7

changes.mady.by.user Unknown User (wayne.chan@umassmed.edu)

Saved on

compared with

New Version 8

changes.mady.by.user Unknown User (wayne.chan@umassmed.edu)

Saved on

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

 Feature Summary of v2.0

Based on feedbacks and input from other researchers, we have made the following updates, adjustments, enhancements, and fixes that may better serve everyone in the i2b2 community:

  1. Updated patient_list params to render this plugin compatible with i2b2 v1.3; and fixed a problem in the version for i2b2 v1.6 (it should now work on i2b2 v1.3-v1.6). 
  2. Added table title and caption to the resulting output table.
  3. Added new 1st column for patient row counts (no column title).
  4. Renamed the "StateCity" column title to "State/City".
  5. Removed any leading and trailing redundant "Zip codes" values from each state value string.
  6. Defaulted to using "concept_cd" for each selected concept entry if neither "tval_char" nor "nval_num" is available.
  7. Improved efficiencies.
  8. Facilitated the flexible dropping of any columns (that may contain data too sensitive or personal) from the resulting output table.
  9. Fixed the Internet Explorer (IE) hang problem.
  10. Fixed the missing "concept" columns on IE problem.
  11. Fixed the blank "patient_IDs" (when "Include Patient Date" not selected) on IE problem.
  12. Fixed table content getting cutoff on IE problem.
  13. Centered content in each table cell of the resulting output table.
  14. Added unique time-stamp to name of exported XLS file.
  15. Updated the description of this plugin displayed (in the available plugin list).
  16. Added more descriptions in the "Specify Data" and "Plugin Help" tab pages.
  17. Updated plugin category from "text" to "standard".

This new release is packed with installation guide and version supplementary note.

In addition to being downloadable from here, it is also available now from Google Codes (http://code.google.com/p/i2b2-export-xls-plugin/downloads/detail?name=ExportXLS-v2.0-20120217.zip&can=2&q=#makechanges).  It will also be available from the UMass Med School MICARD Downloads page (http://micard.umassmed.edu/downloads.php) by next Tuesday, 2/28.

 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).Please don't hesitate to contact us concerning any questions or problems.  Thanks.

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

...