Thank you Stephen. Some others are also facing the same issues and posted here in one of our channels:
http://mifos.cloud.answerhub.com/questions/2383/i-can-not-add-currency.html?childToView=2420#answer-2420 I gave your explanation there. Regards Santosh On Mon, Nov 20, 2017 at 12:57 PM, Stephen Agyepong < [email protected]> wrote: > Santosh, > > No problem. > My partner Charles has found a number of issues where some drop downs dont > get populated when creating an office from scratch. > Our investigation shows inconsistency between the UI code (community > app version 17.xx.xx) and Fineract 1.0.0 > The front end code is referring to code/data that do not exist in Fineract > 1.0.0 > A combination of code changes (from dev branch to 1.0.0 branch) and > manually adding missing data/required data helped to resolved the issues > found so far. > Charles was going to try to resolve the issues with just data changes. I > will let him update us with his findings. > > Thanks > > Stephen > > On Mon, Nov 20, 2017 at 1:30 AM, Santosh Math < > [email protected]> wrote: > > > Adding +Yubaraj and +Gbenga who are facing same type of issues in > different > > scenarios. > > > > Hi Stephen, > > > > Sorry for delayed reply. > > > > Nazeer, considering Stephen's explaination, Could it be the same reason > > for Gbenga and Yubaraj as well for drop-down currency not appearing? > > > > . > > Santosh > > > > On Tue, Nov 14, 2017 at 10:59 AM, Stephen Agyepong < > > [email protected]> wrote: > > > > > Hi All, > > > > > > I did some digging with my problem ("Repayment Scheduleing Type" of the > > > "Create Holiday" feature's dropdown list is empty) and found the > > following > > > issue. > > > The https://localhost:8443/fineract-provider/api/v1/holidays/template > > > endpoint: > > > is missing in the Fineract 1.0.0 branch but exists in the develop > branch > > > > > > package org.apache.fineract.organisation.holiday.api; > > > > > > @Path("/holidays") > > > @Component > > > @Scope("singleton") > > > public class HolidaysApiResource { > > > > > > @GET > > > @Path("/template") > > > @Consumes({MediaType.APPLICATION_JSON}) > > > @Produces({MediaType.APPLICATION_JSON}) > > > public String retrieveRepaymentScheduleUpdationTyeOptions(@Context > > > final UriInfo uriInfo){ > > > this.context.authenticatedUser().validateHasReadPermission( > > > HOLIDAY_RESOURCE_NAME); > > > return this.toApiJsonSerializer.serialize(this. > > > holidayReadPlatformService.retrieveRepaymentScheduleUpdat > > ionTyeOptions()); > > > } > > > > > > Also the following tables are empty: > > > m_holiday > > > m_holiday_office > > > Do we fix the tables or code to resolve the issue? > > > > > > Thanks > > > > > > Stephen > > > > > > On Mon, Nov 13, 2017 at 9:01 AM, Stephen Agyepong < > > > [email protected]> wrote: > > > > > >> Santosh, > > >> > > >> Please find below the screenshots. > > >> I have also attached them just in case. > > >> I see that both of these tables are empty: > > >> m_holiday > > >> m_holiday_office > > >> But m_working_days has an entry > > >> > > >> Do they have anything to do with the problem? > > >> And how/what should be the settings? > > >> > > >> Thanks > > >> > > >> Stephen > > >> > > >>> > > >>> On > > >>> > > >>> > > >>> [image: Inline image 2] > > >>> > > >>> > > >>> [image: Inline image 1] > > >>> > > >>> On Fri, Nov 10, 2017 at 12:07 AM, Santosh Math < > > >>> [email protected]> wrote: > > >>> > > >>>> Hi Stephen, > > >>>> > > >>>> If you are using Google chrome, right click and then click on > inspect > > >>>> element. Then go to 'Network' mode and try to click on drop-down > menu > > >>>> for > > >>>> 'repayment schedule type'. > > >>>> > > >>>> Just take the screenshot and share with us. > > >>>> > > >>>> OR > > >>>> > > >>>> While clicking on drop-down menu , please share screenshot of > tomcat > > >>>> log > > >>>> where you are running it. > > >>>> > > >>>> Regards > > >>>> Santosh > > >>>> > > >>>> On Thu, Nov 9, 2017 at 9:34 PM, Stephen Agyepong < > > >>>> [email protected]> > > >>>> wrote: > > >>>> > > >>>> > Santosh, > > >>>> > > > >>>> > I created a fresh database and ran > > >>>> > $ ..\gradlew clean tomcatrunwar > > >>>> > > > >>>> > The database got populated. > > >>>> > I see, for example, the following entry in m_working_days > > >>>> > id recurrence > > >>>> > repayment_rescheduling_enum > > >>>> > extend_term_daily_repayments extend_term_holiday_repayment > > >>>> > 1 FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR,SA,SU 2 > > >>>> > false > > >>>> > false > > >>>> > > > >>>> > But "Repayment Scheduleing Type*" still not populated > > >>>> > > > >>>> > Thanks > > >>>> > > > >>>> > Stephen > > >>>> > > > >>>> > On Wed, Nov 8, 2017 at 11:57 PM, Santosh Math < > > >>>> > [email protected]> wrote: > > >>>> > > > >>>> > > Hi Stephen, > > >>>> > > > > >>>> > > You need not run the command, > > >>>> > > > > >>>> > > \gradlew migrateTenantListDB -PdbName=mifosplatform-tenants > > >>>> > > > > >>>> > > 1. Just create a new fresh database 'mifostenant-default'. > > >>>> > > > > >>>> > > 2. And run ./gradlew clean tomcatrunwar > > >>>> > > > > >>>> > > Migration should happen automatically. > > >>>> > > > > >>>> > > Regards > > >>>> > > Santosh > > >>>> > > > > >>>> > > On Wed, Nov 8, 2017 at 9:19 PM, Stephen Agyepong < > > >>>> > > [email protected]> > > >>>> > > wrote: > > >>>> > > > > >>>> > > > Santosh, > > >>>> > > > > > >>>> > > > I dropped the databases. But got the following error when I > try > > to > > >>>> > > > re-create: > > >>>> > > > $ mysql -u root -pmysql > > >>>> > > > mysql> DROP DATABASE IF EXISTS `mifostenant-default`; > > >>>> > > > mysql> DROP DATABASE IF EXISTS `mifosplatform-tenants`; > > >>>> > > > mysql> CREATE DATABASE `mifosplatform-tenants`; > > >>>> > > > mysql> CREATE DATABASE `mifostenant-default`; > > >>>> > > > > > >>>> > > > ..\gradlew migrateTenantListDB -PdbName=mifosplatform-tenants > > >>>> > > > Listening for transport dt_socket at address: 8005 > > >>>> > > > :migrateTenantListDB > > >>>> > > > Could not execute query > > >>>> > > > org.drizzle.jdbc.internal.common.query.DrizzleQuery@57466fb7: > > >>>> Table > > >>>> > > > '`mifosplatform-tenants`.`schema_version`' already exists > > >>>> > > > :migrateTenantListDB FAILED > > >>>> > > > > > >>>> > > > FAILURE: Build failed with an exception. > > >>>> > > > > > >>>> > > > * Where: > > >>>> > > > Build file 'C:\workspace\fineract\fineract\fineract-provider\ > > >>>> > > build.gradle' > > >>>> > > > line: 461 > > >>>> > > > > > >>>> > > > * What went wrong: > > >>>> > > > Execution failed for task ':flywayMigrate'. > > >>>> > > > > Error occurred while executing flywayMigrate > > >>>> > > > Error executing statement at line 17: CREATE TABLE > > >>>> > > > `mifosplatform-tenants`.`schema_version` ( > > >>>> > > > `version_rank` INT NOT NULL, > > >>>> > > > `installed_rank` INT NOT NULL, > > >>>> > > > `version` VARCHAR(50) NOT NULL, > > >>>> > > > `description` VARCHAR(200) NOT NULL, > > >>>> > > > `type` VARCHAR(20) NOT NULL, > > >>>> > > > `script` VARCHAR(1000) NOT NULL, > > >>>> > > > `checksum` INT, > > >>>> > > > `installed_by` VARCHAR(100) NOT NULL, > > >>>> > > > `installed_on` TIMESTAMP NOT NULL DEFAULT > CURRENT_TIMESTAMP, > > >>>> > > > `execution_time` INT NOT NULL, > > >>>> > > > `success` BOOL NOT NULL > > >>>> > > > ) ENGINE=InnoDB > > >>>> > > > Table '`mifosplatform-tenants`.`schema_version`' already > > exists > > >>>> > > > Table '`mifosplatform-tenants`.`schema_version`' already > > exists > > >>>> > > > > > >>>> > > > > > >>>> > > > * Try: > > >>>> > > > Run with --stacktrace option to get the stack trace. Run with > > >>>> --info or > > >>>> > > > --debug option to get more log output. > > >>>> > > > > > >>>> > > > BUILD FAILED > > >>>> > > > > > >>>> > > > Total time: 3 mins 5.609 secs > > >>>> > > > > > >>>> > > > > > >>>> > > > > > >>>> > > > On Wed, Nov 8, 2017 at 8:13 AM, Santosh Math < > > >>>> > > > [email protected]> wrote: > > >>>> > > > > > >>>> > > > > Hi Stephen, > > >>>> > > > > > > >>>> > > > > Could you create new database and try the same with it? > > >>>> > > > > > > >>>> > > > > > > >>>> > > > > .Santosh > > >>>> > > > > > > >>>> > > > > On Wed, Nov 8, 2017 at 6:39 PM, Stephen Agyepong < > > >>>> > > > > [email protected]> > > >>>> > > > > wrote: > > >>>> > > > > > > >>>> > > > > > Santosh, > > >>>> > > > > > > > >>>> > > > > > I am running it locally on my laptop (Windows 10). > > >>>> > > > > > I guessed it was database related because when I point to > > the > > >>>> demo > > >>>> > > the > > >>>> > > > > list > > >>>> > > > > > is populated: > > >>>> > > > > > http://localhost:9002/?baseApiUrl=https://demo. > openmf.org#/ > > >>>> > > > > > > > >>>> > > > > > But when I point locally it is not populated: > > >>>> > > > > > https://localhost:8443/community-app/app/index.html#/ > > >>>> > > > > > http://localhost:9002/?baseApiUrl=https://localhost: > > >>>> > > > > > 8443&tenantIdentifier=default > > >>>> > > > > > http://localhost:9002/?baseApiUrl=https://localhost: > > >>>> > > > > > 8443&tenantIdentifier=default#/createholiday > > >>>> > > > > > > > >>>> > > > > > Question is how do I fix this? I followed these links > > >>>> > > > > > > > >>>> > > > > > https://github.com/openMF/community-app/tree/develop > > >>>> > > > > > https://github.com/apache/fineract > > >>>> > > > > > > > >>>> > > > > > Run the following commands: > > >>>> > > > > > > > >>>> > > > > > 1. ./gradlew migrateTenantListDB > > >>>> -PdbName=mifosplatform-tenants > > >>>> > > > > > 2. ./gradlew migrateTenantDB > -PdbName=mifostenant-default > > >>>> > > > > > > > >>>> > > > > > > > >>>> > > > > > Is it possible to get a copy of the demo DB on my local > > >>>> machine? > > >>>> > > > > > > > >>>> > > > > > Thanks > > >>>> > > > > > > > >>>> > > > > > Stephen > > >>>> > > > > > > > >>>> > > > > > > > >>>> > > > > > On Tue, Nov 7, 2017 at 11:20 PM, Santosh Math < > > >>>> > > > > > [email protected]> wrote: > > >>>> > > > > > > > >>>> > > > > > > Adding +Nazeer. > > >>>> > > > > > > > > >>>> > > > > > > > > >>>> > > > > > > Hi Stephen, > > >>>> > > > > > > > > >>>> > > > > > > It's more likely database migration issue at your side. > > Are > > >>>> you > > >>>> > > > running > > >>>> > > > > > it > > >>>> > > > > > > locally in your machine or hosted somewhere? > > >>>> > > > > > > > > >>>> > > > > > > > > >>>> > > > > > > Regards > > >>>> > > > > > > Santosh > > >>>> > > > > > > > > >>>> > > > > > > On Tue, Nov 7, 2017 at 7:56 PM, Stephen Agyepong < > > >>>> > > > > > > [email protected]> wrote: > > >>>> > > > > > > > > >>>> > > > > > >> Hi, > > >>>> > > > > > >> > > >>>> > > > > > >> I am trying to setup a New Head Office on my local > > machine > > >>>> > > (Windows > > >>>> > > > > 10) > > >>>> > > > > > >> but > > >>>> > > > > > >> have issues. > > >>>> > > > > > >> For example, the "Repayment Scheduleing Type" of the > > >>>> "Create > > >>>> > > > Holiday" > > >>>> > > > > > >> feature's dropdown list is empty. > > >>>> > > > > > >> How does it get populated? > > >>>> > > > > > >> I am following this link: > > >>>> > > > > > >> https://mifosforge.jira.com/wi > > >>>> ki/spaces/docs/pages/67895348/ > > >>>> > > > > > >> Initial+System+Set+Up?preview > > >>>> > > > > > >> > > >>>> > > > > > >> What am I missing? > > >>>> > > > > > >> > > >>>> > > > > > >> Thanks > > >>>> > > > > > >> > > >>>> > > > > > >> Stephen > > >>>> > > > > > >> > > >>>> > > > > > >> On Tue, Oct 31, 2017 at 12:25 PM, Ed Cable < > > >>>> [email protected]> > > >>>> > > > wrote: > > >>>> > > > > > >> > > >>>> > > > > > >> > Thanks Santosh. I added bullet loan to the title for > > >>>> people > > >>>> > that > > >>>> > > > > > search > > >>>> > > > > > >> > that. > > >>>> > > > > > >> > > > >>>> > > > > > >> > Ed > > >>>> > > > > > >> > > > >>>> > > > > > >> > On Tue, Oct 31, 2017 at 9:21 AM, Santosh Math < > > >>>> > > > > > >> > [email protected]> wrote: > > >>>> > > > > > >> > > > >>>> > > > > > >> > > Hi Ed, > > >>>> > > > > > >> > > > > >>>> > > > > > >> > > I documented it here with little more and concise > > >>>> > description: > > >>>> > > > > > >> > > > > >>>> > > > > > >> > > http://mifos.cloud.answerhub.c > > >>>> om/questions/2393/how-to-pay- > > >>>> > > > > > >> > > whole-principal-or-whole-principalinter.html? > > >>>> > > > > > >> > childToView=2394#answer-2394 > > >>>> > > > > > >> > > > > >>>> > > > > > >> > > Related to variable instalment, I will reproduce > the > > >>>> > scenario > > >>>> > > > and > > >>>> > > > > > let > > >>>> > > > > > >> me > > >>>> > > > > > >> > > come back on that. > > >>>> > > > > > >> > > > > >>>> > > > > > >> > > Thanks > > >>>> > > > > > >> > > Santosh > > >>>> > > > > > >> > > > > >>>> > > > > > >> > > On Tue, Oct 31, 2017 at 9:29 PM, Ed Cable < > > >>>> > [email protected]> > > >>>> > > > > > wrote: > > >>>> > > > > > >> > > > > >>>> > > > > > >> > >> Santosh, > > >>>> > > > > > >> > >> > > >>>> > > > > > >> > >> Could we document that as a solution in AnswerHub? > > >>>> > > > > > >> > >> > > >>>> > > > > > >> > >> Ed > > >>>> > > > > > >> > >> > > >>>> > > > > > >> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math < > > >>>> > > > > > >> > >> [email protected]> wrote: > > >>>> > > > > > >> > >> > > >>>> > > > > > >> > >>> Hi Ed, > > >>>> > > > > > >> > >>> > > >>>> > > > > > >> > >>> I created one scenario here- all principal only > > paid > > >>>> at > > >>>> > last > > >>>> > > > > > >> > instalment- > > >>>> > > > > > >> > >>> using moratorium on Principal payment. > > >>>> > > > > > >> > >>> > > >>>> > > > > > >> > >>> https://demo.openmf.org/#/viewloanaccount/1722 > > >>>> > > > > > >> > >>> > > >>>> > > > > > >> > >>> If number of instalments are 'n' and then set > > >>>> moratorium > > >>>> > on > > >>>> > > > > > >> principal > > >>>> > > > > > >> > >>> payment as 'n-1' > > >>>> > > > > > >> > >>> > > >>>> > > > > > >> > >>> in above link n=4. > > >>>> > > > > > >> > >>> > > >>>> > > > > > >> > >>> > > >>>> > > > > > >> > >>> Thanks > > >>>> > > > > > >> > >>> Santosh > > >>>> > > > > > >> > >>> > > >>>> > > > > > >> > >>> On Tue, Oct 31, 2017 at 7:59 PM, Ed Cable < > > >>>> > > [email protected]> > > >>>> > > > > > >> wrote: > > >>>> > > > > > >> > >>> > > >>>> > > > > > >> > >>>> Santosh or others, > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> I was trying to test out configuration of a > bullet > > >>>> loan > > >>>> > > (all > > >>>> > > > > > >> principal > > >>>> > > > > > >> > >>>> or principal/interest) to be repaid in the final > > >>>> > > installment > > >>>> > > > of > > >>>> > > > > > the > > >>>> > > > > > >> > loan. > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> I was going to try two approaches and ended up > > >>>> doing mix > > >>>> > of > > >>>> > > > the > > >>>> > > > > > >> two to > > >>>> > > > > > >> > >>>> achieve my purpose but I think it could be made > > >>>> easier. > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> *Approach 1: * > > >>>> > > > > > >> > >>>> - Set loan term to # of months for total > maturity > > >>>> of loan > > >>>> > > > (i.e. > > >>>> > > > > > 24 > > >>>> > > > > > >> > >>>> months) > > >>>> > > > > > >> > >>>> - Set # of repayments to 1. > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> Expected: Repayment schedule has the 1 one > > >>>> repayment as > > >>>> > the > > >>>> > > > > final > > >>>> > > > > > >> date > > >>>> > > > > > >> > >>>> in the maturity of the loan > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> Actual: Repayment date is first due after > > disbursal > > >>>> (i.e. > > >>>> > > > first > > >>>> > > > > > >> > month). > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> Approach 2: > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> - Create a full schedule > > >>>> > > > > > >> > >>>> - Modify repayment schedule and delete all the > > >>>> payments > > >>>> > > > except > > >>>> > > > > > the > > >>>> > > > > > >> > last > > >>>> > > > > > >> > >>>> one and modify installments amount to be total. > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> Expected: successful loan creation > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> Actual: got several different errors even > though I > > >>>> had > > >>>> > set > > >>>> > > > max > > >>>> > > > > > gap > > >>>> > > > > > >> in > > >>>> > > > > > >> > >>>> installment to be greater than the gap I was > > >>>> testing. > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> validation.msg.loan.variable. > > >>>> > schedule.date.must.be.in.min. > > >>>> > > ma > > >>>> > > > > > >> x.range > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> Blended Approach: > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> - At last I just did what I did in approach 1 > and > > >>>> then i > > >>>> > > > > modified > > >>>> > > > > > >> > >>>> repayment schedule to adjust the installment > date > > >>>> till > > >>>> > the > > >>>> > > > > > maturity > > >>>> > > > > > >> > date. > > >>>> > > > > > >> > >>>> Originally I thought i had to do find this > > maturity > > >>>> date > > >>>> > on > > >>>> > > > my > > >>>> > > > > > own > > >>>> > > > > > >> > but then > > >>>> > > > > > >> > >>>> I realize it was displayed so this isn't too > bad. > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> Alternatively one could specify first repayment > > >>>> date as > > >>>> > > this > > >>>> > > > > > >> maturity > > >>>> > > > > > >> > >>>> date too. > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> Is this the approach one should take? > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> -- > > >>>> > > > > > >> > >>>> *Ed Cable* > > >>>> > > > > > >> > >>>> President/CEO, Mifos Initiative > > >>>> > > > > > >> > >>>> [email protected] | Skype: edcable | Mobile: > > >>>> > > +1.484.477.8649 > > >>>> > > > > > >> <(484)%20477-8649> > > >>>> > > > > > >> > >>>> <(484)%20477-8649> > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> *Collectively Creating a World of 3 Billion > Maries > > >>>> | * > > >>>> > > > > > >> > http://mifos.org > > >>>> > > > > > >> > >>>> <http://facebook.com/mifos> < > > >>>> > http://www.twitter.com/mifos > > >>>> > > > > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>>> > > >>>> > > > > > >> > >>> > > >>>> > > > > > >> > >> > > >>>> > > > > > >> > >> > > >>>> > > > > > >> > >> -- > > >>>> > > > > > >> > >> *Ed Cable* > > >>>> > > > > > >> > >> President/CEO, Mifos Initiative > > >>>> > > > > > >> > >> [email protected] | Skype: edcable | Mobile: > > >>>> > +1.484.477.8649 > > >>>> > > > > > >> <(484)%20477-8649> > > >>>> > > > > > >> > >> <(484)%20477-8649> > > >>>> > > > > > >> > >> > > >>>> > > > > > >> > >> *Collectively Creating a World of 3 Billion Maries > > | * > > >>>> > > > > > >> http://mifos.org > > >>>> > > > > > >> > >> <http://facebook.com/mifos> < > > >>>> http://www.twitter.com/mifos > > >>>> > > > > >>>> > > > > > >> > >> > > >>>> > > > > > >> > >> > > >>>> > > > > > >> > > > > >>>> > > > > > >> > > > >>>> > > > > > >> > > > >>>> > > > > > >> > -- > > >>>> > > > > > >> > *Ed Cable* > > >>>> > > > > > >> > President/CEO, Mifos Initiative > > >>>> > > > > > >> > [email protected] | Skype: edcable | Mobile: > > >>>> +1.484.477.8649 > > >>>> > > > > > >> <(484)%20477-8649> > > >>>> > > > > > >> > > > >>>> > > > > > >> > *Collectively Creating a World of 3 Billion Maries | > * > > >>>> > > > > > http://mifos.org > > >>>> > > > > > >> > <http://facebook.com/mifos> < > > >>>> http://www.twitter.com/mifos> > > >>>> > > > > > >> > > > >>>> > > > > > >> > > >>>> > > > > > > > > >>>> > > > > > > > > >>>> > > > > > > ------------------------------ > > >>>> ------------------------------ > > >>>> > > > > > > ------------------ > > >>>> > > > > > > Check out the vibrant tech community on one of the > world's > > >>>> most > > >>>> > > > > > > engaging tech sites, Slashdot.org! > > http://sdm.link/slashdot > > >>>> > > > > > > Mifos-developer mailing list > > >>>> > > > > > > [email protected] > > >>>> > > > > > > Unsubscribe or change settings at: > > >>>> > > > > > > https://lists.sourceforge.net/ > > >>>> lists/listinfo/mifos-developer > > >>>> > > > > > > > > >>>> > > > > > > > >>>> > > > > > > >>>> > > > > > >>>> > > > > >>>> > > > >>>> > > >>> > > >>> > > >> > > > > > >
