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