SiteFX - What's New

Major new updates and features are described below, but minor (but important) updates are happening all the time too.  To review the list of minor updates, check the downloads link at the left and read the release notes for SiteFX.

Release 05.09.02

Data Logger File Support

Better support for data logger files was added in this version.  This includes a new tool for checking logger file compatibility with SiteFX.  Using this tool, you can select any file in question and SiteFX will attempt to determine its format and provide a report.  A screen shot is provided below.

This feature can be accessed from: Temporal Data > Data Loggers > Import Logger Data

Release 05.08.31

Database Checkup Tool

The database checkup tool is used to scan your database for potential issues and to provide diagnostic information.  For each check, the user will receive, as feedback, the number of records that failed the check and potential issues are highlighted in orange.  Additional details can be obtained as well on the specific records causing the issues.

The list of checks will continue to expand over the coming months.

This feature can be accessed from: Tools > Database Checkup

Chemistry Duplicate Removal Tool

A new tool was added to the aid in the removal of duplicate records.  Duplicate records typically get into a database at the beginning of a project when large quantities of historic data are being added to the database.  Duplicate records can also creep into a database over time for various other reasons.

This tool requies that the user have some knowledge of the underlying database table structure.  Using the field names, users can remove duplicate records from the sample detail table (contains sample name, sample date etc.) and the sample data table (contains parameters, values and units etc.).

This feature can be accessed from: Tools > Advanced > Duplicate Record Removal

Release 05.07.26

Location and Interval Data Merge Tool

This tool was added to assist users merge locations and intervals.  The most common situation occurs when a location has been added twice, perhaps from two difference sources.  It is typically best to amalgamate the location's data such as geology, borehole construction, chemistry, water levels etc.

This new tool helps to give users the information they need to make merging decisions, then allows them to shift data back and forth between locations as required, and also delete data if required.

This feature can be accessed from: Tools > Advanced > Merge Location / Interval Data

Release 05.06.19

SQL Statement Executor

The SQL Statement Executor tool was added to allow users to run queries specific on their database. In most cases, SiteFX's regular features provides all the querying power required, but in some cases a 'one-off' query may be required to return results, or update data.

This feature can be accessed from: Tools > Advanced > Run SQL Statements

Release 05.05.26

User Customizable Excel Reports

The Excel Report feature was added in response to our user's request for a more flexible reporting format, especially for water quality data (and other temporal data).  The Excel reporting feature allows users to create their own Excel macros (and vb code) to run on data reports generated from SiteFX.

This feature can be accessed from: Report > Analyze Data

The Excel template can be set on Report Layout tab.