Editing directory names.

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
-- 
View this message in context: http://www.nabble.com/Editing-directory-n
ames.-tf3868609.html#a10960335
Sent from the Gnome - F-Spot mailing list archive at
Nabble.com.

_______________________________________________
F-spot-list mailing list
F-spot-listgnome.org
ht
tp://mail.gnome.org/mailman/listinfo/f-spot-list

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
stephanedelcroix.org

_______________________________________________
F-spot-list mailing list
F-spot-listgnome.org
ht
tp://mail.gnome.org/mailman/listinfo/f-spot-list

Stephane Delcroix wrote:

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

And if you have RAW files your are SOL anyway.


Hub
_______________________________________________
F-spot-list mailing list
F-spot-listgnome.org
ht
tp://mail.gnome.org/mailman/listinfo/f-spot-list

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
> stephanedelcroix.org
> 
> _______________________________________________
> F-spot-list mailing list
> F-spot-listgnome.org
> ht
tp://mail.gnome.org/mailman/listinfo/f-spot-list
> 
> 

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

_______________________________________________
F-spot-list mailing list
F-spot-listgnome.org
ht
tp://mail.gnome.org/mailman/listinfo/f-spot-list

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
> > stephanedelcroix.org
> > 
> > _______________________________________________
> > F-spot-list mailing list
> > F-spot-listgnome.org
> > ht
tp://mail.gnome.org/mailman/listinfo/f-spot-list
> > 
> > 
> 
-- 
Stephane Delcroix
stephanedelcroix.org

_______________________________________________
F-spot-list mailing list
F-spot-listgnome.org
ht
tp://mail.gnome.org/mailman/listinfo/f-spot-list

Stephane Delcroix wrote:
> 
> 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
> 

Thanks Stephane , as usual you are  very helpful and
interested in answering
all our questions.

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

_______________________________________________
F-spot-list mailing list
F-spot-listgnome.org
ht
tp://mail.gnome.org/mailman/listinfo/f-spot-list

I am going to be nasty and top-post  I am happy
to announce that I found
the problem. In the last step where sqlite3 is re-invoked,
the file should
not be an *EXISTING* one. If a different name is supplied
everything works.

A more fun method is the one-liner (unwrap the line)

cp photos.db photos060707.db 
sqlite3 photos060707.db ".dump" |sed -e
's|original/path|new/path|g'
|sqlite3 photos060707_2.db
cp photos060707_2.db photos.db

Thanks,

Turgut


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
> 

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

_______________________________________________
F-spot-list mailing list
F-spot-listgnome.org
ht
tp://mail.gnome.org/mailman/listinfo/f-spot-list