An Idea - Setlist Statistics

[walkermc0206]

Personally, one of my favorite things about musical groups that I really like is seeing what is on their set each night when they're on tour. Now, I think IOV does a great job with Incubus setlists, their up within a day and it's very organized. Compliments to IOV for that. But one thing that keeps me on band websites for a long time is when they use statistics with all the setlists on the site. For example, not only do they have a setlist archive but they also have information on how many times songs were played each tour/overall, what albums had more songs played than others during a tour, etc. I'm not sure if there is some sort of program out there (I suppose I could look into that), and I understand if something like this would take a lot of time and would just seem unreasonable. But I really think that it would attract more visitors and I believe that some of them would browse the site for much longer. I know you're probably not worried about that. Anyway, it was just an idea that I was wondering about. Let me know what you think.
_________________
- Walker

02/06/07 (Chicago). 07/18/07 (Red Rocks), 07/24/07 (Minneapolis), 07/25/07 (Chicago), 07/21/09 (Chicago), 07/22/09 (Indianapolis), 08/21/11 (Chicago), 05/08/12 (Milwaukee)

[multitudious]

Interesting idea. It's possible with awk/perl/sed to rip through the the setlist pages and count up individual songs. I'm a bit rusty with my l33t scripting skills, so if someone is up to the task, by all means. I can set up a db for the final results (perhaps a stepping stone to all shows listed in a db).
_________________
....and you've eaten your pen. simply stunning.

Problems with the board?
Try this subforum or PM / IM me (AIM:aminerx)

[walkermc0206]

so glad you're interested, hopefully someone on here knows exactly how to go about this...would it be a bad idea to move the thread to a more popular category or does this get enough viewers?
_________________
- Walker

02/06/07 (Chicago). 07/18/07 (Red Rocks), 07/24/07 (Minneapolis), 07/25/07 (Chicago), 07/21/09 (Chicago), 07/22/09 (Indianapolis), 08/21/11 (Chicago), 05/08/12 (Milwaukee)

[multitudious]

Hmm, I'm not sure where else to put it. I think all the people that would care that much to put the effort in probably check this forum.
_________________
....and you've eaten your pen. simply stunning.

Problems with the board?
Try this subforum or PM / IM me (AIM:aminerx)

[walkermc0206]

[barf]

i read it.

interesting. ill have to re-read after the beers.

[pflan]

I think the most practical thing to do is create an actual database on the web server. It wouldn't even be that big. I could write the scripts to create the tables and stored procedures to do all the statistical lookups. It's basically what I do for a living anyway. The tedious part would be adding the data to the database.
_________________
-Pat

Maybe we deserve to be caged.

[multitudious]

[pflan]

Wow, i just took a closer look at all the setlist pages. That is a scripting nightmare.
_________________
-Pat

Maybe we deserve to be caged.

[multitudious]

It's not that bad - everything is very consistent, which helps.

regex for the date(<p><b>dd/mm/yyyy), regex to the set (tags always the same around it), regex for the / slash between the songs and a regex to jump to notes. I have some python code from an old cs project i can modify to do this on each page, just not this week.
_________________
....and you've eaten your pen. simply stunning.

Problems with the board?
Try this subforum or PM / IM me (AIM:aminerx)

[pflan]

Some pages us | instead of / and some pages have each show in tables and the notes are in different spots. I never really got into scripting languages so I'm probably just looking at it wrong.
_________________
-Pat

Maybe we deserve to be caged.

[multitudious]

as long as each page is consistent to itself, it's just a minor modification of the regular expressions. after my midterm today i'll give one a whirl.
_________________
....and you've eaten your pen. simply stunning.

Problems with the board?
Try this subforum or PM / IM me (AIM:aminerx)

[m125x]

Something such as what they have for 311 would be great!

[walkermc0206]