10 + 10 = Ouch!!


So, I had some computer issues yesterday (not OpenInsight based I am pleased to confirm) but the end result saw me blowing my machine away and opting for a complete factory reset.  This is usually a pretty painful task, but ‘boy’, did I not know the half of it.  This posting is therefore a reminder for me and also to enable all OpenInsight installers to better prepare for their OpenInsight installations.

With my machine sitting with a newly installed copy of Windows 10, I updated my Internet Security and immediately dived into installing OpenInsight 10 on my machine – well it is the most important piece of software on my box and an application that runs my working life.  Well, I say install but I actually did what I have done a thousand times before and simply copied the RevSoft folder from my backup drive onto my new Windows 10 installation and launched the ClientInstall.exe to install those all important files that OI10 needs to operate properly. 5

Before doing anything with OpenInsight and as per the normal OpenInsight installation documentation, I took the added precaution and checked to make sure that I had the .NET Framework 3.5 and 4.6 installed on my machine.

All was good with both Frameworks displayed in the “Turn Windows features on or off” window.

I therefore ‘thought’ that I was good to go and copied over my backed up RevSoft folder, then I located and launched the ClientInstall.exe file using the ‘Run As Administrator’ option.  However, half way through the install I got the following warning.

1

Now, I know that I don’t have the later .NET Framework installed, so I clicked ‘Yes’ to launch the Microsoft webpage.  This presented me with the .NET Framework 4.7.1 option front and centre and that seemed like a good choice – well it can’t hurt to have the latest version.

Alas, after downloading the file and running it, I was presented with a Microsoft .NET Framework Blocking Issue warning and the only option is to Close out of the installation.   2

OK, so the OI system did say that I needed 4.7, so back to the Microsoft website and towards the bottom of the page are several options including 4.7.  Naturally, I downloaded and installed that version.  Alas, the exact same Blocking result:

3.png

I knew that I’d had the earlier version installed, so I tried 4.6 but, as expected I was told that it is already installed.  Out of desperation I thought I’d try the 4.6.2  version and success, it ran through a full installation.

4

 

Jumping back into the OI ClientInstall I ran the file and crossed my fingers.  Again, the installation failed.  OI really does want 4.7 and nothing else will do.

Time to dive into the ‘More Information’ link and something that I really should have done first off.  This presented me with a long page of different things that can affect the .NET installer but towards the bottom covering just a couple of lines is a note about the .NET Framework 4.7 needing the Windows 10 Creators edition.  Checking my machine and because this is a machine that is a couple of years old, I naturally have an older version.

So, into Update and Security and I began to download the upgrades.

6

With the first set of upgrades installed, I ran the updates check again and the system went off to pull down the Creators Fall Edition, one heck of a long download and almost as long to install.  This process began at around 10:00 hrs this morning.  It’s now gone 16:00 hrs and the Creators Edition is finally installed.  One last update check and one last batch before a final check and we are finally up to date.

7

This time when I ran the ClientInstall, the system ran through as expected with no call out to Microsoft and no need to manually install the Microsoft .NET Framework 4.7, that appears to be installed as part of the update.

8

Somewhat relieved that all now appeared good, despite nearly a whole working day taken to run the upgrades, I launched OpenInsight 10 and my application and it is now functioning exactly as expected – PHEW!!!

So, what is the moral of this sorry tale or woe, angst and dead ends.

The Number One Rule:  Make sure that you or your client have your windows 10 machines fully upgraded BEFORE you step through the door to undertake any software installation that needs a .NET Framework and especially OpenInsight 10.

I’d have hated to have arrived on a client’s site to install their new OI10 based system, to find myself sitting there waiting for Windows 10 machines to update.  One would hope that the machines will have been installed for a while and be fully updated, but you just know that there will be people who only opened the box and turned it on that morning.

Also, be warned that if you have to blow your machine away and back to factory settings and it’s running an earlier Windows 10 release, you will have to factor in a long wait.  I guess that there can be something said for keeping mirror image backups.

So, now that I have my OpenInsight 10 working you’d think that I’m about to dive in and continue with my conversion.  Nope, I’m off to coach archery and OI10 will have to wait until a little later.

Advertisements

OI10 Splitter Bars – Ouch and a smile.


splitterOn the whole, my OpenInsight 10 (OI10) Beta 4 conversion has been a major success and I’m now using the application on a daily basis and working on the UI to make it cleaner using the new tools in OI10.

However, one gotcha which we should all already be aware of, is the splitter bars that were introduced in OI9.  In that version, you simply dropped the controls on the form and it did its best to resize controls (usually edit tables).  The downside for me was a flickering screen as the form constantly redrew whilst the bar was being dragged by the user.

In OI10, Carl has introduced a new ‘MOVE’ event which enables developers to very quickly and easily handle the resizing of the controls to best suit the application.  In my example, I have a form with three panels (Groupboxes) and on each panel is an editable.  The panels are then set to autosize and the following code is added to the upper and lower Splitter Bars to managed the moving of the bars as needed.  The code below is taken from the Upper Splitter bar’s MOVE event.

Declare Subroutine Set_Property

// Adjust the window's controls as the user moves the horizontal splitter bar.

   // Get the bar "thickness"
   barH = Get_Property( ctrlEntID, 'HEIGHT' )
   
   // Get the bar initial position
   barP = Get_Property( ctrlEntID, 'TOP', YCoord )
   
   // Move the bar
   Set_Property( ctrlEntID, 'TOP', YCoord )

   // How far did the bar Move 
   barM = barP - YCoord
   
   // Move the upper panel control
   valPanelUpper = @window:'.GRP_ALF30DAYSPLUS'
   Set_Property( valPanelUpper, 'BOTTOM', yCoord - 4 )

   // Move the lower panel control and reset the height
   valPanelLower = @Window: '.GRP_ALF30'
   Set_Property( valPanelLower, "TOP", yCoord  + barH + 4 )
   
   valPanelHeight = Get_Property(valPanelLower, 'HEIGHT')
   Set_Property( valPanelLower, 'HEIGHT', valPanelHeight + barM )
    
return 1

Disclaimer: The above code is written by me as a non professional developer.  Whilst it works, it is not optimised, does not include any error trapping and does not promote best practice.  The above code includes comments to explain what it does.

I was initially disappointed that I would have to write code to manage the splitter bars, but now that this is done I really like the way that I have control over the controls that move and that the form no longer flickers when the splitter bars are moved.

For more details about OI10 changes, please check out Carl’s OI10 Blog.

 

I’m often asked who is a typical OpenInsight developer and . . .


Mike at last years conference.
Mike at last years conference.

I’m often asked who is a typical OpenInsight developer and why?  I pause for a moment, take a look at the current user base and this usually has me thinking back many years and to ‘why, those people chose to use Revelation Software’s products in the first place’.  That tends to be the more interesting question to answer.

When I look back, I see countless Value Added Reseller (VAR’s) and end users with growing systems and small teams of developers and in most cases one key individual.  That person may not have started out as a software developer, in fact, they are very frequently not a trained software professional at all and they usually come from a totally different background.

I could use numerous individuals as an example, people that started out in a profession, became frustrated with the software solutions available to them and who went on to build their own solution and then to begin offering their solutions to the benefit of hundreds of others (friends and customers).  I don’t paint myself in the same light, but I will use myself as an example.

When I joined Revelation as an ‘Internal Sales Engineer’ (some 15 years ago), I was given Lotus Notes to use.  It came to the end of its useful life within our business and we moved to Act, that was not up to the task and we tried Goldmine, that was too difficult to get data out of and we moved to Maximizer.  I then began to learn about developing the Maximizer interface to give me the data views (datasets) that I needed to support my job role.  All was good for a time and then the authors decided to go the MS SQL Server route and I found myself facing a five fold price increase with decreased functionality – actually, it got so bad, I found myself looking for another solution.

Enter a little plug in for Outlook and once again more frustration.  All seemed to be pretty good initially and then it crashed Outlook, resulting in a restore and time setting everything back up again and lost work hours.  A second occurrence, and then a third.  I used to fly (a Cessna out of RAF Henlow as a work bonus) and I was reliably taught that when three things go wrong, you don’t fly.  I live by that rule even now, so three strikes and the Outlook plug-in was out.

So what next???

Unsurprisingly, the solution was staring me in the face.  It often is in life.  You just need to open your ideas to something new.  I had access to OpenInsight, I had access to some of the best OpenInsight developers on the planet and I had begun to dabble in my own product demonstrations, building simple databases, forms, reports and the like.

So, like many people before me, I was that individual with a need.  A need for a software solution that worked with me and which supported my job role.  I knew my job, I knew what I needed to support that job role and I just needed to get on and build my own system.  And, that is just what I did.  Over the next couple of weeks, with the help of my colleagues (usually Aaron fixing things up in the car whilst I dropped him home from London to Northampton, or Mike on one of our long UK road trips between RUGs and client meetings) I wrote a basic contact manger for RevUK and I have gone on to add to that as it has grown and evolved with our business – much like just about every other Revelation based system that has been running for any length of time.

So why the long and protracted story?

Well, I guess that I’m finally proud of what I have built.  In fact, I knocked up a comprehensive system to manage our archery club (Andrew helped me to build a wicked tournament module that saved a lot of time collating results for multi-round tournaments) and again to manage a small photography business I dabbled with for a time – I wrote that one totally on my own.

But, the real reason is to outline Revelation’s traditional application developer.  Yes we have developers join us and our clients teams who have studied computer science, obtained degrees and can work in one of many different programming languages.  But, this posting is about the individual entrepreneurs, business leaders and department staff members that have the vision and who have used ARev and/or OpenInsight to help them to realise that vision and build that perfect application.

It is those people that take OpenInsight, build solutions and enhance their working lives and who then often go on to enhance the working lives of their colleagues and then their clients.

Furthermore, it is OpenInsight that sits in the middle ground between the lower end fully integrated database tools that are designed for the individual and which are not really scalable and which have their limitations, and the professional software development suites that need degrees and expensive training to master them.  These large systems often need knowledge about; third normal form, inner and outer joins, record locking, working with datasets, how to write and debug code and how to bring several disparate technologies together.  No small undertaking for an individual in an organisation with little time on their hands, but who needs a solution quickly to support their work function.

OpenInsight sits right between these two categories of products.  It’s is fully integrated with everything you need in one toolset – desktop and web development tools, database, user interface, reporting, data warehousing tools and more.  Plus, it is scalable and we have systems supporting hundreds of users over LAN, WAN and Web (mobile) environments.

Better still, with the upcoming release of OpenInsight 10, Revelation are once again providing application development tools that anyone can take to build solutions.  It is amazing how much can be done without having to write code, and how you can then take those systems and easily deploy them to end users, and then how you can further enhance those systems WITHOUT the need to re-engineer your system all of the time.

Interestingly, the team have done so much to enhance the application development process in OI10, I now find myself deleting thousands of lines of cobbled together code in my contact management system, in favour of simply setting a property or two in the designers property panel.  For me, the benefit is setting one option or typing in a value (into a property) to use professionally written code and a better, more optimised and robust solution.

Yeah Mike, I’m giving OpenInsight 10 a double thumbs up as well.

OpenInsight WORKS subscribers can get their hands on the OI10 Beta right now, just log into OI WORKS and locate the OI10 Beta Gateway on the main WORKS page on www.revelation.com.  If you are not a WORKS subscriber, please get in touch and I’ll be pleased to see how we can help you to get into OpenInsight.

OI10 Milestone Reached


OI10logon

As many of you will know, I have been diligently working with the OI10 Alpha releases and more recently the Beta’s which include the internal releases and those released to our WORKS subscribers.

My initial aim was to assist the development team at Revelation, working mostly with the Forms Designer and it’s ossociated tools, in catching as many issues as possible before we go to a final release.  When I saw the conversion tool, I began to dare to hope for a one click conversion, at the same time knowing that such a thing is usually far from possible.

However, with the release of the Beta 4, I am alot closer to that elusive one click conversion. In fact, I’m ‘alot closer’ than ‘alot closer’.

Like many of you, on Friday, I downloaded the Beta, ran through the install, created a new application and waited expectantly as the system ran through the conversion of my contact manager that I use at Revelation day in and day out.  The new conversion tool wizzed through the entities, with lines flashing up on the right side of the new conversion window and the categories of items to be converted were slowly and steadily checked off . . . done, done, done, done.

I had a couple of red categories, but a quick check of the log showed that these were items that I did not have to worry about.  Legacy items that I really ought to have deleted prior to the conversion, but easily deleted in OI10.

So, how did we do?

Much, much, much better than I had hoped.  Sure, my splitter bars no longer work, but I knew about those and I’ll blog about them later. My legacy and poorly written code is fighting OI10 in one or two areas but I’ll be removing hundreds (if not thousands) of lines of my cobbled together code in favour of OI10’s professionally written code that will be better optimised and correctly error trapped.  So those issues are not really issues for me and they don’t stop the application from running.

So, as of Friday afternoon, I was both developer and user of my system under OI10.  I’ll be removing code and changing some of the interface components (for example, my combersome three state buttons and associated GOTFOCUS and LOSTFOCUS code, in favour of the new Glyph buttons), so further developing the converted application.  Plus, I’ll be using the application to support my job role.  Something that I thoght would be a little way off and following a hefty conversion task (project).

The guys are doing an outstanding job with OI10 and the project really has turned a corner.  So many things are finally coming together and it looks like some of the technologies that the guys have had to wait for, are now available to them and the toolset is going forward in leaps and bounds right now.

They are also cracking on with the reported bugs, leaving wishes for later.  For example, I have cleared down no end of officially reported bugs in the OI10 bug tracker.  But, what you don’t see is the internal emails and reports that I send to the guys.  Carl had a ten page report for the conversion tool for my system at the initial internal release of the new conversion tool.  By the final release of the beta 4 (in you are a WORKS subscriber, that is the one you can get your hands on), this was down to six items and a couple of new ones that I have found. [Edit – Oneof those items was user error and another related to my code].

Remember, we are still in beta so issues will remain, but I’m blown away by what OI10 is proving to offer developers.

I’m often asked who is a typical OpenInsight developer and . . .   Well, lets leave that for another posting, I’m keen to get back into working on my brand new user interface – or should I rephrase that to, “the old one simply reworked” – but it feels brand new.

OpenInsight 10 Presentation Server


OI10white

OpenInsight 10 Features –
OpenInsight 10 Presentation Server

The OpenInsight Presentation Server is a core part of the OpenInsight Development suite.  It hosts the OpenEngine virtual machine and provides Basic+ programs with an object based interface to create and manipulate Windows Desktop Applications.  As well as providing the capability to create your own applications, the Presentation Server also provides the actual OpenInsight development environment itself, which comprises the IDE and its associated tools.

Download a copy of the OpenInsight 10 Presentation Server Reference Manual HERE.

PLEASE NOTE: The OpenInsight 10 Presentation Server Reference Manual is currently a work in progress and is may well change between now and the release of the OI10 final release.

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.

Another day of learning in Houston.


1P7A8706Well today was another full day of socialising, learning and inspiration.  Sorry for the brief overview of my day, but tomorrow will be a long day and I’m still putting to bed a photo presentation for the morning.  It’ll also be going online somewhere next week, so watch for more when I’m back home.

Today (we’ll yesterday now), began with breakfast before we broke into two sessions.  I’d listened to Carl yesterday, so it was a hour or so with Bob Carten on the changes to Indexing and Selects.  With help from others in the community Bob has done allot of work on performance profiling of OpenInsight and he is putting that knowledge to good use.  Some long standing assumptions have been dashed and set aside and we can look forward to a new set of OI profiling tools that will help to achieve performance increases within our systems.  Bob has seen increases of up to 30% in places with regards to Selects and Indexing.

Performance and system profiling is an extremely hot topic at the moment with many of my customers and you really needed to be in this session to fully understand the work that Bob and the team have been doing in this area.

Mike followed Bob in a session that looked at the new Forms Designer and some of the new controls that we can look forward to.  However, from my point of view, it was great to see first hand just how easy it will be to utilise much of the new GUI design elements without having to learn and write new code.

Lunch was a wonderful Italian themed affair with lots to choose from.  Refreshed and ready for more, we all joined Mike in the main hall for a session on what is involved with moving an OI 9.4 and prior application to version 10.  The process is not an upgrade, it’s a conversion and Revelation have built tools to, not only help developers through the conversion process, but if you decide to copy the tables over, the process will optimise them as well – a double bonus.

Mike included allot of useful information about preparing for the conversion process and he confirmed that there are numerous ways to achieve the conversion.  As usual there are two ways to do it well, two ways that’ll get your there and two that are not ideal but they’ll get you there all the same.  The attendees, now know at least one of the two best ways and this session provoked allot of questions, so this is clearly something that developers worry about and want to do right first time.

The afternoon got a little heavy for someone with my limited technical understanding but Bryan’s presentation about the Engine Server was not only entertaining (as usual) but highly educational.  We learned how to properly configure and control the engine server and much more.  I the other room, Bill and Dave educated their audience on the introduction of R/List into the Banded Report Writer.

I finished up the afternoon listening to Bill talk about the new OpenInsight Authentication Module that is coming in OI 10 and which ‘can’ be made available to developers using 9.4, on request.  This is another highly topical subject and questions flowed throughout and not least from people building web based solutions.

The weather had turned today and the evening rounded out with a lovely dinner in the Palm Court.  It was a little cold and damp for the planned pool side party.  However, everyone had a great time and many of us took the advantage to catch up with people before we all head off for home tomorrow lunchtime.

That’s it for now.  We have an early start and a long journey home tomorrow and I need some shut eye.  Please watch the blog for details of the photographs and video presentation being published on-line and also how to get Dan’s motivational download.