This shows you the differences between two versions of the page.
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]] windows, click 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 present, no export is available to user. In order to have data in a excel file: |
+ | - Press Ctrl+A to select all cells | ||
+ | - Ctrl+C 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. | ||