DJanGo wrote:
> 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.
THis is simply brilliant. Never thought of doing it this way. Thanks a
lot. This will make it a lot easier to go back to the boxes of CD's and
re-rip the missing ones or to the stores and re-download :)
Main System: Touch; Marantz SR-5004; TMA Premium 905; TMA Premium 901;
BK Monolith+ FF; HDI Dune Smart D1; Pioneer PDP-LX5090H
iPad 32GB Wifi + Squeezepad (local playback activated)
Acer Iconia Tab A700 + Squeezeplayer
Wandboard Duallite + CSOS, integrated LMS activated
------------------------------------------------------------------------
bakker_be's Profile: http://forums.slimdevices.com/member.php?userid=30369
View this thread: http://forums.slimdevices.com/showthread.php?t=104859
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss
