Download Final - Electrical Engineering & Computer Science at CSM

Transcript
3.4.3 Chosen Solution for Using Excel, Access, or MySQL
Omnitech chose to use a MySQL database to store and manage the data, and then use
PHP to display queries to the web. Implementation will require setting up the database
with the appropriate fields and populating the database using links to QB and data
obtained from forms. Before implementation, some design must take place to ensure the
database is set up in the best manner.
4.0 Design of the Solution
4.1 High-level Diagrams of the Solution
4.1.1 Gathering Data
Our solution must gather data from QuickBooks. To accomplish this, our solution will
use an ODBC driver to create a connection between the QuickBooks database and our
system. Users will enter payment terms data and data previously entered into the
intermediate spreadsheets into our solution. Our system will automatically update
QuickBooks with any data it needs (especially terms titles) after each transaction (See
Figure 1).
Figure 1: Users will use our system to enter and store new complex terms titles and trigger dates, and
update data previously entered into the intermediate spreadsheets
Our solution must gather data that users previously entered into their spreadsheets. Our
solution will provide several forms for users to enter their data and send that data to our
database (instead of their spreadsheets). This will be more efficient and easier for users
than maintaining their current spreadsheets. Once the system is set up, we will copy the
data from the users’ spreadsheets to our system and from then on, all users will enter all
their data into the system through forms (See Figure 2).
11