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.