3

Is there a way to just export a list of the filenames, instead of creating a copy of some of the photographs in a new folder? The list should be only those photographs that exist in a group (flagged/colour label/ etc.)

OS is Windows.

1

2 Answers 2

5

You can do this

  1. Apply your filter in the library module,
  2. Select all photos
  3. Select "File Menu/Export as catalog..."
  4. Click "Export selected photos only" (This doesnt export the photos, only the metadata) , uncheck the other checkboxes
  5. Choose an appropriate filename for the .lrcat file, save it, (optionally use the .sqlite extension)
  6. Open the .lrcat file in a database query tool that understands the sqlite data format, e.g. code: https://github.com/lazierthanthou/sqlite-manager , download: https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/
  7. Extract the filename info from table 'AgLibraryFile' with SELECT basename , extension FROM AgLibraryFile (customize the SQL),
  8. save to csv file

(I admit it's a bit involved and awkward, but it gets the job done.)

An even better solution is:

  1. Install Jeffrey Friedl's Data Explorer Plugin.
  2. Open this Plugin. (File/Plugin Extras/ jfDataExplorer Explore...)
  3. Design a search using any criterion
  4. Let the plugin search the catalog.
  5. In the final dialog box, click "Save-to-tab-separated-values file" button

This way you can export even the weirdest and sophisticated searches. See screenshot attached.

data-explorer dialog-box

1

I have the better way.

  1. Move original file to another folder.
  2. Select photos that you want to get the filenames of.
  3. Menu "Export with Preset" -> "For Email (Hard Drive)"
  4. Select Somefolder for Export
  5. After Export you can see "The file could not be found"
  6. click "Save As..." button and type Filename

Now you have a list of photo file names in a Text file.

Remark: If you selected more than 1000 photos for Export, an error might occur. please select only up to 1000 photos per time.

1
  • 1
    This answer could use a bit of clarification. In step 1 I guess the files need to be moved outside of Lightroom? Step 4: select the folder which includes the now missing files? Also you probably need to move the files back to their original folder in a step 7.
    – Grebu
    Jan 21, 2018 at 16:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.