Alternative Method to Maintain Indices Or Any Other Repetitive Processes


If your site is running an engine server, you can take advantage of the built-in “System Monitor” feature to automate regular processes such as index updates.  If you edit, with notepad or similar application, your engine server’s configuration file (normally eserver.cfg, located in your OpenInsight folder), you may find a line that starts:

System Monitor=

Following the equal sign, you can specify the process you want to run, along with the application, user name, and password where the process should be run (comma-delimited).  Multiple processes my be specified, separated by semi-colons.

You can find out more about this useful OpenInsight feature in the OpenInsight Knowledgebase or by simply clicking here.

OpenInsight Authorisation Process


reauthI have recently been asked several times about the OpenInsight Reauthorisation process, how easy it is to use the process and what issues people might face.

The process is extremely easy when planned for because you have to get everyone off of the system and you need to make sure that there are no locks on the system, services running, etc.

The OpenInsight License Renewal and Installation/Upgrade Authorisation Process .pdf file that is located in the Documents folder under your OpenInsight installation contains ‘full’ details, but I have created a couple of videos and uploaded them to my usual RevSoftUK YouTube channel.

There are two videos.  The short video shows how quick and easy it is to authorise systems when the correct procedure is followed.  The longer video goes into a little more detail about why we need this process and some of the usual gottchas that we come across.  The longer video also has a couple of annotations about running the reauth.exe routine with administrator privileges if users don’t have adequate permissions and also about restarting the OEngineServer and other services that might be needed to run the application.

I hope that these videos are useful to developers and end users when reauthorizing their OpenInsight based systems for the annual renewals and also when adding additional users.

This process is applicable to OpenInsight 8.0.3 to 8.0.8, 9.x and it might be different for other versions of OpenInsight (i.e. the forthcoming OI10).

‘I never knew that’, The Calculator Trick


After a relatively quiet period, it is great to be back blogging again and sharing news and technical content relating to OpenInsight and Revelation Software in general.

OI10 is now just around the corner and I can’t wait for conference in April to see the new features, new look interface and all the good stuff coming in the new version of OpenInsight.

I hope to have more and more information about the new release of OpenInsight over the coming weeks leading up to and following the conference.  In the meantime, it is SRP and Sprezzatura that are keeping me busy with great technical content being published on their sites.

Today it is Sprezzatura’s turn and they have highlighted a little known, but highly useful tip for tracking down OLE errors in OpenInsight applications.

Tracking down OLE errors in OpenInsight can be more than a little tricky at times but last week, the guys learned that this task can be made super simple using the Windows Calculator.  As one of them said following the sharing of this tip ‘I never knew that’ and that is a phrase that I don’t often hear from the Sprezzatura boys.

The article explains how they went from a reported error of ” ” from the third party system (yes, you read that right, in it entirety the error was nothing, nada, zip) to a solution and another happy supported client.

Click here to read the full article.

 

Delving Deep into the OI BRW


BRW

I have been a long term fan of the new OpenInsight Banded Report Writer and those goes back to it’s introduction early in the OI 9.x series of releases.  So much so, I decided to take the stand at one of our RUGs and attempt to show our attendees what the new tool set was all about and what it is capable of.

It is a very powerful tool with a familiar design interface that most developers and power users should be happy with following a quick run through the BRW Reference Guide and working through the first few pages of the guide which builds your first report.

However, Don at SRP is in the process of taking the BRW and delving deep into the tool and he aims to reveal how developers can better understand the tool, its configuration and how to get the most from this powerful addition to the suite of OI tools.

His first article has just appeared on the SRP blog and its looks at Unpacking CFG_OIBRW, or more specifically the options for configuring the OI BRW for use and the advantages and disadvantages of each of the options.  There is also a link to the Wiki that he has set up and in which he plans to continue to delve deeper into the tool over the coming weeks.

If you are working with OI 9.x, planning a move to OI 9.x or want to get more from your reporting within OpenInsight, then this series looks set to be a must read.

How To – O4W Pagination


How to create an O4W dialog box using local pagination
If you are building a dialog box or using an existing popup in O4W with a high record count, you may want to consider building each page of the dialog box locally.  This will save on the time it takes the browser to build the dialog box because it will only need to build one page at a time.  The way it works is, you set the default paginator on the O4W Configuration screen to one of the local paginator choices or alternatively, you set the ‘overridePage’ parameter in the O4WTablePagerOptions API to ‘O4WI_TABLEPAGERLOCAL’.  Setting this flag will send an event to your O4W program when the next/previous arrows are clicked as well as any time a column is clicked that is set for sorting.

This post originally appeared in Revelation Software’s monthly newsletter dated 16/06/15.  Click here for the rest of this article.

Windows Powershell


Did you know…That the Windows Powershell scripting environment in Windows Server 2012 can be used to install several Windows features that are required by OpenInsight and O4W.

Typically these features are accessed through the ‘Roles and Features’ screen which requires you to search several steps in an installation wizard to find the appropriate roles and features to activate. This Knowledgebase artcile walks you through accessing the Powershell environment and issuing the commands in several easy steps to add the required roles and features.

Online OI resources.


I hope that my various online exploits help to evangelise and promote OpenInsight and the Multivalue technology more generally.  My resources are designed to provide a mix of news, insight, technical and other topical postings.

You will no doubt have picked up a few of my blog postings about Sprezzatura’s  highly technical blog and which is available from their website and Carl has been collating his exploits with OpenInsight 10 in his blog (Building OpenInsight 10) dedicated to the changes in the new release.

However, I was recently reminded that SRP also have a strong online presence with a number of very useful technical resources for anyone developing with OpenInsight.  Some of the links that they maintain are copied below with a brief explanation as to what they provide.

In the interests of sharing technical and product information, I would like to remind all of you who are working with Revelation’s tools that I am keen to use this blog as a central repository for sharing your news, technical tips and ideas, etc.  Of course, the Revelation discussion forums will remain king amongst sharing specific information about getting over problems and working through them as a community, but please use this blog as a vehicle to share some of your more light hearted moments, your successes and anything that is Revelation related.

Thanks,
M.

————————————–

  • SRP Wiki – This is the home of the SRP download page. The SRP wiki is SRP’s dedicated resource home for all things Revelation.
  • SRP Blog – SRP’s blog is called ‘The SRP Update’.  Like their Wiki, the blog is dedicated to the Revelation community and it features a link for people to subscribe for future updates.
  • SRP Newsletter – SRP’s newsletter is called ‘The SRP Review’.  This is a new publication for 2013 and it features quarterly editions.  Watch out for their next release coming very soon.
  • SRP Forum – SRP receive many questions regarding the companies products as well as general OpenInsight issues.  This resource provides SRP with a central forum to discuss the company’s commercial products.  The forum can also be used to ask and obtain answers to OpenInsight technical issues, but it is not seen as a replacement to the main Revelation forums on www.revelation.com.
  • Facebook and Twitter Pages – SRP have dived head long into the world of social media and they maintain a presence on both Facebook and Twitter.  As is the way with social media, much of the information is duplicated across the various resources, but this does enable you to pick your chosen delivery vehicle.