Unix Technical Forum

RSS Style Feeds from Itunes.xml to External Publicly Accessible DB

This is a discussion on RSS Style Feeds from Itunes.xml to External Publicly Accessible DB within the MySQL General forum forums, part of the MySQL category; --> Greetings All: It's been a while since I've posted, but I wanted to see if any of you have ...


Go Back   Unix Technical Forum > Database Server Software > MySQL > MySQL General forum

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 06:51 AM
Van
 
Posts: n/a
Default RSS Style Feeds from Itunes.xml to External Publicly Accessible DB

Greetings All:

It's been a while since I've posted, but I wanted to see if any of you
have approached the following challenge.

I have a Mac that runs iTunes a few hours a day, sometimes with Ampache
feeding playlists, to it and I'd like to expose my recently listened to
songs to a public web-site for a "see what Van's been listening to
lately" module on the site.

I can cron this from a local linux replicating server that can access
the xml playlist via samba from the imac. Disconnected network states
are acceptable.

My application requires the expertise of itunes.xml to mysql db
developers more than anyone else. I need the locally connected mysql
server to be able to get the itunes.xml via samba to parse through this
xml file and insert into a table on the linux mysql server, which I'll
cron out updates to the publicly available mysql server, which will
accept the db update and render via a php script this list (song, number
plays, skip count, etc.) as an include for publication from other pages
on this site.

Anyone started on such a thing?

If not, and anyone else interested, I'll post my final module, and
implementation.

Thanks,
Van

--
================================================== =============
Ded Serius Music http://www.dedserius.com/
================================================== =============

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:27 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com