show uncategorized images in folder/subfolder?
Moderators: helmut, XnTriq, xnview
-
- Posts: 18
- Joined: Sun Oct 13, 2013 3:16 am
show uncategorized images in folder/subfolder?
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?
Re: show uncategorized images in folder/subfolder?
Show all file (recursive)) is in the context menu of the folder tree.
-
- Posts: 18
- Joined: Sun Oct 13, 2013 3:16 am
Re: show uncategorized images in folder/subfolder?
and how do I filter out categorized images ?
Re: show uncategorized images in folder/subfolder?
Sorry for the delay.shadowpower wrote:and how do I filter out categorized images ?
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
Re: show uncategorized images in folder/subfolder?
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:shadowpower wrote:and how do I filter out categorized images ?
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

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).

Re: show uncategorized images in folder/subfolder?
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.
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.
