New Create User Details function


RTI_CREATE_USER_DETAILS function for OpenInsight 10.0.5 and above.

didyouknowoi

OpenInsight 10 provides support for login policies including locking out of users after a definable number of unsuccessful attempts, password construction requirements, etc. Sensitive data for policy and user information is stored in AES encrypted records.  Policies and users are maintained via the OpenInsight 10 IDE.

OpenInsight 10.0.5 and above introduces a new function called RTI_CREATE_USER_DETAILS that allows developers the ability to create a new user or modify information about an existing user in the OpenInsight database.

Description: Creates a new user or modifies information about an existing user in the current database.

Note:  Only Level 1 (Administrator) and Level 2 (System Administrator) users can create users. Level 0 (User) users can only change their own, existing information.

Syntax: RTI_CREATE_USER_DETAILS(userID, currentPwd, userpassword, fullName, validValue, disabledFlag, disabledDate, disabledTime, resetFlag, userType, userLevel, o4wLevel, expirval, expirdate, errDetails)

Return: “1” if the create or edit succeeded
Value: “” or “0” if the create or edit failed, and additional details are returned in the errDetails parameter.

Parameters: The function has the following parameters.

ParameterDescriptionParameterDescription

Parameter Description
userID A user identifier. userID must begin with an alpha character, followed by any combination of characters, digits, and underscores and cannot include spaces.
currentPwd If enhanced authentication is enabled on this OpenInsight system, then a User-level user who wishes to change any user information must pass in the current password in this parameter. This allows the system to verify that they are authorised to make changes to this user information.
userpassword The new password for this user. If enhanced authentication is enabled, then the password must match the specified authentication policy. If legacy authentication is used instead, the password must be a string of characters, 6 to 20 characters in length, and – if not specified – the default is null, and a password is not required to access the database as this user.
fullName The full name of the user.
validValue This is a user-defined parameter that allows the developer to specify additional information that they would like returned if the user’s logged-in state is queried (for example, to implement additional permission levels and groups). By default, this value is “1”.
disabledFlag If enhanced authentication is enabled on this OpenInsight system, then if set (value is “1”), the user will be disabled; if it is reset (value is “0”), the user will no longer be disabled. If the user is disabled, pass in the additional disabledDate and disabledTime parameters.
disabledDate If enhanced authentication is enabled on this OpenInsight system, and the disabledFlag has been set, this parameter specifies the internal date that the user is disabled until.
disabledTime If enhanced authentication is enabled on this OpenInsight system, and the disabledFlag has been set, this parameter specifies the internal time that the user is disabled until.
resetFlag If this parameter is set (“1”), the user must reset their password at the next login.
userType If this user should only be allowed to access the OpenInsight desktop interface, specify “0” for this parameter. If this user should only be allowed to access OpenInsight via O4W, specify “1” for this parameter. If the user should be able to access both desktop and O4W instances, specify “2” for this parameter.
Userlevel If the user is defined as an OI user, or as both an OI and O4W user, specify the OI permissions level here. There are three levels of users. When the user is logged in, the value is stored in the system variable @ADMIN.

There is no default value for Userlevel. If you do not specify a value, execution fails, and an error is generated.

Value Description
0 User
1 Administrator
2 System Administrator
o4wLevel If the user is defined as an O4W user, or both an O4W and OI user, specify the O4W permissions level here. The valid values for O4W permission groups are customisable on a per-site basis.
expirval Expiration parameter for the password. Possible values are:
Value Description
0 Expires at next login
1 Never Expires (default)
2 Expires at the expiry date
expirdate If expirval = 2, the expiration date (passed as a standard output converted date in a format such as mm/dd/yyyy).  Only required if expirval = 2. Note that this value is only relevant when legacy authentication is used on the OpenInsight system; if enhanced authentication is enabled, expiration will be as per policy.
errDetails If any errors are encountered during the execution of this function, they are returned in this parameter.

 

Advertisements

Pop-ups in OI10


youtube_channel

Sprezzatura recently wrote a blog posting following the release of OpenInsight 10 (OI10) and in that posting was the new way of using a standard OpenInsight pop-up to launch a selected data record.

I’ve had a few people asking for some OI10 videos and someone asked for the new pop-up method to be recorded specifically.  That video is now available on my YopuTube channel at the link below.

Please remember that I am learning fast at the moment, but hopefully the video will help you to use the same feature in your OI10 applications.

Thank you to Andrew McAuley for bringing this feature to our notice and for documenting on the Sprezzatura blog.

Fiddlesticks – More code to remove :)


didyouknowoi

So, Andrew at Sprezzatura really made my day with their latest blog posting.  As a non-programmer, I tend to do things how I was taught.  Sometimes I learned those lessons ages ago and I never think that there might be better and easier ways of doing things.

Andrew’s latest blog posting came literally a few short hours after I’d been cutting code to manage the Pop-Ups in my application and have them pass the ID to the appropriate control and read the record to display the data on screen.  It’s only a dozen or so lines of code, but after reading his blog posting, I now have a whole new way of interacting with pop-ups and I finished the day with a lesson learned and a little more OI10 knowledge.

The result is, that I now need to go back to my new OpenInsight 10 (OI10) application and rip out even more code in favour of using the options that OI10 now exposes in the quick events for most controls.  The clear benefit however, will be less code for me to maintain (or should I say mess up) and the use of professionally written code behind the scenes, easily preferable.

Just another example of how OI10 will definitely help me to produce better and more reliable systems, and much faster than before.

You can read Andrew’s blog article, which takes a first look at OpenInsight 10 here.

So, what has changed in OpenInsight 10?

Bob Catalano has written a nice summary of the features and benefits of OI10.  This is available on www.revelation.com and I have also copied it onto the RevUK website here.  This text is also being picked up on Social Media and other places and shows how exciting this new OpenInsight release is.

If you are an existing OI developer and you want to know more about the wealth of changes to the presentation layer, etc., then Carl’s Building OpenInsight 10 blog is an absolute ‘must read’.

Bob has also provided a number of new getting started documents which now ship with the OI10 software.  This includes guides for non-OpenInsight MultiValue developers who wish to explore using OI10 as a front end to their existing MultiValue databases (U2, D3, QM, etc) and SQL developers which would like to interface to their SQL databases.  There is now a brand-new data connector for some cloud databases, such as Couchbase, all with Quick Start Guides.

If that is not enough, please feel free to contact your local Revelation Software office and we’ll be pleased to take your questions and provide you with some answers.

OI10 really is ground-breaking and it’s set to make Windows and Web Application Development even easier for professional developers and hobby developers, like myself.

 

Major Milestone for OI10


didyouknowoi10As many of you will know, I have been an avid alpha and then beta tester for OpenInsight 10 (OI10).  I have fully converted my internal RevUK CRM system, worked on a few other OI10 based systems and posted a fair number of issues for the guys to look at over the last year or so.

Throughout the project those issues have been cleared and just recently I’ve seen a floury of activity on my issues and lots of them being addressed and closed.  It has been very rewarding to have been just one of the many beta testers and I just hope that, in some very small way, I’ll have helped to make the final release as best as possible for the team working on the next generation of our amazing Windows application development environment.

However, the big news is that Revelation have just reached a
major milestone with the development of OpenInsight 10.

Over the weekend, I learned that the OI10 Beta 7 has been released.  Nothing special in that, other than this has been cited as the ‘last (final) alpha’ to be released.  In his posting on LinkedIn, Mike has also gone on record to state that the scheduled release date for the full release is the 16th April.

ext

I’d like to add my thanks to everyone that has been contributing to the beta program through testing and working with the beta versions and feeding back their thoughts, issues and successes.

If you have not yet played with the OI10 software and you have an OI based system, now is the time to register for the beta, download the final beta release and run your applications through the conversion tools.  You might just find an application specific issue that you would like addressing ahead of the final release.

 

OI10 Conversion Process and New Examples Application


OpenInsight 10 LogoOK, I lie ever so slightly, the new Examples application is the old examples application but with a slightly enhanced user interface but it certainly feels new.

I have now converted a few applications from OpenInsight 9.x to OpenInsight version 10 and I’m always pleased with the results.  It started with me cutting my teeth on the EXAMPLES application and then I moved on to my larger RevSoft UK Contact Manager.  The later benefited from a couple of weeks of evenings working on the user interface before I deleted the old 9.4.2 version and moved 100% OI10.

So, a few people have asked me to produce a video of the conversion process and I’m pleased to announce that both that video and a look at an early version of the new examples application is now online and copied below.

Please note that this is a relatively new YouTube Channel.  I decided to drop the old one with the old 9.x videos in order to provide a clean break between the two and avoid confusion.  For this reason, please subscribe to the new YouTube channel for periodic updates as I produce more OI10 videos.

 

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.