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.
ch...@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
ch...@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 Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
