...
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 listedTo display the data a location has to be selected in the Data Viewer. After selecting a location a list of configuration files will be displayed. The content of the first configuration file will be shown by default in the bottom panel. Selecting another file will display its content.
Only configuration files in .csv or .dbf format can be displayed. If the locations are configured in .xml, the file will not be shown in the display.
Sorting
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 The table 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.
...
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.
Show modified values
Since 2017.02 it's possible to show modfied files in tabular config files that have been applied by modifiers. By checking the "Show changed values" checkbox all values that have been changed by modifiers will get a blue background color. A tooltip will display the unmodified value. The modified values can be exported to CSV using the export button.
Lock
Since 2019.02 it is possible to lock the tabular config file display. When locked, selecting another node, won't change the display.
Link to the Forecast Tree
Since 2019.02 the Tabular Config File Display is can also connected be linked to the forecast tree. If When locations are configured in the Topology.xml configuration with the tabularLocationId element, the related tabular config files for those locations will can be displayed. The first location will be selected in the table.
Since 2021.02 the locations are linked using the tabularLocationId element.
| Code Block | ||||
|---|---|---|---|---|
| ||||
<nodes id="NodesWithLocations" name="Nodes with Location Ids"> <node id="NodeWithLocationId" name="Node with location"> <tabularLocationId>GLB</tabularLocationId> </node> ... |
Prior versions use In FEWS versions before 2021.01 the locationId element .
| Code Block |
|---|
<nodes id="NodesWithLocations" name="Nodes with Location Ids">
<node id="NodeWithLocationId" name="Node with location">
<locationId>GLB</locationId>
</node>
... |
Shape Files
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 Since 2020.02 the attributes from the shape files that have been configured in the Map or Grid Spatial Display, can be viewed with the Tabular Config Files display. No additional configuration is required for this functionality.
Layer Attribute Selection
In the layer panel of the Map Display or Grid 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 Grid Spatial Display.
Shape selection from Map or Grid Display
It is also possible to select a layer attribute on the Map display. This requires the tooltip icon icon 
to 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.
...