Dear Ed, I think this thread has reached its peaceful end. Thank you for the support
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 6:19 PM Francis Guchie <francisguc...@gmail.com> wrote: > 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 <francisguc...@gmail.com> > 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 <francisguc...@gmail.com> >> 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 <edca...@mifos.org> wrote: >>> >>>> Thanks Petri. Sorry that I had duplicated Francis' thread. >>>> >>>> Ed >>>> >>>> On Tue, Aug 18, 2020 at 8:13 AM Petri Tuomola <pe...@tuomola.org> >>>> 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 < >>>>> francisguc...@gmail.com> 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 >>>> edca...@mifos.org | 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 >>>> mifos-develo...@lists.sourceforge.net >>>> Unsubscribe or change settings at: >>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer >>> >>>
