Working with Tables
Tables are used in various pages of RSLog for presenting and editing data. For example the following shows a table with a list of all comments in a test hole:
Each row in the table stores data for one 'record' (in this example, a depth-related comment). Please note that a table typically shows the most important columns; In order to access all data entry fields for a record: hover on the record and click on Edit button at the right end of the row. This will open a new dialog box allowing editing the entire data.
Basic Features
The toolbar at the top of the table provides access to various features:
- Add a Record: click on the Add + button to add a new record. This will open a new dialog-box to allow data entry.
- Import from CSV: if you have your data in CSV format, you can use this feature to import it into the table (see more details). This feature is not available for all tables. In order to start importing a CSV file, open the dropdown menu of the New button and click on Import CSV File menu.
- Edit a Record: you can edit a record by moving the mouse over that record and clicking on the Edit button that appears at the right end of the row. In some tables you can click on a cell and simply edit the data (e.g., Depth cell in the screenshot above).
- Delete a Record: to delete a record, select the checkbox for that row and click on the Delete button from the toolbar. Alternatively, move the mouse over the record and click on 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 mouse over the record and click on the Copy/Duplicate button at the right end of the record.
- Export to CSV: click on the Export button and select Export to CSV. Use this button to export the data to CSV format.
- Export to Excel: click on the Export button and select Export to Excel. Use this button to export the data to Excel format.
- Export to PDF: click on the Export button and select Export to PDF. Use this button to export the data to PDF format.
- Copy to Clipboard: this will copy the table to the clipboard. To use this feature click on the More Options 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 pagination feature).
- Print the Table: this will print the entire table to your default printer. To use this feature click on the More Options button from the toolbar and select Print Table from the menu.
- Clearing the Table: this will delete all records of the table (cannot be undone!). To use this feature click on the More Options button from the toolbar and select Clear Table from the menu.
- Number of Records: a label on the left side of the search box shows the number of records in that table.
Filtering Data
In order to search for specific record(s), enter your search criteria (e.g., borehole name, project number etc.) in the textbox located on the right side of the 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 a 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). Alternatively, you can search for that record using the filtering feature (see above).