Find RAW + NON-RAW photos

Searching for photos that have both a RAW and a NON-RAW version like JPEG, TIFF, PSD, … ?
Default Lightroom can not find these files for you.

Category:

Description

What’s in it for me?

This report will list all photos with both a RAW and NON-RAW version.
Save the list as a CSV file and import it into Lightroom with the Photo list importer Lightroom plug-in into the “LRS_Photo_List” Collection for further processing.

For the difference with the Duplicate file name finder report and the Lighroom plug-in “Find similar file names” see the “Related reports” tab.

This report is can be used in conjunction with the Photo list importer Lightroom plug-in.

Specifications

Lists all photos in your Lightroom catalog or Quick Collection that have not a unique base name.

How does this query work?

Example, say my image has the file name DAH_20130112_9349.CR2.
This report will extract the first part of the file name until the extension: DAH_20130112_9349 (base name called)
Then it will search the Lightroom catalog for all images that have a file name like DAH_20130112_9349.*
So it will find images like:

  • DAH_20130112_9349.CR2
  • DAH_20130112_9349.JPG,
  • DAH_20130112_9349.TIFF,
  • DAH_20130112_9349.TIFF,
  • DAH_20130112_9349.DNG

However, it will NOT find:

  • DAH_20130112_9349_master.TIFF
  • DAH_20130112_9349_web.JPG
  • DAH_20130112_9349_master_BW.TIFF

Save the result as CSV file or any of the other output options, see Export tab.

Difference with theDuplicate file name finder report

Click on this link to for the comparison between these 2 reports.

Difference with the Lighroom plug-in “Find similar file names

Table below lists the difference between this report and the Find similar file names plug-in.

Duplicate file name finder
Find RAW + NON-RAW
Find similar file names
Lightroom plug-in
Search mechanism Search with “Base name.*”Example:
Search for: DAH_20130112_9349.*
Result: DAH_20130112_9349.JPEG and DAH_20130112_9349.TIFF, but not DAH_20130112_9349_master.TIFF
Search with “Base name*.*Example:
Search for: DAH_20130112_9349.*
Result: DAH_20130112_9349.JPEG and DAH_20130112_9349.TIFF, AND DAH_20130112_9349_master.TIFF
Speed Much, much faster Slower
Searches with Lightroom “Smart collection” mechanism.
Limitation Can search whole catalog. Tested on 100K+ catalog. Limited to 5000 images per run.
Advice Use the report when you want to find all duplicate photos in your catalog. Use when you want to find all photos that have a similar file name as the ones you selected.
Especially
useful when you reworked your originals and want to find all the old
derivative files, like master, B&W, web versions etc.

Usage

You can run this report against your whole catalog or against the photos in your Quick Collection.

Export

LightroomStatistics is open, you can export to:

  • PDF
  • Microsoft Office (Word, Excel, PowerPoint)
  • OpenOffice
  • HTML
  • XML
  • CSV

Parameters

The LightroomStatistics reports can be parametrized in order to get the desired results.
These parameters are described below. By the way, all parameters have a default value, so you only have to change them when needed.

Parameter Description
Restrict to images in Quick Collection
Description Restrict the report to the images in your Quick Collection if desired.
Default False (= whole catalog)
Unit Boolean
Format Check box (true or false)
Only photos in the same directory
Description This parameters specifies if the duplicate file names should be in the same directory.
Default false
Unit Boolean
Format Check box (true or false)
Only photos with the same date and time
Description This parameters specifies if only photos with the same date and time are listed or that the date and time may differ.
See the forum topic on “Same date and time”
Default false
Unit Boolean
Format Check box (true or false)

Translations

Translations: English, Dutch, French and German.
Contact us for translating this report into another language and get a license free.

Sample

Sample CSV output.
For other output options, see the “Export” tab.

NON-RAW filename,RAW_Name,baseName
E:/Foto's/2012/12/2012_12_20
Sailing/DAH_20121220_9346.TIF,E:/Foto's/2012/12/2012_12_20 Sailing/DAH_20121220_9346.CR2,DAH_20121220_9346
E:/Foto's/2012/12/2012_12_20
Sailing/DAH_20121220_9346.
PSD,E:/Foto's/2012/12/2012_12_20 Sailing/DAH_20121220_9346.CR2,
DAH_20121220_9346
E:/Foto's/2012/12/2012_12_20
Sailing/Export/DAH_20121220_9346.JPG,E:/Foto's/2012/12/2012_12_20 Sailing/DAH_20121220_9346.CR2,DAH_20121220_9346