Author Archives: Idris Nujjoo

About Idris Nujjoo

Idris is the Product Sector Leader for InfoNet and InfoMaster and has been working for Innovyze (and its earlier incarnations) since 2001 and specifically working on InfoNet and Asset Management for the past decade.

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

Tip & Tricks. Comments in SQLs

Want to make your code understood to colleagues? Want to ignore certain lines whilst developing an InfoNet SQL? A double Backslash ‘\\’ acts as a comment in InfoNet SQL Comments. In computer programming, a comment is a programmer-readable explanation or … 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.

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.

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

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.

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.

Running Spatial Queries on a Selection.

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.