This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
how_to:exportcomparison [2011/02/01 10:14] 132.168.74.230 |
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 ====== |
- | Only one graphical interface now exists to display context comparison results. | + | Only one Graphical User Interface now exists to display context comparison results. |
At present, no export is available to user. In order to have data in a excel file: | At present, no export is available to user. In order to have data in a excel file: | ||
Line 9: | Line 9: | ||
__**Tips to format correctly results in Excel Spreadsheet:**__ | __**Tips to format correctly results in Excel Spreadsheet:**__ | ||
- | The first column (union reference accessions) is not correctly formatted. You can select this column and use ''Data->Text to columns...'' 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. | ||
- | Export multiple contexts comparison ===== | + | 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. |
- | + | ||
- | 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. | + | |
- | + | ||
- | + | ||
- | + | ||
- | :!: 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. | + | |