List of Test Holes
The Test Holes page shows all the test holes of the Active Project (see how to change the Active Project).
To access this page:
Site Investigation Progress
RSLog allows you to track project progress at any point of time. Because of the centralized database design of RSLog, changes made by any user is immediately made available to other users. This user could be working on field data collection using OnSite app, or accessing RSLog from the office, home or anywhere else.
The status of a test hole indicates at which phase of drilling / excavating it is. A progress bar at the top of the Test Holes page shows the site investigation progress:
Each color indicates specific progress status. You can customize the list of progress status levels and their associated colors from Settings page > Data Entry tab > Status Options tab.
List View
The list of all test holes of the Active Project is shown in a table where you can add, edit, or delete a test hole (see working with tables). This list only shows the major properties of test holes; to see the entire data for a test hole click on Edit button on that test hole:
Map View
In order to switch between the list view and map view, use the toggle-bar at the top-right of the table (next to the search box). If the test holes are not shown on the map, please check the following:
- Project CRS: Make sure the selected project coordinate system is correct (see project data entry page),
- Test Holes Coordinates: Check the coordinates entered for test holes on data entry page > General tab > Coordinates tab.
Duplicating a Test Hole
In order to duplicate a test hole click the Copy button at the right end of that row. You will be prompted to enter the number of copies you wish to make. Click OK button to proceed. Please note depending on the number of copies selected, this operation make take from a few seconds to several minutes.
Importing From a CSV File
This allows you to import the list of test holes with their top-level data (i.e. data in the test hole data entry page > General tab) from a CSV file.
Creating the CSV File
Start by creating an Excel spreadsheet containing basic data for each test hole: name, depth, type, coordinates, logger, reviewer, contractor, equipment etc. Please make sure only one header row is present in your Excel file. Save this file in CSV format and try importing it to RSLog.
Importing the CSV File
To start importing the list of boreholes:
- Switch to the List view (table),
- Click on the dropdown arrow on + New button, and select Import CSV File from the menu,
- Select the CSV file and apply filtering and column mapping as required, then click Import button (see this article for CSV import help).
Test Hole Data Entry
Please see this page for a detailed discussion of data entry for a test hole.