Pulling Team Awards
 

So, I've been looking into how to pull team awards data for the past season, and I was hoping that someone would help light the way a little bit.

First, I checked the The FIRST Alliance API and TBA API and neither of them appear to provide that information?

I tried like into going in event by event, but I don't know what all of the event specific codes, and evens till, the html parsing would just get ugly.

So, any suggestions?

- Sunny G.

Re: Pulling Team Awards
 

Team 358 has already compiled that info. You can just grab it from them.
http://team358.org/files/frc_records/AllAwards.xls

They also compiled tons of other information about FRC teams.
http://team358.org/files/frc_records/

Re: Pulling Team Awards
 

Those are some pretty nice sheets, but I would love to have the 2013 records.

I wonder how they build their spreadsheet.

- Sunny G.

Re: Pulling Team Awards
 

Sorry, I don't understand. The sheet I linked to you does have the 2013 records.

Re: Pulling Team Awards
 

Ah, so it does. My bad.

I'd still be interested in a automated approach so I can pull from various resources, but this does the job for now.

Thanks,
- Sunny G.

Re: Pulling Team Awards
 

I've been looking into doing the same thing, and haven't found a better way other than scraping web pages or using an offline database such as the one AGPapa linked.

As far as event codes go, you can find them on the bottom of this page: http://frclinks.frclinks.com/. Remember that for the Championship division pages the full name of the division is used rather than a code.

If you need more ideas, you could try looking through The Blue Alliance's code to see where they get their data: https://github.com/gregmarra/the-blue-alliance