Category: O4W


In the final quarter of 2010, for the first time, sales of handheld mobile devices – defined as smartphones and tablets – exceeded sales of “conventional” connected devices, such as desktop systems and laptops. Although the overwhelming majority of businesses continue to run their essential operations (ERP and CRM) on desktop GUI devices, most client-facing software development in the last decade has focused on internet applications, targeting web browsers running on these conventional systems. With the ascendancy of the handheld mobile device (with their different form factors and varying communication and processor speed), these internet applications will have to change to accommodate the different environment at the same time they grow in importance.

Grouping together smartphones and tablets as “handheld mobile devices” blurs the very large differences amongst the devices in this group, and obscures – but in no way remedies – the problems with building software that works well with all of them. These differences fall into three categories: form factor, connectivity, and software.

READ ON…

Revelation Software are now very close to releasing OpenInsight 9.3.1 and please watch this blog for further news about the release over the next few days.

Although this is a point release that follows the main recent 9.3 release, this new version features the usual enhancements and fixes and a brand new data connector that will enable MultiValue developers to interface OpenInsight with Ladybridge’s QM database.  Already well tested during the beta cycle, this new connector will feature in a new commercial solution from Stage7 – watch out for more news on that right here and as it breaks.

As well as the QM connector, this new release sees 8 customer lead enhancements to the Banded Report Writer, 15 enhancements to O4W including support for ad hoc reporting, rss maintenance, mobile features (including a separate graphing library, run report function for mobile reports, etc) and much more.  The release also sees some fixes for ARev32, OpenInsight’s .NET functionality, fixes requested by you through the suggestions and bug tracker on revelation.com and work on the BFS / Connectors.

Those of you who are WORKS members will be able to download, review the full readme detailing the changes and take advantage of this new release very soon.  Please contact me if you are not a WORKS member and I will gladly email you a copy of the readme file so that you can see what you are missing out on and learn more about the new features that will no doubt be helpful and enhance your OpenInsight applications.

OpenInsight 9.3.1 is currently in beta testing and it is planned to be released in early March 2012.  The 9.3.1 release of OpenInsight will provide the following new components:

  1. OpenInsight for Web (O4W v1.3)
    O4W v1.3 includes additional integration with the new Banded Report Writer, support routines for RSS feeds, and a new “ad hoc” report builder, along with a number of additional mobile enhancements such as mobile-specific menu and report output.  Through O4W’s integration with jQuery Mobile (the companion library to O4W’s jQuery), web pages can be built using “finger friendly” user interface elements and design.  For a preview of this interface click here to view some screen images of Megamation Systems DirectLine Mobile application.
  2. OpenInsight for QM Connector
    The OI for QM connector provides the ability to connect with the OpenQM Database from Ladybridge Systems Limited.

Also included in OpenInsight 9.3.1 are a number of patches and enhancements for the Banded Report Writer, Table Builder, Database Manager, SQL Connector and Arev32.

As many of you will know, the WORKS discussion forum has been O4W driven for sometime.  That same format has now been used to rebuild the open discussion forum on www.revelation.com using O4W.  I really like the new format and I hope that you also find it better than the old Lotus Notes solution.

Continuing with the O4W theme and the US website, Revelation have also rewritten and updated their ISV Catalogue using the O4W toolset.  I am currently working on updated product information for the Sprezzatura Freeware and other chargeable utilities that we offer for the catalogue and Revelation are also offering any OpenInsight VAR the opportunity to have their OpenInsight based application/s listed on the page.  Please contact info@revelation.com should you wish to have your application featured.

O4W is fast becoming the tool of choice for OpenInsight developers who need to extend their applications to the web.  These solutions consist of full desktop browser based solutions, through to solutions for small handheld devices like smart phones.

Megamation Systems  have used O4w to create a solution for such devices and Revelation have recently published some images of the handheld solution.  This is a great example of how O4w can be used to address a modern business need. You can view the example screens by clicking here.

Whilst the wizards in O4W can help developers and power users to build some very nice online database driven applications in super quick time and without the need to write, debug and maintain Web2.0 code, it is no surprise that the true power of O4W is held within O4W’s extensive API.  However, whilst most OpenInsight and ARev developers take to building web pages using the API like a duck takes to water, HTML coders with only a little (or no) BASIC+ knowledge might flounder and find themselves on a shallow, but still unwanted, learning curve.

It is for this reason that Bryan has put together a very, VERY, useful cheat sheet to help developers with HTML knowledge to quickly and efficiently apply that knowledge to building O4W pages using the API.  The cheat sheet is split into three key sections with each showing the HTML tag, attribute, style, etc. and the corresponding O4W API attribute (I hope that I am using the correct terminology here, but someone will correct me if not).  The three sections include:

  1. A non-exhaustive list of the HTML generated by O4W.
  2. A non-exhaustive list of the attributes and styles that O4W generates.
  3. A variety of HTML5 compliant APIs used to support both mobile and newer (HTML5) browsers.

O4W API calls generate HTML in addition to javascript, and occasionally it is useful to know which O4W call generates which HTML.  For example, when searching the internet for a particular solution to a problem, the results will usually be displayed as “regular” HTML; to convert that information into useable O4W calls, it is important to know which O4W calls will return the desired HTML.  This cheat sheet is therefore especially useful when used with the main O4W Reference Guide which documents all of the O4W API calls.  If you are familiar with HTML, then you can look-up the HTML in the left column of the table and then the sheet will give you the corresponding O4W API call to use in the right hand side column.  Armed with this information, it is then a simply task of checking the O4W Reference Guide for more detailed information about using the O4W API call.

As Bryan says, “It’s likely that at some time you’ve found yourself working in O4W, and wondered how to accomplish a specific task (like changing the borders on a table, or generating pre-formatted text).  You probably turned to Google (or your favorite other search engine) (but most likely Google) and found the answer in a few seconds – but the answer told you what HTML you need to use to generate your desired results.  How do you translate that HTML back into O4W API calls?”.  It is this cheat sheet that directly addresses this need.

I have had a change of heart.

Since announcing the RUG and O4W sessions in London, several things have happened which have caused me to rethink my plans for the O4W training session.  It has become clear that there is significant interest in the new web technology, but with the economy the way that it is, people are finding it hard to get a second day off work, to secure the fee and also the associated travel expenses.

We are confident that you will love O4W and want to base your future web and mobile development on the technology.  In fact, we are so confident; we have decided to waive the fee.  However, that comes with a few conditions.

Firstly, we will no longer be holding the O4W day at the Hilton Metropole.  Instead we will be holding the day at our Ealing offices.  This does therefore mean that we will need to restrict the number of attendees to just the first eight registrants and also limit the number of attendees to just one person from any one company.

For this reason I would urge you to contact me as soon as possible.  I’ll be creating a waiting list for those people that miss out on the available places.

Please note – I will be happy to bring O4W to you and run through the technology at your offices or online through WebEx, but remember that I am NOT a programmer and I will not be able to cover the O4W APIs in the same way that Mike will be covering them at this FREE O4W session.

I am pleased to confirm that the venue for the RUG on the 8th November and the O4W training the day after has finally been confirmed.  Both days will be held at the Hilton Metropole in Edgware Road, London and I have included an outline agenda below.  Please note that numbers will be limited for the O4W training day.

I hope that you will be able to attend the RUG as Mike’s presentation is set to be very informative and it will have something for both develoeprs and end-users.  The O4W day is an absolute MUST ATTEND if you are involved with (or planning) any web development for desktop browsers
and/or mobile devices.

During the RUG, Mike will be concentrating on some of the new features in OpenInsight 9.3.  Many of these will enhance your time developing with OpenInsight and there are some useful additions to help end-users gt more from their OpenInsight based applications, such as the brand new Banded Report Writer.  This is set to be the reporting tool of choice in OpenInsight going forward and reports written in the BRW can be run from both OpenInsight desktop applications and also O4W based applications.  In addition, we have Data Encryption at Rest featuring as part of the 9.3 major enhancements.  Written to address the legislative requirement in the USA from Jan 1st 2012, this is a technology that we should all be looking at and I can see European governments following suit and forcing compliance on us here in the EMEA region in the not too distant future.

If you are an OpenInsight developer, End-User or someone working with or thinking of using a MultiValue toolset, then this really is a must attend event.  With data connectors for Rocket’s Universe and Unidata (U2), TigerLogic’s D3 and SQL, and with connectors for mvBase and QM coming very soon, Revelation are opening up the toolset to make MultiValue application development and reporting over the desktop and web even easier, faster and therefore cheaper.

Please contact me without delay if you have not already registered your place and you would like to now.  Please also drop me a line if you would prefer to discuss the value in attending either of these two events.

RUG Agenda (10:00 till 17:00)

  • 09:30 to 10:00      Coffee and light refreshments
  • 10:00 to 12:30      Mike Ruane – State of the company, futures and 9.3 new features
  • 12:30 to 13:00      Lunch
  • 13:00 to 14:00      Andrew McAuley – GUI Special FX in an OpenInsight application
  • 14:00 to 16:00      Mike Ruane – continued review of OpenInsight 9.3 new features
  • 16:00 to 17:00      Close and General Networking

O4W Training Agenda (09:00 till 17:00)

  • 09:00 to 12:00      O4W Introduction to the wizards
  • 12:00 to 13:00      Lunch
  • 13:00 to 16:00      O4W Introduction to the O4W APIs
  • 16:00 to 17:00      Questions and Answers

I look forward to seeing you in London on the November 8th for a great day.

Following the highly successful conference in Las Vegas last week, RevSoftUK are planning to hold a Revelation User Group meeting on 8th November 2011 somewhere in central London. Whilst the timings and venue are yet to be confirmed, the agenda will be given over largely to Mike Ruane during which he will explore the new features contained in OpenInsight 9.3 and O4W, talk about the state of the company and plans for both OpenInsight and O4W in the future.

Consideration is also being given to holding a mini O4W training session on Wednesday, the day after the RUG meeting. The venue will likely be the same, making it easy for people who wish to attend both days and stay in London. The training session agenda is yet to be confirmed, but it is likely to be an informal (presentation style) session where the use of the wizards will be covered in the morning session, with the powerful APIs covered in the afternoon.

The RUG will be a free of charge event, but there will be a nominal charge for the O4W training session. Please contact me if you would like to provisionally register for either or both of these two days and I will email you with further details as I have them.

Bryan Shumsky presenting the O4W API talk.
Bryan Shumsky – Chief O4W Architect.

Wow – I landed back in London on Saturday morning and my head is still spinning from my whirlwind trip to Las Vegas last week for the latest Revelation Users Conference. Those of you that followed my week on Twitter (#mdprevcon) will have had just the tiniest taster of what was going on, what people were learning about and the absolutely amazing things that Revelation and OpenInsight developers are doing with the OpenInsight tools at the moment.

Before I get into some of the highlights, I’d like to say a huge thank you to everyone that made the conference such a success. Mike, Nancy and the team at RevUS put on a flawless event, although sunny Vegas became a cold wet soggy sort of place whilst we were there. That said, the presenters brightened up the conference centre with some very well delivered and highly informative talks and the food was just amazing. I’m not so sure about the unusual attempt to heat up one of the Rio’s towers during the conference though ;) . Hopefully, those in the tower affected were only inconvenienced and nothing more.

The conference got off to a flying start for me at the welcome reception on Tuesday evening. This was only a couple of hours after I’d flown in, so after a shower and change it was off to the conference centre. My time at the welcome reception is usually taken up by working the foor like a tyupical salesperson, but on this occasion it all turned topsy turvey.  Instead, I had plenty of people (new faces and familiar ones) finding me and wanting to talk about my blog and the videos that I have been producing since the last conference and to make some requests. Retreating towards the door for a quiet few minutes to catch up with Bryan, I met a couple of gate crashers from the RV conference going on in one of the adjacent rooms. An initial Q & A about what each of us did, established that they were Unidata users/developers who provide a web based solution and who are unhappy with their front end design tool of choice. Well, red rag to a bull or what!!! On came the OpenInsight and O4W pitch and they were quickly hooked on the idea of exploring OI. Better still, whilst Bob Catalano spoke to one of them about the tools and piled on even more sales pitch, I diverted into an F1 exchange with the other. It is always nice to have multiple interest points.

Following the welcome reception, the conference got off to its real start on the Wednesday morning. Mike opened the conference promptly at 09:00 with his welcome address. This consisted of the usual product update review since the last conference – so 9.2, 9.2.1, UD & UDH 4.x and of course what would be the star of this show – O4W. Mike went on to explain that O4W has now replaced WebOI and the Sierra Bravo dashboards in OI and those technologies are no longer officially OI supported products. He also highlighted that the current development resources are working on 9.3, which is currently in beta, and ‘relaxed development’ on version 10. He then turned to the main topic of his address, being future developments for the Rev team.

These futures centre around five key areas being The Cloud, Portable Devices, Windows 8, Connectivity and 64-bit OpenInsight. So as to not bloat this posting too much and to keep the more pertinent topics more easily accessible, I’ll touch on those topics one at a time over the next few days.

Following the welcome address the conference split into the usual two track technical session format, with a difference. One of the main highlights of this conference would be O4W and attendees were to be treated to two three hour training sessions that would cover both the wizard interface and the O4W API separately. Owing to the importance of this new technology to every OI application developer, these sessions would be single tracked giving everyone the opportunity to attend. Bob Catalano took the first session in the morning on Thursday and then Friday morning was handed over to Bryan Shumsky to cover the API. More on those later. Otherwise, there was only one change to the published schedule. Owing to Carl Pates’ lost voice (well Vegas is a big place to find lost things don’t you know), Mike would be covering the Banded Report Writer as my first session, replacing Carl’s postponed talk on Cloud Computing.

I had been privileged to have a one on one sneak peek at the Banded Report Writer with Mike a few weeks ago, but I was still surprised to see how functional it is and I’m now even more convinced that it will quickly become the reporting tool of choice for developers AND end-users running version 9.3 and later. The interface is very new and fresh, but better still it is one that most users will be familiar with and happy to use. There are countless properties available and these can easily be viewed and set using the exposed properties panel – very nice for power users creating their own reports. The BRW supports multiple fonts, barcodes are built in and you can utilise all of the standard image formats and graphing within our reports. The BRW also features report groups and sub reports. Mike showed the power of embedding a sub report in a main report and grouping reports to be printed as a collection is a great feature for many managers and people running end of month reports and the like. In addition to all of the usual power afforded to developers through LIST statements, the BRW includes super easy to use wizards to make the tools even more attractive to end users. Could this replace third party reporting tools like Crystal reports with OI – I think that it just might!!!

Whilst I was listing to Mike, Jared was educating system administrators in the Practical Guide to OpenInsight Applications. Reports from attendees of that session during the break were extremely positive with many people picking up new tips and best practice advice. Let it not be said that Rev’s conferences are only for the hardened OpenInsight developer – the team really does cater for everyone.

Session two saw Alexander Holliday taking on the topic of Thorny Problems with UTF8, but I dived into Aaron’s (Sprezzatura) talk on MFSs and BFSs. A topic that I knew I would struggle with, but with these terms coming up more and more these days I wanted to at least conceptually understand the hype. I’m glad that I did attend, as the presentation was easily followed by someone of my limited ability, even if I’m never going to fully understand and apply such things.

Following lunch, we all headed off to another single track presentation during which during which Mike would look at the new features in 9.3, another must attend session, so I was glad that I did not have to choose between topics. Many of the new features have been, or will be, covered on this blog and elsewhere, so I’ll not go into details. Needless to say, the highlights were over 1000 new or enhanced entities, updated exe’s and dll’s, new .net features, the BRW, O4W mobile features and Data Encryption at Rest. Oh and Mike also touched on the new Google Visualisations in O4W – what was it he said, oh yeah – “They are wicked, wicked cool”.

Prior to the lunch break, I joined Jody Summers for a review of what they have achieved with O4W for their eTraumaBase application. From some plain html beginnings, they have used O4W to create a very nice looking and functional system. Learning that they had a proof of concept in just three days and then a working prototype in less than three months, left attendees of this session with no misunderstanding that O4W can deliver and very quickly. Whilst Jody was talking Don Bakke (SRP) was presenting the first of a two part session on the Art and Science of Form Design, Kevin would then complete part two following the lunch break. I’d have liked to see these two sessions, but my afternoon was spent in the company of Bob Carten learning more (at least conceptually) about the art of integrating .net into OI applications.

The evening was then consumed by a busy Vendor Fair during which I found little time to eat and surprising little alcohol was consumed by everyone at the event. Are we all becoming more conservative in our drinking habits these days, or were we just overcome by all of the great things going on and the opportunity to share successes with friends and colleagues? Working the Sprezzatura stand, the main interest was in the new Sprezzatura Framework (to be rebranded and commercially released soon) and Carl’s wonderful Engine Server Farm. With a rapidly diminishing voice, Carl spent most of the evening spawning engines and watching them elegantly disappear off of the screen ready for them to respawn as needed again.

Day two began with the first three hour marathon session with Bob running through the power of the O4W wizards. During the session he looked at using the Engine Server in debug mode (a must when developing), creating forms, lookups, reports and dashboards. All super easy stuff that any power user can take on with a little training or self tuition using the Quick Start Guide (or my O4W video series).

After lunch, I headed off to another of Bob Carten’s talks during which he would run though the complexities of Data Encryption at Rest – a new feature in 9.3. This new technology is important for anyone working with sensitive data, but even more so if you are in the USA (or selling systems for use in the USA) as there is new legislation coming online on January 1st and which requires data to be encrypted at rest. A quick show of hands demonstrated that most application developers are not ready and are unlikely to be ready for such changes, but this DER technology in 9.3 will help those people ho need to comply. The session was a little heavy for someone of my skills, but DER should be easy for anyone with any application development knowledge. However, whilst the DER functionality built into OI 9.3 gets your started, the whole topic of DER is much larger and Bob recommended some useful resources that touch on the wider topic of user education.

Whilst Sean spoke about the Commuter Module during the first afternoon session, I headed off to Andrew’s (Sprezzatura) session during which he would undertake a live presentation (no PowerPoint needed here) looking at Special FX. The lack of PowerPoint use quickly became obvious when we saw windows sliding open or moving around the screen and other animations taking place. Then again, whilst Andrew reviewed the reams of code (I exaggerate a little) needed to make these stunningly visual effects. Whilst some work is needed, these wonderfully pleasing user interface techniques really can be used to bring your applications into the 21st century and, better still, help to set you apart from your competition.

Following the lunchtime break I headed off to listen to Stefano Cavaglieri share with us the Management of Multifunctional Information and how OpenInsight has helped him to manage multiple languages and other multifunctional requirements within his sound archives application. Meanwhile, Don from SRP shared with his audience how to “Go All In” using a Framework to develop winning OpenInsight applications.

Following the formal part of the day, proceedings took a more leisurely turn and a few hours where I personally learned a lot and had more than enough fun. The lunch room had been turned into part seating dining area with a superb buffet and part casino with craps, roulette, poker and Black Jack tables around the far and side edges of the room. I’m pleased to say that I was quickly a good few hundred dollars up playing Black Jack with Kerry and Vickie. Then, following a bite to eat, I headed off to the poker table to learn how the betting side of things worked. I had a rough idea of the hands, but the betting side had always eluded me. Time to find out. Well almost, I was fine with the blinds and betting process, but I got somewhat lost when going all in and various pots being shared out – a few more lesson needed I think before hitting the tables for real. Anyway, playing with the dummy chips provided, I quickly amassed a nice little stack before going all in at nine o’clock and what I thought would be the last had. Surprise, surprise, the stack increased significantly, but then Mike looked over the table and called one last hand. Damn – all to do again. We’d all decided to go all in with Kevin (SRP) and I having a fair old stack of chips in front of us. I started with a Jack and another card (can’t recall what), but the river (hope I have the term right) threw up another two Jacks leaving me with a healthy three jacks. So, all in again Las Vegas Casino style and it was Sprezz versus SRP. Kevin followed suit and a reveal of the cards had Sprezz beating SRP (woo hoo – all in the best spirit of course), but wait!!!! Quietly down the other end of the table a full house was produced and all my lovely chips disappeared down the other end of the table. Well Kevin, I guess that you had the last laugh and I learned a lesson that there are plenty of surprises when gambling. I’m glad I don’t try it for real and that I’m never tempted to.

Friday morning came around far too quickly. The second of the two marathon O4W training sessions and this time Bryan would leave me behind as he waded through the power of using the O4W APIs to create dynamic custom web forms. I kept up with Bryan until the break, but the one message that I took away was that the real power of O4W is hidden away in the power of those APIs and that developers can easily use their Basic+ skills to weave some wonderful online database driven solutions using OpenInsight.

The conference was closed by Mike with a hint of the next conference being held in about 18 month’s time. The venue is yet to be decided and Mike outlined the parameters that make the decision and called for suggestions. We saw some of the photographs taken during the show, the vendor fair prise was handed out and the sponsors were thanked. With a shuttle scheduled at the close there was only time to grab my t-shirt and conference CD, say a few far too hurried goodbyes and I headed out the door for the airport and left a highly successful and well run conference behind me.

Finally, I’d just like to thank everyone that took the time to find me and comment on my blog and mostly the videos that I produce from time to time. The videos do take some time to plan and put together, but it was great to learn how useful some of you find them and I will keep them coming as I come across topics that are within my capabilities to do justice.

Follow

Get every new post delivered to your Inbox.

Join 67 other followers