Working with Tables
Tables are used in various pages of RSLog for presenting and editing data. For example, the following screenshot shows a table with the list of all samples of a test hole:
Each row in the table stores data for one 'record' (in this example, a sample). Please note that tables are designed to show the most important columns and not all columns. In order to access all data entry fields for a record:
- Hover over the record to see the 'Row' Buttons at the right end of the row, then click the Edit button.
- This will open a new dialog box for editing the details of that record.
Style of Tables
Tables can be shown in either Compact view or Spreadsheet view. For more details, please see the Data Entry topic..
Features
The toolbar at the top of the table provides access to various features:
Editing a Record
- Add a Record - click the + New button to add a new record. This will open a new dialog-box to allow data entry.
- Edit a Record - you can edit a record by:
- Clicking on a cell to edit it.
- Hovering over that record and clicking the Edit button that appears at the right end of the row.
- Delete a Record - to delete a record:
- Select the checkbox on the left side of the desired rows, and click the Delete button from the table toolbar.
- Hover over the record and click the Delete button that appears at the right end of the row.
- Duplicate a Record - some tables allow you to copy (duplicate) a record (e.g. boreholes and projects tables). To do so, move the hover the record and click the Copy/Duplicate button at the right end of the record.
- Number of Records - a label on the left side of the search box shows the number of records in that table.
Import / Export
- Import from CSV - use this feature to import CSV data it into the table (see more details). In order to start importing a CSV file, click the dropdown next to the + New button to open the menu, then select Import CSV File menu.
- Export to CSV - from the table toolbar click the Export button and select Export to CSV.
- Export to Excel - from the table toolbar click the Export button and select Export to Excel.
- Export to PDF - from the table toolbar click the Export button and select Export to PDF.
More Options
- Copy to Clipboard - this will copy the table to the clipboard. To use this feature click the 'More' button
from the toolbar and select Copy Table from the menu. For tables having more than one page of data, only the first page of the table will be copied (note you can show more data on a page by using the pagination feature). - Print the Table - this will print the entire table to your default printer. To use this feature click the 'More' button from the toolbar and select Print Table from the menu.
- Clearing Table Data - this will delete all records of the table (cannot be undone!). To use this feature click the 'More' button from the toolbar and select Clear Table Data from the menu.
Filtering Data
In order to search for specific record(s), enter your search criteria (e.g., borehole name, project number etc.) in the search box located on the right end of the table toolbar. This will only show the records that match the search criteria.
Pagination
Pagination is a simple navigation method that splits a large number of records in a table into 'pages'. RSLog automatically applies pagination to all tables, therefore, if you don't see the record you are looking for, simply go to the bottom of the table and change the number of records shown on each page, or navigate to the next page(s).
