Hi all Sorry for the delay reply, I've finally had a chance to work on integrating pentaho on the develop branch.
Here you can find it https://github.com/luisalegria/fineract-1/tree/19.14Pentaho Please, Bharath/Francis or anyone could help to test it. I only tested the war file (bootWar option) and it partially works, I'm not experienced on pentaho reports and I'm unsure if this gonna work like 19.12. version. I would be able to view a pentaho file on this fork version, but: - I create a couple of new reports: - One with a simple query <https://drive.google.com/file/d/1CU6fzHtDm7K4VQAHXFc34DpJMT3gCcJu/view?usp=sharing>: fails - Another without querys <https://drive.google.com/file/d/14C9VghUT8B86GgSKKF9frgi9rwSMhCH6/view?usp=sharing>: it works [image: image.png] - With existing reports, there are issues: - Database name's were changed ( mifostenant-default => fineract_default) and all reports need to be updated - And looks like passing parameters on API "run_report" option, works differently and pentaho files didn't get that - I got this message sent by pentaho engine report: - {"developerMessage":"The request caused a data integrity issue to be fired by the database.","httpStatusCode":"403","defaultUserMessage":"Failed at query: \n\n\n\n\n\n\nselect \nid, \nconcat(substring(\"........................................\", 1, \n((LENGTH(`hierarchy`) - LENGTH(REPLACE(`hierarchy`, '.', '')) - 1) * 4)),`name`) as tc \nfrom m_office \norder by hierarchy ","userMessageGlobalisationCode":"error.msg.reporting.error","errors":[{"developerMessage":"Failed at query: \n\n\n\n\n\n\nselect \nid, \nconcat(substring(\"........................................\", 1, \n((LENGTH(`hierarchy`) - LENGTH(REPLACE(`hierarchy`, '.', '')) - 1) * 4)),`name`) as tc \nfrom m_office \norder by hierarchy ","defaultUserMessage":"Failed at query: \n\n\n\n\n\n\nselect \nid, \nconcat(substring(\"........................................\", 1, \n((LENGTH(`hierarchy`) - LENGTH(REPLACE(`hierarchy`, '.', '')) - 1) * 4)),`name`) as tc \nfrom m_office \norder by hierarchy ","userMessageGlobalisationCode":"error.msg.reporting.error","parameterName":null,"value":null,"args":[]}]} Remember: - To avoid error on SQL INJECTION, its necessary replace ")" "(" characters on database: - - UPDATE stretcy_report SET report_name = replace(report_name,"("," " WHERE report_type="Pentaho"; - UPDATE stretchy_report SET report_name = replace(report_name,")","") WHERE report_type="Pentaho"; - 90+ reports are here <https://drive.google.com/drive/folders/1AMEc6RQnidid69iTvbi5L0PIJGr-XZqq?usp=sharing>, and I replaced "(" ")" characters on them. - These files goes on ~/.mifosx/ folder Thank you a lot El vie., 7 ago. 2020 a las 5:11, Francis Guchie (<francisguc...@gmail.com>) escribió: > Dear Bharath, > > My branch is > https://github.com/francisguchie/fineract/tree/supportPentahoReports > > 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 Fri, Aug 7, 2020 at 10:04 AM Bharath Gowda <bgo...@mifos.org> wrote: > >> Hi Ed, >> >> Francis tried, and he was not able to do so due to the following reason. >> >> In 19.2, they are using the compile command >> In 19.4 its implementation command >> >> I have tried to implement Pentaho in the latest build, but i am getting >> an assertion error duplicate classpaths found. >> >> >> Any help from other contributors would be appreciated. >> >> >> >> Regards, >> Bharath >> Lead Implementation Analyst | Mifos Initiative >> Skype: live:cbharath4| Mobile: +91.7019636073 >> http://mifos.org <http://facebook.com/mifos> >> <http://www.twitter.com/mifos> >> >> >> On Fri, Aug 7, 2020 at 4:21 AM Ed Cable <edca...@mifos.org> wrote: >> >>> Luis/Bharath >>> >>> Are one of you going to merge this into the upstream Fineract codebase? >>> We need to ensure it makes it into the 1.4 release. >>> >>> Please make sure there's a Fineract JIRA ticket (Please insert slightly >>> more detail than is at >>> https://github.com/bharathcgowda/Fineract/issues/1) corresponding to >>> this pull request: https://github.com/bharathcgowda/Fineract/pull/2 >>> >>> Ed >>> >>> On Mon, Jul 20, 2020 at 10:47 AM Moses Gitonga Ntiritu < >>> ntiritum...@gmail.com> wrote: >>> >>>> Thanks so much, Congratulations Luis >>>> Moses >>>> >>>> On Mon, Jul 20, 2020 at 4:05 PM Bharath Gowda <bgo...@mifos.org> wrote: >>>> >>>>> Hi All, >>>>> >>>>> Thanks to Luis Efforts in fixing the issue, 19.12 source code is now >>>>> updated with the Pentaho support. >>>>> Kindly check the updated source code here >>>>> <https://github.com/bharathcgowda/Fineract> >>>>> And updated war file here >>>>> <https://drive.google.com/file/d/19MrW8DQDzVYtfFQ7H7aamfsqPSCI-q8r/view?usp=sharing> >>>>> >>>>> Thanks @francisguc...@gmail.com <francisguc...@gmail.com> for your >>>>> initiative in testing the issue. >>>>> >>>>> >>>>> Regards, >>>>> Bharath >>>>> Lead Implementation Analyst | Mifos Initiative >>>>> Skype: live:cbharath4| Mobile: +91.7019636073 >>>>> http://mifos.org <http://facebook.com/mifos> >>>>> <http://www.twitter.com/mifos> >>>>> >>>>> >>>>> On Fri, Jul 17, 2020 at 3:28 AM Luis Alberto Alegría de los Santos >>>>> <luis.aleg...@innovar.app> wrote: >>>>> >>>>>> Hi Francis >>>>>> >>>>>> Thank you very much for your email and your help offer. >>>>>> >>>>>> I'm working with Bharath, He's helping me. >>>>>> >>>>>> Really, thank you so much >>>>>> >>>>>> Best regards >>>>>> >>>>>> El jue., 16 jul. 2020 a las 15:24, Francis Guchie (< >>>>>> francisguc...@gmail.com>) escribió: >>>>>> >>>>>>> Luis, >>>>>>> >>>>>>> Thanks for this good work. >>>>>>> NB: >>>>>>> if you need help on getting started on how to use git. Just pv me, i >>>>>>> will be happy to help >>>>>>> >>>>>>> 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, Jul 16, 2020 at 4:19 AM Luis Alberto Alegría de los Santos >>>>>>> <luis.aleg...@innovar.app> wrote: >>>>>>> >>>>>>>> Hello Bharath, Yurie >>>>>>>> >>>>>>>> I was able to fix pentaho support into version 1.2 of fineract, I >>>>>>>> still haven't had a chance to test in the latest fineract develop >>>>>>>> branch. >>>>>>>> As soon as possible I will test for the latest version of fineract and >>>>>>>> as >>>>>>>> soon as I make sure that everything works correctly I will create the >>>>>>>> PR. >>>>>>>> >>>>>>>> However I just did a test with version 19.12 of MifosX( >>>>>>>> https://github.com/bharathcgowda/Fineract , Bharath's fork ) and >>>>>>>> it was successful, the reports work without problems. There are more >>>>>>>> changes that I have already identified and solved, such as an exception >>>>>>>> regarding error.msg.found.sql.injection and changes in report names. >>>>>>>> >>>>>>>> And I agree with you Bharath, we could get the 19.12 updated first. >>>>>>>> Could you help me please create a branch so I can add the PR on the >>>>>>>> 19.12 version? Thank you very much. >>>>>>>> I am not familiar with git, I tried to create it, however it was >>>>>>>> not possible for me. I understand that it is necessary to have another >>>>>>>> branch to be able to submit a PR. >>>>>>>> >>>>>>>> And I hope these changes help users of pentaho reports without >>>>>>>> licensing issues. >>>>>>>> >>>>>>>> Best regards >>>>>>>> >>>>>>>> >>>>>>>> El lun., 13 jul. 2020 a las 5:39, yurie walter (<yuwa...@gmail.com>) >>>>>>>> escribió: >>>>>>>> >>>>>>>>> This is great, looking foward to this update. >>>>>>>>> >>>>>>>>> On Mon, Jul 13, 2020, 13:16 Bharath Gowda <bgo...@mifos.org> >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> Hi Airsay, >>>>>>>>>> >>>>>>>>>> There was no branch out or tag made for the RC 19.12 at that >>>>>>>>>> time, however, I have Forked out the code base and it is available >>>>>>>>>> in my >>>>>>>>>> Git account. >>>>>>>>>> You can refer to the source code of 19.12 here >>>>>>>>>> >>>>>>>>>> https://github.com/bharathcgowda/Community-app >>>>>>>>>> https://github.com/bharathcgowda/Fineract >>>>>>>>>> >>>>>>>>>> @yurie >>>>>>>>>> >>>>>>>>>> Fineract has removed the Support for Pentaho report due to some >>>>>>>>>> licensing issues, Hence the reports don't run on the Fineract recent >>>>>>>>>> releases. >>>>>>>>>> >>>>>>>>>> However, @Luis Alberto Alegría de los Santos >>>>>>>>>> <luis.aleg...@innovar.app> has done a great job on fixing the >>>>>>>>>> Pentaho reports locally on the latest Develop Branch and he will >>>>>>>>>> soon Send >>>>>>>>>> a PR along with a Discussion thread with the community on the Fix he >>>>>>>>>> has >>>>>>>>>> done. >>>>>>>>>> >>>>>>>>>> @Luis Alberto Alegría de los Santos <luis.aleg...@innovar.app> could >>>>>>>>>> you please send the PR to the 19.12 codebase as well to the Repos >>>>>>>>>> listed >>>>>>>>>> above? >>>>>>>>>> We can get the 19.12 updated first, which will help all the users >>>>>>>>>> who are running on 19.12 release now. >>>>>>>>>> >>>>>>>>>> Regards, >>>>>>>>>> Bharath >>>>>>>>>> Lead Implementation Analyst | Mifos Initiative >>>>>>>>>> Skype: live:cbharath4| Mobile: +91.7019636073 >>>>>>>>>> http://mifos.org <http://facebook.com/mifos> >>>>>>>>>> <http://www.twitter.com/mifos> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Fri, Jul 10, 2020 at 7:04 PM yurie walter <yuwa...@gmail.com> >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>>> Hi Bharath, >>>>>>>>>>> >>>>>>>>>>> I'm experiencing a small problem. After upgrade to Mifos 19.02 >>>>>>>>>>> all Pentaho reports are displaying a black page when we run a >>>>>>>>>>> report. Might >>>>>>>>>>> you know why? >>>>>>>>>>> >>>>>>>>>>> Walter >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Wed, Jul 8, 2020, 09:04 Airsay Longcon < >>>>>>>>>>> airsaylong...@gmail.com> wrote: >>>>>>>>>>> >>>>>>>>>>>> Hello Bharath >>>>>>>>>>>> Please are the source code from which the war file of v19.12 >>>>>>>>>>>> available? >>>>>>>>>>>> >>>>>>>>>>>> Sent from my iPhone >>>>>>>>>>>> >>>>>>>>>>>> On 7 Jul 2020, at 14:50, Bharath Gowda <bgo...@mifos.org> >>>>>>>>>>>> wrote: >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> Hi Edwin, >>>>>>>>>>>> >>>>>>>>>>>> That is a known issue on the 18.03 version of Mifos. you can >>>>>>>>>>>> either upgrade to the latest Develop branch or you can upgrade to >>>>>>>>>>>> 19.12 >>>>>>>>>>>> Branch(which is more stable than 18.03 and was the release >>>>>>>>>>>> candidate >>>>>>>>>>>> version previously) >>>>>>>>>>>> >>>>>>>>>>>> Following war file and root folder are of our initial RC Which >>>>>>>>>>>> is currently the stable codebase - the code version 19.12.01 >>>>>>>>>>>> where these issues have been fixed. >>>>>>>>>>>> >>>>>>>>>>>> You can download from below links >>>>>>>>>>>> ROOT: >>>>>>>>>>>> >>>>>>>>>>>> https://drive.google.com/file/d/1EFvVAz_5d-7Q0v3IfoG_DWUwCAaSmLmx/view?usp=drivesdk >>>>>>>>>>>> >>>>>>>>>>>> WAR: >>>>>>>>>>>> >>>>>>>>>>>> https://drive.google.com/file/d/1Vz_OSttAG8TxWA0sa6kv_4bJE_bThETT/view?usp=drivesdk >>>>>>>>>>>> >>>>>>>>>>>> Following are simple steps to update the server >>>>>>>>>>>> >>>>>>>>>>>> 1. Replace these files in your tomcat webapp folder >>>>>>>>>>>> 2. Unzip the root which is downloaded from the above link >>>>>>>>>>>> 3. Remove the existing fineract-provider folder inside the >>>>>>>>>>>> webapp folder and restart the tomcat server. >>>>>>>>>>>> 4. Take a backup of your existing DB, war file and root folder >>>>>>>>>>>> before performing an update Incase if you have to roll back to >>>>>>>>>>>> the existing setup if you encounter any issue. >>>>>>>>>>>> >>>>>>>>>>>> You can also contact me on skype if you have any questions or >>>>>>>>>>>> concerns. >>>>>>>>>>>> My skype handle is live:cbharath4 >>>>>>>>>>>> >>>>>>>>>>>> Regards, >>>>>>>>>>>> Bharath >>>>>>>>>>>> Lead Implementation Analyst | Mifos Initiative >>>>>>>>>>>> Skype: live:cbharath4| Mobile: +91.7019636073 >>>>>>>>>>>> http://mifos.org <http://facebook.com/mifos> >>>>>>>>>>>> <http://www.twitter.com/mifos> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Tue, Jul 7, 2020 at 7:06 PM Edwin Nchia < >>>>>>>>>>>> edwingudfri...@gmail.com> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Sure, here it is. >>>>>>>>>>>>> 18.03.01 >>>>>>>>>>>>> >>>>>>>>>>>>> On Tue, 7 Jul 2020 16:35 Bharath Gowda, <bgo...@mifos.org> >>>>>>>>>>>>> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Hi Edwin, >>>>>>>>>>>>>> Could you let me know the Release version you are working on? >>>>>>>>>>>>>> Regards, >>>>>>>>>>>>>> Bharath >>>>>>>>>>>>>> Lead Implementation Analyst | Mifos Initiative >>>>>>>>>>>>>> Skype: live:cbharath4| Mobile: +91.7019636073 >>>>>>>>>>>>>> http://mifos.org <http://facebook.com/mifos> >>>>>>>>>>>>>> <http://www.twitter.com/mifos> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Thu, Jul 2, 2020 at 7:06 PM Edwin Nchia < >>>>>>>>>>>>>> edwingudfri...@gmail.com> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Hello! I have created a table but the field is not active, >>>>>>>>>>>>>>> where I wrong? >>>>>>>>>>>>>>> >>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>> Mifos-users mailing list >>>>>>>>>>>> Mifos-users@lists.sourceforge.net >>>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>>>>>>>>> >>>>>>>>>>> _______________________________________________ >>>>>>>>>>> Mifos-users mailing list >>>>>>>>>>> Mifos-users@lists.sourceforge.net >>>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>>>>>>>> >>>>>>>>>> _______________________________________________ >>>>>>>>>> Mifos-users mailing list >>>>>>>>>> Mifos-users@lists.sourceforge.net >>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> LSC. Luis Alegría >>>>>>>> INNOVARAPP >>>>>>>> >>>>>>>> *La información contenida en este correo electrónico y anexos es >>>>>>>> confidencial. Ésta dirigida únicamente para el uso del individuo o >>>>>>>> entidad >>>>>>>> a la que fue dirigida y puede contener información propietaria que no >>>>>>>> es >>>>>>>> del dominio público. Si has recibido este correo por error o no eres el >>>>>>>> destinatario, por favor notificar al remitente de inmediato y borra >>>>>>>> este >>>>>>>> mensaje de la computadora o dispositivo. Cualquier uso, distribución o >>>>>>>> reproducción de este correo que no sea por el destinatario de intención >>>>>>>> queda prohibido.* >>>>>>>> _______________________________________________ >>>>>>>> Mifos-users mailing list >>>>>>>> Mifos-users@lists.sourceforge.net >>>>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>>>>> >>>>>>> >>>>>> >>>>>> -- >>>>>> LSC. Luis Alegría >>>>>> INNOVARAPP >>>>>> >>>>>> *La información contenida en este correo electrónico y anexos es >>>>>> confidencial. Ésta dirigida únicamente para el uso del individuo o >>>>>> entidad >>>>>> a la que fue dirigida y puede contener información propietaria que no es >>>>>> del dominio público. Si has recibido este correo por error o no eres el >>>>>> destinatario, por favor notificar al remitente de inmediato y borra este >>>>>> mensaje de la computadora o dispositivo. Cualquier uso, distribución o >>>>>> reproducción de este correo que no sea por el destinatario de intención >>>>>> queda prohibido.* >>>>>> Mifos-developer mailing list >>>>>> mifos-develo...@lists.sourceforge.net >>>>>> Unsubscribe or change settings at: >>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-developer >>>>> >>>>> _______________________________________________ >>>>> Mifos-users mailing list >>>>> Mifos-users@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>> >>>> >>>> >>>> -- >>>> Moses Gitonga Ntiritu >>>> Director >>>> Digital Oasis Limited >>>> Po. Box 5221-00200 >>>> Nairobi. >>>> Tel: 0700 773 038 >>>> www.digitaloasisltd.com >>>> >>>> -------------------------------------------------------------------------------- >>>> *CMA AWARDS* >>>> PLATINUM/ OVERALL WINNER: Citi Micro Entrepreneurship Awards 2014-2015. >>>> GOLD WINNER : Citi Micro Entrepreneurship Awards, Youth Urban, 2014. >>>> GOLD WINNER : Citi Micro Entrepreneurship Awards, Service Category >>>> 2014. >>>> >>>> *RISING STAR AWARDS* >>>> RISING STAR AWARDS: Finalist, ICT Category, 2014-2015. >>>> >>>> *DAYSTAR ALUMNI AWARDS* >>>> WINNER-Business Progression Entrepreneurship Award 2016 >>>> >>>> *GOOGLE CODE IN US* >>>> *2018 Certified Google Code-in US Mentor* >>>> >>>> >>>> >>>> _______________________________________________ >>>> Mifos-users mailing list >>>> Mifos-users@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>> >>> >>> >>> -- >>> *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-users mailing list >>> Mifos-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>> >> -- LSC. Luis Alegría INNOVARAPP *La información contenida en este correo electrónico y anexos es confidencial. Ésta dirigida únicamente para el uso del individuo o entidad a la que fue dirigida y puede contener información propietaria que no es del dominio público. Si has recibido este correo por error o no eres el destinatario, por favor notificar al remitente de inmediato y borra este mensaje de la computadora o dispositivo. Cualquier uso, distribución o reproducción de este correo que no sea por el destinatario de intención queda prohibido.*
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
