categories

[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?

[xnview]

D:\ with many subfolders?

[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

[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\')

[obelisk]

thanks. we should put this in a faq somewhere.