Re: Editing directory names.
- From: Stephane Delcroix <stephane delcroix org>
- To: ulugeyik <durduran hotmail com>
- Cc: f-spot-list gnome org
- Subject: Re: Editing directory names.
- Date: Wed, 06 Jun 2007 09:34:11 +0200
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
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]