Page 1 of 1

categories

Posted: Sun Jul 25, 2010 11:14 pm
by obelisk
Using WinXP + XnV 1.97.6
I have about 10k files in D:\ with categories.
I'm wanting to move them to a network drive.

I don't want to lose the categories.

What do I do?

Re: categories

Posted: Mon Jul 26, 2010 8:26 am
by xnview
D:\ with many subfolders?

Re: categories

Posted: Mon Jul 26, 2010 11:36 pm
by obelisk
yes that is right

basically

D:\Photos\
and under that folder for each year and inside folder for every event and inside folder for jpg, raw, video, etc

Re: categories

Posted: Tue Jul 27, 2010 7:04 am
by xnview
So make a bakcup of category file :-)
And download SQLiteBrowser (http://sqlitebrowser.sourceforge.net/)
In t2 table you can see the files...

To change the path go to 'execute SQL' and type:

Code: Select all

update t2 set f = 'c:\new path\' || substr(f,length('e:\old path\') +1,999) where f like "e:\old path\%" 
(replace 'c:\new path\' & 'e:\old path\')

Re: categories

Posted: Wed Jul 28, 2010 11:23 pm
by obelisk
thanks. we should put this in a faq somewhere.