ExportToDatabase MySQL/CSV "database type" setting produces

Hi,

ExportToDatabase MySQL/CSV “database type” setting produces wrong object level CSV files. I measure primary and secondary objects (Nuclei, Neurite in my attached pipeline). The pipeline produces two identical CSV files SQL_1_14_Nuclei.CSV and SQL_1_14_Neurite.CSV. Each of them are merger of correct data (see sql.zip) . I assume that direct MySQL connection and ExportToSpreadsheet(see csv.zip) make correct ones. I have two MeasureObjectIntensity modules for each channel

Best
Vlad
csv.zip (1.74 MB)
sql.zip (3.37 MB)
measureNeurons2Channel.cppipe (26.3 KB)

Hi Vlad,

I’ve confirmed this behavior and filed a bug report: github.com/CellProfiler/CellPro … ssues/1165. In the meantime, until we fix it, a workaround should be to use “Single object table” rather than “Single object view” in EpxortToDatabase.

Regards,
-Mark

Hi Vlad,

I’ve confirmed this behavior and filed a bug report: github.com/CellProfiler/CellPro … ssues/1165. In the meantime, until we fix it, a workaround should be to use “Single object table” rather than “Single object view” in EpxortToDatabase.

Regards,
-Mark

This issue has been addressed with the 2.1.1 release.
-MArk