I’m frustrated

Lightroom: Metadata collisions between catalogue and files

Lightroom will report on metadata collisions on a case by case basis. However, it does not provide for a way to search for files that metadata discrepancies vis a vis the catalogue.

Can this feature be easily added?
19 people like
this idea
+1
Reply
  • 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.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

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

    - "Up arrow",
    - "Down arrow", and
    - "Exclamation flag".
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

  • The original feature request has been around for a long as Lightroom itself.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

  • I’m running out of time for this kind of stuff...
    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
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

  • I’m puzzled
    Thanks Rob. Ian, any clue as to why Adobe hasn't responded to requests to make this happen? It seems like it would be a very simple addition to the filter bar. In the meantime, we all have to learn SQL :)
    • My theory: I think the Lightroom team members are very disciplined individuals. If it ain't top priority, it don't make the cut, no matter what it is or how long it would take to do it, or how long its been an issue. - Just a theory. What other earthly reason could there possibly be? - It couldn't possibly take much time to fix, and they couldn't possibly not know about it... Maybe in their own photography hobbies they never have the issue... - 'tiz a puzzlement...
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

  • VERY needed feature.
    I all the time have this issue especially beacause:
    -I cannot geotag within LR
    -Not all metadata can be edited in lightroom
    -Many problems with lightroom handling of time metadata -> which I set outside of lightroom

    I suppose the problem is
    - it takes time to scan all the photos to check if they are synchrone.

    And then what we need is not just 2 arrows (or well only as a short cut)
    what we need is to be able for each photos to display a table of the metadata values in the catalog and in the file so that we can compare both metadata state and decide which way we want to synchronise - and even best : decide for each piece of metadata of each photo the way we want to synchronise them )
    So there would be 3 level
    -decide for a selection of photo the way to synchronise metadata
    -decide for a given photo the way to synchronise metadata while directly comparing these metadata
    -decide for a given metadata of a given photo the way to synchronise it.

    Regards
    Eric
    • view 1 more comment
    • Hi,
      great I will have a look
    • Hi Eric,

      Its not as straight forward as you'd probably like, but I do it "all" the time. Contact me using the old forum's PM or my website if problems or questions.

      Hints:
      -------
      - You have to read metadata from disk, then invoke "Select To Compare".
      - Then select the previous state (from edit history) and invoke the "Compare To" function.

      (There is no facility for item-by-item merging of differences, but the differences are also logged so you can merge manually if necessary)

      If you prefer the state as read from disk, just select it in the edit history. If you prefer the catalog state and there's a conflict to resolve, just re-save xmp (or re-lock photo if you are using that feature of ChangeManager).
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

  • 2
    I would really like to see a Unsaved Metadata Smart Collection item.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

  • Absent any official (or unofficial) response from Adobe, I have assumed that the reason this feature has not been implemented is because it is in general a very expensive feature to implement (in terms of disk access). In order to know the metadata status of a catalog, you need to know the modification time of all files in the catalog, which can only be done one-by-one. I think that mac file systems allow you to easily find changed files, but I don't know about Windows, so relying on that would make for a confusing interface.

    However, after a folder is synchronized, the metadata status of all the files is known (or is known to the time of the synchronization). I wonder if Adobe could somehow lever off the synchronization process to create temporary found sets with various metadata states, but only allow access to them immediately after synchronization (when they are likely, but not assured, to be correct)?

    I think we all feel the need for this, that any even halfway usable solution would be a great boon.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

  • Alan wrote, "Absent any official (or unofficial) response from Adobe, I have assumed that the reason this feature has not been implemented is because it is in general a very expensive feature to implement (in terms of disk access)."

    LR already implements automatic background checking for metadata conflicts and displays the conflicts with an icon on the Library thumbnails, and it records the conflicts in its catalog.

    What people are asking for here is pretty simple: a way to filter just those images that LR has already identified and recorded in its catalog as having conflicts.

    In another thread, some people would also like to have a mechanism to see the fields that are in conflict and be able to choose on a field-by-field basis how to resolve the conflict.
    • view 2 more comments
    • And to comment on an earlier post in this thread, yes, afaict, Lightroom could easily have a smart folder criterion for "unsaved metadata" and it would be very helpful to have such a folder for those who do not "automatically save metadata". I can see no reason why Adobe couldn't implement this immediately.
    • I dont know why Adobe is dragging their feet on this one. Yes, there are some technical issues around when the info is getting updated, and yes, all are easily solvable, or so it seems to me too, so no - I dont have a clue why Lr3 hasn't got this remedied - maybe Lr4 (or Lr3.5, ha-ha).
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

  • I've noticed that every time my Lr catalog is optimized several photos randomly change from "up to date" to "has been changed". I'm absolutely sure the photos haven't been changed in any way, internally or externally, so I guess it's a bug with the optimization routine in Lr, related to the persistent general metadata bug.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

  • 1
    SQLiteroom will create a collection of photos that have metadata conflicts.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

  • Great news - the Metadata Status is now available in the Metadata Filters for Lightroom 4 beta
    • view 2 more comments
    • Hi Rob,
      Yes I know your plugin, tested it and might use it but,
      -not everybody knows it
      -interface / readability is not as good as what could be done natively (though I do not criticize your work :) )
      And finallly, I think that this functionnality is so important for a DAM, that it should have been there right since LR1. especially it is not that hard to code, everything is already in place, you just need proper UI spec.
      But I can understand that it has been held back till now, there is so much to be done.
      It is great that people like you try to address these issue by developping plugins.
      However, ideally, plugin should only be needed for feature that are'nt "basics must have"
      regards
    • There is another thread for discussing metadata synchronization. This one may be a bit dead, since the original FR/Idea really has been implemented now.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly