iTunes XML to SQL

Discussion in 'Digital Audio' started by Dekzter, Mar 15, 2011.

Most Liked Posts
  1. Dekzter, Mar 15, 2011

    Dekzter macrumors newbie

    Joined:
    Jul 21, 2010
    #1
    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!
     
    share
    + Quote Reply
  2. ChrisA, Mar 15, 2011

    ChrisA macrumors G4

    Joined:
    Jan 5, 2006
    Location:
    Redondo Beach, California
    #2
    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
     
    share
    + Quote Reply
  3. Prod, Apr 10, 2011

    Prod macrumors newbie

    Joined:
    Apr 10, 2011
    #3
    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
     
    share
    + Quote Reply
  4. halfthelaw, Jun 28, 2011

    halfthelaw macrumors newbie

    Joined:
    Jan 16, 2009
    #4
    More generally, are there any simple libraries for parsing the iTunes database?
     
    share
    + Quote Reply
    31rhcp likes this.
(You must log in or sign up to post here.)

Share This Page