|
I manage a boatload (several hundred thousand) images for work. We are implementing a Digital Asset Management System so that I don't have to pop into lightroom and export photos every time someone needs to make a powerpoint. Due to a vendor problem, when we imported ~100k photos into the DAMS, the DublinCore keywords did not get ingested into the DAMS metadata. There is a way around this: I can upload a spreadsheet with the filenames and the keywords to the DAMS and it will input them for me BUT how do I make lightroom export me such a list? I just need 2 excel columns: file name and keywords. I am willing to spend money on this solution.
|
# ¿ Dec 25, 2017 01:44 |
|
|
# ¿ May 3, 2024 09:30 |
|
xzzy posted:If you are sql handy, the lightroom catalog is just a sqlite database. The queries are annoying but the main table of interest is Adobe_images. Adobe_images has a column id_local which will reference rows in AgLibraryKeywordImage, and rootFile which gets you the on-disk file name from AgLibraryFile. When you need to convert the keyword id to their string, AgLibraryKeyword is the table to query. I am not handy in that regard but I can relay this message to someone who is!
|
# ¿ Dec 25, 2017 16:14 |