To the OP: I've got a tonne of media on my Drobo, and I feel your pain. Between my MP3s, pictures, videos and books, keeping tabs on file names, physical file locations, its quite the nightmare, and by the sounds of it, Roger has been exposed to this issue more so than I have been, and with my limited experience with just my central repository, well, its a daunting and time consuming task.
For MP3s, there are plenty of applications out there, both paid and free, that will handle tags with ease, check file names, and I've even heard of applications that will "listen" to each MP3 and see how close they sound to each other. A few years back, on my first initial attempt to organize my MP3s, I used Winamp to edit the tags and rename the physical files, however, moving the files to an appropriate directory was still a 'manual' process IIRC, but the physical file management did become easier with the file renames, and Google came in to help me track down lyrics and put the name of a song to an MP3. Then there's how iTunes handles naming files it downloads. *sighs and goes and curls up in a corner* Basically, there is no magic bullet for organizing based on file names. As Roger mentions, a lot of it is going to be a manual process. If you're developing an application that would at least get you started, what I would do is this: - Get a full directory list of all files to be taken into consideration and put them into two tables. One table for the paths that contain the files, and another table to hold the file names. FK between these two tables. - Run through the list of file names and extract each word and put each word into a third table, with another FK relationship to just the file name table. For proper normalization, I could also put a 4th table in the mix to make a "many to many" relationship between the word list and file name list, which I would ensure the third table has only unique words. Depending on how you write and your preferences, this would be up to you. - Have a sorted list of words (Table 3) in a list box on the GUI so that when I click on a word, another list box is populated with the file names and/or the paths of the files found. - Have some kind of event/trigger that would allow me to rename, move, or edit the MP3 ID3 tags of the file in the second list box. Update the database, word list (if needed) and continue on. The reason for the word list is that even though you can search for a particular word, you'd never really be able to ensure a 100% hit on every file by doing a manual key entry, not to mention what you would type in with proper spelling may show up in the word list as being spelled incorrectly. I would then go through each word entry and see if I can find duplicate file names in the second list box. I could also introduce reading the ID tags directly from the MP3 and edit as is. There are many ways to handle this behemoth task. A query, to get you started, like [ select * from FileList where FileName like '%demon%' ] would be something towards what you'd have to use.. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
