>OpenInsight 9.x End-User Benefits


Since the RUG and my road trip with Mike, I have had a number of requests for a document that details the benefits to end-users in the 9.x series. Whilst the majority of the benefits are for developers, there are a large number of enhancements that will benefit end-users.

I was planning on blogging the list, but the document grew to a size where this is not effectively possible. Revelation have packed so much into the 9.x release :). For this reason and a few others, I am planning on making the document available on request. Please drop me an email to my usual address (or comment below) and I’ll get a copy to you via email.

The document itself is divided into two main sections. The first is divided into categories based on the tools and each benefit is listed with a few lines of explanation. The second section is a two page bullet point list that simply summarises the key points.

I hope that this will become useful for those of you, like me, who need to justify the annual license fee to your end-users who are currently on 8.0.8 or prior and who you now need to move into the 9.x series.

>Mike Ruane Kidnapped in London


So, I let Mike out of my sight for one day whilst here in London last week and he gets himself into trouble.

Then, following a grilling about the new tools in OpenInisght 9.2, he produces a new ‘How-To’ video for OpenInsight 9.2’s brand new SQL Connector. This tool lets developers use SQL server data as if it were native MultiValue data, without having to learn SQL. Stick with the BASIC you know.

Well, along with O4W, I guess the connector was one of the big highlights of the week and it is set to open many new doors for Revelations VARs around the world.

>Upgrading to OpenInsight 9.2


Following a hugely successful RUG and road trip around the UK last week (more on the RUG coming soon) and the release of OpenInsight 9.2, we have had a number of support requests from people new to OpenInsight for installation keys. This posting is therefore to remind everyone of the process to obtain the upgrade files and the authorisation key.

The first pre-requisite is that you have a current OpenInsight WORKS subscription. Please contact me if this is not the case. You then need to ascertain which version of OpenInsight you are running at the present time. If it is an older 7.x or 8.x version then you will need to cross-grade your runtime or Developer Class licenses, please contact me for more details about the cross-grade procedure.

Assuming you are simply upgrading your OpenInsight development system (W serial number) you will need to either obtain one of the single hit upgrades that are unofficially available (there is not currently one to jump from 7.x or 8.x to 9.2, but I will blog one if and when it is made available), or the appropriate upgrades from your current version to 9.2. The readme files identify which upgrades can be jumped, however I personally usually apply each in turn. Alternatively, there is a 9.2 full install in the WORKS area and this can be used for a single clean installation by those of you who wish to backup and restore your application/s into a fresh installation of OpenInsight.

Please note that the WORKS area includes both a 9.2 Full Install and also a 9.2 upgrade, so please be careful to download the right file.

Please also note that upgrades prior to 8.0.3 can be installed without an installation authorisation key, but upgrades from 8.0.3 require keys. The good news though is that you only need one key for the whole upgrade process.

OK, so the actual process:

1) Log into http://www.revelation.com with your unique username and password.

2) Locate the ‘WORKS Subscribers’ button on the left navigation bar and use it to enter the private WORKS area.

3) Next locate and click on the ‘Works Downloads’ link in the navigation panel and then choose ‘View All by date Posted’. This works fine for us at the present time, as the two upgrades appear at the top of this list. Otherwise you could select to display all by version.

4) Click on the full installation or upgrade page link to go to the license page.

5) Read and then accept the license to move on to the actual download page.

6) Review this page, but move straight to the OI92Install.exe icon at the bottom of the upgrade page and download the file, saving it to you local machine. Please also be sure to download and study the Installation Guide and Readme Guide as there is information in there about closing services, etc. before running the installation and installing the client files as part of the installation.

7) Move back to the top of the download page and locate the hyperlink to the ‘OpenInsight 9.2 Full Install / Upgrade Request Form. This launches the form that you will use to request your installation key.

8) Complete this form, being sure to complete all of the red labelled prompts, including your correct email address, serial number and a site name (reference to this license). If this is your development license (W serialised engine) then just enter Development License.

9) If you have already uploaded your OEngine.dll file DO NOT upload it again, just hit the save button and your request will be processed automatically and you will receive you code by email within a few minutes.

If you have not previously uploaded your OEngine.dll file for the system being upgraded, please locate your OEngine.dll file from within your OpenInsight folder and upload that now. This will invoke a manual registration process and you should receive your installation key within 24 hours (subject to the US office opening hours).

10) You then simply need to install the upgrade/s or full installation using the authorisation key where prompted.

Although the above ten steps sounds complicated on paper, it is actually very straight forward and (with the exception of the actual download time) the process of obtaining the upgrades and installation key should not take more than a few minutes.

However, please do not hesitate to contact your designated Revelation office should you require any assistance throughout this process.

>OpenInisght 9.2 Now Available.


For those of you that might not have noticed, the final commercial release of OpenInsight 9.2 was made available to all OI WORKS subscribers on Thursday last week and a press release will be going out form the EMEA office ina few minutes.

This new release was very warmly received last week, both at the RUG and the various client meets that Mike and I had around the UK.

Some of the highlights were the enhancements to TCL for end-users and the connectors for SQL and D3 and of course O4W.

There are a number of documents available for the connectors and O4W and we have videos planned for the SQL connector, the D3 connector and I also have plans to turn the O4W Quick start guide into a series of videos over the coming weeks.

All OI WORKS subscribers have access to the new release through the WORKS area on http://www.revelation.com. If you are no longer a WORKS member and would like to get your hands on the new version, please contact me for WORKS renewal details.

>OpenInsight 9.2 now in final beta


Overnight Revelation US has announced to their beta testers that the final OpenInsight 9.2 beta is now available for download from the beta site.

This final beta is the version that the company intends to put on general release on the 15th July 2010. In Mike’s email to the registered beta testers, he says that Revelation are very happy with this release and all of the functionality and features that it brings. He goes on to thank all of the beta testers for their time and feedback and I would like to take this opportunity to add my thanks to everyone involved with this release, both beta testers and the Revelation developers who have worked so hard to make this a great release.

Please remember that Mike will be in London on the 13th July for the next RUG. He will be reviewing 9.2 and also taking a note of your needs for 9.3 and beyond.


>Yet another new OI connector goes into beta.


As many of you will know, Revelation’s OpenInsight supports data connectors for Rocket Software’s (previously IBM’s) Universe and Unidata (U2) and also TigerLogic’s D3 databases.

However, a brand new data connector for Univision has just gone into beta and Revelation hope to release this shortly after the main 9.2 release mid July. Built on Revelation’s existing and proven connector technology, this new connector now means that Revelation supports data connectors for ‘five’ of the leading MultiValue (Pick) databases currently in use, as well as support for a variety of SQL databases.

These data connectors are shipped as part of the development suite meaning that there is nothing extra for you to purchase, other than your third party database licenses. Once configured, a job that usually take no more than a couple of minutes, these connectors enable developers to work with the OpenInsight toolset against the third party data just as if it was native OpenInsight data. This means that the entire OpenInsight toolset can be utilised against these databases: that includes the GUI design tools, the Powerful Systems Editor, the Data Warehouse, the Web Development Tools and much more.

Revelation are currently interested in talking to anyone running Universe, Unidata, D3 and Univision and who need to extend or modernise their current systems. Please contact Martyn in the first instance for more details or you can find out more about these connectors, and see them in operation at the forthcoming RUG in London on the 13th July. This is a free to attend event and you can register to attend on our website. Places are becoming limited, so please register as soon as possible.

>OpenInsight Beta 5 Released.


The OpenInsight 9.2 beta 5 release is now available to all OI WORKS subscribers registered for the beta program. You should have received an email direct from the Mike in the USA, but please drop me a line if this is not the case.

OpenInsight is a solid release and it has been used solely for the development of my new Contact Manager System. Throughout this project I’ve used the Table Builder, Forms Designer, User Interface Workspace, Database Manager, Report Builder, OIPI, the system Editor and more. This project has found a couple of issues and these have subsequently been fixed and I’m now looking forward to the final release in mid July, just after the RevUK EMEA RUG.

Thank you to all of the beta testers who have contributed and continue to contribute during this beta testing period.