Central Pennsylvania Food Bank – Meeting Notes

Monday May 3, 2004

In the past few weeks our group has run into many problems concerned with the following:

>>>data validations within VB and Access

>>>overall runtime stability of the application

>>>error exception handling of events

>>>providing the sponsor organizaton with all necessary project controls such as the masking .OCX controls

>>>>>>including: MSMASK32.OCX

We met with our sponsor organization today to show them our *near* final iteration of the project and to explain to them many facets of the GUI.

They have expressed to us that they would like to formally receive the project on Wednesday during our meeting with them. The sponsor organization seemed pleased with the project as a whole. The evaluation was filled out by elder Cliff Freshmen for evaluation of our team and project and placed in an envelope.

Monday April 5, 2004

Our group met as a whole to complete the final workings on milestone 4 and increment 1. This involved implementing the GUI and the datatbase
into a fully function condition. Myself (Ryan) and Ed were responsible for the background coding in VB to interact with the DB in access.

We had a little trouble here and there getting VB to interact with the SQL code and then with getting the SQL code to interact with the Access DB.

In the end this was completed through reseaching several different methods for creating and ODBC and ADO open connection with the DB.

Wednesday March 31, 2004

Our group got together to format and code much of the original working prototype of the GUI and the database.

Wednesday March 9, 2004

Josh and myself (Ryan) met today with both Debra Benedict and Cliff Freshmen of CCChurch to discuss valuable additions that could be made to the database and also to show them our preliminary mock-up of the database’s front end GUI.

This was shown to them as our mock up of the Search page:

This was shown to them as our mock up of the Registration page for the new recipients:

Overall the meeting lasted around an hour as we discussed the addition of a “clothing voucher received” table to the DB and it’s implications.

The mock up that we wrote for them was written in VB6, we have decided that we would like to possibly use this as the GUI front end for the simple useable access to the MS Access database. This is because VB6 has call controllers for accessing many of the necessary for this application through use of embedded SQL statements in the VB code.

Wednesday February 25, 2004

Josh, Arch and myself (Ryan) met and went to see the food bank operation in action in downtown Harrisburg. We observed them for about 1.5hrs and then proceeded to ask them questions concerning issues they had with the inclusion of the upcoming database and its implications on their operation.

Arch’s Notes from the visit:

Basic Fields:

- Name

- Age

- Phone #

- St. Address

- City

- PA Zip

- Household

o Up to 17

o 17-59

o 60+

- ID # (Driver’s License)

- Last Visited Visited (boolean)

Suggest possible ID cards

- ID #’s

- Laminated

- Additional Costs

Statistics Reports

Question #1 -> unduplicated

Age Groups based on predetermined distributions

Adults – 2

Children – 1.2

Elderly - .5

After leaving the food bank we proceeded to visit Debra Benedict at the church office to discuss the implications of what we had observed at the food bank and how it had changed/affected our presumptions of the project.

After returning from CCC, we began working on the documentation for Milestone 2 for Thursday.

Monday 23, 2004

Met as a group to discuss our proceeding presentation of our Milestone 1 information. Took less than an hour to pull together the necessities for the presentation.

Thursday February 19, 2004

We met briefly with professor Nejmeh as a whole group to discuss the project and some of the possibilities for expansion on the requirements. Some of the ideas for expansion involved the possibility of adding extra reports to the database and also additional search functionality. In addition to this we discussed the possibility of creating an almost generic database engine using open-source technologies with the capability to be applied to many different applications of food bank databases.

Wednesday February 18, 2004

Josh and I went and spoke with our contact at Christ Community Church, Debra Benedict, to discuss all the elements of the database and attain the information necessary for the completion of Milestone 1. In addition to this we also were able to obtain through her several forms which they would like to have the database fill in on-the-fly.

Josh’s pertinent notes from the meeting:

- contact person : missions@christcc.org

- contact name : Debra Benedict

- church technical support : Mark Crieg