Error in load_dam() function and request for help

[katenevin21]

I am having issues with loading data into behavr tables with rethomics. I was wondering if someone could point me in the right direction to fixing my problem. When I try to load my data using the load_dam() function I get either of these two errors constantly:

Error in [.data.table(q, , .(regions = list(region_id)), by = c("path", : column or expression 1 of 'by' or 'keyby' is type list. Do not quote column names. Usage: DT[,sum(colC),by=list(colA,month(colB))]

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

Here is my code:

rm(list = ls())

library(devtools) library(damr) library(behavr)

DATA_DIR <- "C:/Users/Kate/OneDrive/Desktop/Sample" list.files(DATA_DIR, pattern= ".txt|.csv") setwd(DATA_DIR)

metadata <- fread("metadata.txt") dt <- load_dam(metadata)

And here is my metadata region_id DAM file start_datetime stop_datetime genotype sex 1 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 2 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 3 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 4 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 5 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 6 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 7 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 8 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 9 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 10 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 11 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 12 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 13 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 14 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 15 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 16 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 17 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 18 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 19 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 20 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 21 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 22 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 23 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 24 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 25 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 26 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 27 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 28 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 29 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 30 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 31 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 32 21 Monitor 21.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 A male 1 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 2 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 3 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 4 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 5 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 6 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 7 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 8 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 9 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 10 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 11 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 12 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 13 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 14 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 15 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 16 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 17 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 18 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 19 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 20 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 21 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 22 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 23 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 24 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 25 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 26 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 27 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 28 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 29 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 30 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 31 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 32 22 Monitor 22.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 B male 1 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 2 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 3 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 4 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 5 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 6 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 7 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 8 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 9 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 10 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 11 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 12 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 13 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 14 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 15 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 16 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 17 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 18 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 19 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 20 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 21 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 22 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 23 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 24 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 25 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 26 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 27 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 28 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 29 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 30 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 31 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male 32 23 Monitor 23.txt 2021-07-22 10:12:00 2021-07-24 21:10:00 C male

Attached are my three text files, and the .csv and .txt versions of my metadata. Excel keeps changing the time format when I open it up so I prefer to save and use my metadata in the .txt file format. Both versions aren't working for me, so I don't know if that is the issue.

Monitor 21.txt Monitor 22.txt Monitor 23.txt metadata.csv metadata.txt

Thank you!

[qgeissmann]

hi @katenevin21 ,

I was able to reproduce our issue. The date format in your data files is 22-Jul-21 it should be 22 Jul 21. I really don't know why the DAM software generates very incosistent date formats. Half of the issues here seem to result from that with that... Can you try just replacing all - by in your files. Let us know,

[katenevin21]

Hi @qgeissmann, I replaced the - with spaces, but I am still getting the same error unfortunately.

Here are the updated DAM files attached: Monitor 22.txt Monitor 23.txt Monitor 21.txt

Thank you for replying!

[pepelisu]

I think the problem here is the "by". The line 52 in load_dam.R is calling the "by" method with a vector c("path"... the error says that this is not the right way to give a list to "by" and it should be by=.(path,....) or by=list(path,...) without quoting the column names.

[qgeissmann]

do you think you could try a to send a PR @pepelisu ?

[pepelisu]

As soon as I can test that it works, I can do it. But it will not happen before Monday.