Results 1 to 10 of 10

Thread: F-Spot: Move a photo to another dir?

  1. #1
    Join Date
    Mar 2006
    Location
    New Zealand
    Beans
    603
    Distro
    Ubuntu 12.04 Precise Pangolin

    F-Spot: Move a photo to another dir?

    I have just today begun using f-spot, I quite like it and it's a lot better than I expected. In the past I have just used plain folders and nautilus.

    The trouble is that all my photo's had the wrong dates and times. I went through and used the adjust time feature and everything is great... Except that each photo is under it's old year/month/day folder hierarchy.

    How to I force F-spot to reorganise my photo's under their new year/month/days so that everything is organised properly? I know programs like iTunes have the ability to re-organise libraries in this way.

    A final question is that in the event of me needing to format/upgrade my computer how would I export all the photo's with their tags etc? Do I use the export function and export to compressed archive?

    Cheers.

  2. #2
    Join Date
    Jun 2006
    Beans
    Hidden!
    Distro
    Ubuntu 7.10 Gutsy Gibbon

    Re: F-Spot: Move a photo to another dir?

    I have the same issue. I think you may have to update the database with the new path. Try the instructions here.

    I got the error
    Code:
    SQL error: no such column: directory_path
    which either means the new version has different column names in the database, or I typed it wrong.

    EDIT: In my version of f-spot the column is called "uri"
    Last edited by tistria; May 8th, 2008 at 03:03 AM.

  3. #3
    Join Date
    Apr 2006
    Location
    Fresno CA
    Beans
    2,790
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: F-Spot: Move a photo to another dir?

    F-Spots imposed folder and date storage was a real pain foe me. I use gthumb image viewer which gives me the freedom to file my way by topic and project. It also provides basic photo editing.
    Thank a veteran -- George 8)
    Internet Coach & Writer
    Personal Blog -- 3 Joes' Blog

  4. #4
    Join Date
    Jun 2006
    Beans
    Hidden!
    Distro
    Ubuntu 7.10 Gutsy Gibbon

    Re: F-Spot: Move a photo to another dir?

    I use the tagging features of f-spot, which I have not found in gthumb.

    I got the database transfer to happen, to do so I had to use a slightly different command in sqlite3:
    Code:
    sqlite> update photos set directory_path = 'file///home/[username]/Pictures' || substr(directory_path, length('file:///home/[username]/Photos/'), length(directory_path)) where directory_path like 'file:///home/[username]/Photos/%';
    Last edited by tistria; May 8th, 2008 at 03:26 AM.

  5. #5
    Join Date
    Mar 2006
    Location
    New Zealand
    Beans
    603
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: F-Spot: Move a photo to another dir?

    Well improved management of the directories and file locations would really make the program more attractive. In about 6 months I should have some spare money so I may post a bounty somewhere if it hasn't been implemented by 8.10 or the like.

  6. #6
    Join Date
    Dec 2006
    Beans
    19
    Distro
    Ubuntu 8.10 Intrepid Ibex

    Thumbs down Re: F-Spot: Move a photo to another dir?

    There is an extension for F-Spot that allows you to change the directory path in the database. However, it is currently unstable and does not inform you when the update is complete.

    It would be nice if this were a built-in feature, but for now you'll have to try the extension or use the command-line method mentioned above.

    Whatever you do, backup the database first!
    Code:
    cd ~/.gnome2/f-spot
    cp photos.db photos.db.backup
    Last edited by ckoester; May 21st, 2008 at 09:10 PM. Reason: add link to F-Spot extensions page

  7. #7
    Join Date
    Apr 2008
    Beans
    10

    Re: F-Spot: Move a photo to another dir?

    will this command allow me to view my photos without opening f-spot? I cant find my photos don't know where they are stored!

  8. #8
    Join Date
    Apr 2006
    Location
    Fresno CA
    Beans
    2,790
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: F-Spot: Move a photo to another dir?

    Quote Originally Posted by q1u2i3z View Post
    will this command allow me to view my photos without opening f-spot? I cant find my photos don't know where they are stored!
    Left clicking a file causes execution with the default application. When you right click any file you get a drop down menu. The 1st item opens with the default application and the 2nd "Open With" will give you a list of registerted applications for this file type. You may select from that list for this execution only. If you want to change the default application, select Properties on the bottom and then the "Open With" tab. Selecting a different application will make it the default for all files of this type.
    Thank a veteran -- George 8)
    Internet Coach & Writer
    Personal Blog -- 3 Joes' Blog

  9. #9
    Join Date
    Aug 2007
    Beans
    91

    Re: F-Spot: Move a photo to another dir?

    Quote Originally Posted by tistria View Post
    Try the instructions here.
    In case someone using a newer version of Ubuntu stumbles here.. the new location of the database is ~/.config/f-spot/photos.db (As per noted here.)
    Quote Originally Posted by tistria View Post
    ...
    EDIT: In my version of f-spot the column is called "uri"
    Yes that's quite right and while were at it, as per the comments in the instructions, one should also do the same updating for photo_versions table as well.

    P.S. In case you one ain't too pro with sql using sqliteman to edit the database might be easier. You still need to craft the statements, but it might be easier there than on the terminal. Also I would like to point out that it seems the urls are in the database on the form "file:///base/url/to/your/images/yyyy/mm/dd/" so it's probably wise to make sure you keep the file:/// part and the trailing / character in place. I'm not sure if things work if you don't.

  10. #10
    Join Date
    Jul 2007
    Location
    UK
    Beans
    16,867
    Distro
    Ubuntu Development Release

    Re: F-Spot: Move a photo to another dir?

    Necromancy.

    Thread closed.
    Attached Images Attached Images

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •