Dear All, For all those interested in using pentaho reports in the latest build, please note the following
1. follow the discussion here https://github.com/apache/fineract/pull/1262 2. Fineract will not ship with Pentaho reports and thus whoever wants to use them can add them on their own you can use the branch https://github.com/francisguchie/fineract/tree/pentahoReports at an individual Basis (I hope i am not violating any rules by sharing this) 3. If you choose to go Pentaho, below are my findings 1. tomcat 9.0.37 or above will be your best choice as i tried 9.036 and 9.035 and i was having errors displaying the reports 2. if you have tomcat 9.0.3x and you do not wish to redo your work, you can simply use the jar files in the lib folder of tomcat 9.0.37 it worked for me on a tomcat9.0.35 4. I have test this on a windows PC and Ubuntu 18.04 Lts and i am happy with the results 1. Pentaho Reports with names that have no SQL keys words, special characters and operands work well 1. Examples of these are words like Select, AND, characters like -, * ( will display and sql inject error when a user is trying to add the report Enjoy My Kind Regards Francis Guchie Kirago *Skype:* francisguchie *Whatsapp: *232 79 19 44 07 *LINKEDIN:* https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ twitter: @FrancisGuchie On Thu, Aug 20, 2020 at 12:36 AM Francis Guchie <[email protected]> wrote: > Petri, Luis and all > > Thank you for the advise, I have managed to Raise the PR here > https://github.com/apache/fineract/pull/1262 > > Next Steps > > - Making sure the reports with no errors load ( *When i use my Windows > PC, this works very well - reports with "non-bad Names" and those with no > data integrity issues are displayed *) I am still trying to figure > out why this is not the same for Ubuntu 18.04 LTS > - Making Corrections of the Names and editing errors in all / a good > number of Pentaho Reports > > For now i can gladly wait for reviewers of the PR i have raised - as i > see -- All checks have passed > > > > My Kind Regards > > Francis Guchie Kirago > *Skype:* francisguchie > *Whatsapp: *232 79 19 44 07 > *LINKEDIN:* https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ > twitter: @FrancisGuchie > > > > > > > > > > On Tue, Aug 18, 2020 at 8:22 PM Francis Guchie <[email protected]> > wrote: > >> Petri, >> >> No I have not tried this. Let me try it and let you know. >> >> >> >> >> My Kind Regards >> >> Francis Guchie Kirago >> >> Skype: francisguchie >> Whatsapp: 232 79 19 44 07 >> LINKEDIN: https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ >> twitter: @FrancisGuchie >> >> >> >> >> On Tue, Aug 18, 2020, 15:18 Ed Cable <[email protected]> wrote: >> >>> Thanks Petri. Sorry that I had duplicated Francis' thread. >>> >>> Ed >>> >>> On Tue, Aug 18, 2020 at 8:13 AM Petri Tuomola <[email protected]> wrote: >>> >>>> Hi Francis >>>> >>>> If this is a valid and harmless duplicate (i.e. all the JARs include >>>> "overview.html" but that doesn't affect the functionality), you can exclude >>>> the relevant files from the duplicate check by adding them to the function >>>> org.apache.fineract.infrastructure.classdupes. >>>> ClasspathHellDuplicatesChecker.isHarmlessDuplicate() >>>> >>>> Have you tried this to resolve your issue? >>>> >>>> Regards >>>> Petri >>>> >>>> >>>> On Tue, Aug 18, 2020 at 1:09 PM Francis Guchie <[email protected]> >>>> wrote: >>>> >>>>> Dear All, >>>>> >>>>> We would like to see Pentaho Reports available in the next release. >>>>> Support for Pentaho was discontinued due to License issues (Personally i >>>>> don't know how the license issues affect as no details where provided >>>>> where >>>>> i read this note) >>>>> >>>>> At the moment MifosX is compatible with Pentaho 3.9.1-GA / 3.9.1.1 >>>>> >>>>> Luis and I have tried to add Pentaho Reports into the latest build and >>>>> here are our branches mine >>>>> https://github.com/francisguchie/fineract/tree/supportPentahoReports and >>>>> that of Luis >>>>> https://github.com/luisalegria/fineract-1/tree/19.14Pentaho >>>>> >>>>> In both cases, using the following environments on a Windows 10 Ent- >>>>> 64bit PC >>>>> >>>>> 1. gradle 6.5.1 >>>>> 2. Jdk 11.0.8 >>>>> 3. node v14.4.0 >>>>> 4. npm v 6.14.5 >>>>> 5. kotlin 1.3.72 >>>>> 6. groovy 2.5.11 >>>>> >>>>> >>>>> when i run ./gradlew clean build (one of the conditions to be checked >>>>> before a PR is raised) I do get the error below >>>>> >>>>> org.opentest4j.AssertionFailedError: 3 Classpath duplicates detected: >>>>> overview.html >>>>> >>>>> jar:file:/C:/Users/..../org.mnode.ical4j/ical4j/3.0.19/5aa648ce509674af21b3a46ce1efb5aa3300b651/ical4j-3.0.19.jar!/overview.html >>>>> >>>>> jar:file:/C:/Users/..../pentaho-reporting-engine/pentaho-reporting-engine-classic-core/3.9.1.1/77036efc94f1bab8dfe07bfdcf28cb4cdc4dcc46/pentaho-reporting-engine-classic-core-3.9.1.1.jar!/overview.html >>>>> >>>>> jar:file:/C:/Users/..../pentaho-reporting-engine/pentaho-reporting-engine-classic-extensions/3.9.1-GA/24114228757a9325f4b4e4899471413f6ae90d2c/pentaho-reporting-engine-classic-extensions-3.9.1-GA.jar!/overview.html >>>>> >>>>> jar:file:/C:/Users/..../pentaho-library/libfonts/1.2.8/8d20d16c7b4022480df8fb8aa7c51f6357ff1817/libfonts-1.2.8.jar!/overview.html >>>>> >>>>> jar:file:/C:/Users/..../pentaho-library/libserializer/1.2.8/52d4ccad3fa757ec040a3da34314d08c4a071332/libserializer-1.2.8.jar!/overview.html >>>>> classic-engine.properties >>>>> >>>>> jar:file:/C:/Users/..../pentaho-reporting-engine/pentaho-reporting-engine-classic-extensions/3.9.1-GA/24114228757a9325f4b4e4899471413f6ae90d2c/pentaho-reporting-engine-classic-extensions-3.9.1-GA.jar!/classic-engine.properties >>>>> >>>>> jar:file:/C:/Users/..../pentaho-reporting-engine/pentaho-reporting-engine-classic-extensions-scripting/3.9.1-GA/174cce581a247680f24404e9ed6ef1fbfb53ae29/pentaho-reporting-engine-classic-extensions-scripting-3.9.1-GA.jar!/classic-engine.properties >>>>> >>>>> jar:file:/C:/Users/..../pentaho-reporting-engine/pentaho-reporting-engine-wizard-core/3.9.1-GA/671508e5f7b038b19ddbdf34914eab87bbb646ee/pentaho-reporting-engine-wizard-core-3.9.1-GA.jar!/classic-engine.properties >>>>> loader.properties >>>>> >>>>> jar:file:/C:/Users/..../pentaho-reporting-engine/pentaho-reporting-engine-classic-core/3.9.1.1/77036efc94f1bab8dfe07bfdcf28cb4cdc4dcc46/pentaho-reporting-engine-classic-core-3.9.1.1.jar!/loader.properties >>>>> >>>>> jar:file:/C:/Users/..../pentaho-reporting-engine/pentaho-reporting-engine-wizard-core/3.9.1-GA/671508e5f7b038b19ddbdf34914eab87bbb646ee/pentaho-reporting-engine-wizard-core-3.9.1-GA.jar!/loader.properties >>>>> >>>>> jar:file:/C:/Users/..../pentaho-library/libdocbundle/1.2.8/9bde3c7aa2154a08e6c7bfdfd6d35dc3b18d05aa/libdocbundle-1.2.8.jar!/loader.properties >>>>> >>>>> jar:file:/C:/Users/..../pentaho-library/libxml/1.2.8/60a57221b2f5b3ac5e8822bf14001640738a6ab/libxml-1.2.8.jar!/loader.properties >>>>> >>>>> >>>>> I need help on this jarHell error >>>>> >>>>> >>>>> >>>>> My Kind Regards >>>>> >>>>> Francis Guchie Kirago >>>>> *Skype:* francisguchie >>>>> *Whatsapp: *232 79 19 44 07 >>>>> *LINKEDIN:* >>>>> https://www.linkedin.com/in/francis-guchie-kirago-a4379617/ >>>>> twitter: @FrancisGuchie >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>> >>> -- >>> *Ed Cable* >>> President/CEO, Mifos Initiative >>> [email protected] | Skype: edcable | Mobile: +1.484.477.8649 >>> >>> *Collectively Creating a World of 3 Billion Maries | *http://mifos.org >>> <http://facebook.com/mifos> <http://www.twitter.com/mifos> >>> >>> Mifos-developer mailing list >>> [email protected] >>> Unsubscribe or change settings at: >>> https://lists.sourceforge.net/lists/listinfo/mifos-developer >> >>
