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

[Martijn Vermaat]

Here's an attempt at a clean up strategy. Note that I don't have any
incorrectly placed photos on this computer, so the following is all
untested. You should only proceed if you understand what the commands
are doing.

Move the relevant photos (probably in ~/2009) to the ~/Photos directory.
Make sure you don't accidentally overwrite any existing photos or
directories (go back and forth between the two directories, copying
photos, in Nautilus for example). There's probably an easy automated
command line solution for this, but I leave that to someone else (fiddle
with 'find ~/2009', 'mkdir -p', and 'cp').

Now update the F-Spot database:

martijn at michelle:~$ 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/martijn/2009/','file:///home/martijn/Photos/2009/');
sqlite> update photo_versions set uri = replace(uri,'file:///home/martijn/2009/','file:///home/martijn/Photos/2009/');
sqlite> .exit
martijn at michelle:~$

Of course, if you have a localized or customized location for ~/Photos,
use that in the above instructions. And use your own home directory.

This can all be easily combined into a script that does some safety
checks and reports back to the user on its results by whoever wants to
sit down for it.

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