kalain Posted December 13, 2015 Report Share Posted December 13, 2015 Hi, 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 ? Thanks Quote Link to comment Share on other sites More sharing options...
kalain Posted December 13, 2015 Author Report Share Posted December 13, 2015 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) Quote Link to comment Share on other sites More sharing options...
ormen Posted December 13, 2015 Report Share Posted December 13, 2015 I understand .dmc files are SQlite database files.You could from GitHub download the "DB Browser for SQLite" and using this program try to edit or delete keywords, if nothing else works https://github.com/sqlitebrowser/sqlitebrowser/releases Quote Link to comment Share on other sites More sharing options...
rene Posted December 13, 2015 Report Share Posted December 13, 2015 right now, I gues you have to do it manually Quote Link to comment Share on other sites More sharing options...
kalain Posted December 13, 2015 Author Report Share Posted December 13, 2015 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!! @Ormen 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. Quote Link to comment Share on other sites More sharing options...
Murat Posted December 13, 2015 Report Share Posted December 13, 2015 Only readonly empty tags can be removed automaticaly via the Optimize command. Unfortunately there is no way to remove empty keywords unless selecting them manually one by one. But I've update this issue (and appended your vote) on our issue tracker. Quote Link to comment Share on other sites More sharing options...
kalain Posted December 14, 2015 Author Report Share Posted December 14, 2015 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. Quote Link to comment Share on other sites More sharing options...
kalain Posted April 8, 2016 Author Report Share Posted April 8, 2016 Hi, Is there any news about this one ? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.