View Single Post
  #1   Spotlight this post!  
Unread 14-02-2003, 21:33
Jack's Avatar
Jack Jack is offline
FIRST Scouting Network
AKA: Andrew Schenk
FRC #0201 (The FEDS)
Team Role: Alumni
 
Join Date: Feb 2002
Rookie Year: 2002
Location: Rochester Hills
Posts: 643
Jack is a jewel in the roughJack is a jewel in the roughJack is a jewel in the rough
Send a message via AIM to Jack
Team/Regional/Champ List

Well, this is more for scouting (or something close to that), but b/c not a lot of ppl check the scouting forum (which, btw, everone should )

Anyway, back in the begining of Jan, I parsed all the lists of the regionals, and uploaded them. Well.. those have changed (not a lot, but still they've changed) Any way, I also included the champ. event list.

I zipped the two CSV files. The big on is the master data list. It has the team number, team name, team location, and which event the record is for. (and... I parsed out the & to & this time ) The second one goes with each event id, and gives the event id, the event name, and location. Just download it, and you'll see.

If anyone would like an SQL file for easy db insertion rather than a CSV file, pm me.

Jack

PS: For those who don't know a csv file is a comma seperated values file. You can open it either in notepad(bad), or MS Excel (better)
Attached Files
File Type: zip events_list.zip (41.9 KB, 57 views)
__________________
Team 201 - 2003 Great Lakes Semifinalists & 2003 Archimedes Division Finalists :|: Webmaster of www.feds201.com -> FBI Scouting
Winner of The 2003 ChiefDelphi Web Award for: User That Started The Most Non Chit Chat Threads
Winner of: 2003 FIRST Ventures with 5451.68 End Points

All about me: http://knehcsa.vze.com
**Check out the New FIRST Scouting Network**