Re: Editing directory names.

[Stephane Delcroix <stephane delcroix org>]

Sorry if my sounded harsh, and Bengt is working on an extension for
doing this. In the meantime, there's no other solution...

regards

s


On Tue, 2007-06-05 at 19:47 -0700, ulugeyik wrote:
> Hi Stephane,
> 
> Re-doing the hierarchy is a big burden so I would rather not do that.
> Ofcourse, I kept the original database so I can save my behind. But I do not
> know why you sounded so harsh about this, I mean, it would be nice to have a
> program to give flexibility in changing locations of the stuff, would not it
> be? People are using f-spot with 10s of thousands of photos, it is not so
> unexpected that someone would make a mistake like this, or will have to
> change paths in their drives.
> 
> All I did was a search/replace.I replaced all ocurences of /my/old/path with
> /my/new/path . Is that such a bad thing?
> 
> Thanks,
> 
> Turgut
> 
> PS: Ofcourse, I know linux enough that I made symbolic links from original
> place to the new place I  wanted them to be at and it is usable but it is an
> unnecessary complication if I can fix this problem.
> 
> 
> 
> Stephane Delcroix wrote:
> > 
> > sorry, can't help you to fix your db... at the time you start editing
> > it, you're on your own (I mean, we do not know what you did...)
> > 
> > but to solve your particular problem, if 'Write Metadata to files' (in
> > Preferences Dialog) was checked, you can simply drop your db (start with
> > a clean f-spot) and reimport your images. All the tags will be
> > re-created, and you'll only have to redefine the tag hierarchy.
> > 
> > regards
> > 
> > s
> > 
> > On Mon, 2007-06-04 at 16:11 -0700, ulugeyik wrote:
> >> Long time ago, someone posted the following instructions to edit
> >> filenames in
> >> the database. I just tried that, in the last step I had a whole lot of
> >> errors like:
> >> SQL error near line 113772: PRIMARY KEY must be unique
> >> 
> >> So I ignored them and opened up the database in f-spot. It turns out that
> >> it
> >> was able to find the photos and showed the little images associated with
> >> each tag but the tags were gone. I mean, I could select them, search them
> >> etc but pressing "t" to view what tags were there did not work. 
> >> 
> >> I am not following it very closely but there are lot of changes to the
> >> database from what I gather. Can someone help me with the "correct" way
> >> of
> >> doing this? Basically, I imported photos from a temporary folder by
> >> accident
> >> and did a lot of tagging editing on it, so I do not want to re-do this. I
> >> figure, I should be able to edit the database.
> >> 
> >> I apologize if this is common knowledge and I am not seeing it. 
> >> 
> >> Thanks for all the help. Below are the commands I tried.
> >> 
> >> Turgut
> >> 
> >> ===
> >> 
> >> cd ~/.gnome2/f-spot/
> >> mv photos.db photos_orig.db
> >> sqlite3 photos_orig.db .dump > photos.dump
> >>  [ edit photos.dump with a text editor ]
> >> sqlite3 photos.db < photos.dump
> > -- 
> > Stephane Delcroix
> > stephane delcroix org
> > 
> > _______________________________________________
> > F-spot-list mailing list
> > F-spot-list gnome org
> > http://mail.gnome.org/mailman/listinfo/f-spot-list
> > 
> > 
> 
-- 
Stephane Delcroix
stephane delcroix org