by dalanik on Tue May 22, 2007 9:32 pm 
Just a small something I've been working on yesterday, it's not a big deal but helped me a lot, so I figured why not share, if it helps one other person, it's worth the effort
Anyways, my problem is that I have like 1,5Tb of movies online sitting at 2 NAS, ripped as AVIs. The database is in ANT and I really try to enter all the info needed to play the movie into ANT (i.e. URL in ANT is used as PARAMETER field in XLobby) etc. But since in real life things are a bit different, I move stuff around and there are a lot of films in 2 parts (avis), subfolders, etc, I sometimes make mistakes, overtime I am not sure anymore that all movies have correct paths in the database etc.
So I made this small proggy to check it. Right now it only checks XLobby database, but I plan to do it other way around as well (i.e. read files and then check database).
What it does is it reads through movies.xml and checks if individual entries in <parameter></parameter> exist. It also can check for simple wildcards, i.e. <parameter>D:\movies\lord of the rings\*.avi</parameter>. It also reads offline flags from the database.
Then it creates 2 TXT files, one in which it writes (in CSV format) files that are missing, and the other in which it writes offline files.
the files are created in xlobby databases folder.
http://xlobby.lanik.org/XReconcile.v0.01.exe
D.