DataSight Version 3.3 Released
DataSight Version 3.3 is here! New features include the availability of FTP across all File Dialog windows, the ability to use Sub-Reports within a main container of a Master Report including DataSight hard coded Summary Reports, the ability to import data from a Web Service, and more.
A File Dialog window allows you to choose a file from a file directory. In DataSight you use a File Dialog window for a number of reasons. These include:
- Selecting a file to import data
- Selecting a file to import as a document
- Adding a document to Documents
- Saving a document from Documents
- Adding a document to a gauging
- Attaching an image in Construction
- Saving an image from Construction
- Exporting data from Calculation Results
- Saving your document to a file when printing
- Exporting a datasheet or chart to a file
- Saving a Summary Report, Datasheet Report using the Report Wizard, or Query Report using the Report Designer
- Picture Box and Rich Text controls in the Report Designer
- Automating data import, data export, and the publication of charts and reports from the Tasks
- Loading a License
You can now specify a file location in any File Dialog window using FTP. Wildcards are also possible. Please note that sftp is not currently available.
Grid Filters are excel-like auto filters that can be used when viewing tables such as that for Variables and other data properties. They are also available during the Import Routine, and in Conversion Tables, Regressions, Gaugings, Summary Reports and Tasks. The choice of filter includes the Filter Editor, the Find Panel and the Auto Filters.
You can now filter data against single or multiple columns and filter criteria are globally updated across all filter types. You can also specify conditions for individual cells within the auto-filter row. With this update, Null or blank values can now be removed during import.
You can now specify the variable format across the Basic Summary, Annual, Monthly, Daily, Standard exceeding and Rainfall Intensity reports. You can also filter these summary reports with Flag, Quality and Locked/Unlocked data types to further subset your included data. The average value and standard deviation are now provided in the Basic Statistics Summary Report.
MOVING AVERAGE REPORT
We have created a Moving Average Report that provides the average value of a variable in steps moving through a specified date range. The steps are specified by the number of records to be included in each calculation of the average and is limited to 5000 records for any one report. For instance, if you have a continuous record of 15 minute data and you wish to average your data every 4 records (e.g. hourly), then the maximum period would be 52 days.
Report Designer can be used to create Sub-Reports that are subsequently merged into one final report. This can be useful when calling different data sets for each report section, as the Master Report data does not use or override the Sub-Report’s data. The use of Sub-Reports requires that you have already prepared and saved a Summary Report , Datasheet Report using the Report Wizard , or a Query Report using Report Designer to the Saved Views Panel. Note that the different types of reports are now identified with different icons in the Saved Views Panel.
Report Designer has been rearranged with a new Ribbon Menu and updated Standard Controls Panel. New Contextual Tabs display context specific commands, and as such, they don’t need to be on constant display. They are displayed only when a specific object is selected or when you perform a specific action.
Grouped fields in charts no longer require scripting. This script is now generated automatically from code when a chart component is added and grouped from report designer.
IMPORT FROM A WEB SERVICE
Data can be automatically ingested into DataSight from a Web Service. The output from a given web location could be a file, a custom output file or even raw output data. You can now compare your data with other externally sourced data within DataSight.
Import Summary Logs now contain information about the levels created and variables skipped for variable mapping.
You can now use Quality, as set in the Flag Table, to filter your data for datasheets and charts.
Data Groupings, using the datasheet column headers, can now be merged. To merge groupings, drag a column header(s) to the group panel and arrange them across a line while pressing the CTRL key. Drag column headers below or above this line to break merged grouping.
When using the scroll chart, you can now lock the chart bounds. When plotting a function, the corresponding function type and duration is now shown in the chart window.
Copy your conversion table values to clipboard for easy export from DataSight.
You can now print your Regression Chart directly from Regressions via the right click context menu.
A new task status, Failed, has been added to the Task Log and is coloured orange. This status appears when a task fails without an error.
In the Options window, when you check Create SQL View, then every time you save a datasheet in DataSight, a native Microsoft SQL View is saved based on the filters for the datasheet. Your SQL Views now also carry the Level 1 and Level 2 Names.
Please contact your nearest reseller for more information about DataSight Version 3.3.