P: Metadata collisions between catalogue and files

This strikes me as one of those things that should just be done already - assuming it wouldn't take much time...

In the mean time, many have solved this problem by a workaround (issue SQL query to round up the files, then make a collection of said files using plugin). I solved this problem for myself another way, but it would be a nice gift to the community if someone having solved this problem via the SQL query / collection method could post a turn-key start-up script + instructions for others to use... - I'm trying to concentrate on other things m'self...

PS - The above-mentioned solution was posted on the "other" forum, if you could find it...

For example, one could write a python script with guts like:

catalogPath = # get from command line args or config file or something.
lrCatCon = sqlite3.connect( catalogPath )
cur = lrCatCon.execute( sql to round up the files with metadata issues )
# create file with list of those files.

# startup Lightroom
if os.name == 'nt': # windows
os.startfile(catalogPath)
else: # Mac
subprocess.call(['open', catalogPath]) # mac/nix.

Lr/transporter (was it?) or custom plugin takes it from here in Lightroom - makes collection.

Then use this script to start Lightroom and you'd have a collection ready...

FWIW,
R

The original feature request has been around for a long as Lightroom itself.

I'd like to see the ability to filter on all three states of metadata mismatch:

- "Up arrow",
- "Down arrow", and
- "Exclamation flag".

I think the FR is a good idea, and I think it would be easy to do - although I dont have metadata issues much any more...

In the mean time, some people are using a script that extracts the info from the database, and starts up Lightroom, then use LR-somethin-or-other plugin to make a collection of all photos with metadata issues. Detailed info is available on the other forum, however its search is broken.