Document ExportToSpreadsheet saves Experiment.csv to default output folder

[dlogan]

If ExportToSpreadsheet saves to a subfolder of the Default Output folder, and that folder uses Metadata tags, then the Experiment.csv is saved to the DOF, and not the specified subfolder. All the other CSV files are put in the correct folder.

(Note: I used the Welcome Screen Fly images to test this.)

Attachments:
http://cellprofiler.org/issues/uploaded/cBQc5K/project_Experiment_CSV.cpproj

[LeeKamentsky]

It's a little tricky. For all csv's other than Experiment, each row is tied to a particular imageset and that imageset has a definition for each metadata tag. Experiment is different - if there are two plates, and consequently two directories with the two different plate names embedded in them, which directory do I use?

Several choices:

• Give up and use the default output folder (current)
• Use the metadata from the first image set
• Use a placeholder ("Experiment", "Plate" ?) instead of one of the possible values
• Display a second folder location box for Experiment.csv if the user uses metadata tags in their folder names.

Let me know and I'll fix it that way.

[braymp]

I think I like the current behavior of using the DOF. Either that or the last option.

[dlogan]

I see. In the case in which there are multiple different tags used (e.g. "Plate") then I can see the issue, however the example I used had only a single plate, though I still wanted the metadata name substituted. In that case, it seems less intuitive that the Experiment CSV would be saved in a different location (e.g. DOF). So to be explicit, I prefer the last choice. If it's annoying to code for whatever reason, the DOF is a reasonable choice though too.

Either way, we should be explicit about the location in the Help (I didn't see it immediately).

[AnneCarpenter]

Given that at least one reputable person in the world likes the current behavior, let's just document the behavior in the help and be done with it.

[AnneCarpenter]

(Could I ask @dlogan or @braymp to do this, if either of you still has an understanding of the issue?)

[dlogan]

Yes, I can add a little Help clarification for this soon.

[AnneCarpenter]

Hey @dlogan if you can just type the correct text in a comment I'm happy to put it in properly as a pull request.

[AnneCarpenter]

I will do this (as best I can)

[AnneCarpenter]

Strangely, I don't seem to have the power to close this issue @mcquin

[mcquin]

Closed #3232

[dlogan]

sorry @AnneCarpenter I lost track of this. Your text edits read fine to me.