This is the home of the Related Project - ExportXLS space.
ExportXLS Web Client Plugin
As of v.3.3, this plugin provides the following functions:
- 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 that can easily be used by Excel, SPSS and other statistics software.
It can be downloaded from the Download Page (at codeplex).
Please refer to the built-in help ("Plugin Help" tab) for concise information after installation.
Usage Case Suggestions
- Resolving concept/modifier codes is a very time consuming task. It is strongly recommended to enable this function only as a last step, after you are sure that the query itself is perfect.
- The default export CSV file encloses all data cells in quotation marks ("). This is necessary to export special characters like line breaks within a cell. However, some statistics software may get confused with the quotation marks. In this case, check the 'Exclude CSV Cell Delimiter (") Where Possible' box on the "Settings" tab to permit the writing of quotation marks where possible. Cells with special characters will still be enclosed in quotation marks, though... but it will be way less work to remove them manually than if it had to be done for every cell...
- If a query would return very large result sets, the server automatically pages the result. This causes a considerable delay that sometimes will fail or hang, due to timeouts. If you encounter this problem, the query can be paged manually by setting the 'Query Page Size' value on the "Settings" tab. This is still slower than an 'at-once' query, but faster than automatic paging and it avoids server overload. The necessary value cannot be predicted in general and strongly depends on the number of observations returned, but 20 - 50 is a good idea for beginning. Higher values result in faster processing but higher risk of server overload.
- If a patient set contains thousands of patients, and you are not sure if the concepts you are specifying would result in large run time or large result set, then it is better to start with a subset of the patient set (e.g. 'Starting Patient': 1, and 'Number of Patients: 500, etc.) first, as you can always run again with subsequent subsets (e.g. 'Starting Patient': 501, and 'Number of Patients: 500, etc.).
- The '1 row per observation (detailed, 1 column per observation detail)' option of tabulation is the only output option where the 'Observation Value' column will contain the appropriate 'Observation BLOBs' (if the 'valuetype_cd' is 'B' and the user has the "DATA_DEID" access right).
- This plugin has been successfully tested with the following browsers: Firefox (v18.0.2, v28.0), Chrome (v24.0, v33.0), Internet Explorer 32/64 (v9.0.13, v10.0, v11.0 - there seems to be a problem with scrolling bars in small windows, though), Safari (v5.1.7) and Opera (v18.0, v20.0).
- The i2b2 web client itself does not work with Opera (v12.11, v12.16).
i2b2 version compatibilities
This version (v3.3) is compatible with i2b2 v.1.3-1.7.
Version History of this Plugin
Initial release, for i2b2 v1.5.
Updated for i2b2 v1.6.
Updated for i2b2 v1.3-1.6, Internet Explorer compatibilities; added flexible column exclusion, table title & caption, leading row count column, and other enhancements.
Major upgrade; many new features (CSV export, detailed tabulating of all observations, formatting options, paged queries...), heavily re-engineered.
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.
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)'.
- 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.
Based on feedback and input from other researchers, we have made the following updates, adjustments, enhancements, and fixes that may better serve everyone in the i2b2 community:
- 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).
- Added table title and caption to the resulting output table.
- Added new 1st column for patient row counts (no column title).
- Renamed the "StateCity" column title to "State/City".
- Removed any leading and trailing redundant "Zip codes" values from each state value string.
- Defaulted to using "concept_cd" for each selected concept entry if neither "tval_char" nor "nval_num" is available.
- Improved efficiencies.
- Facilitated the flexible dropping of any columns (that may contain data too sensitive or personal) from the resulting output table.
- Fixed the Internet Explorer (IE) hang problem.
- Fixed the missing "concept" columns on IE problem.
- Fixed the blank "patient_IDs" (when "Include Patient Date" not selected) on IE problem.
- Fixed table content getting cutoff on IE problem.
- Centered content in each table cell of the resulting output table.
- Added unique time-stamp to name of exported XLS file.
- Updated the description of this plugin displayed (in the available plugin list).
- Added more descriptions in the "Specify Data" and "Plugin Help" tab pages.
- Updated plugin category from "text" to "standard".
This new release is packed with installation guide and version supplementary note, and is available from the Google Code project download page set up for it, as well as the UMass Med School MICARD Downloads page.
- 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 (S. Wayne Chan, Rajani Sadasivam, Thomas Houston, & the rest of the BMI-Core), and the Universita' di Pavia, Italy (Mauro Bucalo).
- The latest version (v3.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).
Please don't hesitate to contact us concerning any questions or problems. Thanks.
Copyright 2011-2013 University of Massachusetts Medical School, Universita' di Pavia & Friedrich-Alexander-University Erlangen-Nuremberg.
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.