View Single Post
  #1   Spotlight this post!  
Unread 04-03-2008, 23:20
Larry Lewis's Avatar
Larry Lewis Larry Lewis is offline
The Spiky Hair Guy
FRC #1511 (Rolling Thunder)
Team Role: Leadership
 
Join Date: Apr 2005
Rookie Year: 2005
Location: Rochester, New York
Posts: 109
Larry Lewis is a name known to allLarry Lewis is a name known to allLarry Lewis is a name known to allLarry Lewis is a name known to allLarry Lewis is a name known to allLarry Lewis is a name known to all
Re: 2008 Team 1511 Scouting Database

It seems like there are some questions with the installation or configuration of the database. Make sure you read through the read me file located in the following location if you use the default installation path.
C:\Program Files\Team 1511 Scouting Database\data\read me.doc
This may help a little bit with the setup of the program.
Ok so here are some tips for installing.
You NEED to have Microsoft Excel installed on the computer you are running the database on. The database does uses Excel to build the datasheet where all the information is contained.
When you first run the program you will notice that only the configuration menu button is shown. I did this to ensure that the database is configured correctly before you start to read or write data. This was my way to allow users to select the path of an existing spreadsheet that they want to use instead of making the file mandatory in a set location. That being said make sure that you click the Change Filepath of Database button and browse to the spreadsheet you want to use. Once you have selected this sheet the program will save your settings and you will no longer need to link to that sheet. I hope this helps with some of the database file configuration issues.

Networking
Yes you can network together multiple computers and have it write to one database file. This is the way that we currently do our scouting. We hook up 7 computers to a router or hub which is the backbone of our network. Really any TCP/IP based network will work. Next is to designate a host computer. I usually pick the fastest one to do this since it has to receive all the information. On that host computer create the spreadsheet you want to use as your database file. Put it in a shared directory that allows access to read and write to that file. On the remaining 6 computers map a drive to the computer on the network to that folder. The next and final step is to go into your configuration menu and select the mapped drive and navigate to the spreadsheet. That should do it. I know it sounds like alot but it is really not that bad once you get it setup.
Once warning I have is to try to not all write to the database at the same time. The program will error saying it cannot write to the database. This is due to the file being locked up. It is not a big deal since it will just go back to the main submission screen and you can try again.

I hope that this helps out anyone that is having any problems getting things installed or configured. If there are any further questions let me know. Due to the recent increase of interest I will try to make it on more. Stay tuned for the next release! Featuring placement of ball on overpass! Thanks!

Also thanks to Kim for filling in for me.