Category Archives: InfoNet

Tip & Tricks. Comments in SQLs

Posted on March 20, 2017 by Idris Nujjoo

Want to make your code understood to colleagues? Want to ignore certain lines whilst developing an InfoNet SQL? From InfoNet version 17.5 a double Forwardslash ‘//’ acts as a comment in InfoNet SQL Comments. In computer programming, a comment is … Continue reading →

Posted in InfoNet, InfoWorks ICM | Tagged , , | Comments Off on Tip & Tricks. Comments in SQLs

Using the WRc Stylesheet (*.XSL) to Visualise and Display MSCC CCTV XML File.

Posted on March 7, 2017 by Idris Nujjoo

Not exactly an InfoNet specific post but for those users working with the UK’s WRc’s MSCC Sewer CCTV Survey Standard this blog may be of use, it explains how to better visualise the data exchange XML file. A typical File … Continue reading →

Posted in InfoNet | Comments Off on Using the WRc Stylesheet (*.XSL) to Visualise and Display MSCC CCTV XML File.

Tips & Tricks – Importing Images/Attachments Using the Open Data Import Centre, Selecting the Correct Mapping Fields.

Posted on February 2, 2017 by Idris Nujjoo

A long time ago now, version 10.5 or earlier, objects in InfoNet had the ability to only store a fixed number of images or attachments. As an example the Manhole Surveys object could only store four images and attachments in … Continue reading →

Posted in InfoNet | Comments Off on Tips & Tricks – Importing Images/Attachments Using the Open Data Import Centre, Selecting the Correct Mapping Fields.

A Spatial SQL – Selecting Objects from another Table based on their Proximity to a Selection

Posted on January 11, 2017 by Idris Nujjoo

I’ll use the following example to demonstrate how, with a couple of simple SQL Queries, it is possible to select objects from another table based on their proximity to a current selection of objects. In the following distribution network there … Continue reading →

Posted in InfoNet, InfoWorks ICM | Comments Off on A Spatial SQL – Selecting Objects from another Table based on their Proximity to a Selection

How to Untangle A String… A Method to Convert a String to Float.

Posted on November 28, 2016 by Idris Nujjoo

In this BLOG post I’ll outline a method of converting a value in a text field into a number. So whilst I have what appears to be a number such as 43 or 43.0 or 43.67 in a text field, … Continue reading →

Posted in InfoNet, InfoWorks CS, InfoWorks ICM, InfoWorks RS, InfoWorks WS | Comments Off on How to Untangle A String… A Method to Convert a String to Float.

Why is the ‘GIS Layer Control’ Unavailable?

Posted on November 28, 2016 by Nicole Hathorn

When you right click on your GeoPlan, you may notice that your GIS Layer Control option is grayed out and unavailable. To fix this problem, first, make sure that your Map Control is not set to ‘None’ (Tools>Options>GeoPlan). You can … Continue reading →

Posted in InfoNet, InfoWorks ICM | Tagged , , , , | Comments Off on Why is the ‘GIS Layer Control’ Unavailable?

Running Spatial Queries on a Selection.

Posted on November 4, 2016 by Idris Nujjoo

A spatial SQL allows users to make selections or carry out other SQL functionality based on how objects are spatially related to each other. Such as where object as lines ‘cross’ each other. If an object is ‘inside’ another such … Continue reading →

Posted in InfoNet, InfoWorks ICM | Comments Off on Running Spatial Queries on a Selection.

Innovyze Workgroup Data Server (WDS)

Posted on August 18, 2016 by Andrew Walker

Overview of the Innovyze Workgroup Data Server (WDS) The Innovyze Workgroup Data Server is a server component which manages access to Workgroup databases from InfoWorks ICM and InfoNet Clients. The Data Server is designed to improve the performance and reliability … Continue reading →

Posted in InfoNet, InfoWorks ICM | Comments Off on Innovyze Workgroup Data Server (WDS)

Little Gems Of Functionality – Visualising Structural and Serviceability Defect Scores on the Long Section View.

Posted on August 16, 2016 by Idris Nujjoo

The long section pick tool has always been a great tool, giving users the ability to display one or more pipes in profile. The CCTV Survey Defects can also be displayed along the pipes, which appear as coloured crosses. The … Continue reading →

Posted in InfoNet | Tagged , , , , | Comments Off on Little Gems Of Functionality – Visualising Structural and Serviceability Defect Scores on the Long Section View.

Cross Network SQLs – Running an SQL Query Across Multiple Networks

Posted on August 9, 2016 by Idris Nujjoo

It is possible to run an SQL query across more than one network. This can be achieved by selecting the main menu Tools > Run Query Across Multiple Networks. Let say I am interested in knowing the total length of … Continue reading →

Posted in InfoNet | Comments Off on Cross Network SQLs – Running an SQL Query Across Multiple Networks