[ubuntu-mono] [Bug 354264] Re: Imports all photos to the root of the home directory

[chrisgriggs]

For me all photos ended up in my home directory without sub-directories
for dates. So after moving all my photos to the right place a slight
modification of Martijn's database update was needed. Note that all the
filenames for my photos start with "dsc". I hope this is useful to
someone.

chris at k9:~$ sqlite3 .gnome2/f-spot/photos.db 
SQLite version 3.6.10
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> update photos set uri = replace(uri, 'file:///home/chris/', strftime('file:///home/chris/Photos/%Y/%m/%d/', time, 'unixepoch')) where uri like 'file:///home/chris/dsc%';
sqlite> update photo_versions set uri = replace(uri, 'file:///home/chris/', strftime('file:///home/chris/Photos/%Y/%m/%d/', (select time from photos where photos.id = photo_versions.photo_id), 'unixepoch')) where uri like 'file:///home/chris/dsc%';
sqlite> .exit
chris at k9:~$

-- 
Imports all photos to the root of the home directory
https://bugs.launchpad.net/bugs/354264
You received this bug notification because you are a member of MOTU Mono
Team, which is subscribed to f-spot in ubuntu.