Pulling a List of Teams into Excel

[Eugene Fang]

Originally Posted by Ed Law

I have another spreadsheet that gets the team lists from usfirst website directly and it still works. How do we access through the my.usfirst for team list? I must not have used it that way.

Team list for CASJ here: http://frclinks.com/e/casj

You can't directly navigate to https://my.usfirst.org/myarea/index....014&event=casj due to the reason Pat mentioned above. FRCLinks has a redirect hack that makes it work.

What page do you use to get team lists that's not a my.usfirst page?

[Christopher149]

If you need only current data (and not anything historical):

https://my.usfirst.org/frc/scoring/i...page=eventlist contains and ID_event column, which you can use like https://my.usfirst.org/frc/scoring/i...ID_event=10837 (for Traverse City). Is this good enough?

[ttldomination]

Originally Posted by Eugene Fang

What page do you use to get team lists that's not a my.usfirst page?

Looks like Ed pulls his information from the event pages (www2.usfirst.org) and not from the event listing.

Originally Posted by Christopher149

https://my.usfirst.org/frc/scoring/i...page=eventlist contains and ID_event column, which you can use like https://my.usfirst.org/frc/scoring/i...ID_event=10837 (for Traverse City). Is this good enough?

This actually works pretty well. I'm wondering (a) where do we get event ids and (b) why this data pulling isn't using an HTTP referrer check.

Interesting,
- Sunny G.

[Ed Law]

Originally Posted by Christopher149

If you need only current data (and not anything historical):

https://my.usfirst.org/frc/scoring/i...page=eventlist contains and ID_event column, which you can use like https://my.usfirst.org/frc/scoring/i...ID_event=10837 (for Traverse City). Is this good enough?

This is interesting. It works well.

I was tired last night and got confused. I thought I was pulling team list data from another place. It turns out my other spreadsheet pulls in match schedule and determine the team list that way. It is only useful after match schedule is out and before matches begin.