Re: FIRST contact database
 

It might be cool to tie this into FIRST Blogs such that searching for a team would also reveal who on (or previously on) that team has a blog (and where said blog is). At the moment we haven't been tracking team number information there (but I could get it, I'm sure); and could perhaps provide you with some form of XML feed, web service API, or similar if you're interested.

P.S.

Yes, that is a really bad sentence; you're referring to how there's no left margin/padding/what not in FF causing the T as in "The" to be cut off?

Re: FIRST contact database
 

That would be cool. If you obtain the team numbers and setup an xml feed, I'd definetely add it. Maybe I could also look into providing links to the profile of team members on CD. Probably have a cron job copy team member data into database at 3am when there isn't much activity.

It cuts off the T? :eek: Which browser and OS are you on? Could I get a screenshot?

I was actually talking about the black (don't know how that happens; there's no black in the image) quarter circles on the right side.

Re: FIRST contact database
 

If you were to (with Brandon Martus' permission of course) get the team member data into your database (and keep it regularly up to date; I'd imagine that data updated weekly would be just fine for both your site and my intended use) I would be most interested in obtaining an XML feed of some sort of that, too (I figure it could be a very effective way of detecting new/existing blogs since that's likely to be what at least some people set their profile's website to, or mention in their sig, or some other place in their profile).

As for the browser thing; FF on Mac (I don't get black circles).

Re: FIRST contact database
 

Cool site, nice job Ryan!

I must have missed this thread when it went through before, but I added our team, and you are up to 31 teams now!

I was wondering if there is an easy way to download the information, or if you have thought of it, so that we dont have to individually click on each team to get the info they typed in. Ideally I think it would be nice to have it output an excel (or even .csv) file that has "Team #" and "main email", so that it would be easy to develop contact lists. I dont know how your site is set up, but it would be neat to do that if you have time.

Re: FIRST contact database
 

Really awesome job. This will certainly useful. I should be getting official heatwave contact info up on there shortly (within the next three weeks), pending approval from our team mentor after we return to school.

Hopefully most teams will see this and put their info up as well to make it effective.

Re: FIRST contact database
 

Cool idea. One suggestion:

Tell people the cutoff limit for the contact info, or stop the text-box from accepting too much text. I typed the following for team 948:
But it gave me:

Re: FIRST contact database
 

Hm... I don't remember building a limit in. :) Maybe a wrong MySQL type.

I'll check on it. Thanks for the heads up. I'll add the extra info once I figure out the problem.

--EDIT--
I fixed it and added a counter to show your remaining characters.

For the interested, the problem was that the MySQL type is actually essentially the same as varchar(255). I bumped it up to text, so you can now store up to 65,536 characters.

Re: FIRST contact database
 

Now that the season has started and this place will be busy, it would be great if we could get as many teams as possible in the FIRST contact database.

That's all I'll say. See rest of this thread for more info.

(P.S. Sorry that it was down yesterday, if anyone tried it. The laptop it runs on was at kickoff. ;))

Re: FIRST contact database
 

The FIRST Contact Database is up again! Due to a move, I was unable to host it any more, but Tim Ginn has graciously offered to host in on the OpenFIRST servers.

Please visit at its new home at http://contacts.openfirst.org and add to its usefullness. :)