Error in ExporttoSpreadSheet

Hi everybody !
I created a pipeline in CellProfiler 4.0.4 on my Mac. When I try to analyze my images I have this error message: " Encountered uncrecoverable error in ExportToSpreadsheet during post-processing:
‘ascii’ codec can’t encode character ‘\u2019’ in position 6560: ordinal not in range(128) "
I used this pipeline (I changed just some threshold) on this computer one month ago and everything was good so I don’t understand what is the problem.
Thank you for your help !
Justine

Hi @Justinenouj,

Could you share your pipeline and an example image so that we can try to reproduce the error? That’ll help us make a diagnosis.

Thanks!

Hi Pearl !
Attached here my pipeline with the image in the pipeline!
Thanks a lot
Justine Pipeline HaCaT 20x JNO.cpproj (1.2 MB)

Hi @Justinenouj,

The project files don’t include the image files (they instead have a path telling CellProfiler where to look for the images on your computer). Could you attach a couple of example images here instead? Thanks!

HaCaT lentiCRISPRv2 + eGFP 20X 01-Image Export-31_b0c2x0-1388y0-1040.tif (714.8 KB) HaCaT lentiCRISPRv2 + eGFP 20X 01-Image Export-31_b0c0-3x0-1388y0-1040.tif (1.9 MB) HaCaT lentiCRISPRv2 + eGFP 20X 01-Image Export-31_b0c0x0-1388y0-1040.tif (568.6 KB) HaCaT lentiCRISPRv2 + eGFP 20X 01-Image Export-31_b0c1x0-1388y0-1040.tif (690.1 KB) HaCaT lentiCRISPRv2 + eGFP 20X 02-Image Export-32_b0c0-3x0-1388y0-1040.tif (2.9 MB) HaCaT lentiCRISPRv2 + eGFP 20X 02-Image Export-32_b0c2x0-1388y0-1040.tif (1.1 MB) HaCaT lentiCRISPRv2 + eGFP 20X 02-Image Export-32_b0c1x0-1388y0-1040.tif (868.9 KB) HaCaT lentiCRISPRv2 + eGFP 20X 02-Image Export-32_b0c0x0-1388y0-1040.tif (885.5 KB) HaCaT lentiCRISPRv2 + eGFP 20X 03-Image Export-33_b0c2x0-1388y0-1040.tif (1013.1 KB) HaCaT lentiCRISPRv2 + eGFP 20X 03-Image Export-33_b0c1x0-1388y0-1040.tif (838.2 KB) HaCaT lentiCRISPRv2 + eGFP 20X 03-Image Export-33_b0c0x0-1388y0-1040.tif (837.6 KB) HaCaT lentiCRISPRv2 + eGFP 20X 03-Image Export-33_b0c0-3x0-1388y0-1040.tif (2.7 MB)

Oh yes sorry ! Here’s 3 images !
Thanks!!

I can’t reproduce this on my Mac in either CellProfiler 4.0.6 or 4.0.7. CellProfiler runs fine in both such cases. I believe this is related to a bug we already fixed in 4.0.5; can you see if upgrading to 4.0.7 fixes the issue?

If it does not, can you confirm there aren’t any non-ascii values (characters with accents, tildes, etc) in either where your files are located or where you’re attempting to write to?

1 Like

Hi @bcimini,
Will my pipeline still work if I upgrade the cell profiler version?
I had some problems with my pictures so I attached a new batch of pictures, you could probably reproduce my pipeline now? And no I don’t have ascii values in my file. Pipeline HaCaT 20x JNO.cpproj (1.2 MB) HaCaT lentiCRISPRv2 + eGFP 20X 01-Image Export-57_b0c2x0-1388y0-1040.tif (900.2 KB) HaCaT lentiCRISPRv2 + eGFP 20X 01-Image Export-57_b0c0x0-1388y0-1040.tif (745.0 KB) HaCaT lentiCRISPRv2 + eGFP 20X 01-Image Export-57_b0c1x0-1388y0-1040.tif (882.9 KB) HaCaT lentiCRISPRv2 + eGFP 20X 01-Image Export-57_b0c0-3x0-1388y0-1040.tif (2.0 MB) HaCaT lentiCRISPRv2 + eGFP 20X 02-Image Export-58_b0c0x0-1388y0-1040.tif (1.1 MB) HaCaT lentiCRISPRv2 + eGFP 20X 02-Image Export-58_b0c0-3x0-1388y0-1040.tif (3.2 MB) HaCaT lentiCRISPRv2 + eGFP 20X 02-Image Export-58_b0c1x0-1388y0-1040.tif (1.1 MB) HaCaT lentiCRISPRv2 + eGFP 20X 02-Image Export-58_b0c2x0-1388y0-1040.tif (1.3 MB) HaCaT lentiCRISPRv2 + eGFP 20X 03-Image Export-59_b0c0x0-1388y0-1040.tif (1.0 MB) HaCaT lentiCRISPRv2 + eGFP 20X 03-Image Export-59_b0c1x0-1388y0-1040.tif (1.0 MB) HaCaT lentiCRISPRv2 + eGFP 20X 03-Image Export-59_b0c0-3x0-1388y0-1040.tif (2.8 MB) HaCaT lentiCRISPRv2 + eGFP 20X 03-Image Export-59_b0c2x0-1388y0-1040.tif (1.2 MB)

Hi @Justinenouj,

Yep, your pipeline will still work if you upgrade your CellProfiler. I just checked it in CP 4.0.7 and it processed your new batch of images without errors. Between CellProfiler 4.0.4 and 4.0.7 we’ve fixed several bugs and introduced a few new features but have not changed how the underlying image analysis code works, so you should have consistent results.

Good luck!