4

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.

Michael Martin-Smucker
  • 6,602

3 Answers3

2

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

fossfreedom
  • 172,746
0

All the photos are stored in Photos folder in Pictures folder in your home. And each photo is stored according to the date the photo is taken like this "Pictures/Photos/Year/Month/date".

For example if your photo is taken on 2011-10-20. It is stored in Pictures/Photos/2011/10/20 path.

Manula Waidyanatha
  • 8,555
  • Over the years, F-Spot's default location has changed from ~/Photos to ~/Pictures/Photos. This has left a lot of clutter in various places in the home folder, and I think it's what led to the missing files in the first place. I need to know -- on a picture-by-picture basis -- where F-Spot is looking for each photo. – Michael Martin-Smucker Aug 05 '11 at 14:44
  • F-spot stores pictures according to the Date the picture has been taken. For instance if you have 2 photos taken on 2011-10-20 and 2011-10-21 they will be stored on ~/Pictures/Photos/2011/10/20 and ~/Pictures/Photos/2011/10/21. So what you have to do is check the date the photo has taken (you can do it by right clicking the picture and go to the image tab -- nautilus) and put it in to the specific folder as I have mentioned. – Manula Waidyanatha Aug 06 '11 at 06:32
  • 1
    Thanks for your help, but the date isn't the part of the file location that I'm worried about -- it's the first part. Some pictures are stored in ~/Pictures/Photos, some in ~/Pictures and some in ~/Photos (and some in various other locations). I can find the photos, but F-Spot can't, and I'd like to know where it's looking for each individual picture (which varies wildly from one photo to another). – Michael Martin-Smucker Aug 06 '11 at 18:41
0

I found a (slightly complicated) solution. Right click the photo from the standard view (the one you get when you first Open F-Spot), and choose open with>Image Viewer.

In Image Viewer (in this case EOG), right click the picture and choose properties. It will show you where you photo is.

enter image description here

RolandiXor
  • 51,541