The Module Run Table Display (available since 2015.01) can show data imported using the importCsvModuleRunTablesActivity of the 05 General Adapter Module. The imported CSV files are stored in FEWS and can be displayed using a table viewer with sorting, filtering and column hiding functionality.
To use the Module Run Table Display viewer, configure it as <explorerTask> in Explorer.xml. For example:
In the DisplayConfigFiles directory a ModuleRunTableDisplay.xml file needs to be created:
To display the data a topology node has to be selected that maps to the run that imports the csv. After selecting the node the Module Run Table Display will appear. On top of the display is a list with csv files that have been selected. Default the first file will be displayed. Clicking on any file will display the imported csv content.
The table can be sorted by clicking on a header.
Tables can be filtered by double clicking on a cell entry. Only records with 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 case not all columns should be visible, right clicking on a value will show the "Set column visibility" menu. 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.
On fail configuration
By design the activity will fail if the configured importFile is not found. To overrule this behaviour the following configuration option is available:
If onFailWarnAndContinue has been set to ture, a warning will be logged if the configured importFile cannot be found, but the activity won't fail.