iTunes XML to SQL

[Dekzter]

Hey,
Not entirely sure if this topic belongs here, but...

I'm looking to find out if anyone has a method or written a program to basically take an iTunes Library.xml file and insert all of the information into a SQL database. I want to be able to upload and view the information of my iTunes library to my website for others to see. I can do with the web and all, but do not have the skills to extract the information and put each item into a query.

Thanks in advance!

 

[ChrisA]

Hey,
Not entirely sure if this topic belongs here, but...

I'm looking to find out if anyone has a method or written a program to basically take an iTunes Library.xml file and insert all of the information into a SQL database. I want to be able to upload and view the information of my iTunes library to my website for others to see. I can do with the web and all, but do not have the skills to extract the information and put each item into a query.

Thanks in advance!

Better I think to translat the XML directly into the HTML you want.
http://www.w3schools.com/xsl/

You might try asking this is a developer forum

 

[Prod]

Hey Dekzter

Yes I've written such a program, SqlMyTunes for iTunes ... it also allows you to create playlists from SQL queries. It's at www.misterpete.co.uk if you want to take a look. Windows only I'm afraid at this stage, supports MS SQL Server/Express but I'm looking at MySQL support too.

Cheers,
Pete

 

[halfthelaw]

More generally, are there any simple libraries for parsing the iTunes database?