Skip to Content

Wiki source code of Export

Version 3.1 by Martin SZOTKOWSKI on 2019/03/22 16:50
Show last authors
1 There is possibility to **export Compounds and Assays** results to the **Excel**.
2
3 = {{id name="Export-SelectingCompounds"/}}Selecting Compounds =
4
5 To choose compounds for export you can use **Compound cart** (similar to an eshop).
6
7 * select compounds by **mouse and Shift or Ctrl** key
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**
10 [[image:attach:image2019-3-22_15-33-51.png||thumbnail="true" height="150"]]
11 * (((
12 compounds remain in the cart until you remove them using **Empty compound cart**
13
14 * note: before you start your next export do not forget empty your cart
15
16 [[image:attach:image2019-3-22_15-35-4.png||thumbnail="true" height="150"]]
17 )))
18 * to edit compound cart use menu **Edit compound cart**
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 **
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
26 = {{id name="Export-Startingexportjob"/}}Starting export job =
27
28 * By pressing button **Start Export selected and cart compounds**
29 [[image:attach:image2019-3-22_16-12-38.png||thumbnail="true" height="150"]]
30 currently selected compounds are added to the cart and Export window appears:
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.
34
35 === {{id name="Export-Selectingfieldsforexport"/}}Selecting fields for export ===
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:
38
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
41 [[image:attach:image2019-3-22_16-26-11.png||height="400"]]
42
43 \\
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.
47
48 === {{id name="Export-StartExport"/}}Start Export ===
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.
51
52 There are following information about running export:
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 [[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
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
61 [[image:attach:image2019-3-22_16-43-31.png||height="150"]]
62 * by double click on the export line you can download any ready export, even repeatedly.
63 \\
64
65 \\
66
67 \\