CellProfiler/CellProfiler — Issue #70: JIRA [IMG-1460] Properly handle grouping when using ExportToDatabase as a data tool
Author: thouis
Created: 2011-11-23 20:49:49+00:00
State: open
Labels: current

hello,
i am having some issues with the ExportToDatabase menu item.
basically i think it would be good if it had a few more choices such as:
- select tile_size
- select well_format
- for my applications i need the Metadata also in the per-object table,
because i want to compute summary statistics based on
"Metadata_treatment" per object (not per image)
(this is already possible in the ExportToSpreadSheet)
- and, currently, i get an error message when i click that i would like
to have groupings
currently my work-around-flow is:
i) Analyse our data on the cluster in CP => ExportToSpreadsheet
ii) Merge the .csv files in R
iii) generate the db.properties, Setup.SQL, per_image.csv, and
per-object.csv in R
iv) import into CPA
advantage is that like this i can do in R what i want in order to get
"nice" input for CPA
however, i realized that what i actually do in R is very minor so one
could compress the workflow substantially by giving the ExportToDatabase
module a bit more power...
what do you think?
Tischi

Original reporter: leek
Jira link: https://jira.broadinstitute.org/browse/IMG-1460
Fix version: Current
Assignee: leek