Edit Sample Data Grid

Sample data grid view

After starting a database query for descriptions select Grid → Sample data grid view … from the menu. The query result list is passed to the description grid view form and a window as shown below opens. In the first line the database name is displayed. If you move the mouse cursor over the database name, a tooltip shows the actual connection paramter.

img/DD_Description_Main

The table in the lower parThe table in the lower part of the window shows the sampling unit IDs in the first column and the sample data in the other columns. Each sample column holds the data of a certain descriptor. The upper part of the window shows the selection parameters that are used for building the sampling unit table. You may change the table colors by clicking the button . A form as shown below will be opened. 

Click on buttons categorical, quanitative, text or sequence to select the corresponding table colors. By clicking the Reset button below the color, the corresponding default value will be selected. After changing the table colors by a click on the OK button, you must re-draw the table.

 

Selection parameters

In the upper left part of the parameters for the samping unit table can be adjusted. If in the query list passed to the form descriptions of different projects are present, the displayed project can be selected with the Project drop-down box. The entries in the drow-down list include the project name, followed by the number of descriptions for that project in brackets and an asterisk (*) if the user has only read access for that project.

After selecing a project in section Descriptions and sampling events (right upper part of the window) the descriptions and their sampling events are listed. Here you may select the descriptions and sampling events that shall be used for building the sampling unit table. The buttons all, none and swap can be used to change the selection of all tree elements. By pressing the button the tree view may be expanded to display the contained sampling events, by pressing the button only the descriptions will be shown. In the bottom of the section the currently selected number of sampling events and sampling units is displayed.

When you click on a single sampling event and more than one description is in the list, the button appears in the tool strip. By clicking this button you can open a description selection window and thus shift the sampling event to a different parent description. 

The Descriptor tree drop-down box restricts the descriptor columns to the descriptors contained in the selected tree. Furthermore the tree hierarchy is included in the descriptor names if a structured descriptor tree is selected (see images below).

  

The values From descriptor and to descriptor limit the range of descriptor sequence numbers that is included in the discription tabe. Be aware that this restiction is additionally effective to a selected desriptor tree! If you want to de-activate this restriction, select “from” value 0 “to” value 999999 by a double-click on the labels From descriptor rsp. to descriptor. The limitation of the number of descriptor columns makes speeds up the description table generation, especally if many descriptor (e.g. some hundrets) are present.

Finally click the button Display sampling units table to build a new sampling unit table according to your settings. During output of the sampling unit table the icon of the button changes to  and you may abort processing by clicking the button.

 

Continue with:

Jul 8, 2025

Subsections of Edit Sample Data Grid

Edit Sample Grid

Data editing

The first column of the sampling unit table shows the sampling unit IDs titles, which are fixed. I.e. if you scroll the sample data to the right, the IDs are still visible at the left. The other columns show the sample data, where the descriptor type is indicated by the background colour: categorical, quantitative, text or sequence. The column titles include the descriptor name, the mesurement unit in square bracket for quantitative descriptors and the descriptor’s sequence number (see image below).

When a sample cell in the sampling unit table is selected, the field Sampl. event: shows the sampling event titles, field Description: shows the description title and field Descriptor: shows the symbols according the descriptor type ( for categorical, for quantitative, for text and for sequence) and the descriptor title. If for a descriptor resources are available, this fact is indicated by a coloured symbol background. You may view them by a double-click on the descriptor title. If for a description resources are available, the symbol is displayed before the title. Double click in that symbol to view the resources.

For the selected cell the sample data may be edited as described in section Editing the description - Sample data tab of this manual. For modified sample cells the text colour changes to blue and the sample unit IDs will be shown with yellow background in the table.

 

Changing the sampling event

To shift samling units to a different sampling event, select the whole data rows by clicking in the area left from the “Sampling unit ID” column. In the tool strip the set event button appears. After clicking the button a window for selecting the new parent sampling event will be opened (see image below).

 

Copy sampling units

To copy one or more sampling units select the whole data rows by clicking in the area left from the “Sampling unit ID” column. In the tool strip the copy button appears (see image below).

  

After clicking the button the copied line are inserte at the end of the tabel (see image below). 

  

 

Delete sampling units

To delete one or more sampling units select the whole data rows by clicking in the area left from the “Sampling unit ID” column. In the tool strip the copy button appears.

 

New sampling unit

To enter a new sampling, click on button and a new row will be appended. After clicking the button a window for selecting the sampling event will be opened.

  

 

Continue with:

Jul 8, 2025

Edit Sample Data Grid

Save or discard changes

When you click in button “OK” the sample data grig view is closed and all changes are automatically saved in the database. If you did some changes and want to save them without leaving the form, simply click on (see image below). If you close the window, e.g. by clicking the “Cancel” button, and still have unsaved changes, you will be asked to save or discard the changes.

img/DD_Description_Main

Undo all changes

You may discard all unsaved changes without leaving the form by clicking the undo button and the data will be reloaded form the database (see image below).