On 1 Feb 2013, at 14:58, Michael Hendry <[email protected]> wrote:

> 
> On 31 Jan 2013, at 23:00, Jim Nelson <[email protected]> wrote:
> 
>> We've had an outstanding bug that resulted in some thumbnails not being 
>> regenerated, as well as a bug where video thumbnails were not being 
>> regenerated.  These are fixed in master and will be available in 0.14.
>> 
>> If you'd like to try the absolute latest of Shotwell, you can install it 
>> from our Daily Build PPA: https://launchpad.net/~yorba/+archive/daily-builds/
>> 
>> One other trick for forcing Shotwell to generate all your photo thumbnails 
>> (but not the videos): in the Library page (the first one when you run 
>> Shotwell), press F8 and press the far-left button on the Search bar; this 
>> will display only photos.  Then press Ctrl+A and Ctrl+R.  This will rotate 
>> all the photos, generating new thumbnails along the way.  When it's 
>> finished, press Ctrl+Z.  This will revert the rotation and generate 
>> thumbnails again.
>> 
>> Convoluted, but a simple trick until 0.14 is released.  Or, as I mentioned, 
>> please consider running our Daily Build version and see if that fixes it.
> 
> Further to my last message, the select all, rotate and undo didn't work for 
> me.
> 
> I think I may have to cut my losses and try a different angle on this.
> 
> What I'm proposing is:
> 
> 1. Clear the library in my (Parallels) version of Shotwell altogether.
> 2. Copy across the database and thumbnails from the old computer.
> 3. Work out how to change the references in the database so that the full 
> paths to the files match the new computers file structure, not the old.
> 
> I've done a bit of work in MySQL, so I think I might be able to cope with 
> this.
> 
> Is this a feasible route?
> 
> Michael

And the answer is: Yes!

1. Is unnecessary.
2. Proceeded without trouble. I overwrote all the files in the .shotwell 
directory with their counterparts from the source computer.
3. Required me to install sqlite on the destination computer.

Opening the database in sqlite, I found that the table "PhotoTable" has a 
column "filename" which contains the absolute path to the file which needs to 
be changed to suit the destination computer. Fortunately, there is a simple SQL 
statement which does this:

update PhotoTable set filename = replace(filename, '/home/michael/Pictures/', 
'/home/parallels/Desktop/Parallels Shared Folders/Home/Pictures/Shotwell 
LIbrary/')

I confess that I had my fingers crossed when I powered up Shotwell after doing 
this, but all appears to be working correctly.

All I need to do now is find out how to set up the external editor links so 
that the Mac copies of GIMP and UFRAW are used.

Oh, and keep an eye open for the aspects of the conversion I've been too 
ignorant to spot…

Michael

_______________________________________________
Shotwell mailing list
[email protected]
http://lists.yorba.org/cgi-bin/mailman/listinfo/shotwell

Reply via email to