On 13/01/07, Patrick Wagstrom <[EMAIL PROTECTED]> wrote: > On 1/12/07, Dotan Cohen <[EMAIL PROTECTED]> wrote: > > I seem to have some photos with duplicate file names in F-Spot. I > > intend on renaming them so that I could more easily export my photos > > to my website, but then I'm afraid that F-Spot will not recognize > > them. How can I tell F-Spot that I've renamed a photo (short of > > reimporting it)? > > You may have to do some SQL hacking. Run these commands: > > sqlite ~/.gnome/f-spot/photos.db > > update photos set name='NEWFILENAME' where > directory_path='DIRECTORYOFPHOTO' and name='OLDFILENAME'; > > > For example, if outside of f-spot I renamed /home/patrick/photos/photo1.jpg > to /home/patrick/photos/photo2.jpg I would run: > > update photos set name='photo2.jpg' where > directory_path='/home/patrick/photos' and name=' > photo1.jpg'; > > If I moved /home/patrick/photos/photos1.jpg to > /media/photos/photo2.jpg I would run: > > update photos set name='photo2.jpg', > directory_path='/media/photos/photo2.jpg' where > directory_path='/home/patrick/photos' and name=' > photo1.jpg'; > > The usual caveats about backing up your system and being able to shoot > yourself in the foot doing this apply. > > --Patrick
That doesn't seem to bad. sqlite won't recognize the photos.db file, so I'm using sqlite3. No biggie. Thanks. Dotan Cohen http://what-is-what.com/what_is/website.html http://essentialinux.com/emulators.php _______________________________________________ F-spot-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/f-spot-list
