Re: Renaming files

["Dotan Cohen" <dotancohen gmail com>]

On 13/01/07, Patrick Wagstrom <patrick wagstrom net> wrote:
> On 1/12/07, Dotan Cohen <dotancohen gmail com> 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