Lightroom: Is there a fast way to turn off/on export of all synonyms?

  • 3
  • Question
  • Updated 1 month ago
  • Answered
  • (Edited)
For my website I want to have keywords with my photos - of course who would not. But my webspace provider would restrict the amount of keywords per photo to be indexed for searches to 30. Since I have set up around 23000 different keywords with synonyms and am using them frequently (of course not 23000 on one photo) I am above that limit very fast, if I export my photos including the synonyms, which now is activated for every single one of them.
Is there any fast way to turn of the export of synonyms, so that I do not have to edit every single keyword to get that mark out of that one box?

If there is no such fast track - I would love this as a future feature :)

Thanks in advance.

Best regards

Wiebke
Photo of Wiebke Schrøder

Wiebke Schrøder

  • 18 Posts
  • 1 Reply Like

Posted 6 years ago

  • 3
Photo of Rob Cole

Rob Cole

  • 4831 Posts
  • 389 Reply Likes
If you want to permanently kill ALL synonym exporting, then use SQL:

update AgLibraryKeyword set includeSynonyms=0;

e.g. via SQLiteSpy - exit lightroom & backup .lrcat file first..
Photo of Wiebke Schrøder

Wiebke Schrøder

  • 18 Posts
  • 1 Reply Like
Thanks - that will most certainly help make things easier :) Guess I will go and analyze the databases structure then later and see what I can do else in little scripts to make things go easier :D
Photo of Rob Cole

Rob Cole

  • 4831 Posts
  • 388 Reply Likes
If you want to run SQL scripts each time you start Lightroom, consider:

SQLiteroom

Rob
Photo of Wiebke Schrøder

Wiebke Schrøder

  • 18 Posts
  • 1 Reply Like
Thanks, that sounds cool :)
Photo of Wiebke Schrøder

Wiebke Schrøder

  • 18 Posts
  • 1 Reply Like
@Rob Cole: Thanks for your little update and your more complex tool. That helps me get my keywords sorted easily - I saw myself going through all my keywords manually and that on a few LR catalogues, would have taken ages I suspect.
Photo of Geoffrey Billet

Geoffrey Billet

  • 1 Post
  • 0 Reply Likes
This reply was created from a merged topic originally titled Lightroom classic : Don't export synonyms.

Hello,


I have a hierarchy of keywords using synonyms but I do not want for each workflow to export the synonyms every time. I was told that by checking / unchecking the export option "Write keywords according to the hierarchy of Lightroom" but I do not see any differences, the synonyms are in the files with each choice.

Someone would have a solution to choose the export or not of the synonyms with the keywords (solution, plugin ...)
 
Thank you in advance ;)
Photo of John R. Ellis

John R. Ellis, Champion

  • 4685 Posts
  • 1268 Reply Likes
As Johan replied in the original thread, your only option is painful: Editing each keyword and unchecking the Export Synonyms option.  See this previous reply for how to do this quickly by modifying the catalog database directly: 
https://feedback.photoshop.com/photoshop_family/topics/lr_5_1_fast_way_to_turn_off_on_export_of_all_... (That's obviously a solution that needs extreme care.)

Unfortunately, longstanding omissions from the LR SDK prevent plugins from setting or unsetting the Export Synonyms option:
https://feedback.photoshop.com/photoshop_family/topics/sdk_no_way_to_set_get_export_containing_keywords_export_synonyms