ITMS Uses Revelation Software to Stay Ahead of the Curve

An article by Stephanie Simone.

OPTO Software, part of iTMS Software Pty Ltd, provides manufacturing inventory software, including ERP solutions, to a wide variety of industries. Customers span the fields of manufacturing, mining, civil, fabrication, and engineering as well as distribution, retail and wholesale, construction, and importing and exporting.

Based in Brisbane, Australia, Opto has been providing ERP, material requirements planning, manufacturing and inventory software solutions to Australian businesses since the early 1990s, and in turn, these software solutions have enabled smaller manufacturers to close the technological and competitive gap between their business and larger-scale market leaders.

Used by hundreds of clients across Australia, Opto prides itself on being small enough to be highly flexible but large enough to deliver the latest technology trends to its customers while shielding them from the underlying complexity. Providing steadfast support, Opto seeks to guide customers through every phase of their installation, from evaluation and feature selection to technical support and help desk enquiries.

OpenInsight at the Core
“Our focus is on the manufacturing technologies you use to build things. Surrounding that, we also plug into accounting systems,” said Jeremy Bolton, managing director. “Revelation Software’s OpenInsight is the heart of our business; our whole product is based on it.”

According to Bolton, a key differentiator for ITMS/OPTO is its deep understanding of the nuances of manufacturing. Revelation supports that agility, ensuring that OPTO platform is easily configured.

“We’re very good at making software fit into many applications with the ability to deliver it quickly and cost effectively, while also making it easy to understand,” Bolton said. “What sets us apart is the ability for the OPTO platform to be easily configured to precise customer requirements.”

The company’s partnership with Revelation was forged after OPTO’s CEO sought to build an effective and simplified system to solve manufacturing issues.

Ability to Adapt
Revelation has made OPTO’s platform very adaptable. It’s simple to build on and it supports both emerging and existing applications, according to Bolton.

Because it runs on a MultiValue database, OPTO can add new capabilities to its platform without affecting the data model.

“If someone needs something with Revelation, the architecture of our product enables us to add the new capability without changing the underlying data model of every other customer,” Bolton said. “Our software can fit in many applications.”

MultiValue database technology can be quickly tailored to unusual requirements and it can talk directly to the CRM copy machine, Bolton explained.

“When we are talking to people about layout, normally we have to get spreadsheet, but this technology allows us to do a layout quickly and effectively,” Bolton said. “Revelation gives us the flexibility we need when responding to customer requirements.”

Built for the Future
Reliability and compatibility are also why OPTO has stayed with Revelation for more than 20 years.

The technology helps OPTO support its customers by providing them with a platform that delivers better customer outcomes, quickly, and cost-effectively.

The MultiValue aspect of the platform make it possible to process requests from customers quickly and with a speed that relational database management systems can’t provide, according to Bolton.

“Running Microsoft SQL Server or Oracle didn’t make any sense,” Bolton said. “There is nothing else you can find to handle so much data.”

Additionally, the cost to customize the platform for a customer was “astronomical,” whereas using Revelation makes the platform cost-effective for the client, Bolton explained.

However, if customers do need to utilize relational database management software, the OPTO platform can integrate to any part of the database that’s necessary, he noted.

Read On…


SRP HTTP Framework – Create REST APIs for OpenInsight

srphttpframeworkThere has been a lot of talk about REST and Restful APIs in recent months.  Don spoke about SRP’s use of RESTful APIs in his conference presentation last year and I noticed that other MultiValue vendors are starting to support the technology – it’s seems to have now moved beyond the latest must have.

In addition to SRP’s pre-conference blog posting RESTing before RevCon 2016, SRP have just published a follow-up blog article which talks about why they released their SRP HTTP Framework and also about their new version of the toolset (Version 3).

You can read the full blog article on their blog – here.  If nothing more, the postings and the Powerpoint presentation will give you a good grounding for the technology and how it can be exploited in OpenInsight.  You won’t be caught out when providing a demo and you are asked about support for REST and what it might mean for you and your application.

Running two instances of OI10

OK, so this posting is more as a reminder for me going forward than anything else.  Last weekend I was working with the OI10 Alpha and I wanted to copy things from one instance of OI10 to another. However, I was blocked because I was only permitted to use one engine and it was being used by the first instance of OI.  I thought that this might have been a restriction but I reported it anyway.

It turns out that this is another setting in the new .rxi file that is used by OpenInsight when first launched.  I have a couple of .rxi files on my system, so the first challenge was to work out which one I needed to change.  This is pretty easy to work out, you just follow these rules:

  1. If the RX switch is used in the shortcut, you’ll use that .rxi file.
  2. If none is defined then OI10 will look for a .rxi file with the same name as the application that you are loading with the /AP switch.
  3. If there is no application defined using the /AP switch, then Oi10 assumes SYSPROG and it’ll use that .rxi file.

So, after a quick check, I’m using SYSPROG, or the SYSPROG.rxi file in my bin32 folder under the OI installation.

I initially guessed that my issue was the <singleInstance> entry which was set to 1, but Carl quickly put me straight and told me that heading will shortly be changed.  In the meantime, he’s told me to look at the <serverName> entry in my .rxi file.  Because I have a serverName set, I am effectively trying to use the same engine as the first instance and Oi behaves correctly and stops the session.  All I need to do is clear the entry by setting it to nothing and then OI will launch as many instances as my license count permits.

Starting OI10 is fully documented in the ‘OpenInsight 10 Presentation Server Object Model’ documentation.  This is a work in progress document that is already into 272 pages but today has been yet another reminder of the numerous options that the guys are exposing to developers when launching OpenInsight.

Consider the .rxi file as a more powerful OInsight.ini file and you won’t go far wrong.  Just don’t do what I did and blindly dive in.  Please take some time to better understand the .rxi files as noted on Carl’s OI10 blog and also in the paperwork when eventually published and released.

For now, I’ll be back into my OI10 Alpha project later today for more learning.



OI10 from Sprezz’s viewpoint

Whilst everyone at the conference we talking positively about the changes that are coming, and rightly so, it is always nice to see what people decide to put into writing following the event.

If you have a blog article that you have written and which relates to the conference, or anything OpenInsight related, please let me know and I’ll gladly add a post onto my blog which has a growing reach.

Today, Sprezzatura have published their viewpoint on the conference.  Entitled ‘A view from the Rev Conference 2015‘ the posting make for a good read AND it includes a screenshot of the new OpenInsight 10 IDE that the guys are working on, plus some details about how Carl put that amazing login screen together without the use of html or fancy image manipulation.

Another legacy Rev based system modernises

More and more people running old ARev and early OpenInsight based systems are seeing the benefits and needs of modernising their systems.  Not only does this future proof these systems going forward, but it often enables developers to better and more easily integrate with more modern hardware.  This reduces the risk of trying to find replacement units or parts for obsolete equipment or sourcing unsupported hardware and software.

SRP Computer Solutions have recently helped one of their clients to modernise by embracing thin client technologies, with USB wedge barcode scanners and one of their connection controls.

Click here to read the full article that SRP have recently published on the project.

Improving throughput in OpenInsight

As I am non-technical, it is always nice to receive some technical information from around the Revelation community. Revelation often shares things with me, but there is a wealth of technical knowledge and information out there in the community. I watch many of the blogs but a heads up is always useful and Martin Drenovac from Powerforce recently contacted me with a very useful tip:


Martyn good evening

Just reading your blogs and OI pointing to the use of cacheing – we’ve recently started to refactor some portions of our system to use rtp65 as a means of improving throughput.

And internally we use the web to document our own code / specs – and I wonder whether this article (not yet complete), might be a useful example to put into the OI community.

Please note that it’s not fully written up just yet.

Martin Drenovac
Powerforce Software P/L

OpenInsight 10 and the next UK RUG

OpenInsight 10 taskbar progress bars
OpenInsight 10 taskbar progress bars

Another very nice feature has just been written into the OI 10 release and one that many OpenInsight developers will no doubt be keen to exploit.  One of the most useful features introduced with the Windows 7 taskbar was the ability to display progress information directly on your forms taskbar button.  From OpenInsight 10, developers will be able to include this lovely feature in their applications through two brand new WINDOW properties.You can find full details about this new feature, including screen shots of the different coloured progress bars on the Building OpenInsight 10 blog.

EMEA RUG – Please also add Wednesday 25th September into your diary.  Mike will be over from the USA that week and as usual I intend to host a RUG for our EMEA client base.  The venue is likely to be at the Hilton in Ealing.  For those of you that have stayed in the Ramada in Ealing, it is the same place.  I am yet to fully formalise the agenda, but I am hoping that Mike will undertake his usual address (state of the company, current and future developments, etc.).  Hot on the heels of the roaring success in the States, I am hoping that Carl will share many of the new features that he has been working hard on for the OpenInsight 10 project.

Remember – Wednesday 25th September – If you are an OpenInsight Developer, an OpenInsight User or a MultiValue developer using D3, U2 or QM, this is one event that you’ll want to make sure that you attend.

As usual the day will be free of charge to attend, but places are likely to be limited to 25 people, so please contact me to reserve your place on this key Revelation EMEA event.