Home / ubuntu / Questions / 55682
Accepted
Michael Martin-Smucker
Asked: 2011-08-04 09:36:20 +0800 CST

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

  • 772

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.

f-spot

3 Answers

  1. Best 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

    • 2

  2. 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.

    • 0

  3. 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

    • 0