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 > > [EMAIL PROTECTED] > > > > _______________________________________________ > > F-spot-list mailing list > > [email protected] > > http://mail.gnome.org/mailman/listinfo/f-spot-list > > > > > -- Stephane Delcroix [EMAIL PROTECTED] _______________________________________________ F-spot-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/f-spot-list
