![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Through the power of EphPod, WinVI, Regular Expression replace strings, MySQL, SQLYog and PHP I have reached new levels of nerdyness!
I found that EphPod will export your iPod playlist as Comma Separated Values (suitable for importing into MySQL!) The problem is that it exports WAY more crap than I want. So I whipped up a handy regular expression to remove all the fields after Title, Album, Artist, Genre and Track Number. Excellent!
The cleaned .csv then got imported into a MySQL database created especially for the purpose. Now I'll just have to write up a PHP script to display the information nicely, and we're set! Now scummpod.scummbox.org exists!
And best of all... since I crafted a regular expression to get rid of the extra crap in the CSV, I can keep the site up-to date very easily! :D
I found that EphPod will export your iPod playlist as Comma Separated Values (suitable for importing into MySQL!) The problem is that it exports WAY more crap than I want. So I whipped up a handy regular expression to remove all the fields after Title, Album, Artist, Genre and Track Number. Excellent!
The cleaned .csv then got imported into a MySQL database created especially for the purpose. Now I'll just have to write up a PHP script to display the information nicely, and we're set! Now scummpod.scummbox.org exists!
And best of all... since I crafted a regular expression to get rid of the extra crap in the CSV, I can keep the site up-to date very easily! :D
Tags: