Tuesday 29 September 2009

I18N round table and RUG meeting



26th October 2009 - I18N round table
The Internationalisation (I18N) round table shall be held at our Ealing offices in London. To keep the meeting moving, places will be limited to half a dozen. For this reason, please contact Martyn to check availability and to confirm the times, etc.



27th October 2009 - RUG Meeting
The next Revelation User Group (RUG) Meeting will be held at Revelation’s offices in Ealing, London during the 27th October. The doors will be open from 10:30 for tea and coffee and then we will begin the main meeting from 11:00 sharp. There will be a short lunch break and then we will resume finishing at about 15:00.

As usual, Mike Ruane will be over from the USA and during the Revelation User Group (RUG) meeting he will review the 9.x releases, touch on our plans for 9.2 and future versions and he will also be showcasing a brand new web technology, currently known internally as O4W – OpenInsight for the Web.

O4W is a fully featured online web application development environment providing developers with the fastest and easiest way to get Revelation data onto the web using latest web technologies, such as AJAX, etc. This will be the first opportunity to get an advanced look at the technology within the EMEA region and this is a must see for anyone planning, or even mildly considering, providing a web interface to their applications.

Most importantly, previous attendees have made important suggestions for inclusion in the OpenInsight toolset and many of those have made the next commercial release. The RUG is the perfect opportunity to put your OpenInsight requirements direct to the main decision maker at Revelation.

Reserve your place online now - www.revsoft.co.uk/eventregistration.htm.

Venue address:
45 St Mary's Road
Ealing
London
W5 5RG
England
tel: +44 (0) 20 8912 1000

Thursday 24 September 2009

Open OIPI report previews maximised



A couple of times recently, I have been asked how to launch the OIPI preview window maximised. I therefore thought it worthwhile to remind everyone that the INIT Set_Printer Message can be used to achieve how the window launches, amongst several other things.



There are nine main parameters, the 5th parameter handling how OIPI launches and what is displayed. The 5th parameters ‘Style’ setting consists of 6 options that you can define in your report. The options are:

  • 0 = Print to printer
  • 1 = Display PrintSetup
  • 2 = Preview normal
  • 3 = Maximized
  • 4 = Last location
  • 5 = Specific location
  • 99 = Print to printer with the WMF fix

To launch OIPI maximised you would use something like -
stat = Set_Printer("INIT", "Report 1", title, "", 1, 3)

The INIT message must be called before any printing can start as it controls the initial properties for each printing session. A full list of the properties can be found within the OpenInsight help files, by running a search for “INIT Set_Printer Message” and the help file contain a lot of useful additional information with regards to the INIT Set_Printer Message.

Tuesday 22 September 2009

I18N Round Table & RUG – Register online now.



You can now register online for the October I18N Round Table and the next RUG. The registration form can be located at http://www.revsoft.co.uk/eventregistration.htm.

More details will follow shortly.

I18N round table and RUG - Register online.




You can now register online for the I18N Round Table and the next Revelation User Group. The registration form can be found at http://www.revsoft.co.uk/eventregistration.htm.

Monday 21 September 2009

I18N round table and RUG





26/10/09 - I18N Round Table
27/10/09 - Revelation User Group


Details are currently being finalised, but I am pleased to announce that RevSoftUK will be hosting an Internationalisation (I18N) round table and a Revelation User Group meeting on Monday 26th and Tuesday 27th October respectively.

Revelation have recently seen a heightened interest in OpenInsight from clients and prospects around Europe, Russia and the Middle East, many of which require support throughout the product for special characters. Whilst a lot of work has already been undertaken, Revelation appreciate that the subject is complex and wide reaching.

For this reason, a very special I18N round table is being hosted on the afternoon of the 26th October. This is the perfect open discussion forum for anyone working with (or needing to work with) special characters. Mike Ruane and Carl Pates will be in attendance to share their current I18N support ideas and they will be interested to hear your ideas on those plans and also be fully understand your specific requirements.

This is a unique opportunity to influence the future direction of OpenInsight and a must for any developer or user working with special characters.

The following day (27th October) will see the next Revelation User Group (RUG) taking place. The full agenda is yet to be confirmed, but Chaired by Mike Ruane, I anticipate that attendees will hear an update on how the company is doing, plans for 9.2 and later and also an overview of the 9.x releases. If for nothing else, this is a must attend for anyone developing with OpenInsight or ARev as it is your opportunity to voice your requirements from the product. Following each RUG recently, the majority of the suggestions and needs of attendees have found their way into the product – you are also pretty much guaranteed to learn something about the product that you did not know before and that will make your life just that little bit easier.

Both events will be based somewhere in London and I will post further details about the times, venues, etc. as they are finalised.

For now, please be sure to block these two important dates in your diary and please drop me a line to reserve your place and help me to better estimate the numbers to cater for.

Tuesday 15 September 2009

RevDotNet QSG video



A couple of new YouTube videos have just been added to the RevSoftUK video library. In addition, a new YouTube Channel has been created bringing all of my RevSoftUK OpenInsight videos together.

The two latest videos are a representation of Revelation’s RevDotNet Quick Start Guide. Split over two videos, the first consists of a presentation that looks at using RevDotNet and a closer look at the API itself. The second video explores the process of using a Calendar .NET control in an OpenInsight 9.1 form.

These videos take a while to put together and I am therefore interested to know whether you find these videos useful or not. For this reason, I have included a poll on the blog and I will be very grateful if you could take a couple of moments to cast your vote. Please also use the comments below this posting to suggest any future topics for videos that you might be interested in.

Friday 11 September 2009

Did you know - Knowledge Base



Hopefully this will simply serve as a reminder, but just in case you’d forgotten (or never got round to taking a look) the Knowledge Base section http://www.revelation.com/ is just one of several valuable developer resources that Revelation makes available to its worldwide community of developers.

The knowledge base is updated regularly with insightful articles on the use and behaviour of Revelation’s products and it’s worth making a monthly to-do task to check it for new information.

Some recent postings are:

Thursday 10 September 2009

OI and .NET – but how?



OpenInsight version 9.1 has seen two new features to enhance OpenInsight’s integration with .NET. However, following the release has come a number of questions from developers asking which should be used and then how that technology should be implemented.

Bryan Shumsky has addressed this in his discussion page on the subject which also links to the two Quick Start Guides covering NetOI and RevDotNet. This page has now been added to the EMEA web site along with links to the two Quick Start Guides. The main page can be found at http://www.revsoft.co.uk/dotnet.htm.

If you are not yet using OpenInsight version 9.1 and you would like to check out these two great new features, a 30 day evaluation of 9.1 is now available from http://www.revsoft.co.uk/evalmain.htm.

Wednesday 2 September 2009

OpenInsight 9.1 - Where do I start??



Yesterday I said to watch the blog for further details with regard to the new functionality in version 9.1, then later I downloaded and reviewed the 9.1 readme and wow, there is much ,much more than I had anticipated. This posting is therefore very much a touch of the highlights and I suggest that you review the full readme for full details – email me if you are not a WORKS subscriber and would like a copy of the readme to review.

One of the main new features to immediately become apparent is the enhanced support for the .NET framework. This new release includes two key methodologies for integrating OpenInsight with .NET and they include NetOI and RevDotNet. The NetOI .NET assembly enables developers to code entirely in Visual Studio and to develop a Windows application that utilises OpenInsight as its data source. RevDotNet is a set of API calls made from within OpenInsight to a .NET control. In addition, Revelation have provided a DOTNET EXPLORER window that enables developers to crack open and explore a .NET control.

In addition, The Basic+ commands for working with .Net assemblies have been modified. These include STARTDOTNET, SET_PROPERTY.NET, GET_PROPERTY.NET, GET_INFO.NET, EVENTS.NET, SEND_MESSAGE.NET, CREATE_CLASS.NET, FREE_CLASS.NET, CREATEINTERNALOBJECT.NET, and PARSEDOTNET.

The new release also includes the ability to send a fax from within OpenInsight using the standard Windows Fax Server that is now included in Windows XP, Vista and Server 2003 and Server 2008. In addition, RTI_CDOMAIL enables an email to be sent from within OpenInsight using an authenticated login and or SSL.

RTI_TASK_SCHEDULER has been introduced in this release, providing an OpenInsight front end to the Windows control panel scheduled tasks. Along with the Engine Server, this can then be used with the new RTI_INDEXER_CONFIG routine to schedule indexing. OERUN.exe also uses the RTI_TASK_SCEDULER and it is intended for this to be run from the Windows task scheduler, but it can just as easily be called from a batch file as required.

The RTI_CreateGUID routine enables a GUID to be generated without using locking and provide developers with a nice way to obtain unique keys and other unique identifiers.

For those of you who need to validate passwords, credit cards or Social Security Numbers without storing those details, RTI_MD5 has been created.

At the last UK RUG, Mike spoke about support for JSON within OpenInsight and this release sees a new routine called RTI_JSON which allows your to generate JSON formatted data. This is especially useful for anyone involved with custom web programming using AJAX techniques. Revelation have included an example (RTI_RSS) that shows how RSS feeds can be read in JSON format.

Another feature of the RUG was the Code Templates and these too find there way into the new release. As many OpenInsight teams grow and organisations looks for consistency within their programs, this new feature enables code templates to be created and saved for future use. These can be used for countless purposes, but one of the main ones will be to prompt developers for consistent opening comments that include a description of what the program does, who initially authored the code and on what date and details of any subsequent modifications. These code templates are stored in the System Editor ++ and a handful of examples templates are included with the 9.1 release.

Many of the new features in 9.1 have been lead by OpenInsight developers through your feedback, comments, suggestions, etc. Many of you have requested an ability to obtain a network user’s name and this is now facilitated trough the use of RTI_GETNETWORKUSERNAME.

I could continue for sometime yet as just about every part of OpenInsight has seen some change, turning what was expected to be a small patch release into another major release. For example, the maximum number of controls on a form has been more than doubled to 2048, ARev32 features eight notable enhancements as a result of a growing number of ARev conversions, WebOI sees a handful of changes and CTO includes the ability to create macros for use with the CTO Child and Standalone forms.

However, I’ll finish up with yet another couple of customer driven enhancements;

The first is the ComboBox Populator which has been enhanced to support a SORTBY tag. This now enables data in a ComboBox to be sorted as ascending left or right and descending left or right. Also, additional ‘literal items’ can be added to the list and they will appear at the top of the dropdown.

I am frequently asked for assistance with modernising the look of the user interface. Revelation have provided two such features in version 9.1. The first of which is the ability to add icons and text separators in your application’s menus – both the main menu and also the context menu and the two menu designers have been modified accordingly to make the process of adding icons and text separators as simple as possible.

Secondly, a new set of FOCUSCELL properties have been added. I’ll leave you to review the readme and OpenInsight help system for complete details, but to summarise, these new properties enable developers to take far more control over a specific EditTable cell. For instance a specific font can now be set for a cell, as can specific colours be set for the foreground and background colour of the cell that has focus. In addition, the border of the cell can be manipulated to change its line style and thickness. A new page and tab in the Database Manager have been added to the Environment Settings window and these allow the developer to set default behaviours for the application’s forms background gradient colours, EditTable FocusCell settings and Graphical Menu settings.

I personally think that this, along with version 9.0, is an awesome release and I’d like to express my thanks and admiration to everyone involved with the development of the 9.x releases. Roll on version 9.2!

Tuesday 1 September 2009

OpenInsight 9.1 Upgrade now available!



I am pleased to announce the release of OpenInsight version 9.1 and which is now available from the WORKS area on www.revelation.com. This is the latest version of Revelation Software’s flagship product and it takes the usual leaps forward in enhancements.

I will cover some of the main enhancements in another blog posting over the next couple of days, but those of you who have been eagerly waiting for the release need wait no longer.

Please note that this upgrade can only be applied to OpenInsight version 9.0 and you will need one of the new 5x5 authorisation keys from Revelation before you can install the upgrade. This can be requested using the OpenInsight 9.1 Upgrade Request Form in the download area.

Remember, if you have previously received an authorization code when you upgraded to a prior version of OpenInsight, you do not need to re-upload your Oengine.dll. However, if you have never applied for an authorization code, you will be required to upload the Oengine.dll for the site you are upgrading. You will automatically receive an email with the authorization code after the Request has been sent.