FAQ Search Memberlist Usergroups Profile Log in to check your private messages
Incubus-Online-View Forum Index  Log in  Register
An Idea - Setlist Statistics

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Incubus-Online-View Forum Index -> Comments About Incubus Online View
View previous topic :: View next topic  
Author Message
walkermc0206
Turbo Geek


Joined: 19 Nov 2006
Posts: 358
Location: Milwaukee

PostPosted: Wed Oct 17, 2007 2:48 pm    Post subject: An Idea - Setlist Statistics Reply with quote

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)
Back to top
View user's profile Send private message Send e-mail AIM Address
Author Message
multitudious
Megalomaniac


Joined: 24 Feb 2004
Posts: 2498
Location: Philadelphia

PostPosted: Wed Oct 17, 2007 5:07 pm    Post subject: Reply with quote

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)
Back to top
View user's profile Send private message AIM Address
Author Message
walkermc0206
Turbo Geek


Joined: 19 Nov 2006
Posts: 358
Location: Milwaukee

PostPosted: Wed Oct 17, 2007 5:54 pm    Post subject: Reply with quote

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)
Back to top
View user's profile Send private message Send e-mail AIM Address
Author Message
multitudious
Megalomaniac


Joined: 24 Feb 2004
Posts: 2498
Location: Philadelphia

PostPosted: Thu Oct 18, 2007 11:15 pm    Post subject: Reply with quote

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)
Back to top
View user's profile Send private message AIM Address
Author Message
walkermc0206
Turbo Geek


Joined: 19 Nov 2006
Posts: 358
Location: Milwaukee

PostPosted: Fri Oct 19, 2007 8:46 pm    Post subject: Reply with quote

multitudious wrote:
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.


good call.
_________________
- 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)
Back to top
View user's profile Send private message Send e-mail AIM Address
Author Message
barf
Zedeveel


Joined: 27 Sep 2006
Posts: 3018
Location: Tx

PostPosted: Fri Oct 19, 2007 9:48 pm    Post subject: Reply with quote

i read it.

interesting. ill have to re-read after the beers.
Back to top
View user's profile Send private message
Author Message
pflan
Azwethinkweist


Joined: 14 Jul 2003
Posts: 4836
Location: Chicago

PostPosted: Thu Oct 25, 2007 9:44 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Author Message
multitudious
Megalomaniac


Joined: 24 Feb 2004
Posts: 2498
Location: Philadelphia

PostPosted: Thu Oct 25, 2007 10:01 am    Post subject: Reply with quote

Aceman118 wrote:
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.


Yeah, I don't have any problem creating the database - that's the easy part (and this is a really small amount of data - three tables would suffice - shows table with showid/date/venue/comments/tourid and a songs table with showid/song number pk and a tourid table - I'd be surprised if it was larger than 10mb). We really need someone to write a script to parse out what's already on the html set list pages into sql statements that can be run en mass on the db. I could probably do it, but I simply don't have the time between school and work right now.
_________________
....and you've eaten your pen. simply stunning.

Problems with the board?
Try this subforum or PM / IM me (AIM:aminerx)
Back to top
View user's profile Send private message AIM Address
Author Message
pflan
Azwethinkweist


Joined: 14 Jul 2003
Posts: 4836
Location: Chicago

PostPosted: Thu Oct 25, 2007 10:41 am    Post subject: Reply with quote

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

Maybe we deserve to be caged.
Back to top
View user's profile Send private message
Author Message
multitudious
Megalomaniac


Joined: 24 Feb 2004
Posts: 2498
Location: Philadelphia

PostPosted: Thu Oct 25, 2007 10:56 am    Post subject: Reply with quote

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)
Back to top
View user's profile Send private message AIM Address
Author Message
pflan
Azwethinkweist


Joined: 14 Jul 2003
Posts: 4836
Location: Chicago

PostPosted: Thu Oct 25, 2007 11:23 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Author Message
multitudious
Megalomaniac


Joined: 24 Feb 2004
Posts: 2498
Location: Philadelphia

PostPosted: Fri Oct 26, 2007 10:01 am    Post subject: Reply with quote

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)
Back to top
View user's profile Send private message AIM Address
Author Message
m125x
Zeta


Joined: 03 Apr 2007
Posts: 64

PostPosted: Fri Oct 26, 2007 10:38 pm    Post subject: Reply with quote

Something such as what they have for 311 would be great!
Back to top
View user's profile Send private message
Author Message
walkermc0206
Turbo Geek


Joined: 19 Nov 2006
Posts: 358
Location: Milwaukee

PostPosted: Sat Oct 27, 2007 1:15 am    Post subject: Reply with quote

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


Also, antsmarching.org <- Dave Matthews Band Fansite

check um out
_________________
- 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)
Back to top
View user's profile Send private message Send e-mail AIM Address
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Incubus-Online-View Forum Index -> Comments About Incubus Online View All times are GMT - 4 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

BBTech Template by © 2003-04 MDesign