These community forums are free for anyone to use, they provide support for OpenUnderwriter related matters. Please note, you must register with the website and login to post messages and questions, this helps reduce spam.

Support Forum

  • Index
  • » Users
  • » matthew.tomlinson
  • » Profile

Posts

Posts

Hi WenHui,

Have you tried stopping and restarting your instance of OpenUnderwriter?  Sometimes when copying a whole new product into the system via Webdav, some of the files do not get properly registered.  Restarting the server normally fixes it.

Webdav also doesn't like copying javascript files, so if there are any of those you may need to import them directly into the system from 'Products' tab.

Finally, if you get a message like quotationPageFlow not found and a restart doesn't work, then try recopying just that file.

Regards
Matthew

2015-07-28 10:12:07
getting the source code
Category: User Forums

Excellent!  Glad you sorted it out.

2015-07-28 10:12:04
getting the source code
Category: User Forums

Excellent!  Glad you sorted it out.

2015-07-28 09:56:39
Category: User Forums

Try http://www.openunderwriter.com/community/download.

SourceForge has been down recently, but Everything appears to be back up now.

2015-07-24 19:44:00
getting the source code
Category: User Forums

Yes - its one of the options we are looking at.  We intend to have a mechanism that allows us to sync multiple repositories, so if one goes down we can continue  to access the other.

I would be really interested to hear about your interest in OpenUnderwriter, feel free to PM me if you don't feel you can share over a public forum.  The more we understand about the user community, the better we can make the software for the community, so it would be really appreciated if you could share any details.

Many thanks
Matthew

2015-07-24 19:12:07
getting the source code
Category: User Forums

Unfortunately SourceForge went down a week ago, and whilst they have been gradually restoring services, they have not yet been able to restore svn.  Until they do this nobody can access the repository.

I appreciate this is really inconvenient, but at the moment it is out of our hands and with SourceForge.  We will be looking to introduce a backup mechanism for the OpenUnderwriter project moving forward, should a similar outage occur in the future.  However, this will take some time to implement, so until them we just need to wait until the svn service is restored.

JDK1.7 should be fine with the latest build.

2015-07-08 09:16:27
Category: User Forums

Not at the moment - product aren't distributed that way.  However if products as webservices is a feature you would like to see, please visit our Jira and raise a request.

Matt

2015-07-08 09:16:26
Category: User Forums

Not at the moment - product aren't distributed that way.  However if products as webservices is a feature you would like to see, please visit our Jira and raise a request.

Matt

2015-07-08 09:12:43
Instal error
Category: User Forums

I can't see what the problem could be - try deleting the OU directory and starting again.  Make sure you run "run.bat", and as long as you have  the correct version of Java and MySQL (see readme file), you should be fine.

Matt

The Joomla WSRP component (as well as the WordPress one) are designed to work with an older version of OpenUnderwriter and the Alfresco content management system.  The new OpenUnderwriter uses Liferay, but at the moment the Joomla and Wordpress components still need upgrading to support that.  However, if you take a look at this JIRA (https://openunderwriter.atlassian.net/browse/OU-248) you will see a working PHP example for the latest build ofOpenUnderwriter.

To change the html, you may actually be better off overriding the velocity templates defined in OpenUnderwriter's base product, by creating new ones in your product that output the HTML you require.

Finally, some of the demo products have branching question sets and multiple sections, the TradePL product for example, which will demonstrate how you can offer different types and levels of coverage to different proposers, such as Public Liability with optional Professional Indemnity.

I hope that helps.

Regards
Matthew

Hi Karthick

I have actually had to make a field read only recently, this is how I configured the pageflow to achieve it:

Code:

<pageScript script="$(document).ready(function(){$('div.businessdescription input').attr('disabled','disabled');});"/>

<question title="Business Description" binding="/asset[id='company']/attribute[id='businessDescription']" styleClass="businessdescription"/>

I hope that helps.
Matthew

2015-04-13 23:17:06
Category: User Forums

Hi Jordan,

Currently our main focus is the OpenPolicy (policy management functionality) with OpenClaim development prioritised after that.

We are expecting a first delivery of OpenPolicy during Q2 2015, with work on OpenUnderwriter development  driven by a combination of product roadmap and commercial client requirements. 

I hope this helps, if you have any further questions, or would like to discuss any requirements we may be able to help you with in more detail, please don't hesitate to contact the team using the contact forms on this website. 

I would  be really interested to learn more about your project.

Kind Regards
Matthew

Hi, 

I have sent you an email, although didn't realise the urgency until I read this post.  I will get a member of our technical team to contact you.

Regards
Matthew

The OpenUnderwriter team is really proud to announce the release of OpenUnderwriter 2.1 SP1.

Following on from the success of version 2.1, this latest release further refines and expands the software's feature set. The focus, as always, is delivering innovative software that allows Insurance organisations to deliver results and quickly and efficiently.

A demonstration site is available so you can see how OpenUnderwriter can benefit you and your customers, read more about it in our blog post blog/item/demonstration-broker-website-customer-focus

The binary download can be found here: community/download

2014-12-10 20:26:01
Corrupt zip file
Category: User Forums

To download again, you need to go back to the download web page (http://www.openunderwriter.com/community/download), click the download link and complete the form again.

Regards
Matthew

2014-12-10 16:46:24
Corrupt zip file
Category: User Forums

Hi,

I've just tried downloading and unzipping the file myself and didn't have any issues.  I was using 7-Zip to extract on a Windows 7 (64bit) machine.

There are a few things you do need to watch out for (dependent upon your environment)  because the zip is large (approx 667MB) with a fairly deep directory structure inside.

1.  Depending upon your environment, you may want to unzip the file as close to the root directory as possible to minimise the risk of the system struggling with the directory depth.
2.  The zip tool built in Windows is not great for larger zip files, so we recommend using another tool (there are lots of great free tools out there WinZip, 7-Zip etc.), although as you are on Linux I suspect this isn't the issue.
3. Being such a big file it may have simply become corrupt during the download process if there was an issue with the connection at any point.

I hope this helps, please let us know if you continue to have difficulties.

Regards
Matthew

Hi Mark,

Hopefully you have had some success since my precious post.

In this post I want to cover currency.

The currency used in the LifePlus product is GBP, however it is an easy thing to amend.  When changing the currency you need to make certain all areas of the product definition use the same currency when calculating a premium, and in the LifePlus product currency is only every configured in the PolicyRating.xls rating spreadsheet.  So every instance of the text 'GBP' in the rating sheet should be changed to 'EUR' if you want to use Euros.  In the original sheet the occurrences appear in cells F33 and D44, and its that simple - well almost!

In the LifePlus rating sheet someone was trying to be clever with the cell formatting for the base rate lookup table premium values (cells D46 to D53).  The cells are formatted as '£' currency fields, which displays the numbers with a leading '£' symbol. The code behind the scenes knows to remove any leading symbols from a number (although the symbol must match the defined currency being set).  However if you change the format of the cells, to lets say German Euros, the code behind the scenes has a problem interpreting it, for two reasons, firstly German Euros has a trailing '€' rather than a leading one, and secondly because there is a space between the amount and the symbol.  Try formatting as a plain number, so there is no currency symbol, or alternatively use a currency format where the Euro symbol is leading the amount (with no spaces).

Hopefully you should be able to get your Euro product running fairly quickly.

Regards
Matthew

Hi Mark,

I've tested Libre Office and it worked for me, although if I saved it as an older .xls format (i.e. Excel 95) that did break the rules engine - not in exactly the same way however.    My version of Libre is significantly older than yours though, version 3.6, but I can't see that would be the issue.  Looking at the two files you sent the is nothing obviously wrong there either.  I will investigate further - but it may take some time to get to the bottom of it.

Regarding the possible bugs you found:

I'll start with the referral rule, in my version of the spread sheet the age refers if it is greater than 75, and that mechanism works for me, with a "Insured is too old" referral description being generated.  However, due to a slightly flawed premium table, there are no base premiums defined for anyone over the age of 65, so anyone over 65 will also be referred with a "Calculation of total premium failed (line not found in assessment sheet)" referral description being generated, this is because the rule engine can't calculate a premium for them.

If you view the assessment sheet when you get to the referral page in the Sandpit, you will see the generated referrals.

Next, regarding the premiums, these are in fact correct - however there is a slight issue, but I'll come to that later! 

The element of the premium you are missing in your calculation is the Insurance Premium Tax (or IPT).  This products IPT is 5%, so a £100 base premium plus %5 smokers loading is £105, then add 5% IPT and you get a further £5.25 totalling £110.25.

However, I mentioned their was an issue.  When you apply loadings and discounts you can set a priority, allowing the order of calculations to be set.  However the loading in this case was not given a priority and so it was simply applied last - after the IPT.  The loading should really be applied before the tax, and only because both the loading and tax are 5% did the premium come out at the correct amount.

Cell E58 contains the loading script - the original version looks like this:
$AssessmentSheetArgRet.addLoading("$2", "total premium", "total premium", new Rate("$1"));

but if a priority is to be set it should look like this:
$AssessmentSheetArgRet.addLoading("$2", null, "total premium", "total premium", new Rate("$1"), 90);
where 90 is the priority, and the larger number (1 to 100), the earlier on the rule will be applied.

Once the priority is set in the rules, the loading is applied before the tax.  Again, this can all be observed in the assessment sheet.

Finally, the question around your third test case (Male 60y, Smoker, No Exercise). Row 33 of the spreadsheet has a rule that limits the maximum premium - you can see the mechanism at work in the assessment sheet - the calculated premium (base+loading+IPT) should be £220.50, but the premium limits rule only allows a maximum of £200 and so automatically readjusts the premium, resulting in a £200 total premium.

I hope that all makes sense.  Ask if you need any clarification.

Kind regards
Matthew

Thanks for the update Mark, I have both Excel and Open Libre here, so will try to duplicate the problem.

Kind regards
Matthew

Hi Mark,

Please could you upload the rating spreadsheet you are amending?  I would like to compare it with the demo version I have to look for any potential differences that may be causing the issue.

Many thanks
Matthew

Hi Mark,

OK, that is quite a lot to cover in one post!  So I'll cover some bits initially, and come back on the other elements later.

Its worth noting that the 'help' menu option on the OpenQuote area does have a product development tutorial that is worth having a look at.

Modification of Rate.
Firstly lets concentrate on the actions required to change a rate.
1. Open the rating spreadsheet in an Excel compatible tool (Libre Office Calc will work).
2. Edit the rates
3. Save the changes (this action triggers the automatic checking out of the file on the server)
4. Checkin the changed file - go into OpenUnderwriter, navigate the product directory to find the file (it should be shown as status 'draft'), and select 'checkin' from the files drop-down menu. (see attached screenshot)

http://www.openunderwriter.com/images/agorapro/attachments/70/mini_checkin.jpg

This should now incorporate the rate changes into the quote process.  The first time you run the quote process after a rule change there will be a wait whilst the system translates the spreadsheet into a native rules script, subsequent runs through the process will not need to do this and therefore will run much faster.

To create a new product, we don't currently have the templates as in OpenQuote 1.4, you can however simply copy a product in a file manager (i.e. Windows Explorer) connected to the server and rename the copy, using that as the starting point for your new product.

That is probably enough for this post, I'll post again later with more information on changing currency and the portal websites.

Regards
Matthew

2014-07-22 08:55:50
Category: User Forums

Hi Sean,

It looks like you may have an issue connecting to the MySQL database.  Please could you double check that your username and password for MySQL are being correctly entered during the run.bat process.  By default these are username 'root' with a blank password.  If these are different for your MySQL instance you are given the opportunity to enter alternatives during the run.bat process.  The MySQL profile needs to create and populate Databases and tables, so it really needs root type privileges.

Please also note, when you want the run.bat to create and set-up the database from scratch, you should drop the OpenUnderwriter databases from your MySQL and also delete the OpenUnderwriter directory from you PC, then start again by unzipping the OpenUnderwriter 2.0 zip download and re-running the run.bat (you may want to save the run.bat file you amended however).  The reason for deleting the directory is because the run.bat process updates files to ensure it doesn't run the database set-up script every time you start the server.

Please let me know how you get on.

Kind regards
Matthew

2014-07-21 12:45:00
Category: User Forums

Hi Sean,

Thank you for you post.

Firstly, I would recommend you try installing OpenUnderwriter 2.0 rather than OpenQuote 1.4.  OpenUnderwriter 2.0 uses Liferay instead of Alfresco.

We do recommend a 64bit environment - which with Windows 8 you should be OK, along with 8Gb memory if possible.

All the operating systems you mentioned have been tested with the software, so they shouldn't cause an issue. Also, I wouldn't expect the  run.bat script to need any changes - what changes have you made?

It would be useful to see the server log the system generates, this can be found here:
for OpenQuote 1.4 - [OpenQuoteHome]/jboss/server/default/logs/server.log
for OpenUnderwriter 2.0 - [OpenUnderwriterHome]/liferay-portal-6.2.0-ce-ga1/jboss-7.1.1/standalone/log/server.log

Some additional points you may or may not already have considered:

* You should make certain MySQL is installed with the MySQL bin folder path included in your Windows "path" environment variable.
* By default the setup.bat for OpenUnderwriter/OpenQuote expects the MySQL 'root' user to have a blank password, although this can be changed.
* Try unzipping the downloaded binary zip with something other than the default windows zip functionality (as it is known to have some issues).
* Minimize the root directory path and name for OpenUnderwriter (i.e. 'C:/ouw2/') as some versions of windows struggle with deeper directory structures.


I'm sure we can get you up and running, once you post the log file we can take a more detailed look.

Kind regards
Matthew

2013-12-05 14:16:51
Unifying efforts under OpenUnderwriter

Hi!

This is just a quick post to let you know about recent changes.  Applied Industrial Logic (AIL), creators of OpenQuote, are now trading as OpenUnderwriter.  This is simply to provide the organisation with a name that relates more closely to the work we do - AIL still exists as the registered company, but as a name it is going to take a back seat, with OpenUnderwriter leading the way as we move forward. 

We are also now building a suite of open source insurance solutions, OpenQuote is just one of these, with OpenActuary also now available, and OpenPolicy and OpenClaim in development.  These all fall under the banner of OpenUnderwriter.

To reflect these changes, we now have this great new website (www.openunderwriter.com), and have updated the forum to the professional version of Agora.

Thank you all for your time and support up until now, and thank you in advance for your continued support.  Please let us know what you think of the changes, and be sure to tell us of anything else you would also like to see.

Kind regards
Matthew

  • Index
  • » Users
  • » matthew.tomlinson
  • » Profile

Connect

Get in touch with the team

     

OpenUnderwriter

Mocatta House
Trafalgar Place
Brighton
BN1 4DU
United Kingdom

Contact

 contact@openunderwriter.com
 +44 (0)20 7183 4578
 Contact form