Reduce the number of fields in Per_Image table


#1

Hi,
I have a pipeline which loads images (illumHoechst, illumER, illumSyto, …), then loads the correction matrices (illumHoechstcorrect, illumERcorrect, illumSytocorrect, …) via LoadImages and applies them to the original images with CorrectIlluminationApply, resulting in Hoechst, ER, Syto… .
I have noticed that the information on the original images, in which I am not really interested, is still written to the database. The Per_Image table contains fields such as Image_FileName_IllumHoechst, Image_Height_IllumHoechst, Image_MD5Digest_illumHoechst.
Is there an option to tell CellProfiler to write less image information into the Per_Image table?

Many thanks in advance.

Kind regards,
Axel


#2

While ExportToSpreadsheet allows you pretty fine-grained choice over which columns to include, there really isn’t a way to do this for ExportToDatabase. Sorry!


#3

Ok, at least then I can stop looking for the checkbox :wink:
Thanks for the fast answer (again)!
Would an ExportToSql module which exports to an sql file instead of a csv spreadsheet an option for the future?

Kind regards,
Axel


#4

ExportToDatabase can write directly to SQL (also SQLite). Is there something else that you meant?


#5

Sorry, I did not see the “MySQL / CSV” option in the ExportToDatabase module before. This is exactly, what I meant, I will look into that.

Many thanks again for your help.

Have a nice and relaxing holiday!

Kind regards,
Axel