Filtering images on Categories

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

Moderators: XnTriq, xnview

Post Reply
Tetraquark
Posts: 3
Joined: Fri Dec 03, 2010 7:11 pm

Filtering images on Categories

Post by Tetraquark » Fri Dec 03, 2010 7:44 pm

Hello,

First, I must say that I am very much impressed with XnView! It has numerous features and also many possibilities for user customization. The program is far better than any of other alternatives which are even commercial programs.

I have a few questions:

1) I am using CATEGORY feature to filter images with different categories. When I click on few categories the application shows all images which have ANY of the selected categories. This means the application uses OR between categories. However I need that the application shows images which have ALL of the selected categories. This means I need AND between categories.
Is there an option to customize the application for choosing between AND or OR between categories?

2) When I assign one or more categories to an image I assume that the application does not store that info in the image's meta data (i.e. into the image's file - although this would be a nice feature) but instead into the application's database.
a) Can anyone please tell me how to backup this database (in order to restore it when the application is reinstalled)?
b) Where is the database stored? I know that the program has an option which controls where the settings are stored (an .ini file in User or Program directory or in Windows registry).
c) Is the format of the database publicly specified? (in order to use the database potentially with other applications)

thank you in advance for the support!

kind regards
Last edited by Tetraquark on Mon Dec 27, 2010 1:08 pm, edited 1 time in total.

Tetraquark
Posts: 3
Joined: Fri Dec 03, 2010 7:11 pm

Re: Filtering images on Categories

Post by Tetraquark » Fri Dec 03, 2010 8:07 pm

I have configured XnView to store its settings into the USER folder (C:\Documents and Settings\ XZY user \Application Data\XnView) and there I have found 2 database files and an .ini file. One database file is called "category.db" and by opening it in a file hex viewer I see "SQLite Version 3" in the file's header. Well, SQLite is an SQL database engine and that pretty much answers my question 2c... Although I would very much appreciate this fact to be formally specified in the XnView's specifications.

User avatar
xnview
Author of XnView
Posts: 31002
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: Filtering images on Categories

Post by xnview » Mon Dec 06, 2010 1:05 pm

Tetraquark wrote: Is there an option in the order to customize the application to chose between AND or OR between categories?
Currently no way
2) When I assign one or more categories to an image I assume that the application does not store that info in the image's meta data (i.e. into the image's file - although this would be a nice feature) but instead into the application's database.
a) Can anyone please tell me how to backup this database (in order to restore it when the application is reinstalled)?
b) Where is the database stored? I know that the program has an option which controls where the settings are stored (an .ini file in User or Program directory or in Windows registry).
You have category.db in your ini profile
Pierre.

Post Reply