On Sat, Jan 03, 2009 at 03:43:04PM -0500, Dave Sill wrote: > I'm a newbie so bear with me. I normally store my photos under > /data/photos. The first couple of rolls I imported to my home > directory, so I've got 2007, 2008, etc. directories--I'd assumed it > would create a Photos subdir, but obviously not. Anyway, I've changed > my import directory to /data/photos, but I'd like to get the 300+ > photos in my home directory moved there, too, but I don't want to have > to retag them. > > I search the list archives and found a PHP script that I can probably > modify to do the job, but I'm not crazy about mucking around with the > database.
I think mucking would be easier than exporting and importing. This is completely untested, but it's easy enough to play with. I have f-spot 0.5.0.3. Move your photos to the photos directory, something like: $ mv 200* /data/photos/ Make a copy of your database (this is where mine is): $ cp .gnome2/f-spot/photos.db test.db $ sqlite3 test.db SQLite version 3.5.9 Then muck all you want. I'm only renaming one (where id = 1). You can use a more complex where to select which to operate on, or just leave it off to do it with all: sqlite> select uri from photos where id = 1; file:///media/store/photos/2004/05/06/foo.jpg Do the replace (you would want to make sure you have a good match string): sqlite> update photos set uri = replace( uri, '2004', 'photos/2004' ) where id = 1; sqlite> select uri from photos where id = 1; file:///media/store/photos/photos/2004/05/06/foo.jpg Now, there's also a "photo_versions" table, so you would likely need to repeat for the "url" there, too. -- Bill Moseley mose...@hank.org Sent from my iMutt _______________________________________________ F-spot-list mailing list F-spot-list@gnome.org http://mail.gnome.org/mailman/listinfo/f-spot-list