Page 1 of 1

Categories.db AGAIN

Posted: Mon Nov 12, 2012 7:24 am
by obelisk
OK I'm about to give up on using Categories at all.
I setup all these Categories and tagged 10k+ of files.

I reprocessed some files and as a result they have moved from <path1>\x.jpg to <path2>\x.jpg. Path names are different lengths so I can't hack into the category.db to fix it.

I'm not going to re-categorize all these files again. I can't find a free sqlite editor that can do batch replace. I feel like I'm wasting my time. Half the time I'm worried category.db will be corrupt and lose all my data gain so I can't open multiple xnviews. 4 Years ago we asked you to store category either in a folder db file, or in IPTC. It's clearly not going to happen. So what now?

Re: Categories.db AGAIN

Posted: Mon Nov 12, 2012 7:48 am
by xnview
yes it's a problem in XnView, XnViewMP use different database
Do you use 'sqlite browser'?

Re: Categories.db AGAIN

Posted: Mon Nov 12, 2012 9:19 pm
by obelisk
My search for sqlite editors all can read, and edit one cell
But nothing can do replace <path1> to <path2>

That's why I can't fix it.
When will MP be complete replacement for XnView?

Re: Categories.db AGAIN

Posted: Tue Nov 13, 2012 7:15 am
by xnview
obelisk wrote:My search for sqlite editors all can read, and edit one cell
But nothing can do replace <path1> to <path2>

That's why I can't fix it.
Here is an example
http://newsgroup.xnview.com/viewtopic.p ... ser#p85799
When will MP be complete replacement for XnView?
I don't know yet...