Skip to Content

Changes for page Export

Last modified by Mr on 2019/06/03 13:59
From version 4.1
edited by Martin SZOTKOWSKI
on 2019/03/22 17:00
Change comment: There is no comment for this version
To version 6.1
edited by Martin SZOTKOWSKI
on 2019/03/27 09:36
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,27 +1,30 @@
1 -There is possibility to **export Compounds and Assays** results to the **Excel**.
1 +There is possibility to **export Compounds and Assays** results to the simple **Excel**.
2 2  
3 3  = {{id name="Export-SelectingCompounds"/}}Selecting Compounds =
4 4  
5 -To choose compounds for export you can use **Compound cart** (similar to an eshop).
5 +To choose compounds for export you can use **Compound cart** (similar to an eshop cart).
6 6  
7 -* select compounds by **mouse and Shift or Ctrl** key
7 +* Select compounds by **mouse and Shift or Ctrl** key
8 8  [[image:attach:image2019-3-22_16-3-29.png||thumbnail="true" height="150"]]
9 -* to add selected compounds to the cart use the menu **Add selected compounds to cart**
9 +\\
10 +* To add selected compounds to the cart use the menu **Add selected compounds to cart**
10 10  [[image:attach:image2019-3-22_15-33-51.png||thumbnail="true" height="150"]]
12 +\\
11 11  * (((
12 -compounds remain in the cart until you remove them using **Empty compound cart**
14 +Compounds remain in the cart until you remove them using **Empty compound cart**
13 13  
14 -* note: before you start your next export do not forget empty your cart
16 +* Note: before you start your next export do not forget empty your cart
15 15  
16 16  [[image:attach:image2019-3-22_15-35-4.png||thumbnail="true" height="150"]]
19 +\\
17 17  )))
18 -* to edit compound cart use menu **Edit compound cart**
21 +* To edit compound cart use menu **Edit compound cart**
19 19  **[[image:attach:image2019-3-22_16-5-21.png||thumbnail="true" height="150"]] [[image:attach:image2019-3-22_16-5-41.png||thumbnail="true" height="150"]]
20 20  **
21 21  ** LEM list must be comma separated and only valid form LEMs are allowed (LEMnnnnnnnn - 8 digits).
22 -** do not forget use button **Update LEM list** to store changes in cart.
23 -** note: invalid LEMs formats are removed from the cart
24 -** there is nor check if the LEM exist in Portal neither you have access to this compound, but inaccessible compounds are not exported
25 +** Do not forget use button **Update LEM list** to store changes in cart.
26 +** Note: invalid LEMs formats are removed from the cart during updating.
27 +** There is nor check if the LEM exist in Portal neither you have access rights to this compound, but inaccessible compounds are not exported
25 25  
26 26  = {{id name="Export-Startingexportjob"/}}Starting export job =
27 27  
... ... @@ -29,41 +29,51 @@
29 29  [[image:attach:image2019-3-22_16-12-38.png||thumbnail="true" height="150"]]
30 30  currently selected compounds are added to the cart and Export window appears:
31 31  [[image:attach:image2019-3-22_16-36-42.png||height="150"]]
32 -* you can name you export for easier finding if you start more exports. Name is only used in Portal and is not part of the exported Excel.
33 -* you can also again check and edit compounds in cart.
35 +* You can set export name for each export. Name is only used in Portal and is not part of the exported Excel.
36 +* You can also edit compounds in cart.
34 34  
35 35  === {{id name="Export-Selectingfieldsforexport"/}}Selecting fields for export ===
36 36  
37 -In the Compound and Assay tree you can see all fields what can be exported. At the beginning some fields are preselected. Here you can add more fields for the export. Idea behind this selection is following:
40 +In the Compound and Assay tree you can see all fields what can be exported. Some fields are preselected by default. There you can change selection of export fields. Idea behind this selection is:
38 38  
39 39  e.g. Assay Cell Cycle Analyses - Flow Cytometry will export in following settings these fields: for each compound in cart will be exported columns with data for Cell Line CCRF-CEM and Concentration among first 3 (sorted ascending) and values sub-G1 Avg, G0/G1 Avg, etc.
40 40  
41 -[[image:attach:image2019-3-22_16-26-11.png||height="400"]]
44 +[[image:attach:image2019-3-22_16-26-11.png||width="400"]]
42 42  
43 43  \\
44 44  
45 -* Note: you have to create valid selection. E.g. if you deselect Cell Line in above example then export will not start.
46 -* Note: currently there is not possibility to save selection of fields.
48 +* Note: you have to create valid selection. That means you have to select at least one item from each subcategory: Cell Line, Concentration and Data.
49 +* Note: currently there is not possibility to save selection of export fields.
47 47  
48 48  === {{id name="Export-StartExport"/}}Start Export ===
49 49  
50 -By pressing button Start Export, the export job is scheduled and performed on the server. You can continue in the other work with Portal and also start another export.
53 +By pressing button Start Export, the export job is scheduled and performed on the server. You can continue working with Portal and also start another export.
51 51  
52 -There are following information about running export:
55 +There is following information about running export:
53 53  
54 -* short indication that export has started: [[image:attach:image2019-3-22_16-39-8.png]]
55 -* running dot in menu Export [[image:attach:image2019-3-22_16-39-34.png||thumbnail="true" height="52"]]
56 -* in the menu Export you can see progress of the lately started export
57 +* Short indication that export has started:
58 + [[image:attach:image2019-3-22_16-39-8.png]]
59 +\\
60 +* Running dot in menu Export 
61 +[[image:attach:image2019-3-22_16-39-34.png||thumbnail="true" height="52"]]
62 +\\
63 +* In the menu Export you can see progress of the last started export
57 57   [[image:attach:image2019-3-22_16-42-1.png||thumbnail="true" height="150"]]
58 -* you can download latest Export from the menu when it is ready and/or in the menu Show all Exports
65 +\\
66 +* You can download last Export from the menu when it is ready. Or you can open dialog with all exports via menu item Show all Exports.
59 59  [[image:attach:image2019-3-22_16-44-53.png||thumbnail="true" height="150"]]
60 -* there is list of all exports you have run within last 7 days including information about progress
68 +\\
69 +* There is list of all exports you have run within last 7 days including information about progress
61 61  [[image:attach:image2019-3-22_16-43-31.png||height="150"]]
62 -* by **double click on the export line **you can download and open any ready export, even repeatedly.
63 -\\[[image:attach:image2019-3-22_16-52-33.png||height="150"]]
71 +\\
72 +* **Double click on the export line **will download and open any export with status ready, even repeatedly.
73 +[[image:attach:image2019-3-22_16-52-33.png||height="150"]]
64 64  
65 65  = {{id name="Export-ExportedExcel"/}}Exported Excel =
66 66  
67 -Exported excel is very simple data oriented excel where in multiline header are selected fields names and in the data below the header are values. Values are rounded to 2 significant digits, same as in the Portal. There is no divider between Compound and each Assay, you should found it be the header.
77 +Exported excel is very simple data oriented excel where:
68 68  
69 -\\
79 +* in multiline header are selected fields names and
80 +* in the data below the header are values from the Portal.
81 +
82 + Values are rounded to 2 significant digits, same as in the Portal. There is no divider between Compound and each Assay, you could found it by the header.
Confluence.Code.ConfluencePageClass[0]
Id
... ... @@ -1,1 +1,1 @@
1 -22413382
1 +22413392