Skip to main content
plunkettphoto
plunkettphoto
Inspiring
May 30, 2010
Question

Need help extracting and exporting metadata for other applicationsas

  • May 30, 2010
  • 2 replies
  • 961 views

As some of the lua documentation says, I have neither the time nor inclination to learn Lua but if what I need is even possible, I would hire someone to write the code for me.

What I want to do is extract metatdata stored in the PSD/TIFF or RAW files and write it out in a form that I can import it into a SQL database (Specifically Sqlite).  I can already read the LR catalog and get the information I need stored there but apparently the the Title and Caption info is not in the LR catalog but is stored in the image file itself.  I could be wrong on this but I have been unable to find these two fields in any of the Lightroom tables - but they are fairly cryptic.  It seems strange that the EXIF data would be pulled into the catalog but the caption and title, generated within lightroom are written back to the image file.

I showed this by tagging an image in lightroom with a very unique title, then using spotlight to search for that title.  The only file returned was the original PSD file - not the lrcat file.

can anyone help ?

thanks

bill plunkett

This topic has been closed for replies.

2 replies

A
Anonymous
May 31, 2010

You can use an existing plug-in to do this. The excellent LR/Transporter plugin (http://www.photographers-toolbox.com/products/lrtransporter.php) will allow you to export the metadat you want in a comma separated file, which you can then import into the database of your choice.

Neil

P
petez
Participating Frequently
June 22, 2010

Or use this Windows app:

http://pkzsoftware.com/LME.aspx

plunkettphoto
plunkettphotoAuthor
Inspiring
May 30, 2010

Okay, the Title and Caption are buried in the AgMRUList table.  Problem is I haven't been able to hack the foreign key relationships to uniquely identify the rows that go with a particular image.  The table contains a row for the caption and another row for the title, problem is the id_local fields for the two rows are different so I can't determine what ties the rows in AgMRUList to the rest of the image information.

anyone have any information on how the lr catalog is organized as far as the SQL tables?

thanks bill

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices