CellProfiler SQL output file paths improperly escaped

cellprofiler

#1

Backslashes in pathnames are not escaped in the CSV files generated by the SQL export function in CP 5122 on XP32, which causes the backslashes to be recognized as escape sequences by the MySQL interpreter. Backslashes should be doubled by the export function.

Example of incorrect output:
1,“a-4d-01-001 blue.tif”,“a-4d-01-001 green.tif”,“C:\data\044-141 zzz\smashed”,“C:\data\044-141 zzz\smashed”, (…)

Example of correct output:
1,“a-4d-01-001 blue.tif”,“a-4d-01-001 green.tif”,“C:\data\044-141 zzz\smashed”,“C:\data\044-141 zzz\smashed”, (…)

thanks,
tim


Another basic question
#2

Hi Tim,

Thanks for reporting this. It should only occur with backslashes, and thus Window OSes.

If you search CPconvertsql.m and replace
ENCLOSED BY '"'
with
ENCLOSED BY ‘"’ ESCAPED BY ‘’

It should fix it. This bugfix will be in the next release.

Cheers,
David


Problems exporting demo examples to CellProfiler Analyst
#3

Great; thanks!

tim