bakker_be wrote:
> I'm working on Windows actually.
hopefully your are not a beginner in the "black & white world (command)"
of Windows:D
ok you need sqlite3 the commandline executable - google for that and put
it somewhere in a separate folder.
you need a copy or the original library.db copy that to the folder where
you put sqlite3.
run a cmd shell
Code:
--------------------
sqlite3 library.db "select url from tracks">myfiles.txt
--------------------
Now you should have a new file -myfiles.txt- - since thats a onces only
job - you open that file with notepad.
Search and replace
- %20 against " " (space)
- / against \
- File:// against "" (nothing) or the path where your windows System
finds these files
- if there are another %00-%FF - you have to find what chars these
represent and replace these also
- if your done save that file
now you need some cmd file.
Code:
--------------------
echo "@echo on">my_batch.cmd
notepad my_batch.cmd
--------------------
this file should look like:
Code:
--------------------
@echo on
for /f "delims="" %%a in ('type myfiles.txt') do
if not exist "%%a" echo "%%a">>lost_files.txt
next
--------------------
save that file and run it. If its done you should have a new file named
lost_files.txt and that should list all the files that lms know and not
included in your Backup.
Gruss
Jan
------------------------------------------------------------------------
DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516
View this thread: http://forums.slimdevices.com/showthread.php?t=104859
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss
