search

rethomics / damr

Read TriKinetics' DAM data in R
http://rethomics.github.io
6 stars 6 forks source link

Error in find_dam_first_last_lines(path, start_datetime, stop_datetime, : No data in selected date range #47

Open Anuragbio opened 2 months ago

Anuragbio commented 2 months ago

Hi, I am trying to use .txt output from Ethoscope to perform DAM analysis using rethomics. However, I got the following error at

dt <- load_dam(metadata)

Error in find_dam_first_last_lines(path, start_datetime, stop_datetime, : No data in selected date range Ethoscope001.txt metadata.csv

The files I am using are attached. Could you help me figure out how to resolve the problem?

Best, A

johanna0809 commented 3 weeks ago

I also had this problem and there were various things I had to change as this happened on multiple occasions:

1) The format of the date_starttime/date_stoptime was incorrect in the .csv file 2) I didn't have the original .txt file in the folder that I assigned the file path to 3) sometimes the program struggled with the MT/Ct Date Type in the text file. When I changed MT to 0 and Ct to 1 it worked.

Hope this helps, although it might be a little late.

J.

Anuragbio commented 3 weeks ago

Hi johanna0809,

Thank you for your reply. May you let me know:

1. The format of the date_starttime/date_stoptime was incorrect in the .csv file

What is the correct date_starttime/date_stoptime format you used. I have attached the output files with my query above, it will be helpful if you can suggest changes there

  1. I didn't have the original .txt file in the folder that I assigned the file path to I used the correct file path.
    1. sometimes the program struggled with the MT/Ct Date Type in the text file. When I changed MT to 0 and Ct to 1 it worked. May you let me know where you made these changes.

Best, A

johanna0809 commented 3 weeks ago

  1. The format of the date_starttime/date_stoptime was incorrect in the .csv file date_starttime: YYYY-MM-DD hh:mm:ss date_stoptime: YYYY-MM-DD

  2. sometimes the program struggled with the MT/Ct Date Type in the text file. When I changed MT to 0 and Ct to 1 it worked. I changed it in the original .txt file that is produced by the DAM system.

J.

johanna0809 commented 3 weeks ago

Ok so now the error occured again with another file. It is structured exactly the same as the files with which it worked. Maybe somebody else can help us out..