Jeffrey’s “Data Explorer” Lightroom Plugin

One example of the plugin's 186 ways to group your images

This plugin for Adobe Lightroom allows you group photos and videos in your Lightroom catalog by more than 150 data criteria. For example, grouping a large folder tree by “Crop Amount” might result in the screenshot seen above.

By clicking “isolate” on each row, the relevant images are shown. The plugin also creates a row-specific collection, such as:

Data Explorer > Crop Amount > Slight Crop

and populates it with the pertinent photos so that you can refer to them later.

The basic purpose is essentially the same as Lightroom's own Library Grid Filter, but Adobe's built-in functionality, though fast, has extremely limited scope. If it were able to handle more than the scant few fields it currently supports, there would be no need for this plugin, but it doesn't, so here we are.

As it is, this plugin lets you inspect and group photos via a bewildering number of criteria, from the mundane (“group by copyright name”) to the esoteric (“group by geoencoded hemispheres”) to the particular (“group by amount of Clarity applied in Develop”) to the advanced (“group by camera-calibration profile”). The entire list of 186 criteria is shown below.

Table of Contents

Download

This plugin works in Lightroom CC/6, Lightroom 5, and Lightroom 4.

Lightroom 4.1 or later is required.

The same download works for both Windows and Mac. See the box to the upper right for the download link (in orange) and installation instructions.

Search. Filter. Group. Explore.

This plugin can be used to search or to browse. A search helps you locate photos that match specific criteria, such as “Where are my panoramas with a really wide aspect ratio?”, while browsing lets you see the range of values represented by some particular criteria in your library, answering questions like “What range of aspect ratios do I have in my library?” (The answer for my catalog at the moment: as tall as 1 : 2.58151 and as wide as 6.4 : 1”).

Browsing can be both fun and useful, especially for catalog cleanup, such as after grouping by “Copyright”, you may see various versions of the same person's name that you'd want to make identical.

Sometimes the results are surprising. While making the screenshot shown at the top of this page, the first thing I noticed was that four photos had an essentially-100% crop! I wondered what they were, and found the answer with one click of the “isolate” button: the four photos were presented and I recognized them as the extrem crops that appeared on this blog post 18 months ago, and an extreme crop of the first photo on this post that I used to use as my online avatar.

Anyway, I started writing this plugin the first time I tried to use the results of an X-Rite ColorChecker Passport in Lightroom, which allows you to make situation-specific camera-calibration profiles for Lightroom's render engine. After trying it with some photos in my library, I quickly lost track of which photos got which profile; it was very frustrating because the only way to know was to inspect each photo's develop settings, one by tedious one, and manually keep a running tally.

Now, I can invoke this plugin on a folder and quickly see:

It didn't take long to solve my immediate need (a crude plugin that merely listed the camera-calibration profiles and their photos), but it's taken three weeks of never-ending “just one more enhancement...” development to whip it into good enough shape to put my name on and release.

Even while writing up this web page after I thought the plugin was ready to release, I realized that Lightroom does not normally subject images hidden within collapsed stacks to catalog operations (such as the grouping operation done by this plugin), so writing this page got put on hold while I addressed that issue in the plugin:

It wasn't straightforward at all, especially to handle it as efficiently as possible, so I burned the better part of a day on just that. Such is the nature of Lightroom plugin development driven by a passion to make things useful.

While talking about searching and browsing, for times when you want only to search, this Data-Explorer plugin may well fill your needs, but you may also want to keep the following plugins in mind as well:

I've not used John's plugin, but it looks to be quite impressive.

Invocation

The plugin is invoked via “File > Plugin Extras > Explore...”, but it's much faster and convenient to invoke via a Lightroom keyboard shortcut.

On Windows, the keyboard shortcut is “ALT-F S E”.

On a Mac, you can set the shortcut as you like. For my own workflow, I've chosen Option Shift Command F”.

This pops up a dialog that allows you to select the criterion to explore by:

You can pick something from the dropdown box (currently showing “Aspect Ratio...” in the screenshot above), or just start typing search terms, and the dialog immediately transforms into an effective way to find the item you want among the 186 criteria the plugin supports:

Clicking on any criterion returns you to the initial dialog with that item selected, but if the search results in just one criterion, you can press ENTER to immediately launch Data Explorer with that criterion as the basis for grouping.

The “Include items hidden within collapsed stacks?” option is off by default because with large sets of photos it can cause quite a delay because when enabled, the plugin must fetch stack-related data from the catalog, then walk the list inspecting each stack for new photos not already included.

This doesn't take long for small sets of photos... on my laptop it takes about a second to do 1,000 photos, but even this is highly dependent on what else Lightroom is doing in the background. (When I select “All Photographs”, Lightroom turns my CPU into a space heater as it renders thumbnails in the background.)

But that time adds up, and it's a one-minute delay for 60,000 photos. Because the process must finish before the grouping process can be launched, I made the entire option default to unselected.

By the way, here's an interesting general little Lightroom workflow tidbit: Lightroom ignores stacks if you select both Folders and Collections, bringing anything that had been hidden within collapsed stacks into the target set. So, if you select “All Photographs” in the upper left of Library and see X of Y photos” in the filmstrip instead of just Y photos”, and if this can't be explained by you Library Filter, you have photos hidden within collapsed stacks.

If you then option-click (ALT-click) on any folder, you're not really adding anything new to the target set because any folder's photos are already included with “All Photographs”, but because you've now got a collection and a folder selected, Lightroom ignores stacking and voilà, you're at a straight-up Y photos” that really is everything in your catalog.

You can apply the same idea while viewing a specific folder if you create an empty collection (perhaps named “Empty”) that you can add to the selection.

Criteria List

The following table lists the 186 criteria available as of version 20150607.96.

Due to the nature of Lightroom's plugin infrastructure, items marked with a “*” take longer to process.
Items marked with a “***” take even longer, requiring a full inspection of each master image file.

In Lightroom Library
File Currently Available?*File is available, or offline (e.g. on an external disk not currently connect)?

Example responses include:

  • Offline (master file not available)
  • Offline (but Smart Preview does exist)
  • Available (though without a Smart Preview)
  • Available, but file on disk is empty(!!!)
  • Available, but file on disk is smaller than Lightroom expects
  • Available, but file on disk is larger than Lightroom expects
Smart-Preview Status*Does a smart preview exist for the image? (Lightroom 5.0 and later)

Example responses include:

  • Yes
  • Yes (but master image has fewer bytes)
  • No (but could be built)
  • No (can't be built; photo is unavailable)

Also reports the amount of disk space actually taken by Smart Previews, and the space savings afforded by those Smart Previews (that is, for images with Smart Previews, their disk space relative to the disk space required for their master images).

File TypeFile type (DNG, JPEG, Raw, Video, ...)
File Write-Permission StatusWhether the file can be changed (written) and/or deleted
Folder NameName of the folder (without path) the file is in. Useful for isolating images in a parent folder when there are also images in a subfolder.
Path NameFull path of the folder the file is in. Useful for isolating images in a parent folder when there are also images in a subfolder.
File ExtensionFilename extension (JPG, NEF, AVI, MTS, CR2, ...) in a case-insensitive manner.
File Extension
(case sensitive)
Filename extension (jpg, NEF, AVI, mts, CR2, ...) in a case-sensitive manner
Copy NameVirtual-copy name for the photo/video.
Virtual-Copy CountNumber of virtual copies a master image or video has.
Snapshot Count*The number of snapshots for the related master photo.
Stacking StatusStatus with respect to stacking (within its parent folder).

Example responses include:

  • Not stacked
  • Part of a visible stack
  • Top of a collapsed stack
  • Hidden within a collapsed stack
Stack-Membership SizeNumber of photos/videos in its stack (within its parent folder).
Position in StackPlace in stack (within its parent folder).

Example responses include:

  • Not stacked
  • Top
  • Bottom
  • Inside
Number of UpdatesRough count of changes (both metadata updates and develop edits). It's not an absolute counter, though, as Lightroom lumps multiple changes within a short time as a single update.
Most-Recent Update DateDate of the most recent database change (metadata update or develop edit) to the image
RatingStar rating (a number from 1 to 5).
Flag StatusPick, Rejected, or Neither
Color LabelColor label name.
Keyword List
(all)
List of all keywords associated with an image (warning: can be long!).
Keyword List
(exportable only)
List of keywords marked “Include on Export” (warning: can be long!).
Keyword List
(non-exportable only)
List of keywords not marked “Include on Export” (warning: can be long!).
Count of people tagged in a photoCount of people tagged in a photo (confirmed faces only).
Count of people tagged in a photo
via keyword that is marked “Include on Export”.
Count of people tagged in a photo (confirmed faces only) where the keyword is marked “Include on Export”.
Count of people tagged in a photo
via keyword that is not marked “Include on Export”.
Count of people tagged in a photo (confirmed faces only) where the keyword is not marked “Include on Export”.
Keywords
(individually, all)
Each keyword associated with an image, as individual items.
Keywords
(individually, exportable only)
Each keyword marked “Include on Export”, as individual items.
Keywords
(individually, non-exportable only)
Each keyword not marked “Include on Export”, as individual items.
Keyword Count (all)Count of all keywords associated with an image.

Also reports the total number of distinct keywords seen across all selected images.

Keyword Count (exportable only)Count of keywords marked “Include on Export”.

Also reports the total number of distinct keywords seen across all selected images.

Keyword Count (non-exportable only)Count of keywords not marked “Include on Export”.

Also reports the total number of distinct keywords seen across all selected images.

Plugin custom metadata?Shows the number of plugins that have added custom metadata for the image. The list of plugin ids is included in TSV spreadsheet file.
Collection Membership
Collection Membership*
(All)
Lists the collections (standard or publish) that selected photos are part of.

This item could entail a performance hit for some catalogs. In order to calculate the results for this item, the plugin has to do a manual walkthrough of every photo in every publish collection and in every non-publish smart collection of the entire catalog, regardless of how many or few photos are selected for inspection. This could take some time.

Normally the search ignores collections that this plugin itself creates (when you isolate results after a search), but as an option you can have them included as well.

Note: any Workflow Delete Options collections are always ignored.

Collection Membership*
(non-Publish only)
Lists the standard (non-publish) collections that selected photos are part of.

This item could entail a performance hit for some catalogs. In order to calculate the results for this item, the plugin has to do a manual walkthrough of every photo in every non-publish smart collection of the entire catalog, regardless of how many or few photos are selected for inspection. This could take some time.

Normally the search ignores collections that this plugin itself creates (when you isolate results after a search), but as an option you can have them included as well.

Note: any Workflow Delete Options collections are always ignored.

Collection Membership*
(Publish only)
Lists the publish collections that selected photos are part of.

This item could entail a performance hit for some catalogs. In order to calculate the results for this item, the plugin has to do a manual walkthrough of every photo in every publish collection of the entire catalog, regardless of how many or few photos are selected for inspection. This could take some time.

Normally the search ignores collections that this plugin itself creates (when you isolate results after a search), but as an option you can have them included as well.

Note: any Workflow Delete Options collections are always ignored.

Equipment
Camera Make and ModelCamera make and model in a normal human-readable way (e.g. “Nikon D4”, “Apple iPhone 5s”, etc.)
Camera Make, Model,
and Serial Number
Camera name with its serial number.
LensThe lens used to take the photo (e.g. “50 mm f/1.4”).
Lens Description***
(built from master-file data)
A description of the lens cobbled together from the raw master-file metadata. This can be useful to identify certain kinds of manual lenses, or perhaps lens + teleconverter combinations.
Focal LengthFocal length of lens as shot (e.g. “85 mm”).
Focal Length 35mm EquivFocal length of the lens as shot, in full-frame 35mm terms (e.g. “135 mm”).
SoftwareSoftware used to process/create the photo prior to import into Lightroom.
Exposure
Exposure*Exposure summary (e.g. “1/60 sec at f/2.8”).
Total Exposure
(camera Ev)
Total camera exposure (Ev), derived from the shutter speed, aperture, and the ISO speed rating (but without any adjustment for Exposure added or removed in Lightroom). Gives a sense for how much light was available. Lower numbers mean less light.
Total Effective Exposure*
(effective camera Ev)
Total effective camera exposure (effective Ev), derived from the shutter speed, aperture, and the ISO speed rating, then adjusted to reflect any Exposure added or removed in Lightroom. Gives a sense for how much light was available. Lower numbers mean less light.
Shutter Speed*Shutter speed used to take the photo (e.g. “1/60 sec”).
Aperture*Aperture used to take the photo (e.g, “f/2.8”).
In-Camera Exposure Bias*In-camera exposure bias/compensation (e.g. “-2/3 EV”).
FlashWhether the flash fired (“Did fire” or “Did not fire”).
Exposure ProgramExposure program (“Manual”, “Aperture priority”, “Landscape”, ...).
Metering ModeMetering mode (“Center-weighted average”, “Spot”, ...).
ISOISO Sensor-sensitivity speed rating (e.g. “100”).
Subject DistanceSubject distance (e.g. “1.92 m”); often wildly incorrect.
Size
Cropped?Has a crop been applied in Develop? (“Cropped” or “Not cropped”)
Crop Rotation*Amount of crop rotation applied in Develop, rounded to the nearest degree (e.g. “2° CCW”).
Crop Amount*Relative area of the image cropped away from the original, in percent. Larger numbers indicate images left with increasingly smaller areas compared to their original.
Megapixels (post-crop)Image size, after any Develop crop/rotation adjustments, in megapixels.
Megapixels (original)Original image size, prior to any Develop crop/rotation adjustments, in megapixels.
Megapixels (max available)Image size originally available, prior to any downsizing that might have happened prior to import into Lightroom, and prior to any cropping within Lightroom. This uses the IPTC “maxAvailWidth” and “maxAvailHeigh” fields if available (which is rare). If not available, this is the same as “Megapixels (original)”.
Width x Height (post-crop)Dimensions, after any Develop crop/rotation adjustments, in pixels and megapixels (e.g. “3208 x 4928 (16.0 MP)”)
Width x Height (original)Original dimensions, prior to any Develop crop/rotation adjustments, in pixels and megapixels (e.g. “3208 x 4928 (16.0 MP)”). Note: “Original” does take into account any “Rotate Left (CCW)” or “Rotate Right (CW)” applied to the photo; just not subtle rotation applied in the Develop Module
Long Edge (post-crop)Length of the long edge of the image, after any Develop crop/rotation adjustments, in pixels.
Long Edge (original)Length of the long edge of the original image, prior to any Develop crop/rotation adjustments, in pixels.
Short Edge (post-crop)Length of the short edge of the image, after any Develop crop/rotation adjustments, in pixels.
Short Edge (original)Length of the short edge of the original image, prior to any Develop crop/rotation adjustments, in pixels.
Width (post-crop)Width of the image, after any Develop crop/rotation adjustments, in pixels.
Width (original)Width of the original image, prior to any Develop crop/rotation adjustments, in pixels. Note: “Original” does take into account any “Rotate Left (CCW)” or “Rotate Right (CW)” applied to the photo; just not subtle rotation applied in the Develop Module
Height (post-crop)Height of the image, after any Develop crop/rotation adjustments, in pixels.
Height (original)Height of the original image, prior to any Develop crop/rotation adjustments, in pixels. Note: “Original” does take into account any “Rotate Left (CCW)” or “Rotate Right (CW)” applied to the photo; just not subtle rotation applied in the Develop Module
Aspect Ratio
(short:long, post-crop)
Aspect ratio of the image, after any Develop crop/rotation adjustments, without regard to image orientation (e.g. “2 : 3”)
Aspect Ratio
(short:long, original)
Aspect ratio of the original image, prior to any Develop crop/rotation adjustments, without regard to image orientation (e.g. “2 : 3”). Note: “Original” does take into account any “Rotate Left (CCW)” or “Rotate Right (CW)” applied to the photo; just not subtle rotation applied in the Develop Module
Aspect Ratio
(width:height, post-crop)
Aspect ratio of the image, after any Develop crop/rotation adjustments (e.g. “5 : 4”).
Aspect Ratio
(width:height, original)
Aspect ratio of the original image, prior to any Develop crop/rotation adjustments (e.g. “5 : 4”). Note: “Original” does take into account any “Rotate Left (CCW)” or “Rotate Right (CW)” applied to the photo; just not subtle rotation applied in the Develop Module
Aspect Ratio compared to...Post-crop aspect ratio compared to an aspect ratio you specify: “Same”, “Wider”, “Taller”. This can be useful if you need to do different processing/cropping/exporting based on how an image's aspect ratio best fits a specific display aspect ratio.
Orientation*
With Respect to Image Sensor
The image orientation with respect to a straight-from-the-sensor presentation, e.g. “rotated 90° clockwise” and “flipped vertically”. For many modern cameras with orientation sensors, Lightroom applies an orientation update automatically upon import; these automatic updates are not distinguishable from subsequent user-directed updates.
File size (bytes)File size of the master image or video, in bytes. Also reports total disk usage for selected items. Note that due to a Lightroom bug, the size for offline items is not shown correctly.
Cached-Preview Size (bytes)Size on disk of all the cached normal previews for the image. (Smart Previews are not included.)
Audio sidecar file*The kind, if any, of the audio sidecar file associated with the image
XMP sidecar file*Does the image have an associated XMP sidecar file?
JPEG sidecar file*Does the image have an associated JPEG sidecar file?
Video
Video Size and RateVideo frame dimension and rate (e.g. “1080 x 1920 (30)”)
Video Trim*Whether the video has had its start and/or end trimmed (“Trimmed at start and end”, “Trimmed at end only”, “Untrimmed”, ...).

Example responses include:

  • Not trimmed
  • Trimmed at start and end
  • Trimmed at start only
  • Trimmed at end only
  • Untrimmed
Video Length (Trimmed)Length of the video, after any trimming in Lightroom (e.g. “17 min”).
Video Length (original)Length of the original video, without regard to trimming in Lightroom (e.g. “22 min”).
Video Frame RateFrame rate for the video (“15.000 fps”, “29.989 fps”, ...)
Audio Sample Rate
(of a video)
Sample rate for the audio track of a video (e.g. “48000 Hz”).
Audio Channels
(of a video)
Number of audio tracks (“Mono”, “Stereo”, “5.1”, ...)
Video Pixel Aspect RatioAspect ratio of pixels encoded in a video (e.g. “1”, “1.3333”, ...)
Develop (except crop)
Develop Sections Disabled*List of disabled Develop-module sections (e.g. “Paint-Based Corrections and Lens Correction”).
Red-eye Corrections*Count of red-eye corrections applied in Develop (e.g. “3 Eyes”).
Clone/Heal Corrections*Count of clone/healing-healing corrections (spots and strokes) applied in Develop, e.g. “27 corrections (7 clone spots and 20 heal strokes)”.

Also reports the total number of corrections across all inspected images, and the median number of corrections among images with at least one correction.

Local Adjustment-*
Brush Corrections
Count of local adjust-brush spots and strokes applied in Develop.
White Balance*White-balance setting applied in Develop (“Daylight”, “Custom”, etc.). Also, notes which images have the same white-balance temperature and tint as the most-selected image.
Exposure Adjustment*
(in Lightroom, to the closest ⅓ stop)
Amount of overall exposure compensation applied in Develop, to the closest ⅓ stop.
Contrast*Amount of overall “Contrast” applied in Develop, rounded to the nearest +/- 5.
Highlights*Amount of overall “Highlights” applied in Develop, rounded to the nearest +/- 5.
Shadows*Amount of overall “Shadows” applied in Develop, rounded to the nearest +/- 5.
Whites*Amount of overall “Whites” applied in Develop, rounded to the nearest +/- 5.
Blacks*Amount of overall “Blacks” applied in Develop, rounded to the nearest +/- 5.
Clarity*Amount of overall “Clarity” applied in Develop, rounded to the nearest +/- 5.
Vibrance*Amount of overall “Vibrance” applied in Develop, rounded to the nearest +/- 5.
Saturation*Amount of overall “Saturation” applied in Develop, rounded to the nearest +/- 5.
Color Treatment*Black & White vs. Color vs. Desaturated Color

Example responses include:

  • Black & White
  • Color (but fully desaturated)
  • Color (but extremely desaturated)
  • Color (but highly desaturated)
  • Color (but somewhat desaturated)
  • Color (but slightly desaturated)
  • Color
  • Color (super-saturated)
  • Color (hyper-saturated)
Tone Curve Name*Name of the tone curve applied in Develop (“Linear”, “Custom”, “Strong Contrast”, ...)
Lens Corrections*List of Lens Corrections enabled in Develop (e.g. “Color defringe + Manual”).
Lens-Correction Profile Name*The name of the lens-correction profile applied
Chromatic-Aberration Removal*Indicates whether “Remove Chromatic Aberration” is enabled
Defringe Enabled*Indicates whether “Defringe” is enabled
Unconstrained Crop*Identifies photos with lens corrections that might expose canvas, but without “Constrain Crop” enabled.
Upright Lens Corrections*Status of the “Upright” Lens Correction in Develop (e.g. “Auto”, “Full”, “Off”, etc.)
Vignette*Amount of post-crop Vignette effect applied in Develop (e.g. “Slight white vignette”, “15 black vignette”, ...)'
Grain Amount*Amount of overall “Grain Amount” applied in Develop, rounded to the nearest +/- 5.
Process Version*Name of the Lightroom render engine applied in Develop (e.g. “2012 (standard in Lightroom 4)”).
Basic Tone/Presence Edits?*Reports whether an images has basic Tone changes (exposure, etc), Presence changes (saturation, etc.), both, or neither.
Camera-Calibration Profile*Name of the camera-calibration profile applied in Develop (e.g. “Adobe Standard”).
Comparison with Most-Selected Image
Develop differs*
from most-selected image?
Experimental comparison of develop settings the “most-selected” image to each other selected image.

This is a very-experimental feature, and it may not be completely accurate; it may incorrectly cite a photo as having different develop settings when in fact those settings that differ play no part in the final rendition (for example, if the redeye data for the two photos differ, but redeye correction is also disabled for both photos, they may flag as “different”).

If no more than 50 images are found to be different, you can pop up a dialog that displays the raw differences. (More than about 50 taxes Lightroom's display infrastructure too much.) This entire feature is subject to radical change in future versions of the plugin.

Artist / Copyright
Copyright StateCopyright state.
Artist / CreatorArtist's name.
Rights Usage TermsInstructions on how image can legally be used.
Copyright Info UrlCopyright info URL.
ProviderName of person who should be credited when image is published.
SourceOriginal owner of the copyright.
Creator JobJob title of the person that created the image.
Creator AddressAddress for the person that created the image.
Creator CityCity for the person that created the image.
Creator State/ProvinceState or province for the person the created this image.
Creator Postal CodePostal code for the person that created the image.
Creator CountryCountry for the person that created the image.
Creator PhonePhone number for the person that created the image.
Creator EmailEmail address for the person that created the image.
Creator UrlWeb URL for the person that created the image.
Location
CityName of the city where image was taken.
StateName of the state where image was taken.
CountryName of the country where image was taken.
Country Code2 or 3 letter ISO 3166 Country Code of the country.
LocationDetails about a location where image was taken.
Geoencoded HemisphereGeoencoded hemispheres (e.g. “North/East”). This can also be used to answer simple “Geoencoded?” queries, and to find mis-encoded “0°N 0°E” entries.
Geoencoded Location*
Marked Private?
Is the geoencoded location marked a private? (“Private”, “Not Private”, or “Not Geoencoded”)
Geoencoded AltitudeGeoencoded altitude (e.g. “65 m”).
Other Text Fields
Title lengthReports whether “Title” is blank, starts or ends with spaces or had doubled spaces; otherwise reports the length.
Title line countReports the number of lines in “Title”.
Headline lengthReports whether “Headline” is blank, starts or ends with spaces or had doubled spaces; otherwise reports the length.
Headline line countReports the number of lines in “Headline”.
Caption lengthReports whether “Caption” is blank, starts or ends with spaces or had doubled spaces; otherwise reports the length.
Caption line countReports the number of lines in “Caption”.
SceneIPTC Scene.
EventNames or describes the specific event at which the photo was taken.
IPTC Subject CodeIPTC Subject.
IPTC Category
(deprecated field)
deprecated IPTC Category.
IPTC Other Categories
(deprecated field)
deprecated IPTC Other Categories.
Description WriterName of the person who wrote the description.
Intellectual GenreIntellectual genre.
Job IdentifierA number or identifier needed for workflow control or tracking.
InstructionsInformation about embargoes, or other restrictions not covered by the Rights Usage field.
Name of Org ShownName of the organization or company featured in this image.
Code of Org ShownCode from a controlled vocabulary for identifying the organization or company featured in this image.
Leading/Trailing Spaces
in a Text Field
Lists which text fields contain a leading and/or trailing space
Multiple Embedded Spaces
in a Text Field
Lists which text fields contain more than one embedded space in a row, “Like    This”
Modeling
Plus VersionThe version number of the PLUS standards in place at the time of the transaction.
Model AgeAge of human model(s) at the time this image was taken in a model released image.
Minor Model AgeAge of the youngest model pictured in the image, at the time that the image was made.
Model Release StatusSummarizes the availability and scope of model releases authorizing usage of the likenesses of persons appearing in the photo.
Model Release IDA PLUS-ID identifying each Model Release.
Additional Model InfoInformation about the ethnicity and other facets of model(s) in a model-released image.
Source TypeThe type of the source of this digital image, selected from a controlled vocabulary.
Property Release StatusInfo on the availability of property releases.
Property Release IDPLUS-ID identifying each Property Release.
Person Shown in ImageIPTC person-shown field.
Dates
Has “dateTimeOriginal” fieldA simple yes/no on whether the “dateTimeOriginal” field is present.
Has “dateTimeDigitized” fieldA simple yes/no on whether the “dateTimeDigitized” field is present.
Has “dateTime” fieldA simple yes/no on whether the “dateTime” field is present.
Has “dateCreated” fieldA simple yes/no on whether the “dateDreated” field is present.
Date fields agree?Reports on whether the “dateTimeOriginal”, “dateTimeDigitized”, and “dateTime” fields are the same

Example responses include:

  • All are empty
  • All are the same
  • They differ
By HourGroups images by the hour of the day in which they were taken.
By DateGroups photos by date they were taken on.
By Day of WeekGroups images by the day of the week that they were taken on.
By MonthGroups photos by the month they were taken in.
Date/Time RangeIsolate photos taken within a specific range of dates, times, and/or week days. Useful for finding all photos taken during a particular season, for example.
Height of the SunHeight of the sun above (or below) the horizon when the photo was taken.

Requires photos to be geoencoded and have timestamps. Furthermore, all photos must either have a timezone marked via my Geoencoding-Support plugin, or be in the same timezone with other photos processed together (and have that timezone specified manually during the search).

The distance reported is the amount of space between the horizon and the closest edge of the sun (that is, if above the horizon, the distance from the horizon to the lower edge of the sun's disk). The result takes into account the atmospheric refraction of fair weather at 20°C.

The result is quite accurate if the photo time, timezone, and location are accurate, and you're at the same altitude as your horizon (such as when at a beach looking out over the ocean). If an altitude is registered for the photo, and it's over 4000m, the plugin assumes you're in a plane and that your horizon is at sea level.

Significant errors can appear if you're not at the same altitude as your horizon (such as on a high cliff over a beach looking out over the ocean). At about 300m above, your sun will just be touching the horizon while it will just be disappearing for someone on the beach.

Of course, all bets are off if there are things like mountains or buildings at your horizon.

Example responses include:

  • 70° above the horizon
  • 15° above the horizon
  • 6° above the horizon
  • touching the horizon
  • 4° below the horizon
Kind of Sunlight
(Twilight, Golden Hour, etc.)
Based on the angle of the sun above/below the horizon

Requires photos to be geoencoded and have timestamps. Furthermore, all photos must either have a timezone marked via my Geoencoding-Support plugin, or be in the same timezone with other photos processed together (and have that timezone specified manually during the search).

“Golden Hour” is when the sun is within 10° above the horizon.

Example responses include:

  • setting sun golden hour (sun 1°〜10° above horizon)
  • morning astronomical twilight (sun 18°〜12° below horizon)
  • at sunrise
Master Image File
Bit Depth / Color Mode***
of the master image file
The bit depth (per channel) and color mode (e.g. RGB vs. CMYK) of the master image.
Color Space***
of the master imgage file
Color space (e.g. sRGB, AdobeRGB) of the master image. Note that the color space for a raw file is specific to the camera make and model; raw files appear here as "unknown".
Speical: List Data Fields***Lists raw metadata field labels and values found in the most-selected master image file. This is useful to find appropriate field names for the “User-Specified Master-File Data Field” search item described immediately below.

With this special item, only one photo/video is processed, regardless of how many are selected. This is sort of a “raw” version of my Metadata Viewer plugin; this item is useful to find the exact master-file field label for use in the “User-Specified Master-File Data Field” search item described immediately below, while the Metadata-Viewer plugin is far superior for general “what metadata is in this master file?” browsing.

User-Specified Field***
of the master image file
Explore the specific master-file metadata field entered by the user.

You can enter any metadata field known to ExifTool; you can see the list of raw fields for a specific master file by selecting it and applying this plugin's “Special: List Master-File Data Fields” search item, described immediately above..

Results Dialog

After the plugin does its work, it brings up a dialog to display the results, for example:

I've spent considerable energy on tailoring the presentation and default sort for each of the 186 criteria the plugin supports. In the “Lens” example seen here (which Adobe's Library Grid Filter does support, though not as well), I take care to sort the lenses by focal length, and to pretty up the presentation (e.g. “50 mm” instead of “50.0 mm”).

Some features of the results dialog:

  • Click on an “isolate” button to create a collection named for the criteria and result, populate it with the appropriate photos, and switch to it.

  • Click on the “Isolate All...” button to create all the individual collections and dismiss the dialog.

  • Click on two or more checkboxes to enable an “Isolate Combined Checked Items” button that creates one special collection with all the photos of the checked rows.

  • Click on a column header to toggle the display sort.

  • Click on a photo- or video- count number to display some percentage information. In the example above, clicking on the “8,306” of the “Voigtländer 125mm f/2.5” row reveals that 31.9% of the target photos were taken with that lens (because it's such an oh-so-sweet lens whose results I adore).

Availability

This plugin is distributed as “donationware”. I have chosen to make it available for free — everyone can use it forever, without cost of any kind — but unless registered, its functionality is somewhat reduced after six weeks.

Registration is done via PayPal, and if you choose to register, it costs the minimum 1-cent PayPal fee; any amount you'd like to add beyond PayPal's sliding fees as a gift to me is completely optional, and completely appreciated.

Note: a Lightroom major upgrade, such as from Lr4 to Lr5, de-registers the plugin in the upgraded version, so if you want to maintain registration, a new ($0.01 if you like) registration code is needed in the upgraded version. It makes for a hassle every couple of years, I know. Sorry. See this note for details.

For details on plugin registration and on how I came into this hobby of Lightroom plugin development, see my Plugin Registration page.

Version History
( Update Log via RSS )

20150728.101 Had the wrong data in the crop-factor database for the Fuji X100s. Fixed that, and added some other recent Fuji cameras.
20150705.100

The results column on Windows was sometimes too narrow. Had to make the result text unselectable to get around it.

20150626.99

Changed how develop-setting numbers are reported, now explicitly presenting the range of each slot.

Added new items: "Split Toning", "Sharpening Amount", "Sharpning Detail", "Sharpening Masking", "Color Noise Reduction", "Color Noise-Reduction Detail", "Color Noise-Reduction Smoothness".

Added an "Another Search" button to the results page.

20150622.98 Added a couple of Olympus cameras to the crop-factor database
20150618.97 Added Leica M typ 240 to the crop-factor database
20150607.96

Added support for People (LrCC/6)

20150301.95

Make collection-names sort properly ("Hour of the Day", "Day of Week", and "Month" items).

Even if all photos have the same result, show the full-results dialog if data was collected for a spreadsheet report, so that the "save to file" button is available.

20150206.94

In the POODLE-vunerability dialog, display a raw URL of a page on my site that discusses the issue, so that folks can be independently sure that the dialog is indeed from me and not malware.

20150131.93 Build update.
20150115.92

Updated the camera-name code to try to guess the actual camera model of Hasselblad H5D files, since in their infinite wisdom Hasselblad decided to encode three distinct models with the same internal code, making it impossible to know for sure what camera produced a given image file.

Same sluthing for Hasselblad crop-factor calculations.

Added the "Megapixels (max available)" search item.

20141225.91

Added the Canon EOS 7D Mark II to the camera crop-factor database.

20141127.90

When applied to a collection, photos not in the collection could have been included in the search via the "items hidden within collapsed stacks" option.

The "Camera Name" items were missing a row for photos that had no camera make/model data.

Added new items to search by: "Cached-Preview Size (bytes)", "Local Adjustment-Brush Corrections", "Height of the Sun", and "Kind of Sunlight (Twilight, Golden Hour, etc.)"

For data that are simple numeric values (such as "length of short edge, in pixels"), when isolating photos to a collection, the collection may be created with a name that has some extra spaces at the beginning, in an attempt to get Lightroom to sort the list of collections reasonably.

Upgraded to the embedded copy of ExifTool to version 9.76.

20141104.89 For the "keyword count" items, added a summary note about the total number of distinct keywords seen for the inspected items.
20141104.88

Added a bunch of Canon cameras to the crop-factor database.

20141019.87 Windows Only: Add a one-time check for the POODLE security vulnerability, and alert the user if it exists.
20140928.86

Added various "collection membership" items.

Updated the various "Keywords (individually)" items to include a row for photos that have no keywords of the given type, if any.

20140913.85 Added Olympus E-M1 to the camera crop-factor database. (Why Olympus can't include the crop factor in the metadata like most everyone else is beyond me...)
20140902.84 New build system
20140820.83 Added new items for lens-correction profile name, chromatic aberration, and defringe.
20140805.82

Updated the "White Balance" item to note which images have the same white-balance temperature and tint as the most-selected photo.

The "Develop differs from most-selected image?" item had actually referred to the first image selecte, not the "most-selected image". It now refers to the most-selected image, unless there isn't one, in which case it reverts to the first image.

20140801.81 Added new "Keywords, individually" items.
20140731.80 Registration fix for Lr5.6
20140730.79 Added "Video Size and Rate"
20140720.78

The “has ...” items for dates (for dateTimeOriginal, dateTimeDigitized, and dateTime) now actually work.

More Creative-Cloud support.

20140715.77

Fixed an issue with Creative-Cloud revalidation.

20140712.76

Lr5.5 and later Creative-Cloud installs can now revalidate themselves if needed.

20140710.75 Sigh, had a bug in the Creative-Cloud support.
20140708.74

Now supports Lr5.5+ Creative-Cloud Installs.

20140706.73 Added some more keyword-related search items.
20140704.72 For some reason (bug in Lightroom?), Lightroom is not following the plugin's direction on how large to make the result dialog, so in an attempt to work around it, I've added a "debug options" link in the upper-right corner of the item-selection dialog.
20140701.71 Added some debug logging to track down a display-size issue.
20140630.70 Build-system update
20140629.69

Added "By Month" data item.

20140629.68

Added "By Date Taken" data item. The Library Grid Filter is probably better for browsing by date, but this might be useful if you want to automatically create collections based on the date.

Updated some of the other date-related items to try harder to find a date associated with the photo.

20140605.67

Upgraded to the embedded copy of ExifTool to version 9.60.

20140506.66 Added a new search criteria: file writeability (e.g. readonly or not)
20140422.65

Fixed a bug in the "smoother revalidation" stuff recently added.

20140418.64

Make the revalidation process smoother, especially for folks using Lr5.4 and later.

20140330.63

Worked around a Lightroom bug that stopped the new "list master-file data fields" from displaying properly on Windows.

20140327.62

Added the “User-Specified Master-File Data Field” item, giving the plugin the ability to explore arbitrary master-file metadata.

Added the “Special: List Master-File Data Fields” item to allow you to quickly see the raw metadata field labels need for the “User-Specified Master-File Data Field” item.

Upgraded to the embedded copy of ExifTool to version 9.53.

20140311.60 Wow, I'd really screwed up the calculations for the “Total Exposure (camera Ev)” and “Total Effective Exposure (effective camera Ev)” items. In both cases I had the sense of adjustment for ISO speed backwards, and in the latter case I had the sense of adjustment for the Lightroom develop setting backwards, and in some cases could use the wrong number to begin with. Doh!
20140302.59 added the following items to the list of explorable items: amount of Contrast applied in Develop, amount of Highlights applied in Develop, amount of Whites applied in Develop, amount of Blacks applied in Develop, amount of Vibrance applied in Develop, amount of Saturation applied in Develop, and the IPTC “Person Shown in Image” field.
20140212.58 Updated the file-size counting done for “File size (bytes)” and “Smart-Preview Status” to better indicate the file-size status for offline files.
20140207.57

Added “Most-Recent Update Date” and “Number of Updates” items.

20140206.56

(Lr5.2+) Update the “Clone/Heal Corrections“ item to report the total number of corrections for the inspected photos, and to report the median number of corrections among photos with at least one correction.

20140124.55

Added more detail to the disk-usage summary presented for the “File size” and “Smart-Preview Status” items. Fixed a bug in how previews for vidoes are reported.

Cite in the result-dialog title the number of items inspected.

20140120.54

Result dialog for the “File Size” item could end up too big for the screen.

Upgraded to the embedded copy of ExifTool to version 9.46.

20140104.53 Updated a bug with “Cropped Amount”, and renamed its "100%" result with "Almost Completely Cropped Away".
20131230.52 Updated the “File Currently Available” item to report whether a Smart Preview exists.
20131128.51 Updated how megapixels, video duration, and focal length are displayed, to avoid apparent duplicates (such dual "20.0" and "20" results).
20131125.50 Made the “Expousre Adjusment” results look nicer, and made it clear that results are displayed to the nearest ⅓ stop.
20131124.49 Added “Flag Status” item
20131122.48 Fixed error with “Expousre Adjusment” item.
20131115.47

Fixed a bug in the "File Size" stuff added yesterday.

20131114.46

Discovered that at some point Lightroom developed a bug that makes reporting the byte size of offline images impossible. The plugin report now notices when this happens and points out that the data is not to be trusted.

Added an extra report to the "File Size" item to show the disk space used by all the selected items (the masters, smart previews, and normal previews). However, it currently doesn't work correctly for offline images due to the Lightroom bug cited above.

20131102.45

Update for OS X Mavricks.

Updated the Image::ExifTool library to version 9.39.

20131014.44 Found that with certain settings some math errors would pop up.
20131010.43

Update how the aspect-ratio criteron are computed. Should give more reasonable results.

Updated the Image::ExifTool library to version 9.38.

20131003.42

Added new criteria: "Leading/Trailing Spaces in Text Field" and "Multiple Embedded Spaces in Text Field".

You can now tell which results you've isolated... the "isolate" button becomes "view" once the associated collection has been created.

20130930.41

Added "Unconstrained Crop" criteria.

Fixed a bug with the "Lens Corrections" item, which always indicated that "Chromatic Aberration" and "Constrain Crop" were set for an image regardless of whether they were.

More attention to the default display order of some results.

20130926.40

Added new criteria: "By Weekday", "By Hour", and "Date/Time Range".

An update to track a change in Lightroom 5.2 in how develop clone/heal spots and strokes are encoded.

Made it much easier to see relative percentages in the results... just click on any total and all totals are replaced with percentages.

20130925.39 Updated the camera crop factor database.
20130911.38 The "Total Effective Exposure (effective camera Ev)" criteria couldn't be selected.
20130910.37 Added a bunch of cameras to the crop-factor database.
20130910.36

Added a new criteria, “Aspect Ratio: compared to...”.

Renamed “File Extension” and “File Extension (case-insensitive)” to “File Extension (case-sensitive)” and “File Extension” respectfully, and swapped their order in the list, because Lightroom generally runs on case-insensitive file systems, so case insensitive is the norm, and case sensitive the oddball.

Gave the spell-checker a much needed run.

20130908.35 The “File Currently Available?” item relied on a component of Lightroom's internals that seems to be buggy, so I rewrote it to check the disk directly for the presence of the master image file.
20130830.34 Added a few more cameras to the crop-factor database.
20130828.33

Added new exploring criteria “Has plugin custom metadata?”. If you generate the spreadsheet-data file, it'll include the list of IDs for the plugins involved.

Changed the label “Spot-Healing Corrections” to “Clone/Heal Corrections” and updated it to include clone/heal strokes as well as spots, producing results along the lines of "“11 corrections (2 clone spots, 2 heal spots, 3 clone strokes, and 4 heal strokes)”.

Updated the list of develop changes (as generated by th “Develop differs from most-selected image?” criteria) to include more detail about clone/healing strokes and spots. Also, removed “Orientation” from consideration as a develop change, to match that develop-settings copy/paste doesn't include the orientation. You can deal with orientation via the newly-added the “Orientation With Respect to Image Sensor” criteria.

20130828.32

Added the ability to compare develop settings against the most-selected image. It's a work in progress. See documentation for “Develop differs from most-selected image?” above.

20130826.31 Some fixes to the previous changes for Windows.
20130826.30

Added several new search criteria: “File Extension (case insensitive)”, “Lens Description (built from master-file data)”, “Bit Depth and Color Mode”, “Color Space”,

Made searching large numbers of images a bit more efficient, and allow the searches to be canceled midway.

In the criteria-picker dialog, added a direct link to the full criteria list.

20130723.29

Added the ability to save the raw data to a TSV (tab-separated values) file.

20130721.28 Added Canon 650D to the camera sensor-crop database
20130629.27 In some rare cases photos with a Process Version of 2003 would show up as "Unknown".
20130626.26 Added a bunch of data to the crop-factor database
20130620.25 Updated the "Color Treatment" item to partition color photos based on their amount of saturation/desaturation.
20130613.24 Better support for plugin revalidation.
20130611.23 Yet another Lr5 update
20130610.22

Updated the "Lens Corrections" item for Lr5, and added a new "Lens Corrections (Upright only)" item.

Added an item related to whether smart previews exist.

Added a bunch of new crop-factor data, and corrected the crop-factor data for the Canon Powershot G1 X.

(Note: Lr5 painted heal/clone brush strokes are not yet taken into account.)

20130501.20 Update for Lr5
20130420.19

Added "Folder Name" and "Path Name" to the list of search items.

20130415.18

Added the “Has Basic Tone/Presence Edits” search item.

Fixed the “dateCreated” search.

20130412.17 Build system update.
20130330.16 Added some Ricoh cameras to the crop-factor database.
20130328.15 Fix for the registration system.
20130311.14

Added "Total Exposure (Ev) and Total Effective Exposure (effective Ev).

Filled in some areas where the docs were not yet written.

20130219.13 Added some notes to the aspect-ratio results to denote common aspect ratios (e.g. 16:10 is a wide-screen monitor)
20130218.12 Added some extra text fields (title, caption, etc.)
20130214.11

Added the ability to identify images with sidecar files.

In the criteria-selection dialog, warning messages would sometimes get truncated.

20130212.10 Added some date fields
20130209.9 More build-system maintenance
20130206.8 Tweak for my registration system
20130124.6 Added a bunch of Canon cameras to the crop-factor database.
20130119.5

Computation for the megapixel notation for "Width x Height (post-crop)" was wrong.

Many of the pixel-size items crashed when used on videos.

20130111.4

Focal-Length 35mm crashed if a photo didn't have focal-length data.

Added a bit of buffer to the dialog-height calculations to help ensure that the dialog doesn't grow taller than the screen.

20121113.3 Made "Dimensions" available for video.
20121020.2 Added "Lens Corrections"
20121019.1 Initial public release.

The 30 most-recent comments (out of 51; see all), most recent last...

Does this plug-in (or any other plugins) have the ability to isolate dates and times individually?
Something like:
ie. Show all pictures taken in December (to get all holiday pictures)
ie. Show all pictures taken on December 25th (to get all Christmas day pics)
ie. Show all pictures taken between 8pm and 5am (to get all night photography)
ie. Show all pictures taken between June->August AND 6pm->8pm (to roughly find sunset pictures)

I’ve added a few new criteria to the Data Explorer, including “Date/Time Range” where you can isolate on any combination of date span, time-of-day span, and specific days of the week. I’d done all the math to compute the angle of the sun above/below the horizon for a particular location and time, but then realized that I can’t use it because it’s not known explicitly what timezone the photo’s capture time is, so there’s not enough data for the calculation. )-: —Jeffrey

Update 14 months later (Nov 27, 2014): I’ve handled the timezone thing, so the plugin now includes the ability to classify by the angle of the sun and the type of light (“Golden Hour”, etc.) —Jeffrey

— comment by Matt on September 25th, 2013 at 1:35am JST (1 year, 10 months ago) comment permalink

I want to be able to filter all images where LR has put a ‘Reset’ into the History steps. I hoped it would be in Data Explorer, but no luck. Can it be done?

Thanks,

Bob Frost

No, history is not exposed to plugins at all. )-: —Jeffrey

— comment by Bob Frost on September 30th, 2013 at 5:29pm JST (1 year, 10 months ago) comment permalink

Hey Jeffrey,

Thanks for all your hard work! I love your plugins.
Would it be possible to split the ‘Most-Recent Update Date’ so it does not combine the developments settings like the basics, tone curve etc bunched together with say flagging or starring and key wording? I do understand that it’s basically all metadata in the end. So this would probably take bit of coding to extrapolate and qualify it? I would want to mostly see when basic edits was performed and on which date. Setting flags, keywords, ratings, labels or colors sometimes is not seen as an edit in my workflow.
I love the way you split it into hourly where the same day applies.

Looking forward to hearing from you all the way from the tip of Africa :-)

Unfortunately, no, Adobe has one date that they bump up for any kind of change. I’ve been asking for separate pixel/non-pixel data for years, but so far to no avail. —Jeffrey

— comment by Paul on March 3rd, 2014 at 10:38pm JST (1 year, 5 months ago) comment permalink

Hi Jeffrey and thanks for your great collection of Lightroom plugins, I love them!

Hovewer I this plugin, I think I found an coding error!

The problem is in the “Total Exposure” and the “Effective EV”. I think you reversed the effect of ISO. For example, if photo is taken with shutter speed 1/30 and aperture f/2.0 and ISO 100, your plugin calculates EV7 which i agree on, but if of the shutter and aperture remains the same, and i rise the ISO to 400, (iso +2 steps in other words), your plugin calculates EV9, but it should be (as i calculate it) EV5.

I believe you’re right. It turns out that I had a number of mistakes in how I calculate “effective Ev”… for some reason, the subject just seems to turn my brain to mush…. but I think I’ve sorted it out (as of version 20140311.60). Thanks for the heads up! —Jeffrey

— comment by Fredrik Holmberg on March 9th, 2014 at 9:34pm JST (1 year, 5 months ago) comment permalink

Thank you Jeffrey!

Now it works great! it’s very cool with this possibilities with metadata and statistics! :)

— comment by Fredrik Holmberg on March 13th, 2014 at 10:49pm JST (1 year, 5 months ago) comment permalink

Greetings from the UK! Not sure if this is the right place to ask, but is there any way of finding all images that have been published to Flickr that have a non-null Comment field, or ‘Favorite count’? That data displays underneath the standard metadata in LR, presumably under control of the Flickr plugin. –Michael

No, unfortunately, Adobe doesn’t expose that data to the plugin nor to the user. You’d think a sort via most-recent comment would be natural. —Jeffrey

— comment by Michael Maggs on March 24th, 2014 at 3:01am JST (1 year, 4 months ago) comment permalink

Jeffrey, is it possible to make the Data Explorer plug-in or any other plug-in find images for which in-camera or in-lens image stabilisation has been used ?

I just pushed version 20140327.61 of Data Explorer, which now includes a “User-Specified Field” criteria. If you can figure out whether your camera writes stabilization info to the master-file metadata, and what its field name is, you can now explore it. —Jeffrey

— comment by Alan on March 24th, 2014 at 1:44pm JST (1 year, 4 months ago) comment permalink

This plugin will be of great help to me to determine my buying choice for my next camera and lenses. Based on my 50k pictures I will see what light (EV) I most frequently shoot in and it will help me determine which lenses I should invest more in order to have better quality pictures in the future. It might be a tideous task but with your plugin it will be much easier and quicker to come up with an analitical way to make my choice.

Thank you once again for the great work that you are doing. Lightroom is a great tool but your plugins makes it so much more awesome.

— comment by jgrzadka on May 9th, 2014 at 11:06pm JST (1 year, 3 months ago) comment permalink

Is there a way to sort by resolution or ppi?

You mean by pixels per inch on the sensor? No, sorry, not that I know of. That information may not be known for many images anyway…. —Jeffrey

— comment by Ahmet Dereci on June 16th, 2014 at 2:27pm JST (1 year, 1 month ago) comment permalink

Shouldn’t I be able to group by date? I’d like to create a collection for each date I shot at Monkey Bay
I can’t see how.

thanks a lot!

I’d not had it because the Library Grid Filter already offers a great way to explore by date, but I’d not thought about the collection point of view, so I just added “By Date Taken”. —Jeffrey

— comment by Charles e Uibel on June 29th, 2014 at 11:34am JST (1 year, 1 month ago) comment permalink

Hi Jeffrey.
Something even more useful date would be to group by calendar month, because that is not easily accessible in Lr. This would allow a quick review of all photos taken in say August of any past years to reveal what we could expect to find in the coming August.

– Alan

I went ahead and added it, but note that you can do Date Range already, perhaps a more specific way to checking out the seasons… —Jeffrey

— comment by Alan on June 29th, 2014 at 3:54pm JST (1 year, 1 month ago) comment permalink

omg thanks. I have 800 days at Monkey Bay.

— comment by Charles e Uibel on June 29th, 2014 at 8:17pm JST (1 year, 1 month ago) comment permalink

Grouping by kewords(count) would be helpful for me.
Thanks

Good idea… I’ve added it! —Jeffrey

— comment by Charles e Uibel on July 6th, 2014 at 11:25am JST (1 year ago) comment permalink

Hi, is it possible for Data Explorer to break out into individual keywords?

For instance, I may have a photo that’s tagged with 3 keywords: Apples, Oranges, and Pears.

When I run Data Explorer using “keyword list” as the criteria, I’m seeing a single entry “Apples, Oranges, Pears”. I would like it to show an entry for each of the keywords.

Is that possible?

Thanks!

Sure, I just added it in version 20140801.81 —Jeffrey

— comment by Joe on July 31st, 2014 at 10:58pm JST (11 months, 30 days ago) comment permalink

Thanks for adding that feature to the keywords criteria! I let the author of Aperture Exporter know. He has other customers looking for a tool such as yours. With this new feature, it will help many of them.

— comment by Joe on August 2nd, 2014 at 6:04am JST (11 months, 28 days ago) comment permalink

Hi. I am not sure if I have asked you before.
Due to some stupid reason, an unknown amount of photos in my catalog has been synced to the same white balance. I know the synced valued (Temp 5450, Tint 25). And I was trying to use Data Explorer to search the photos that has this exact white balance. Currently if I search it, all of the are “custom” and I can’t tell which is of that settings.
Could you add that search field so that I can search the temp and tint?
Thanks so much.

Upgrade the plugin, select one of the photos with the value you want to find, and then try the “White Balance” setting again. —Jeffrey

— comment by Kolen on August 6th, 2014 at 8:48am JST (11 months, 24 days ago) comment permalink

Thanks so much for updating it so quick. I can successfully hunt down the photos with that White Balance with “Custom (same as most-selected image)”. I didn’t realize “same as most-selected image” means identifying those that share the same white balance.
Thanks so much.

That’s what I updated… that hadn’t been there before. I just realized that I’d forgotten to update the online docs for “White Balance”, but I’ve done so now. —Jeffrey

— comment by Kolen on August 6th, 2014 at 6:06pm JST (11 months, 24 days ago) comment permalink

Hi! Would it be possible to split the Lens Corrections in individual parts? I am interested in isolating all photos where CA or Defringe have been applied and also it would be good to be able to isolate based on Lens Profile alone.

Seems reasonable. I’ve just added them to the latest version of the plugin. —Jeffrey

— comment by Øystein on August 7th, 2014 at 6:39pm JST (11 months, 23 days ago) comment permalink

Thank you for breaking out the CA and Defringe from Lens Correction, Jeffrey! Much appreciated :)

— comment by Øystein on August 20th, 2014 at 3:41pm JST (11 months, 10 days ago) comment permalink

Hi. Great plug-in!

Here’s my scenario: I return from shooting a wedding with about two thousand photos from three cameras. A major issue with weddings is the changing light sources. I adjust each camera’s white balance setting and shoot a Gray Card every time the lighting conditions change. In theory, this should make it very easy to batch-correct the white balance in Lightroom for each group of photos shot in the same conditions, but in order to do this, I need to be able to group them by the numeric “Temp” and “Tint” settings, not just by “As Shot” or “Custom”. I seem to have the latest version of your plug-in, but when I explore by White Balance, all I get is “All [quantity] photos have “White Balance” of “As Shot (same as most-selected image)”. It’s not showing me the photos with the same Temp and Tint. Does that only work when it has been changed? (I.e., “Custom” as opposed to “As Shot”.) If so, that doesn’t help me.

Alternatively, there’s an EXIF field that LR does not read called “LightSource”. I tried using Data-Explorer to sort on this field, but it always returns “All [quantity] photos have Master File EXIF:LightSource Field of ‘unknown’ ” even though this field is populated in every photo with settings such as “Flash” or “Cool White Fluorescent”. I tried sorting on a different EXIF field, such as “Exposure Time” and it works very nicely. Am I doing something wrong?

Thanks!

I’m going to guess that the LightSource item in your files is not in the Exif group, but in the MakerNotes group. In any case, you can let ExifTool figure it out by simply using “LightSource” instead of “Exif:LightSource”. —Jeffrey

— comment by Jonathan Ford on September 10th, 2014 at 4:29pm JST (10 months, 20 days ago) comment permalink

Hi Jeffrey. I am using your Data Explorer for all sorts of things right now. Man, is it a lifesaver!

However, I was wondering if you have thought of putting the “Isolate” results in a format that would make it easier to browse in Lightroom. Right now you put the pixel buckets as, say, 1,311, 2,412, 3,123, 215, 315, 925. (This is the order that Lightroom sorts in). It would be much more convenient for many uses if you made collections with the names 0215, 0312, 0925, 1311, 2412, 3123, so that Lightroom’s alphabetical sort also sorted them numerically.

But I guess you’d probably get complaints if you did this — ‘why is there a “0” at the beginning of some numbers?’

In any event, thanks for a great tool.

Good idea. Lightroom doesn’t make it easy, but it turns out that I can prepend spaces as well, so I’ve set up something that handles most numeric fields automatically. I maybe have to go in for some custom code for some fields, but this update will handle most. I also added a few new things to search on. —Jeffrey

— comment by Alan Harper on November 26th, 2014 at 3:35am JST (8 months, 4 days ago) comment permalink

Hi Jeffery, thank you so much for your amazing plugins – I use the jF flikr plugin extensively. A quick question as I’m just getting into the explore plugin. Is there any way to sort flickr published images based on comments / favorites? It would be great to “Crowd source” the fickr community and compile a collection of most commented on / most Favorited images from my photostream. Is this possible with custom criteria in explore?

Thanks again
-Brendan PICSPORADIC

Unfortunately, not with what’s built into Lightroom… it has all the info about which photos have how many comments and likes, but they don’t expose that for searching or sorting. —Jeffrey

— comment by Brendan James on December 8th, 2014 at 1:30am JST (7 months, 22 days ago) comment permalink

Very useful – Thanks!

Small request: It would be great to have Hour of day in 24 hour time, or something that sorted in chronological order. (I guess even AM 1, AM 2 might work)

Open ended idea: I’m searching for a way to clean up sidecar JPGs. Looks like this tool can detect Raw with jpg, but I’m guessing LR doesn’t have a way to select or delete the JPGs.

Steve (Bellevue, WA, USA)

Ah, you mean about the collection names, when groups of photos are isolated to their own collection? Good point. I’ve just pushed out a version that handles that properly. About the sidecar thing, select the “JPEG sidecar file” item and enable the “also collect data for spreadsheet export” option. Then in the results dialog, save the spreadsheet. You can edit it in a text editor to replace the various extensions with “jpg”, and then you have your list of sidecar files. —Jeffrey

— comment by Steve Weil on March 1st, 2015 at 3:49pm JST (4 months, 29 days ago) comment permalink

That was a quick fix – awesome!
Also, thanks for for sidecar suggestion – that’s perfect.

— comment by Steve Weil on March 4th, 2015 at 3:14pm JST (4 months, 26 days ago) comment permalink

Hi Jeffrey,
I love this plugin, would it be possible to add a return to ‘select search criteria’ button instead of having to ‘dismiss’ then reopen?

cheers
MB

Better late than never… I just added it. —Jeffrey

— comment by MichaelB on April 6th, 2015 at 10:19am JST (3 months, 24 days ago) comment permalink

Is it possible to add likes and/or comments from Lightroom mobile to data explorer?

Thanks for checking.

No, unfortunately, this data is not at all available to plugins. —Jeffrey

— comment by Steve Ledwith on May 5th, 2015 at 11:07pm JST (2 months, 25 days ago) comment permalink

Hi. I would like to select all photos within a sharp setting in the Detail section. Is that possible?
Hint: Would it be a great feature adding selecting a range for some settings which are still not present in the plugin like the details, split toning, etc…

Thanks

I just pushed out a new version with a bunch of these now included. —Jeffrey

— comment by Carlos Viana on May 6th, 2015 at 6:27am JST (2 months, 24 days ago) comment permalink

Hi there. I’ve been using and enjoying jf Facebook for some time. Now I’d like to be able to filter images I’ve uploaded with your plugin from ones I haven’t. Do you know if this is possible, either using one of your plugins or otherwise?

Thanks!

You can select “Uploaded to Facebook” in the Metadata section of the Library Grid Filter. —Jeffrey

— comment by Michael on June 6th, 2015 at 11:47am JST (1 month, 24 days ago) comment permalink

Hi Jeffrey! I would like to isolate all images to which I have applied a Split Toning treatment, but I see that there are no criteria for the adjustments in the Split Toning panel. Would it be possible to add criteria for Highlight Saturation and Shadow Saturation (as any images for which the values are greater than 0 are images to which Split Toning has been applied)? Alternatively, how about a criterion along the lines of “Has Split Toning Edits?” Thanks!

Done. —Jeffrey

— comment by Richard Drdul on June 26th, 2015 at 9:40am JST (1 month, 4 days ago) comment permalink

Hi Jeffrey,

I’m using Data Explorer to find the number of photos taken (or scanned) per date. The report window I get cuts off most of the date and doesn’t seem to allow me to expand the date column.
You can see it in this screenshot.

Thanks,
Todd (Austin, TX)

Strange… it seems to be a Windows-only issue. Not sure why it happens, but when I made the text unselectable, it seems to have fixed it, so I just pushed that out in a new version of the plugin. —Jeffrey

— comment by Todd Drga on July 4th, 2015 at 3:28pm JST (3 weeks, 5 days ago) comment permalink
Leave a comment...


All comments are invisible to others until Jeffrey approves them.

Please mention what part of the world you're writing from, if you don't mind. It's always interesting to see where people are visiting from.


You can use the following tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Subscribe without commenting