Jump to content

How to remove empty keywords ?


Recommended Posts



I have added by error some pictures in my catalog and then a while later remove from it.

But now, I have plenty of keywords in the list which equals 0.


I would like to "clean" keyword list from these "empty" keywords.


Didn't find how to do this easily without browsing keyword list. (Over 500 keywords!)


Optimize action do not give me the choice to remove these empty keywords.


Any isea for this ?



Link to comment
Share on other sites

May be, If keyword list could be sorted by number of items, sorting it ascending will show all '0' on top.


then, it will be easy to select all empty and delete.


Also sorting lists by item number gives some 'statistics' about used tags. (keyword, place, event,....)

May be would be nice to have such possibility? (Sort by item number)

Link to comment
Share on other sites

right now, I gues you have to do it manually

Well, this will stay like this because I finally have more than 1300 keywords in my list!!



Thanks for the tip, interesting but not so easy to understand how tables are linked.

I prefer not modify anything from SQL Browser because I'm not sure at all of the (good) result.


Anyway, this will stay like this waiting a better (and automatic) solution from new release.

Link to comment
Share on other sites

May be this can also be done each time when removing any item (via removing a folder or not).

This concern all tags : Media Format, Camera model, camera lens, people, place (?), Event, keywords, categories (?), and collections (?)


If doing this in real time (when removing from catalog) increase significantly remove operation (due to additionnal sql queriy), it's may be better to postpone this operation by a specific action, in Optimize action for example.

Link to comment
Share on other sites

  • 3 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...