Well done and thank you for sharing @Francis On Thu, 20 Aug 2020 at 21:21, Francis Guchie <francisguc...@gmail.com> wrote:
> 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 >>>> >>>> >>>> >>>> >>> >>> >> >> > > Mifos-developer mailing list > > mifos-develo...@lists.sourceforge.net > > Unsubscribe or change settings at: > > https://lists.sourceforge.net/lists/listinfo/mifos-developer
