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:44]
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 formatted. You 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 accession, select 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 displayed. See 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 user. In order to save data in a excel file, from one or the other 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 title. In this case, when changing the displayed set of properties to copy, be sure to not reorder the rows ! \\ 
-:!: In the summarized table, you should copy one property after the other ... be sure to not reorder the rows between two copy. 
  
  
  
  
how_to/exportcomparison.1262789068.txt.gz · Last modified: 2010/01/06 15:44 by 132.168.73.247