Geopsy: Table

A Table is a Signal viewer representing the metadata of a set or a subset of signals. It can be created using the View menu and then drag and drop the set of signals of interest in table. Drag and drop signals directly on the table icon in the toolbar produces the same.

The various actions that can be performed with a subset of signals in a table are described in Signal viewer entry.

Basically, a table allows you to view and to edit the header information about signals. Each row represents a signal and each column is an information field. The order and the list of displayed fields is specified by the table preferences for all newly created table. You can also change the displayed information for the active table only by selecting item set data fields from View menu. Columns and rows can be resized (press mouse at the limit between two columns or cells). However, automatic resizing is usually correct.

Signal selection

Signals are selected with the mouse left button. If the SHIFT key is also pressed the selection is extended from the current row to the selected row. If the CTRL key is pressed at the same time as the mouse left button, the selected row is added to the selection and become the current row. The current row contains the active cell.

Pressing the mouse left button on any selected row and moving the pointer initialise the signal drag and drop mechanism marked by a modified mouse cursor. A circle crossed by a line means that the signals cannot be dropped at this place. When it changes to a plus sign, the mouse left button can be released to drop the signals to the destination (an existing viewer or the icons of viewers: , , in the toolbar).

Cell editing

To edit the contents of a cell, you must first unlock cell editing. Click on menu item "Edit/Lock table edition" to uncheck the option. In this mode, you can select individual cells and change their content. This mode is not suitable to drag and drop signals. Return to the original lock mode to move signals to other viewers.

You can edit any cells, but some of them are linked to read-only fields (e.g. NSamples, the number of samples).

To edit many cells with a few operation you can also you dialog box proposed by menu item "Edit/Set headers".

Export

Copy and paste action are not possible like in common tabular softwares. However, it is possible to export the information contained in a table to a text file (column separated by TABs) which can be in turn loaded in any usual tabular software. The file can be edited and imported in the table to apply the changes. Read-only fields are not affected by imports.

To export a table, select "Export" from menu "File". A combo box lets you select the export format. Select "Table" format. Enter the file name to export. A default extension (".txt") is provided for compatibility with usual tabular software. Comment are marked with '#' at the beginning of lines. Not all fields attached to a signal are exported but only the fields displayed in the active table. The list of fields is given in the first uncommented line. The field names are the standard ones given in the database description.

Example of a file exported from a table

1. This file contains all the variables that were listed in Geopsy's Table
2. You can edit this file as you want.
3. All columns must be separated by only one tabulation.
4. Lines starting with '#' are always ignored when importing.
5. The first line starting without '#' must contains the name of each variable.

ID Name Component TimeReference T0 EndTime SampFreq DeltaT NSamples Duration ReceiverX ReceiverY SourceX SourceY 7 Vertical 01/01/2003 00:00:00 0 405.3875 114.285714285714 0.00875 46330 405.3875 -48 9 0 0 8 North 01/01/2003 00:00:00 0 405.3875 114.285714285714 0.00875 46330 405.3875 -48 9 0 0 9 East 01/01/2003 00:00:00 0 405.3875 114.285714285714 0.00875 46330 405.3875 -48 9 0 0 13 Vertical 01/01/2003 00:00:00 0 405.3875 114.285714285714 0.00875 46330 405.3875 -31 39 0 0 Import

Select "Import table" from menu "File". The first uncommented line must contains the list of fields to modify separated by TABs (see Export). The first signal of the active table is modified according to the second uncommented line of the imported file. The second signal with the third uncommented line and so on until reaching either the last signal or the last line of the file.

To avoid errors when importing files, it is better to leave the exported table active while modifying the exported file and to re-import the modified file with the same active table, to be sure that the order and the number of signals is exactly the same. In this case, never remove lines from the exported file. To limit the number of potential errors, you can remove all columns except the ones you really want to change. This method for modifying the fields of a table must be used with care and should be used only when there is no other choice. Prefer menu item "Edit/Set headers".