We have run into a problem using the ExportToDatabase Module using Cell Profiler 2.0, on revision 9777. It appears the data in the Per Object CSV files are out of order relative to the variables listed in the .SQL file. Objects in the exported Per Object CSV file appear to be in alphabetical order. For example, when the expected order is for Nuclei, Cells, Cytoplasm, the columns are exported in order of Cells, Cytoplasm, and Nuclei.
Then, using the spreadsheet files, we can re-arrange them and get it to work, but it’s a time-consuming manual process, prone to human error. So, we were able to diagnose the problem this way, but not able to fix it. Attached for your reference are the original and fixed Per Object CSV files along with the SQL file with the variables.