adobelightroom

Performing mass file renaming on the Lightroom database


I'd like to perform a mass renaming of all files in the lightroom database From: xxx_2.nef To : xxx.nef

I.e, for each image, if the name contains _2, then remove it.

Which tables and columns would be appropriate to hit?


Solution

  • Ended up using sql lite to open up the .lrcat file: Ran this query to fix the issue:

    update AgLibraryFile
    set basename = substr(basename, 0, length(basename) -1),
    idx_filename = substr(basename, 0, length(basename) -1)  || '.' || extension,
    lc_idx_filename = substr(basename, 0, length(basename) -1)  || '.' || extension,
    originalFileName = substr(basename, 0, length(basename) -1)  || '.' || extension
    WHERE basename like '%-2'