RecordTable error - station directory not found in Digikam

[Angela Rana]

Hello,

I am encountering an error when I try to run Recordtable on the video files that I have tagged in Digikam. 

My code below:

NHead_test <- ("H:/PhD/Camera footage/Tunnels/NorthHead/") 

length(list.files(NHead_test, pattern = "AVI", recursive = TRUE))

dat <- read.csv("H:/PhD/Camera footage/Tunnels/NorthHead/NH_CamTrapR_cams_test.csv")

rec.db.species0 <- recordTable(inDir  = NHead_test,

                               IDfrom = "metadata",

                               timeZone = "Australia/Brisbane",

                               metadataSpeciesTag = "Species1",

                               video  = list(file_formats = c("jpg", "mp4", "avi", "mov"),

                                             dateTimeTag  = "DateTimeOriginal",

                                             db_directory = "C:/Users/aran8255/Pictures",

                                             db_filename = "digikam4.db"),

                               writecsv = TRUE

                               )

Error as follows:

Error: station directory H:/PhD/Camera footage/Tunnels/NorthHead//NHCS1 was not found in digiKam albums. Skipping

In case it helps, here is a screenshot of my camera info file (NH_CamTrapR_cams_test.csv)

and a screenshot of my Digikam albums:

I'm wondering whether the issue is because of the extra subfolders I have after the Station folders?

Any help would be much appreciated, thank you!

Angela

[lucer...@gmail.com]

Hi Angela,

Did you get any answer? Because I’m having the same exact error!

If you fixed that error, would you mind to share your solution?

Best,

Lucero

[Juergen Niedballa]

Hi Angela & Lucero,

I'm sorry for not replying to the original post, I must have missed it

The problem is the double forward slash you can see in the error message. 

It is caused by the "/" at the end of the input directory: 

NHead_test <- ("H:/PhD/Camera footage/Tunnels/NorthHead/") 

Change it to 

NHead_test <- ("H:/PhD/Camera footage/Tunnels/NorthHead") 

and it should be fine. 

Additional subdirectories should not cause problems.

Best regards,

Jürgen

[Emiliano Manzo]

Hi all,

I find an error when I try to run Recordtable on the video files that I have tagged in Digikam. 

 wd_video <- ("~/Documents/Camera_Trapping")
> length(list.files(wd_video, pattern = "MP4", recursive = TRUE))
[1] 1212
> rec_table1 <- recordTable(inDir  = wd_video,
+                           IDfrom = "metadata",
+                           minDeltaTime = 720,
+                           deltaTimeComparedTo = "lastRecord",
+                           metadataSpeciesTag = "Species",
+                           video  = list(file_formats = c("jpg", "mp4", "avi", "mov"),
+                                         dateTimeTag  = "QuickTime:CreateDate",
+                                         db_directory = "~/Documents/Camera_Trapping",
+                                         db_filename = "digikam4.db"))
Warning: timeZone is not specified. Assuming UTC
.mysql.digikam:      0 files      Skipping
Error: station directory /Users/emilianomanzo/Documents/Camera_Trapping/P1 was not found in digiKam albums. Skipping
In addition: Warning message:
.mysql.digikam :  contains no files of interest and was omitted 

Any ideas? I can't fix this error

Thank you

Emiliano

[Juergen Niedballa]

Hi Emiliano, 

I am not sure what exactly the problem is. I am quite sure that R finds the digiKam database and can open it (if not you'd get a different error message). There seems to be a problem with locating the folders within the database. 

Is the path that R is trying to locate: "/Users/emilianomanzo/Documents/Camera_Trapping/P1" a correct folder?

I developed the workflow on Windows and have never used a digiKam database from Mac. I expected them to work just the same, but never confirmed. The warning abour ".mysql.digikam" suggests that things may be a bit different on Mac (never seen this warning or this folder before). So there's a chance it may be a Mac issue. 

I don't think I'll be able to debug this remotely. Would you mind sharing the digikam4.db file please? Feel free to do so privately to my email-address. I'll then try to find the issue. 

Sorry I can't be more specific at this point. 

Best regards,

Jürgen