The Quick Checker is a tool to help you organize your data from spreadsheets into a format ideal for importing into your database and then validate it before importing it into the database.
The Quick Checker module is an important part of the overall EDD workflow, which includes four simple steps:
•Create a new Electronic Data Deliverable (EDD) template using the EDD Template Designer
•Open the EDD template and the source data file within the Quick Checker
•Use the Quick Checker to validate your data against the EDD template and generate a *.zip_hga import file
•Import the *.zip_hga directly into Hydro GeoAnalyst; data mapping and validation has already been completed by the Quick Checker
The Quick Checker can launch as a module from the main toolbar by selecting the button on the main Hydro GeoAnalyst toolbar.
You can install the Quick Checker as a stand alone application for use on computers that do not have Hydro GeoAnalyst installed or licensed, including external project stakeholders such as subcontractors, analytical labs, or support teams. The standalone installation can be downloaded from the Waterloo Hydrogeologic website at https://www.waterloohydrogeologic.com/support/getting-started/ and finding the Hydro GeoAnalyst Quick Checker link:
The standalone version allows project partners (i.e. field personnel, analytical laboratories, and subcontractors) to use the Quick Checker without requiring a full license of Hydro GeoAnalyst. This allows them to provide you with a single data file (i.e. the *.zip_hga import file) which is pre-validated and pre-mapped, making it extremely simple for Hydro GeoAnalyst database managers to import that data.
When the Quick Checker module is first launched, the window below will open:
You can select the new button to create a new quick checker file or open an existing one by selecting the button and browsing to your saved *.qck file.
The Quick Checker method is based on the following components:
•An EDD template file (*.tmpl), which contains data validation criteria
•A Microsoft Excel data file (*.xls, *.xlsx), which contains the data to be imported
•A Quick Checker file (*.qck), which represents the combination of the EDD template and Excel data files (i.e. intermediate file type, after import but before validation)
•A validated Quick Checker import file (*.zip_hga), which can be imported directly into HGA
When creating a new file you will be prompted to select the EDD template file you wish to use and then you are given the option to either enter data manually or import data from a selected excel file.
When choosing to import data from an excel file you will need to map your spreadsheet to the fields in the EDD similar to the way you map in the General import routine. If your spreadsheet does not contain one of the fields you have the option to Add empty column so you can manually enter this data for validation.
This quickly brings your data into the Quick Checker for validation. You should see a data tab associated with data table that was included in the EDD template file. You still have the option to add or edit data after importing the data in. This can be done manually by simply selecting the desired data field and typing the required values. If the EDD template includes a 'pick list' for any particular field then the pick list will be displayed when entering values into that field (e.g. see the 'Color' field in the image below). It's also possible to manually add or remove rows from the Quick Checker using the 'Add New Row' () and 'Delete Selected Row(s)' () buttons.
In the following example you can see there are some problems with the data. The tab where errors occur are flagged (red) and the errors are displayed on the right hand side Error section. If you double click on an error it will take you to the row containing the error so you can correct it. Once all errors are corrected the flag will disappear, and the data will then be ready for validation.
Under the Quick Checker toolbar you will be able to save the existing Quick Checker file (*.qck) for future use by clicking the Save button (). If you have additional Excel spreadsheets with further data to be imported you can click the 'Import MS Excel File' button (). This allows you to incorporate data from multiple spreadsheets into the Quick Checker file. It's also possible to export the data contained within the Quick Checker at anytime by clicking 'Tools' > 'Export to Excel..' from the main toolbar. This will open a Windows Explorer window, allowing you to select a location and file name for the exported data.
It's also possible to perform data corrections using the 'Find and Replace' tool, which can be accessed by clicking 'Tools' > 'Find and Replace...' from the main toolbar. This will open the 'Find and Replace' window, as shown below.
Finally, it's possible to clear all the data currently loaded into the Quick Checker using the 'Clear Data' tool the main toolbar. Selecting the 'Clear Data' tool will open a warning message, asking if you would really like to clean the grid data. Selecting Yes will clear all data from the Quick Checker.
Once all of the required data has been loaded, and all data errors have been resolved, you can then click the 'Validate and Submit' button (). You will then be prompted to save your file as a *.zip_hga file which can be easily imported through the Import Data module. See the EDD Import section for more information about importing the validated data file.