User Tools

Site Tools


how_to:exportcomparison

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
how_to:exportcomparison [2010/01/06 15:45]
132.168.73.247
how_to:exportcomparison [2011/02/01 10:19] (current)
132.168.74.230
Line 1: Line 1:
-====== ​Export ​comparison result ======+====== ​How to export ​comparison result ======
  
-===== Export 2 contexts ​comparison ​=====+Only one Graphical User Interface now exists to display context ​comparison ​results.
  
-On the [[userguide:​contextcomparisons#​compare_two_contexts_with_each_other1|comparison result]] windowsclick the ''​export''​ button. A window will be displayed for user to choose which parameters will be exported. **''​(R)''​** prefixed properties are for first compared context (Reference context) and **''​(C)''​** prefixed properties are for second compared context.+At presentno export ​is available to userIn order to have data in a excel file:  
 +  - Press Ctrl+A to select all cells  
 +  - Ctrl+to copy data 
 +  - Open an Excel document and press Ctrl+V to copy data
  
-{{ :how_to:​export2ctxtcomp1.png |}}+__**Tips to format correctly results in Excel Spreadsheet:**__
  
-An other window will ask for destination file path and name and for exported format ​(//xls//, //pdf// or //html//+The first column ​(union reference accessions) is not correctly formattedYou can select this column and use ''​Data->​Text ​to columns...''​ (Or ''​Données->​Convertir...''​ wizard ​to extract accessions only (specify '​space'​ as delimiter and then only extract ​column ​containing accessions)To remove the last bracket '​]'​ at the end of the accessionselect ​the column and use ''​Data->​Text to columns...''​ wizard again, specify a custom delimiter '​]'​ and only extract ​the column having accession.
-\\ +
- +
- +
-The comparison table to which specified properties are added will be exported to specified file. +
- +
-===== Export multiple contexts comparison ===== +
- +
-When [[userguide:​contextcomparisons#​compare_n_contexts|comparing a context with its child]], two tabs are opened. The first one, the //full table//, all properties of each context ​is displayedSee how to [[how_to:​accessproperties|change displayed properties]]. +
-The second tab is a more readable table where only one property at the time is displayed for each context. +
- +
-For now, no export is proposed to userIn order to save data in a excel file, from either tab:  +
-  ​Press CTRL-A to select all cells  +
-  - CTRL-C to copy data +
-  - Open a excel file and press CTRL-V to copy data. +
- +
-:!: The column title are not copied using this method, verify their order in hEIDI table before reporting it to excel file\\ +
-:!: In the //full table// it is possible ​to display ​only a set of properties to be able to read column ​titleIn this case, when changing ​the displayed set of properties to copy, be sure to not reorder ​the rows ! \\ +
-:!: In the summarized tableyou should copy one property after the other ... be sure to not reorder ​the rows between two copy.+
  
  
how_to/exportcomparison.1262789158.txt.gz · Last modified: 2010/01/06 15:45 by 132.168.73.247