Question

2

Using F-Spot, how can I find the file location for a specific photo?

rated 0 times [ 2] [ 0] / answers: 1 / hits: 993 / 1 Year ago, tue, may 30, 2023, 5:25:05

Several of my parents' photos in F-Spot have gone missing. I can't seem to figure out the location of the photo file that F-Spot expects to find. I've been looking around for something like "Photo Properties" but so far I haven't seen it.

This is sounding confusing, so hopefully a screenshot will help clear things up:

enter image description here

In this photo, F-Spot is missing a picture.

We can see that the filename is img_0445.jpg.

I've found the actual photo in my backups.

I'm having a hard time replacing the missing photo, because I can't figure out in which directory F-Spot is expecting to find the photo.

Is there any way, using F-Spot to find the File Location of a photo? Something like Banshee's "Open Containing Folder"? I thought previously you could right-click a photo and choose "Copy File Location", but I'm not seeing that option in F-Spot 0.8.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

utonmbo

Add To Favorites

Follow

Total Points: 134

Total Questions: 104

Total Answers: 118

Location: Argentina

Member since Mon, Jan 3, 2022

2 Years ago

answered 1 Year ago uestred · Accepted Answer

You could interrogate the f-spot database itself to search for the filename in question. Once found, the file-location that f-spot was expecting will be available. This method would be particularly useful if you've got lots of pictures to search for.

Install sqlite3:

sudo apt-get install sqlite3

Now dump the f-spot database:

sqlite3 ~/.config/f-spot/photos.db .dump > ~/filelocations.csv

Using LibreOffice Calc - open the file filelocations.csv and search using the filename with the missing picture. The filename should exist in two rows - one or both of which should display your missing file location.

for example

enter image description here