Fixing missing stacks using SQLite (imported photos from PS Elements)

  • Thread starter Thread starter tobbe75
  • Start date Start date
Status
Not open for further replies.
T

tobbe75

Guest
I am trying to migrate my catalog of about 2'.''' photos from Photoshop elements to Lightroom 2.4.

First of all I don't have the "Import catalog from elements" option in the menu. I have read this might be an issue on Vista 64-bit OS

So I used psedbtool(http://www.johnrellis.com/psedbtool/index.htm) to export the keywords more reliably to the files (hierarcical keywords)
Then I imported all photos with the "import from files and folders" option.
So far so good.
But Elements is using a naming convention where edited photos are named originalname-edited1.JPG. Those photos are then "stacked" in a "version set".
I want to have those photos stacked in Lightroom and put the most recently edited photo on top of that stack. I can use the "auto-stacking using capture time" option, but it seems to not work for all photos, besides that the original photo then becomes the "top" photo of the stack.

So now I am trying to use SQLite to do the stacking (on a copy of my catalog file).
I have manged to do this, but something must be wrong or missing, since the thumbs of thoose stacks are missing along with the stacked photo symbol in grid view. I can still edit the photos, but not expand the stack, and not view either the top or bottom photo in grid view. The bottom photo is not possible to see at all.

I would be very thankfull for any suggestions on either another way to do this, or examples on how to create the stacking in the database directly.

PHP files for manipulating the database is available and I will post this here if necessary, along with any other information and/or files.

Obviously manually stacking of 2'.'''+ photos is not an option.

OS: Windows Vista 64-bit
LR version 2.4
PS elements version 7
PHP 5.3.' (with its standard support for sqlite3)

Thanks in advance,
Tobbe
 
I don't have an answer, as I suspect you may be the first person ever to attempt such a thing.

But I do wish you good luck.
 
Wow, that's quite a task! I don't know the answer either, but I'd love to hear how you get on!
 
Even those of us who enjoy their SQL wince at the thought of this.

It's also worth adding that the difficulty of migrating to other programs is a reason for not putting too much faith in stacks.

John
 
Status
Not open for further replies.
Back
Top