Hi Guys - Thanks for the various suggestions. At the end of the day I took the xml to csv example and cannibalised it. I don't have to deal with subscriptions and there is some of the other stuff I can throw away so it wasn't that big a deal really.…
Ummmm.... Ok, here it is. I make no claims regarding the quality of my PHP so would be happy for someone to point out improvements (I'm aware I need to do things to the date before putting it into the database... just haven't got round to it yet) -
OK, thanks Brett. I might change to using the API rather than the XML at some point (I can see clear advantages) but the client isn't paying me to do it twice so for the moment I won't.
cheers,
Gordon