REVIEW SAVED DATA:
This form gives a viewpoint into the saved database. All data can be reviewed and edited to correct or delete mis-keyed information.
CAUTION: Any alterations could effect the reliability of the reports and therefore adjustments need to be in the identical format as previous entries.
The form represents a spread sheet in format. Sorting of columns can be effected by using the mouse and clicking on the column headers for an ascending sort or holding down the Ctrl key while clicking for a descending sort.
Deletion of a record is obtained by clicking any where in the row and then highlighting the whole row by clicking on the row indicator at the left hand side of the row. Once the row is highlighted press the keyboard 'Del' key and answer the message to confirm.
Records can be added by highlighting the row marked with a star however this is not recommended method for data entry.
Changes to individual boxes can be done by highlighting the box and editing. On pressing the close button you will be questioned on committing changes to the data. Answer yes or no as appropriate.
Filter button allows selection of defined data.
Filter raw data
The buttons on the left select the table to search in. The criteria drop down box provides a range of common selection functions. The item to filter box allows selection of data to filter from selected table.
By entering successive filtering it is possible to select a narrow range of data.
Pressing the reload button after a filter operation restores the full table.
The Sort button can be used by entering the column name with a + or - proceeding it to return an ascending or descending sort respectively.
This function allows export of data from the 'Data Review' screen. The selection is by date range first selecting the start date and then end date. The CSV file is automatically saved with the date generated as part of the file name in the Analyzer Plus home directory unless changed at the export dialog screen.
The CSV file data can be used to create custom data for other applications or as in the following example: A remote user, perhaps a contractor can now email in there job data (CSV file as attachment) for a selected period to be consolidated and reported into the main Analyzer Plus database. It is important that the remote database generating the CSV data has the same database structure as the master database. A blank master database which the remote users must use should be generated by using the 'File > Create New ' menu item. The database name chosen should reflect the remote user e.g 1usr010506.mdb (remote user 1, date created). At the next screen select 'Yes' to create from existing database. Navigate to your master database location and select the database. Check all four tick boxes - this creates an exact duplicate of all the base data less any saved entries. This database is installed at the remote users site.
If the database at the remote sites needs to be updated as time goes on due to new projects, tasks etc. being added then a new base database must be supplied or the detail so that the database can be manually updated. The remote user exports the entire CSV after determining the date range. This data can then be re-imported into the new database. There is one caveat to this - Any projects that have been deleted from the master database must also be deleted from the remote database before CSV data is exported or re-imported. NB the import will fail if there is not a matching project.