Changes between Version 4 and Version 5 of i2b2 Excel Spreadsheet Extract


Ignore:
Timestamp:
12/10/15 09:59:04 (9 years ago)
Author:
Richard Bramley
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • i2b2 Excel Spreadsheet Extract

    v4 v5  
    1 = I2B2 Plugins =
     1= i2b2 Excel Spreadsheet Extract
    22
    3 * [[https://community.i2b2.org/wiki/display/mi2b2/mi2b2+Home| mi2b2]] - Imaging cell
    4 
    5 == ExportXLS ==
     3Tags: [[i2b2]]
    64
    75Colleagues in Pavia and Erlangen have developed a plugin to create an xls / csv export from i2b2. It's very helpful. Unfortunately it doesn't currently allow duplicate elements from the ontologies to be exported, and that's unfortunate, given that we have many duplicates between the MINAP datasets, for instance.
    … …  
    108
    119The plugin offers two formats for the download file - one is an html version of an excel file, the other is csv. However, the csv and the html/xls renders with multiple result rows per patient in Excel if there is multiple data in any of the columns because each result observation is followed by a carriage return. A workaround is to open the csv file in LibreOffice or LibreOfficePortable, and then save the resulting data in excel xls format.
     10
     11[[BackLinks]]