View Full Version : MS Access for scouting???
Quentinfool
11-01-2003, 21:25
Last year for scouting we used excel and that worked. I wanted to know if anyone tried using access and if that worked or not. it is microsofts default database program so it makes sense to use it for scouting. Let me know if u tried and if it works.
:confused:
Originally posted by Quentinfool
Last year for scouting we used excel and that worked. I wanted to know if anyone tried using access and if that worked or not. it is microsofts default database program so it makes sense to use it for scouting. Let me know if u tried and if it works.
:confused:
We used access last year. I will once again be making an access xp db that will also be complyent with uploading to www.feds201.com :) - Expect it to be ready sometime in late Feb. I'll upload it here on CD for all to use. :)
Jeff Waegelin
11-01-2003, 21:43
We used Access last year. It was a rather old version (95), but it was what we had, and it worked. All our alliance partners were impressed with the quality of our database. It wasn't that complex, but it worked well. Jack can elaborate if you have any questions (he wrote it), but it's pretty self-explanatory.
Jeremy_Mc
11-01-2003, 22:34
file maker would be ideal for scouting (you get it free this year in the kit). it's a a VERY easy to use database program that can export to numerous formats and it also runs on mac.
Just a suggestion tho :)
*jeremy
Quentinfool
12-01-2003, 14:19
file maker eh? hmmm ill have to take a look at it. is it wth the autodesk software?
Yan Wang
12-01-2003, 14:22
I emailed quentin and told him that I'd be posting up our Access database on Delphi's white pages sometime soon... not really necessary till competition starts. We used it in Canada; had pics of each robot, serach for teams, notes on teams, rankings, etc and it ended up being about 42mb. Obviously, a blank version shouldn't be more than a mb.
Stephen Kowski
12-01-2003, 15:09
We used Access 2...or was it 3 years ago...I don't remember but neways it works fine, but the issue with us is that we weren't able to make any ability for synchronization so it ended up being one person taking information off of a piece of paper and putting it into the Access database one at a time....ugh how tedious. Once we figured out to put things on handhelds and make many people able to gather information at the same time we were in business. :D So I guess my point is if you can't get multiple people putting information into the database at the same time get ready for some LONG nights at the nationals. Regionals weren't too bad because there are normally only 40 or so teams there, but wow were the nationals hard to deal with.
Bduggan04
12-01-2003, 15:16
Originally posted by Quentinfool
file maker eh? hmmm ill have to take a look at it. is it wth the autodesk software?
No, it shipped with the big blue book form MSC, the banner sensors, and the .NET software.
Bduggan04
12-01-2003, 15:18
Originally posted by Stephen Kowski
We used Access 2...or was it 3 years ago...I don't remember but neways it works fine, but the issue with us is that we weren't able to make any ability for synchronization so it ended up being one person taking information off of a piece of paper and putting it into the Access database one at a time....ugh how tedious. Once we figured out to put things on handhelds and make many people able to gather information at the same time we were in business. :D So I guess my point is if you can't get multiple people putting information into the database at the same time get ready for some LONG nights at the nationals. Regionals weren't too bad because there are normally only 40 or so teams there, but wow were the nationals hard to deal with.
Actually, with access you can use linked spreadsheets for data. If the spreadsheet is available to everyone through a network, everyone can add to it.
Stephen Kowski
12-01-2003, 15:23
thus my point of what to watch out for.
We had a filemaker database shared over a network last year, it worked great. It's much easier to use and much more intuitive than Access.
Curtis Williams
12-01-2003, 19:26
We have used access in the past and also had the problem with one person typing from tons of papers. However, It did work and took less than an hour to set up.
As for this year, we are toying with making a .net solution that uses SQL Server (MSDE, comes with vs.net) to store all the data. A windows application or maybe a web application for entry/query and a web service for sharing data with anyone wants it.
This may seem overkill but half of my day is spent in programming class.
Brandon Martus
12-01-2003, 21:46
Originally posted by Curtis Williams
... for sharing data with anyone wants it.
Check out the thread at the top of the scouting forum (http://www.chiefdelphi.com/forums/forumdisplay.php?s=&forumid=36) about a standard. It'll be easier to share info if more people use the standard. :)
Quentinfool
14-01-2003, 14:05
Filemake ris awesome... is there a way to share a database between 4 computers without needing to get licenses? I want a way to set it up so like one computer hosts/posts and other 3 modify data oin the databse too. anyone?
Originally posted by monsieurcoffee
I emailed quentin and told him that I'd be posting up our Access database on Delphi's white pages sometime soon... not really necessary till competition starts. We used it in Canada; had pics of each robot, serach for teams, notes on teams, rankings, etc and it ended up being about 42mb. Obviously, a blank version shouldn't be more than a mb.
I guess there were a lot of pictures.... Keep in mind the MS Access feature: Tools > Database Utilities > Compact and Repair database. This will purge much of the (often useless) hidden data kept around by access.
KA-108 :cool:
www.soap108.com
Originally posted by Quentinfool
Filemake ris awesome...
We thought that at first too (1999-2000). It was so easy to create, layout, and share. But it is entirely cumbersome to create and use relationships. Programming anything complex is a nightmare. I can only guess the extreme headaches FIRST is going through writing the scoring system in FMP!
FM Pro 6 has one, repeat one, useful feature: Script step "Execute SQL". With plug-ins this was possible on earlier versions of FMP. On the side we've developed a Front-end GUI for quickly editing fields in FMPro. But in the background there's a SQL Server managing the data.
If you have any Q's drop SOAP a line.
KA-108 :cool:
www.soap108.com
Tom Schindler
12-02-2003, 02:35
Originally posted by soap108
I guess there were a lot of pictures.... Keep in mind the MS Access feature: Tools > Database Utilities > Compact and Repair database. This will purge much of the (often useless) hidden data kept around by access.
KA-108 :cool:
www.soap108.com
Because of hte way access stores the image files, you will not see much of an improvement by compacting and repairing the databse. What i usually do is store hyperlinks to files on my hard drive. This keeps the "net" size of the database down. If i store a 100k jpg in the database, it increases the size of the db by about a meg.... go figure :)
Tom
Hey Tom!
Maybe I have an old email, but I was trying to see if you would be able to digitize any of the regionals you attend this year...
Thanks,
KA-108
Dan Richardson
12-02-2003, 21:01
We are using filemaker this year ( #710 ) and we havn't had a problem, we've done some pretty intense stuff with it, including Real Time Game stats )
Its a little Tedious but we've worked on it in tandom and got It down pat in a couple hours work ( does help tho when you have a mentor who's been using it since the late 80's )
We'll have all our scouting on palms and Game scouting on a laptop in the arena for keeping stats on the teams which are playing
this will equate to real quanatative formulas into what we hope will become our BCS poll Ranking system ( based on robots efficiency wrather than the first point system )
BCS = Bot Categorization System
The info will be ready available for all at our Regionals ( and if we make it to our national even )
Quentinfool
14-02-2003, 14:08
well we make our own scoring system tailored to each new game. rating based on match score is kinda silly i think. everyone should design a scoring system that will rank high the type of robot they want as alliance partners
vBulletin® v3.6.4, Copyright ©2000-2017, Jelsoft Enterprises Ltd.