You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 22 Next »

Overview

The Tabular Config Files Display can show a list of configuration files (csv and dbf) that are used to configure the selected locations, parameters and qualifiers. The configuration files can be displayed using a table viewer with sorting, filtering and column hiding functionality. This display is also accessible using the F12 debug menu. There have been several improvements to this display since the first introduction in 2015:

  • Since 2019.02 the display is also connected to the forecast tree.
  • Since 2020.02 the Tabular Config Files Display is connected to shapefiles that are displayed in the Map Display or the Spatial Display.
  • Since 2024.01 it is also possible to edit CSV config files with the Tabular Config Files Display.

Configuration

To use the  TabularConfigFilesDisplay  viewer, configure it as  an <explorerTask> in Explorer.xml. For example:

		<explorerTask name="Tabular ConfigFiles Display">
			<iconFile>csvfile.png</iconFile>
			<mnemonic>L</mnemonic>
			<predefinedDisplay>tabular config files display</predefinedDisplay>	
			<toolbarTask>true</toolbarTask>
			<menubarTask>true</menubarTask>
			<accelerator>ctrl L</accelerator>
			<toolWindow>false</toolWindow>
			<loadAtStartup>true</loadAtStartup>
		</explorerTask>

When the editing functionality is used, an additional display config file (TabularConfigFilesDisplay.xml) can be added to the  DisplayConfigFiles configuration folder. The configuration of this files is explained in the editing section below.

Display functionality

When the Tabular Config Files Display is started, there will be a toolbar at the top of the display, and the two panels will probably be empty as is shown in the example below 

The top panel will list the meta data files that are used in the Delft-FEWS application, the bottom panel will show the content of a selected meta data file.  Only meta data files in .csv or .dbf format that are used in the configuration can be displayed. If the locations are configured in *.xml, *.Json or database, the file will not be shown in the top panel of the display.

The display is linked to the locations list in the Data Viewer (Filters). When a location in the locations list is selected, the meta data files that are used by this location will be listed. The content of the first configuration file will be shown by default in the bottom panel. Selecting another file will display its content.

The toolbar contains 6 buttons with the following functionality

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.

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

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. 

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

Copy: Copy the content of selected cells to the clipboard

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.

Link to the Forecast Tree

Since 2019.02 the Tabular Config File Display can also be linked to the forecast tree. When locations are configured in the Topology.xml configuration with the tabularLocationId element, the related tabular config files for those locations can be displayed. 

Topology.xml with tabularLocationId
<nodes id="NodesWithLocations" name="Nodes with Location Ids">
	<node id="NodeWithLocationId" name="Node with location">
		<tabularLocationId>GLB</tabularLocationId>
	</node>
...

In FEWS versions before 2021.01 the locationId element was used for this linking, this is not possible anymore. The tabularLocationId element need to be used instead.

Link to Shape Files

Attributes from map layer shape files that have been configured in the Map or Spatial Display, can be viewed with the Tabular Config Files display. No additional configuration is required for this functionality.

In the layer panel of the Map Display or Spatial Display a layer attribute can be selected. The Tabular Config Files Display will show the associated Shape Layer DBF file and its entries. The selected layer attribute will highlight the corresponding row in the table. When selecting a row in the table, the corresponding layer attribute will be highlighted on the Map or Spatial Display.

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.




  • No labels

Disclaimer