Re: Editing directory names.

[ulugeyik <durduran hotmail com>]

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
> 
> 

-- 
View this message in context: http://www.nabble.com/Editing-directory-names.-tf3868609.html#a10981487
Sent from the Gnome - F-Spot mailing list archive at Nabble.com.