Category Archives: InfoNet

Tips & Tricks – Moving Survey Images/Attachments into the Default Fields Using SQL

InfoNet will store an unlimited number of images and attachments per object. However there are old default fixed attachment fields, these have a green background to the data row. For some users their exports or reports are set to pull … Continue reading

Posted in InfoNet | Comments Off on Tips & Tricks – Moving Survey Images/Attachments into the Default Fields Using SQL

Creating and Updating a Microsoft Server SQL or Oracle Workgroup Database

The purpose of this post is to provide users who plan to use or currently use Microsoft SQL Server or Oracle databases for InfoNet and/or InfoWorks ICM with the resources they need to initially create and/or update their database to … Continue reading

Posted in InfoNet, InfoWorks ICM | Tagged , , , , , | Comments Off on Creating and Updating a Microsoft Server SQL or Oracle Workgroup Database

Leaks and bursts: find, fix and prevent them

If you’re concerned about leaks in your water supply network – whether they’re steady, or sudden bursts – they can be addressed. Reducing leaks and non-revenue water (NRW) means happier customers and regulators, savings on wasted water, and fewer fines. … Continue reading

Posted in DemandWatch, InfoMaster, InfoNet, InfoWorks WS Pro, IWLive Pro, SCADAWatch | Tagged , , , , | Comments Off on Leaks and bursts: find, fix and prevent them

Tips & Tricks – Easily Finding a Column in a Grid.

Another short post on a very useful tip & trick, how to find a field in a grid. Some objects have many fields and finding the field in a grid table can be frustrating. A quick way of finding a … Continue reading

Posted in InfoNet, InfoWorks ICM | Comments Off on Tips & Tricks – Easily Finding a Column in a Grid.

Using Web Map Services (WMS) in InfoWorks ICM, InfoWorks WS Pro and InfoNet

InfoWorks ICM, InfoWorks WS Pro and InfoNet all support the following Map Controls: ArcGIS Engine, ArcGIS Desktop and MapXtreme. The GIS Layer Control Dialog is used to choose how map layers are displayed on the GeoPlan Window. The dialog is … Continue reading

Posted in InfoNet, InfoWorks ICM, InfoWorks WS Pro | Tagged , , , , | Comments Off on Using Web Map Services (WMS) in InfoWorks ICM, InfoWorks WS Pro and InfoNet

InfoNet 18.5 – Re-sizeable SQL Dialog Box

InfoNet 18.5 is now out in the wild and along with a wealth of new functionality, we’ve thrown in some that will hopefully make day to day usage somewhat more pleasant. One of these is the SQL dialog box which … Continue reading

Posted in InfoNet, InfoWorks ICM | Comments Off on InfoNet 18.5 – Re-sizeable SQL Dialog Box

InfoNet Dashboards

Dashboards allows users to display their data graphically, thus drawing out and displaying it as useful information. Dashboards in InfoNet display simple graphics (called ‘widgets’) like a numerical, a pie chart, graph or simple table. Note that it is SQLs … Continue reading

Posted in InfoNet | Comments Off on InfoNet Dashboards

A Method (RUBY Scripting) to Import an InfoWorks ICM Model into InfoNet.

Over the years there has been one question from my InfoNet clients that has consistently popped up; “How do I import an InfoWorks ICM Model into InfoNet?”. I must have been asked this a squillion times, and the answer has … Continue reading

Posted in InfoNet, InfoWorks ICM | Comments Off on A Method (RUBY Scripting) to Import an InfoWorks ICM Model into InfoNet.

Confused about WHILE, IF

Clients often get confused about WHILE, IF etc. It is quite common for those unfamiliar with SQL often try to use IF/ELSE/WHILE when there is no need and normal SQL commands are more appropriate. The important thing is to understand … Continue reading

Posted in InfoNet, InfoWorks ICM | Comments Off on Confused about WHILE, IF

Open Data Export Centre – Exporting the Attachments Array

InfoNet has the ability to attach an unlimited number of attachments to any of its objects, which are managed through the attachments array (see image below). This post explains how to export the attachments array information using the Open Data … Continue reading

Posted in InfoNet | Comments Off on Open Data Export Centre – Exporting the Attachments Array