Extracting historical data from LiveStats.XSP 7 RRS feed

  • Question

  • Hi there.

    I've inherited a LiveStats.XSP installation from a predecessor, which houses web stats for over 400 web-sites.  I would like to extract his data from livestats and convert it into a format which can be processed by our in-house stats package...  So far I've had very little luck in deciphering the database schema, or the data files stored in the livestats installation directory - I've wasted well over a day trying to make sense of it all.

    The data points I'm primarily interested in are daily bandwidth usage, and the daily number of hits per site.  Can anyone shed any light onto the process I might undergo in order to perform this conversion?  I'm not to keen on the prospect of having to manually login to livestats for every site, and download a couple XML/CSV files for each - that, IMO, is just to tedious a task for anyone to have to perform... unless they were being punished for something :P

    Any ideas, or ready made scripts out there that can save the day for me?

    Thanks in advance!
    Tuesday, April 7, 2009 7:21 AM