Subscribe for automatic updates: RSS icon RSS

Login icon Sign in for full access | Help icon Help
Advanced search

Pages: [1] 2 3 ... 10
 on: January 16, 2020, 03:29:42 pm 
Started by Snorri B. - Last post by Snorri B.
Hello everyone.

We are wondering if it is possible to embed (via javascript) a Genero application (example: input form) into a website which is created in React.js?
And apply the css styles from that website to it?
If this is,  does someone have hints or examples?

Best regards,

 on: December 18, 2019, 11:27:36 pm 
Started by Lu?s T. - Last post by Reuben B.

Re: XIRR in Excel and not in ApachePOI I see what you mean.  Never the less there were a few interesting URLs

plus this one !!!


 on: December 18, 2019, 11:22:33 am 
Started by Lu?s T. - Last post by Lu?s T.
Hi Reuben,

Thanks for your contribution. I didn't know the Apache POI Libraries and much less the fgl interface to it.

In any case, the corresponding Excel function for what I am doing is XIRR, which is not an Excel standard function but an Add-in. The difference is that in IRR you pass a list of values and in XIRR you pass a list of values and dates. To use IRR instead, in a 4 year loan for example, I'll have to pass around 1400 values, 95% of the being 0.

I could not find it i POI docs, I supposed because it is an Add-in.



 on: December 18, 2019, 12:10:54 am 
Started by Lu?s T. - Last post by Reuben B.

This happens when we call IRR (Internar Return on Investment), using Newton method. We need to actualize each cash-flows of a loan to the number of days from the initial date of the loan. As we are calculating this in a dayly base, and the operation have 4 years duration, it makes around  1460 day for the last flow.


whilst this discussion is interesting around the merit and performance of ** versus fgl_decimal_power versus util.math.pow()  (I'd forgotten that the second argument of  ** is an integer, so 4**0.5 gives you 1, not 2 !!!) , what Luis had was a function calculating IRR or Internal Rate of Return.   if I was to guess Luis and other developers with financial software have similar functions written many years ago 

When I put together my example showing how you can utilise the Java Apache POI libraries to interact with Word and Excel I had an example in that showed you could create an Excel sheet in memory, populate the cells in memory, put a Excel formula in one cell, evaluate that formula, and return the value of the formula back to the 4gl program.  The example I used with IRR or Internal Rate of Return but any financial formula in Excel could've been similarly exposed and made available to a 4gl program.

I was curious how the performance would compare but then I thought what if I could do that without the overhead of creating an Excel workbook and worksheet in memory, do the Apache POI libraries expose those Excel formulas?.  Sure enough they do so I have added to the repository a 4gl module that exposes some of those functions and some quick tests

  1. IMPORT FGL fgl_financial
  2. ...
  3.    CALL list_of_values.clear()
  4.    LET list_of_values[1] = -100000
  5.    FOR i = 1 TO 240
  6.        LET list_of_values[i+1] = 592.89
  7.    END FOR
  8.    LET irr = fgl_financial.irr(list_of_values,0.10/12)

In short you do not have to rewrite and maintain financial formulas from scratch in 4gl, you can utilise Java libraries that do the same thing.  I would be curious to know from a precision and performance point of view, how these stack up.  (Of course one day we could go one better and add a package e.g. IMPORT financial, that has these financial methods)


 on: December 17, 2019, 06:18:19 pm 
Started by Olivier E. - Last post by Olivier E.

 Supported OS list erratum

Dear customers,

We updated the Supported Operating Systems list for Genero 3.20.xx, and documented that Genero Studio (GST) and Genero Desktop Client (GDC) were supported on Suse Enterprise 12 (SLES 12). This was in error, SLES 12 is not supported for GST or GDC.

However, SLES 12 is supported for non-graphical Genero 3.20 products, such as GST Server, FGLGWS, GRE, and GAS.

We apologize for any confusion or inconvenience.


Four Js Development Tools

 on: December 17, 2019, 03:41:16 pm 
Started by Gary C. - Last post by Candy M.
Does Fourjs have a guideline as to how that ulimit should be set, that is some sort of formula how we should estimate this value for the ulimit?


 on: December 17, 2019, 03:27:52 pm 
Started by Huy H. - Last post by Huy H.
For us, this is sort of a one-of situation.  We have our action defaults defined in a 4ad file.  In this particular situation, we wanted the attributes of this action to be different than the defaults defined within the 4ad.  We've used INFIELD and ATTRIBUTES in the past, it just wasn't clear to us that the two cannot be used together in the code.  It's not a big deal really, we've found a work around that we think it's more intuitive to the user:  We added a button on the form next to the field (therefore DEFAULTVIEW = YES) and only used the INFIELD in the code.

Like Rene had alluded to, there's other ways that we can do to get to the behavior we desire, just that it wasn't obvious to us why the syntax didn't work.

 on: December 17, 2019, 02:17:36 pm 
Started by Gary C. - Last post by Neil M.
Just to update on the state of this case.
The problem looks like it was a combination of a known and fixed issue ( ) and not setting the ulimit correctly.

The GAS dispatcher shows the ulimit settings on a server as a 'heads up' to limits that might cause an issue to the GAS.
The OS 'open files' default of 1024 is rarely going to be enough for the GAS Dispatcher + GAS Proxy  + FGL ( which will access all the .42m / .42f / .4st / .4ad )
This 'open files' limit is per OS user, since the GAS and all the fglrun's will be normally running as the same OS user, so you need to set this limit accordingly.

 on: December 17, 2019, 12:06:34 pm 
Started by Lu?s T. - Last post by Sebastien F.
We have created the ticket FGL-5315 for this enhancement of the ** implementation.

 on: December 17, 2019, 10:32:46 am 
Started by Lu?s T. - Last post by Lu?s T.
Thanks Rene and Henry,

Yesterday my colleague Josť Virtuoso found a post in Stack Overflow discussing the theme:

They refer to the same algorithm and also point for an old post with a really deep discussion about efficient implementations of integer based power function:

In the meanwhile we'll use your myExp() function!

Pages: [1] 2 3 ... 10
Powered by SMF 1.1.21 | SMF © 2015, Simple Machines