How to find out what songs SS missed out?

[ntang]

Did not get any reply from the "General" forum...here goes:

I have about 4000 Apple lossless files in my Itunes library. Not all of them are represented in SlimServer. I understand that Slimserver does not like certain naming conventions such as at times a "," in the name of a directory or some other reasons. I have tried to fixed those known ones as much as I can.

Question is whether there might be a way to find out all the rest of the songs that SlimServer did NOT pick up. Currently there are about 100+ out of 4000

/Nick

[egd]

Question is whether there might be a way to find out all the rest of the songs that SlimServer did NOT pick up. Currently there are about 100+ out of 4000

Once solution (possibly not the fastest/most efficient) is to generate a listing of all flac files in your music folder(s) and export that to a csv file. Assuming you're running a windows OS, something like

dir /b /on /s <musicgfolderbase>\*.flac > c:\temp\dirlist.csv

will generate the disk based listing.

Connecting to the slimserver db via mysql and running a suitable query to list all tracks would give you similar output, which you should route to a text file.

Import both of these files into OpenOffice or Excel, column A and B respectively and parse the strings if necessary to enable a simple formula comparison in column C, which reads

=A1=B1

Any rows producing a FALSE value are mismatches requiring investigation. Where differences exist, you will need to move data around to realign matching rows. The spreadsheet comparison process assumes both lists are alphabetically sorted.

[ntang]

Many thanks for your reply. Would you know what I need to do to generate the list from SS? Not familiar with SQL and al.

/Nick

Once solution (possibly not the fastest/most efficient) is to generate a listing of all flac files in your music folder(s) and export that to a csv file. Assuming you're running a windows OS, something like

dir /b /on /s <musicgfolderbase>\*.flac > c:\temp\dirlist.csv

will generate the disk based listing.

Connecting to the slimserver db via mysql and running a suitable query to list all tracks would give you similar output, which you should route to a text file.

Import both of these files into OpenOffice or Excel, column A and B respectively and parse the strings if necessary to enable a simple formula comparison in column C, which reads

=A1=B1

Any rows producing a FALSE value are mismatches requiring investigation. Where differences exist, you will need to move data around to realign matching rows. The spreadsheet comparison process assumes both lists are alphabetically sorted.

[egd]

Many thanks for your reply. Would you know what I need to do to generate the list from SS? Not familiar with SQL and al.

/Nick

Sorry, but I'm no SQL guru and I'm not familiar with the slimserver database schema. I seem to recall there was a gif or jpg copy of the schema floating about somewhere in the these forums. The schema should help you identify the relevant tables, relationships etc. and MySQL has a few free tools to help you construct a query. Given what you're after is all tracks the query could be pretty simple, perhaps as simple as

SELECT * from TRACKS ...