If there was ever any doubt in my mind about my lack of time management skills and general insanity, it's gone now. Because, now that the massive archiving project is over and all my CDs are nicely organized and labeled in their binders, I've decided that I simply must start another humongous music-related project. This time it's a database of all songs in the Divaville Lounge collection.
It sound nuts, but there's a good reason for it. Christa showed me to use allmusic.com to search for music info. Which is necessary more often than you might think. Supposing someone calls in requesting Jeri Southern. I don't have any albums of hers, but I might have a song or two on compilations. Or they want the song, say, "Ida, Sweet as Apple Cider," but they don't know who sings it. Again, I might have it, but if I haven't played it before, I probably don't know where.
During the hustle and bustle of a show, there is simply no way I could find these songs just by flipping through the binders. Especially if I don't know for sure if I even had them or not. So allmusic.com becomes an invaluable resource. I can search for an artist or song, and see if they turn up on any albums I have. Christa used it even when she knew she had the song, to quickly find the album it was on. If you have over 20 albums by one artist, this can save you a lot of time!
The only problem is, allmusic.com hasn't been working for me. It's been timing out every single time I try to use it. In the past 3 weeks I've tried many times, during the show or not, on different computers and different browsers. Not one successul search. Christa warned me that the site was flaky, but this is ridiculous.
After 3 weeks of this I'm ready to write off allmusic.com. And I've realized that what I really need is a searchable online database of my own music collection. The massive indexing project! Luckily, due to the massive archiving project, at least half the collection is still on either my computer or Georg's. (We didn't want to delete the files in case one of the CDRs went bad.) A thousand thanks to Lisa and D. for pointing out last night that iTunes generates an XML file of its library. Thus sparing me from having to import the data from all those hundreds of albums, one at a time.
It was easy as pie to import the iTunes libraries into Filemaker. Unfortunately Filemaker's "web publishing" feature leaves much to be desired. If I had a permanent IP address for my computer, I could link directly to the database through a web interface. But, I don't. If I had the more expensive "server" version of Filemaker I could export the DB to a searchable web page. But, I don't.
What I'm left with is exporting the DB to one big long humongous web page, comprising a big long humongous table which displays every record. Not exactly what I wanted. So the next step will be to export the Filemaker database to MySQL, and then write PHP pages to display the song info exactly the way I want.
It won't be ready by today's show, since I don't feel like rushing to get it done this morning. And then there are still all the albums that weren't in our iTunes, which will indeed have to be added manually, one at a time. Still, I feel better just knowing that I have a plan. In the meantime I can search Christa's and my old playlists if I need song info. It's not perfect because it only includes songs that have been played on prior shows, but it's a pretty good stopgap.