search

clairelbromley / ZebrafishKymographing

Various software tools written for analysis of lumen opening and membrane retraction in zebrafish.
1 stars 0 forks source link

Problems with export #33

Open clairelbromley opened 7 years ago

clairelbromley commented 7 years ago

If import inclusion data, when export the data all speeds read 'NaN' in the first sheet containing data from all the kymographs- then on the mean, median etc sheets all of the values are the same for every embryo

clairelbromley commented 7 years ago

screen shot 2016-10-06 at 13 58 55

clairelbromley commented 7 years ago

Export test 1) Selected 2 embryos and labelled a few kymographs with good/misassigned - export 1 For this export, speeds were exported for kymographs that had been QC checked, but not for those that had no edge or were not QC'd (not a problem)

2) Closed viewer then opened dataset again and did the inclusion wizard. Then did data export. (export 2) The below warning appeared, but the speeds were actually incorporated in this case.

Warning: Out of range or non-integer values truncated during conversion to character.

In viewerMain>parseForXLExport at 1099 In viewerMain>exportWizard_Callback at 903 In gui_mainfcn at 95 In viewerMain at 42 In @(hObject,eventdata)viewerMain('exportWizard_Callback',hObject,eventdata,guidata(hObject))

clairelbromley commented 7 years ago

https://drive.google.com/drive/folders/0B5BMTPgxKjfcTm1TWXlEOUxBMzg?usp=sharing

Link to drive that contains test data, and the two export files as details above

clairelbromley commented 7 years ago

However, the above problem with getting 'NaN' for speeds applies when I try to do the import inclusion and then export on the old data that I have previously assigned (as the top screenshot shows above)

clairelbromley commented 7 years ago

https://drive.google.com/file/d/0B5BMTPgxKjfcTlhwc3VhUHVMUVk/view?usp=sharing

Above is the link to the import inclusion excel sheet that is not working

clairelbromley commented 7 years ago

So I thought the problem with the initial import sheet might've been that the speed section on the import sheet said 'NaN' - so I cleared the column so that there was nothing in it to copy, but still it is coming up as NaN

clairelbromley commented 7 years ago

\ I've figured out the problem: the issue is that for the import inclusion data, the software just copies whatever speed is in the inclusion data excel spreadsheet rather than taking it from the viewer. This isn't a problem for most things, but could be for speed.

clairelbromley commented 7 years ago

Unfortunately, this is still a problem :( The import inclusion data that I have does not contain any speeds, as these were not exported properly before - and now the new export data just copies speeds from the excel spreadsheet as detailed above