show uncategorized images in folder/subfolder?

Ask for help and post your question on how to use XnView MP.

Moderators: helmut, XnTriq, xnview

Post Reply
shadowpower
Posts: 18
Joined: Sun Oct 13, 2013 3:16 am

show uncategorized images in folder/subfolder?

Post by shadowpower »

I'm using xnviewmp 0.72 in windows 8.1 64 bits and I want to know how to get all the images inside a folder and all of it's subfolders, I tried using Categories filter / Special items / Uncategorized but it shows a lot of folders that aren't inside the current folder, even if match is set to Current Folder (Recursive). Is there another way to do it or am I doing something wrong?
User avatar
XnTriq
Moderator & Librarian
Posts: 6512
Joined: Sun Sep 25, 2005 3:00 am
Location: Ref Desk

Re: show uncategorized images in folder/subfolder?

Post by XnTriq »

Show all file (recursive)) is in the context menu of the folder tree.
shadowpower
Posts: 18
Joined: Sun Oct 13, 2013 3:16 am

Re: show uncategorized images in folder/subfolder?

Post by shadowpower »

and how do I filter out categorized images ?
User avatar
XnTriq
Moderator & Librarian
Posts: 6512
Joined: Sun Sep 25, 2005 3:00 am
Location: Ref Desk

Re: show uncategorized images in folder/subfolder?

Post by XnTriq »

shadowpower wrote:and how do I filter out categorized images ?
Sorry for the delay.
It seems as though this feature has yet to be implemented:
m.Th. ([url=http://newsgroup.xnview.com/viewtopic.php?p=122222#p122222]Filter one Folder by Category - not complete Database[/url]) wrote:It seems that a better solution for GUI would an addition in the drop-down menu of the Match button (top-left in the Category Filter pane). The menu should be like this:


Match
     Any     //these already exists
     All
     ------------
     Globally
     Current Folder
     Crt Folder (recursive)     //only one option can be active
danjcla
Posts: 49
Joined: Fri Feb 13, 2015 12:08 am

Re: show uncategorized images in folder/subfolder?

Post by danjcla »

shadowpower wrote:and how do I filter out categorized images ?
I've recently ran into 3 problems vaguely like this. Luckily it turns out XnView uses the popular SQLite database backend; so for this, this seems to work:

SELECT Pathname || Filename AS Fullpath
FROM Images
LEFT JOIN TagsTree ON Images.ImageID = TagsTree.ImageID
JOIN Folders ON Folders.FolderID = Images.FolderID
WHERE TagsTree.ImageID IS NULL
ORDER BY Fullpath

I'm working on a slightly more difficult problem that may help out here as well - clearly you want to be able to use this info in XnView MP, and I personally wouldn't want to do any writes to the database (doing reads like the above is totally harmless). I believe (not tested yet) XnView can search for metadata embedded in files without having actual sync to XnView database enabled (I assume this is somewhat slow).

So to get around lack of features like this or features that don't work (at all for you for some reason / well / consistently) like any kind of syncing between the XnView database and in-file metadata and full boolean/predicate logic searches of categories (e.g. you have photos of bride, groom, bride+groom; in order to avoid the superfluous bride+groom category you need NOT or ONLY or IFF or whatever you want to call it options so you can find the bride alone, the groom alone, and the bride and groom together with just two categories.) I think you can have a work cycle like this:

1. Do some stuff you can do in XnView itself
2. Optionally close XnView (I'm not sure how cool XnView is with file's metadata being changed while it is running)
3. Write an SQLite query to get the info you want out of the database (the sqlitebrowser GUI is your friend) - or use the SQLite API with your favorite programming language
4. Dump the results of your query to a CSV file
5. Use a spreadsheet or shell script or whatever you are comfy with to manipulate the data in a way that is useful to you
6. Use some command line utility (there are lots; I haven't gotten to choosing one yet) to translate your edited CSV file into in-photo metadata
7. XnView can now do searches based on that in-file metadata (I hope)

So in your case, you could just use the exact output as a set of files to put an "Uncategorized" XMP/IPTC-IIM / acronym of the week keyword in. Keeping in mind that that keyword will not magically go away when you categorize the photo in XnView. But it'd be easy to do another query that would result in a list of files that are actually categorized but have an "Uncategorized" in-photo keyword, and then remove those :-) [EDIT: Actually this would be a little more complex because you'd have to deal with getting the in-file data; but still pretty easy if you are good with spreadsheets or shell scripts.]

I think that in my case the in-file metadata search might not have sloppy matching, but if it does I can do something silly like automatically generate a categoryname-ONLY keyword for each photo in only one category (and of course this gets uglier and uglier the larger and larger number of distinct subsets you need to keep track of).
danjcla
Posts: 49
Joined: Fri Feb 13, 2015 12:08 am

Re: show uncategorized images in folder/subfolder?

Post by danjcla »

I have a much, much nicer way of doing this now - see my latest post at Boolean search for keywords possible?

It shows a method to add an "∅" category that includes all uncategorized (by a human) images - you can then use xnview's search to find all of those images in a certain folder.
Post Reply