View Single Post
  #1   Spotlight this post!  
Unread 06-05-2014, 20:14
Eugene Fang's Avatar
Eugene Fang Eugene Fang is offline
The Blue Alliance
no team
Team Role: Alumni
 
Join Date: Jan 2007
Rookie Year: 2000
Location: Bay Area, CA -> Pittsburgh, PA
Posts: 772
Eugene Fang has a reputation beyond reputeEugene Fang has a reputation beyond reputeEugene Fang has a reputation beyond reputeEugene Fang has a reputation beyond reputeEugene Fang has a reputation beyond reputeEugene Fang has a reputation beyond reputeEugene Fang has a reputation beyond reputeEugene Fang has a reputation beyond reputeEugene Fang has a reputation beyond reputeEugene Fang has a reputation beyond reputeEugene Fang has a reputation beyond repute
Re: Pulling a List of Teams into Excel

Quote:
Originally Posted by ttldomination View Post
For the past year, I've been using Excel's web queries to pull a list of teams attending the event. The process is relatively simple, go to frclinks.com/event/gadu, point to the table that contains the information, and *bam*, done.

However, recently, the web queries have been failing, and the information isn't showing up.

I'm at a bit of a loss and am wondering if anyone else is either (a) seeing a similar failure and (b) has a solution that let's me continue to avoid parsing through the HTML.

Thanks,
- Sunny G.
The Blue Alliance has CSV dumps of all events in our database. For your GADU example, the team list would be here: https://raw.githubusercontent.com/th...gadu_teams.csv

Complete data cam be found at: https://github.com/the-blue-alliance/tba-data-backup

Edit: We will provide a CSV dump of all teams (name, sponsors, location, etc.) in the near future.
__________________
Eugene Fang
2010 Silicon Valley Regional Dean's List Finalist

Various FLL Teams - Student (2000-2006), Mentor (2007-2010)
FRC Team 604 - Student (2007-2010), Mentor/Remote Advisor (2011-2015)
FRC Team 1323 - Mentor/Remote Advisor (2011-2014)

The Blue Alliance | TBA GameDay | TBA Android App

Last edited by Eugene Fang : 06-05-2014 at 20:17.
Reply With Quote