Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The toolbar contains 6 buttons with the following functionality

Image Modified

Lock: It is possible to lock the tabular config file display. When locked, selecting another location in the locations list, won't change the selected location row in the display.

Image Modified

List all Files: When this button is pressed, the file list will populate all meta data files used in the configuration

Image Modified

Show modifiers: It's possible to show modified values in the tabular config files, these are the location attributes where modifiers have been applied. All values that have been changed by modifiers will get a blue background color. A tooltip will display the unmodified value. 

Image Modified

Show virtual columns:  Location ID and Location Name are based on meta data in the CSV/dbf files. These columns, together with special edit columns can be made visible or hidden in the bottom panel

Image Modified

Copy: Copy the content of selected cells to the clipboard

Image Modified

Export to CSV: The selected meta data file can be saved as CSV file. This is especially relevant when modified values need to be exported to a CSV file.

Sorting

The table with meta data can be sorted by clicking on a column header. Clicking one extra time on the same column header toggles the direction or deselects the sort column header. When multiple column headers have been sorted on, tiny indices indicate which is the order in which the columns are sorted. In the right mouse popup menu the Undo sort option quickly deselects all selected sort columns.

Filtering

Tables can be filtered by double clicking on a cell entry. Only records with exactly the same entry for the selected column will be displayed. The selected entry will be highlighted (blue). Double clicking another entry will expand the filter. To undo the filtering the highlighted column has to be double clicked again. In the right mouse popup menu the Remove all filters option quickly remove the set filters.

Column hiding

In case not all columns should be visible, right clicking on a value will show the pop-up menu with the "Set column visibility" menu item. This allows a user to select or deselect columns that should be visible (at least one column has to remain visible). These settings will be stored in the user settings and will remain available after FEWS was restarted.

...

It is also possible to select a layer attribute on the Map display. This requires the tooltip icon to be enabled. When hovering over the layers on the map or Grid, the layer attributes will be highlighted. When they are highlighted, using a left mouse click to select the map element, this will show the corresponding entry in the Tabular Config Files Display.

Configure Meta Data Column Headers

The column headers of the meta data table use by default the column name in the CSV or DBF file. It is possible to overrule the column headers with configurable names. These names are configured in the LocationSets.xml file. There are two name elements that can be used for this.

  • For standard location elements (like id, name, x, y) use the columnDisplayName element.
  • When the meta data is used as a location attribute, use the name element.


Code Block
languagexml
titleLocationSets.xml with name elements
<csvFile>
	<file>AUS_stations</file>
	<readOnly>true</readOnly>
	<geoDatum>WGS 1984</geoDatum>
	<id columnDisplayName="HyFS Station ID">H%bom_stn_num#6%</id>
	<name columnDisplayName="HyFS Station Name">%bom_stn_name% - H%bom_stn_num#6%</name>
	<x columnDisplayName="Longitude">%long_dec_deg%</x>
	<y columnDisplayName="Latitude">%lat_dec_deg%</y>
	<attribute id="HYFS_STATIONID" name="HyFS Station ID">
		<description>HYFS station location identifier</description>
		<text>H%bom_stn_num#6%</text>
	</attribute>
.....

When using the name element for location attributes, make sure not to use the same attribute name for attributes from the same meta data file, this will throw a Config ERROR when Delft-FEWS starts.

Configure Meta Data Rules

It is possible to configure meta data rules in the LocationSets.xml file. These rules are used to check the meta data on Errors.

One of the rules is included in the attribute element, a format can be added to the <text> element (see below). The example forces the attribute will always contain 6 numbers. When the meta data file contains a value "12345", FEWS will change this to "012345". A leading zero is added to the attribute.

Code Block
languagexml
titleLocationSets.xml with name elements
<attribute id="HYFS_SENSLOCID" name="BoM Sensor Location Id">
	<description>Associated HYFS station location identifier</description>
	<text>%BOM_STATIONID#6%</text>
	<required>true</required>
</attribute>


It is also possible to add an enumeration. The attribute will then be checked on one of the enumeration values. In the Tabular Config Files editor, a drop-down element will be used where the user can select one of the enumerations.

Code Block
languagexml
titleLocationSets.xml with name elements
<attribute id="ACCEPTANCE">
	<description>Only accepted sensors are included in the location set</description>
	<text>%ACCEPTANCE%</text>
	<enumerationValue>ACCEPTED</enumerationValue>
	<enumerationValue>REJECTED</enumerationValue>
	<enumerationValue>DISABLED</enumerationValue>
	<required>true</required>
</attribute>


When an attribute can contain multiple values, a regularExpression can be used. The example below allows for example an attribute value "NSW;VIC". See regular expression function examples on the internet for more examples. 

Code Block
languagexml
titleLocationSets.xml with name elements
<attribute id="REGION" name="Region">
	<description>Regional office(s) responsible for station. Enumeration: WA, NT, SA, QLD, NSW, VIC, TAS. Reflects time zone information</description>
	<text>%REGION%</text>
	<regularExpression>[WA|NT|SA|QLD|NSW|VIC|TAS|;]*</regularExpression>
	<required>true</required>
</attribute>

The Meta Data Rules are used by Delft-FEWS when the meta data configuration is loaded, Errors will be logged when meta data is not according to the configured rules. In The Tabular Config File Display, the rules are used to find and flag errors. 

Edit Meta Data

Since Delft-FEWS version 2024.01 there is functionality added to edit meta data from CSV meta data files. To activate this functionality a TabularConfigFilesDisplay.xml configuration file is needed in the DisplayConfigFiles config folder.

An example of such a file is shown below.

Code Block
languagexml
titleTabularConfigFilesDisplay.xml
<?xml version="1.0" encoding="UTF-8"?>
<tabularConfigFilesDisplay xmlns="http://www.wldelft.nl/fews" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.wldelft.nl/fews http://fews.wldelft.nl/schemas/version1.0/tabularConfigFilesDisplay.xsd">
	<editPermission>Configuration</editPermission>
</tabularConfigFilesDisplay>

There is only one element required in this configuration file, this is the permission for the user group that is allowed to edit meta data files. When this display file is added, the toolbar of the Tabular Config Files display is extended with meta data edit functionality.

 Image Added

The toolbar contains XX additional buttons with the following functionality

Image Added

Only Show Errors: When Errors are found in the meta data, enabling this button will only show the meta data files and rows that have errors. Very much linked to the configurable meta data rules.

Image Added

List all Files: When this button is pressed, the file list will populate all meta data files used in the configuration

Image Added

Show modifiers: It's possible to show modified values in the tabular config files, these are the location attributes where modifiers have been applied. All values that have been changed by modifiers will get a blue background color. A tooltip will display the unmodified value. 

Image Added

Show virtual columns:  Location ID and Location Name are based on meta data in the CSV/dbf files. These columns, together with special edit columns can be made visible or hidden in the bottom panel

Image Added

Copy: Copy the content of selected cells to the clipboard

Image Added

Export to CSV: The selected meta data file can be saved as CSV file. This is especially relevant when modified values need to be exported to a CSV file.



Add Custom Activities