OpenInsight 9.4 “Roll Up” Patch v3


OpenInsight 9.4

 Revelation Software have recently released a third roll up patch for OpenInsight making it much easier for developers and users to keep their systems up to date.

This patch includes all previous fixes for OpenInsight 9.4 and replaces the original  “Roll Up” Patch v1 released on March 3, 2016 and the second “Roll Up” Patch v2 released on March 8, 2016. The patches included are as follows:

  • BUTTONDOWN Event Handler Patch for OI 9.4
  • SQL Connector Patch for OI 9.4 v2
  • Buffer Overflow Error Patch for OI 9.4 v2
  • RevelationDotNet 9.4 “Roll Up” Patch
  • RTI_TASKMANAGER 9.4 Patch v2
  • O4W Validation Patch for OI 9.4
  • QBF Patch for OI 9.4
  • Arev32 Descending Sort Issue Patch for OI 9.4 v2
  • Single Sign On Patch for OI 9.4
  • CTODICT.MFS Patch for OI 9.4 v2
  • Arev32 Conversion Utility Patch for OI 9.4
  • Socket Functions Patch for OI 9.4
  • O4W Popup Patch for OI 9.4
  • Base64 Encode/Decode Patch for OI 9.4
  • PREVVAL Patch for OI 9.4
  • O4WGRAPHDATA Patch for OI 9.4
  • RTICDOMAIL Patch for OI 9.4
  • Banded Report Writer Patch for OI 9.4 v2
  • Engine Server Patch for OpenInsight 9.4
  • Listbox Patch for OpenInsight 9.4

Works members can download this patch from the Works Downloads section of our web site.

New OI User Story


Plumbing Company Modernizes Services with Revelation Software
By Joyce Wells

New England Water Heater is a plumbing services company specializing in water heater repair and installation based in North Waltham, MA. The company provides a centralized service through a network of geographically dispersed plumbing companies in the surrounding region, including its own company, Home Services of New England (HSNE) Plumbing.

NEWH’s services include the sale, lease, installation, and repair of water heaters for non-commercial customers in the New England states, as well as other plumbing services, ranging from fixing leaking faucets to handling oil-to-gas conversions.

To support this work, the company provides a customer hotline in Massachusetts for more than 20,000 accounts. Revelation Software is the backbone of the overall IT system.

Goal
Today, businesses of all types are changing the way they operate. They are adopting hosted services rather than purchasing and maintaining software and hardware on-premises, and, as a result, employees also now frequently work remotely.

With the advances in IT services that have taken place over the past 5 years, NEWH saw an opportunity to move to a cloud-based system to support its employees and customers.  The goal was to improve its overall quality of service while also enabling office staff to access systems from home.

In addition, the company wanted to eliminate the overhead costs of office space, a local area network, and shared printers. Critical to the new set-up was the ability for its affiliated plumbing companies, as well as its own HSNE staff, to input information about service visits and billing into the system and access new assignments while on the road.

Process
In September 2015, NEWH and HSNE decided to eliminate their physical offices, where each employee was provided with a desk, telephone, shared printer, and a desktop computer connected to a local file server to perform their job, said David Harmacek of Harmacek Database Systems, who specializes in Revelation Software products. The process of publishing the company’s 28-year-old Advanced Revelation application to the cloud was handled by Harmacek, who has been a consultant to NEWH since 1994.

When the decision was made to migrate the system, NEWH had a typical Windows Server, internet connections, IP phones for customer support, and a range of website-oriented support interfaces, as well as a hybrid Arev (Advanced Revelation) 32 and OpenInsight 9.4 database system.

To modernize the operations, Harmacek put a plan in motion to switch to a hosted system and began implementing this new approach in February 2016.

The Arev32/OpenInsight system was migrated to a Parallels server. Since the telephones were already on an IP system, no adjustment needed to be made, but office documents and storage outside of the database needed to be moved to Microsoft Office 365 and OneDrive.

As a long-time Revelation Software customer, NEWH uses a system on Revelation’s OpenInsight 9.4 for business processes such as document management, phone calls, and customer support—everything but accounting.

Because the system is so critical to its business—handling processes such as document management, phone calls, and customer support—the NEWH migrated the system to the Parallels 2X RDP server, while also maintaining the physical system, to make sure that everything transitioned flawlessly.

Eventually, even though the company had not yet moved from its physical office space, it began using only the remote services, as if all the employees were working from home, said Harmacek. The dual on-premise and cloud approach lasted until late spring. By June 2016, the company no longer had physical offices, said Harmacek.

Biggest Challenge
“Working with a 28-year-old application, we found that there are many features that are no longer in use, while other capabilities are leveraged all the time and have been just working forever,” said Harmacek.

“The biggest challenge was eliminating the dependence on a local network for file storage and local printing, since the employees could no longer walk over to an office and hand someone a piece of paper, and they could no longer print anything,” he said.  This issue has been solved by using the feature in Parallels 2X that allows a local folder to be managed from the application. Reports and PDF files can be placed onto the remote desktop. Files, both PDFs and images, can be uploaded and integrated with the hosted database.  “Anything that needed to be done had to be accomplished by interacting with the system. I had to find all the places in the processes where this was needed and change the system to allow it to be done that way.”
Read On…

On the Road


SpectrumLogoLargeRevelation Software will be presenting at the International Spectrum 2017 Conference and Exhibition which will be held between the 1st May 1st and 4th May 2017 at Litchfield Park, AZ.

OpenInsight 10: The Most Modern MV Development Tool
You’re probably familiar with OpenInsight from Revelation Software, the MV development tool and database that was written for the Windows world. What you haven’t seen is OpenInsight 10 – completely rewritten from the base code up, it has a new, industry standard IDE for desktop Apps, a new web-based design platform for browser-based design, and as always our connectors to all the MV databases, cloud-based databases, and SQL.

In his presentation, Mike Ruane, President and CEO of Revelation Software will give a real-time demonstration of some of the features of OpenInsight 10, answering questions, and showing modules of specific interest to the audience. Attendees will be able to Download an evaluation version of the product.

Click HERE for more information.

DBTA – MV Vendors Look to the Role of MV in the Future


1P7A8552Database Trends and Applications have just published a new article that looks at the role of MultiValue technologies in the future.

Author Stephanie Simone, talks to six of the key leaders in the MultiValue community to get their viewpoint on the future of our great technologies into the future.

Here is what Mike Ruane, President and CEO, Revelation Software had to say on the subject.

“At Revelation Software, we are incorporating features, capabilities, and integrations into OpenInsight (our MultiValue database development environment) to address the challenges of evolving data environments.

We are providing MV developers with a browser-based rapid application development tool that lets them generate responsive forms, reports, and dashboards, and we are supporting the “develop once and deploy to the desktop, tablet, or a mobile device” design philosophy.

With a development environment that tightly integrates with the Git source code management system, we offer an environment that allows for collaborative development teams as well as source code management.

Moreover, our database development environment seamlessly integrates with cloud databases. Building applications that utilize NoSQL cloud-based data storage allows us to support large numbers of concurrent users, deliver highly responsive experiences to a globally distributed base of users, provide high availability, and also handle semi-structured and unstructured data.

Enhancing usability, OpenInsight offers a development user interface within MV that is similar to what developers outside the MV world are accustomed to, provides a database environment that utilizes industry-standard AES encryption and policies, and enables end users who work with MV data stores to view their data in today’s BYOD world.”

Your can view the entire article on DBTA’s website here.

OpenInsight 10 – Alpha 7


OI10whiteRevelation have made some good progress with the OpenInsight 10 Alpha and I’m currently working through my bug list and closing a nice number of reported issues from earlier alphas, something that I’ll continue with over the weekend.

In line with their open and transparent policy for OpenInsight 10, they Alpha v7 is now available for download to all Works Members.

The Alpha v7 is available as a full install. So, if you have worked with earlier alpha’s please use the AppBackup facility to backup your old alpha work and restore it into the new alpha.  This is what I do but one word of warning.  If you keep your data, images and other supporting files in a specific folder (I keep things in C:\RevSoft10.6\MDPmyApp) you’ll need to copy that folder from the earlier alpha and into the new alpha once installed.  The app restore will then use the new folder and the restore should run just fine.

This version includes many enhancements to the IDE, Form Designer, Table Builder and O4W, so it is well worth a look and to take the opportunity to report any issues that you find to Revelation and have those issue addressed before Revelation releases the beta.

OpenInsight for Web (O4W) v2.0, included in the OpenInsight 10 Alpha v7, is a rapid application development tool that lets you generate responsive forms, reports, and dashboards.  Use the powerful GUI drag-and-drop to lay out your forms and then test in both desktop and mobile browser mode. Or use the toolset’s full-function API to create the most sophisticated web pages.

Alpha v7 is set to expire on April 4, 2017.

Furniture Retail Operations Group Uses Revelation to Help Power its Business


The September 19, 2016 issue of Database Trends and Applications features an article written by Stephanie Simone titled Furniture Retail Operations Group Uses Revelation to Help Power its Business.

The Furniture Retail Operations Group (FROG) provides innovative, yet easy to use IT solutions for furniture and appliance stores.  Its mission is to create reliable and cost-effective methods that allow home furnishings retailers to operate more efficiently.

The company’s KISS system is a fully integrated point-of-sale solution for Windows built by experts in furniture operations to make companies more efficient in how they operate. In order to get the most out of this system, fix problems, and create new solutions and projects, FROG uses Revelation Software’s OpenInsight solution.

The OpenInsight Windows application is a big part of FROG’s ability to run its business, according to David Hatcher, director of software services at FROG.  Keeping the system running 24/7 to support customers means FROG needs a foundation that’s reliable and Revelation delivers that.

Choosing OpenInsight
“OpenInsight is what handles the data,” Hatcher said. “The nice thing is that it has a CGI (common gateway interface) for web-based data handling. An OpenInsight windows interface takes the same data from the internet, from an app, from a browser or from within the built-in Windows application all at same time, in real time. From any device, we can get into the system to manipulate data, keep track of customers, and do what need to do to keep business going.”

FROG’s data management system was created in the late 1980s on PICK mini-computers and Revelation technology helped the company move from that platform to the first DOS-based system.

“We’ve been able to maintain same data structure through those decades. Some code from the old Pick system was even ported to the DOS system and then later to Windows,” Hatcher said.  “The data control on even the new capabilities we develop often has 25 years of testing behind it so we don’t have many of the problems that can come up with new development using a new system.”

The ability to keep the environment stable while having the flexibility to evolve and change has been a key reason why FROG continues to utilize Revelation’s systems, he said.

Evolving with Revelation
In addition to using OpenInsight at the back end for many years, FROG more recently began using O4W (OpenInsight for Web) in its web applications.

“Most of our new development is on O4W,” he said.  “As we move more and more of the system to apps, eventually our system will eventually be 100% application-on-cloud and we’ll have no need for Windows anymore.”

The latest initiative FROG has underway involves OpenInsight and Google geocoding and tracking to route and monitor trucks, according to Hatcher.  “It has heat maps of where our customers are for ad purposes and we can see anything we want to know about customers through these maps which are linked into apps suite.”

Meeting New Goals
By working with Revelation, FROG has been able to shift technologically into anything, anywhere, Hatcher explained.  “The advancements with CGI and Revelation’s O4W keep data flowing out to the latest and greatest apps and that’s been extremely useful.”

Revelation is always ahead of the curve, keeping up with latest trends and sensing where the market is going, he noted.  “They react to new capabilities the technology sector is developing but also knows what to retain so we can keep the same database and stay on the leading edge,” Hatcher said.

‘The advancements with CGI and Revelation’s O4W keep data flowing out to the latest and greatest apps and that’s been extremely useful.’

Because of Revelation’s innovations and foresight it has never made sense to switch to another provider, he said.  Revelation’s ability to stay with the same data structure, move through several transitional kinds of interfaces, and ability to provide constant upgrades, has made it easier on FROG to keep its system going.

“We didn’t have to rewrite for all the changes,” Hatcher said. “The ability to transition has been greatly simplified by keeping data separate from the user interface as technology changes.”

What’s Ahead
Preparing for the future, FROG is in the process of enhancing its database to make sure it runs faster, and apps perform reliably and smoothly as the company runs into more internet networking situations, Hatcher explained. The plan is to be able to offer its services exclusively through apps in the cloud.

“Building apps for the system was a big step forward and we’re looking forward to having the ability to go into back end with a new engine Revelation is working on,” Hatcher said.

<Article sourced from Revelation Software’s monthly newsletter>

OI10 Alpha 3


OI10whiteThis is just a quick reminder that the Alpha 3 is available to all OpenInsight WORKS members via the WORKS area on http://www.revelation.com.

Whereas previous alpha releases were full installation only, this release is provided as a full installation or and upgrade, allowing you to continue any work that you have done in the previous Alpha 2 release.

This version includes many enhancements to the IDE, Form Designer, Table Builder and O4W.  In fact O4W sees a lot of change and it is now badged as OpenInsight for Web (O4W) v2.0.

O4W 2.0 is a rapid application development tool that enables you to very quickly and easily generate responsive forms, reports and dashboards.   This new version supports more drag and drop functionality and it now enables developers to lay out forms using the drag and drop features.  Once complete, you can then test them in both desktop and mobile browser modes, or you can use O4W’s full-function API to create the most sophisticated web pages for just about any mobile or desktop device that runs a browser.