ExportXLS
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

This page contains all the caveats and the known workarounds that we are aware of.  Please read through each one to determine if any applies to your particular environment and situation.  Thanks.

Researcher's Guide 

We have provided a Guide (http://micard.umassmed.edu/downloads/The_New_ExportXLS_plugin_for_i2b2_(MiCARD)_webclient.pdf) for this plugin to our researchers in University of Massachusetts Medical School. We welcome anyone who may find it useful to the researchers in their own institutions as well.

Ignore Excel Warning Dialog

Wiki MarkupWhen opening the resulting exported HTML-coded Excel file (.xls), a dialog similar to the following may be displayed: !ExcelWarningDialog.png|align=center! Simply click \[Yes\] to Image Added
Simply click [Yes] to proceed.

Different Browser Type may Exhibit Different HTML-coded Excel Spreadsheet Exportation Behaviors

In our development and testing efforts, we've noticed that when the data is exported to the HTML-coded Excel spreadsheet, the behaviors vary among the 4 different browser types (Firefox, Chrome, IE, and Safari). These differences are not anything that can be controlled through our codes (at least not anything we're aware of, though we'll be grateful if any one can suggest any specific workable improvements).

...

 When I go back to the i2b2 tab, there is an IE popup asking to open or save the file, so that's ok."

php.ini Setting and Resulting Exported HTML-coded Excel Spreadsheet File

Gregory Schulte (Children's Hospital Colorado) has alerted us that if the "short_open_tag" in the /etc/php.ini file of the i2b2 server is NOT set to "on", then the resulting exported HTML-coded Excel spreadsheet may be just a blank file.

...