search

gilestrolab / ethoscope

a platform from monitoring animal behaviour in real time from a raspberry pi
http://lab.gilest.ro/ethoscope/
GNU General Public License v3.0
17 stars 25 forks source link

Database File structure incorrect? #189

Closed BrainFriedLab closed 5 months ago

BrainFriedLab commented 5 months ago

Hi there,

I'm so close to getting rethomics working, I can taste it. BUT, I've found a weird problem with the .db files that is holding me up. Below is a comparison between the database file structures of my .db file (left) and your rethomics ethoscope .db file (right). The csv table is aokay looking. But it's missing tables for all of the ROIs and missing "Start events" and "Var_map" tables which is preventing me from loading up the data into rethomics.

image
BrainFriedLab commented 5 months ago

One thing I know I have an issue with is the settings for the backup of the data. The folders are weird, so we got into the habit of just going onto the ethoscope raspberry pi folder and copying the .db and .txt files from it and pasting them into a little back up folder on the node.

We did this because the node or ethoscope seemed to freeze or get hung up when we ran the "backup" process. According to the following link, perhaps that "backup" process is more than just moving files around? Maybe without backing it up with that button and just copy and pasting the files, I'm missing out on a step where the database creates new tables?

https://giorgiogilestro.notion.site/Performing-data-backup-22b2260e7c9c444aa6542e33f5a7cb29

BrainFriedLab commented 5 months ago

Figured it out! I went back to more .db files. Turns out my other .db files are a-okay in terms of the tables that are in them. It's just this single one that doesn't have the tables correctly in there. Not sure how to add proper tables, but I've gotten through that error!

ggilestro commented 5 months ago

Good to hear!