You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Stephen Agyepong <st...@gmail.com> on 2017/11/07 14:26:00 UTC
Re: Help in Configuring Bullet Loan in Mifos
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/wiki/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 <ed...@mifos.org> 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 <
> santosh@confluxtechnologies.com> wrote:
>
> > Hi Ed,
> >
> > I documented it here with little more and concise description:
> >
> > http://mifos.cloud.answerhub.com/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 <ed...@mifos.org> wrote:
> >
> >> Santosh,
> >>
> >> Could we document that as a solution in AnswerHub?
> >>
> >> Ed
> >>
> >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
> >> santosh@confluxtechnologies.com> 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 <ed...@mifos.org> 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.max.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
> >>>> edcable@mifos.org | 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>
> >>>>
> >>>>
> >>>
> >>
> >>
> >> --
> >> *Ed Cable*
> >> President/CEO, Mifos Initiative
> >> edcable@mifos.org | 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>
> >>
> >>
> >
>
>
> --
> *Ed Cable*
> President/CEO, Mifos Initiative
> edcable@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>
>
Re: Help in Configuring Bullet Loan in Mifos
Posted by Stephen Agyepong <st...@gmail.com>.
Ed,
I am running
mifosplatform-17.07.01.release
fineract 1.0.0
Thanks
On Tue, Nov 7, 2017 at 9:39 AM, Ed Cable <ed...@mifos.org> wrote:
> So stephen you don't see the two values in the dropdown here? What version
> are you running?
>
>
>
>
> On Tue, Nov 7, 2017 at 6:26 AM, Stephen Agyepong <
> stephenagyepong@gmail.com> 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/wiki/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 <ed...@mifos.org> 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 <
>> > santosh@confluxtechnologies.com> wrote:
>> >
>> > > Hi Ed,
>> > >
>> > > I documented it here with little more and concise description:
>> > >
>> > > http://mifos.cloud.answerhub.com/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 <ed...@mifos.org> wrote:
>> > >
>> > >> Santosh,
>> > >>
>> > >> Could we document that as a solution in AnswerHub?
>> > >>
>> > >> Ed
>> > >>
>> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
>> > >> santosh@confluxtechnologies.com> 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 <ed...@mifos.org>
>> 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
>> > >>>> edcable@mifos.org | 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>
>> > >>>>
>> > >>>>
>> > >>>
>> > >>
>> > >>
>> > >> --
>> > >> *Ed Cable*
>> > >> President/CEO, Mifos Initiative
>> > >> edcable@mifos.org | 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>
>> > >>
>> > >>
>> > >
>> >
>> >
>> > --
>> > *Ed Cable*
>> > President/CEO, Mifos Initiative
>> > edcable@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>
>> >
>>
>
>
>
> --
> *Ed Cable*
> President/CEO, Mifos Initiative
> edcable@mifos.org | 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>
>
>
Re: Help in Configuring Bullet Loan in Mifos
Posted by Ed Cable <ed...@mifos.org>.
So stephen you don't see the two values in the dropdown here? What version
are you running?
On Tue, Nov 7, 2017 at 6:26 AM, Stephen Agyepong <st...@gmail.com>
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/wiki/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 <ed...@mifos.org> 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 <
> > santosh@confluxtechnologies.com> wrote:
> >
> > > Hi Ed,
> > >
> > > I documented it here with little more and concise description:
> > >
> > > http://mifos.cloud.answerhub.com/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 <ed...@mifos.org> wrote:
> > >
> > >> Santosh,
> > >>
> > >> Could we document that as a solution in AnswerHub?
> > >>
> > >> Ed
> > >>
> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
> > >> santosh@confluxtechnologies.com> 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 <ed...@mifos.org> 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.max.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
> > >>>> edcable@mifos.org | 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>
> > >>>>
> > >>>>
> > >>>
> > >>
> > >>
> > >> --
> > >> *Ed Cable*
> > >> President/CEO, Mifos Initiative
> > >> edcable@mifos.org | 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>
> > >>
> > >>
> > >
> >
> >
> > --
> > *Ed Cable*
> > President/CEO, Mifos Initiative
> > edcable@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>
> >
>
--
*Ed Cable*
President/CEO, Mifos Initiative
edcable@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>
Re: [Mifos-developer] Help in Configuring Bullet Loan in Mifos
Posted by Santosh Math <sa...@confluxtechnologies.com>.
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 <
stephenagyepong@gmail.com> 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 <
> santosh@confluxtechnologies.com> 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 <
> > stephenagyepong@gmail.com> 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 <
> > > stephenagyepong@gmail.com> 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 <
> > >>> santosh@confluxtechnologies.com> 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 <
> > >>>> stephenagyepong@gmail.com>
> > >>>> 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 <
> > >>>> > santosh@confluxtechnologies.com> 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 <
> > >>>> > > stephenagyepong@gmail.com>
> > >>>> > > 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 <
> > >>>> > > > santosh@confluxtechnologies.com> 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 <
> > >>>> > > > > stephenagyepong@gmail.com>
> > >>>> > > > > 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 <
> > >>>> > > > > > santosh@confluxtechnologies.com> 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 <
> > >>>> > > > > > > stephenagyepong@gmail.com> 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 <
> > >>>> edcable@mifos.org>
> > >>>> > > > 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 <
> > >>>> > > > > > >> > santosh@confluxtechnologies.com> 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 <
> > >>>> > edcable@mifos.org>
> > >>>> > > > > > wrote:
> > >>>> > > > > > >> > >
> > >>>> > > > > > >> > >> Santosh,
> > >>>> > > > > > >> > >>
> > >>>> > > > > > >> > >> Could we document that as a solution in AnswerHub?
> > >>>> > > > > > >> > >>
> > >>>> > > > > > >> > >> Ed
> > >>>> > > > > > >> > >>
> > >>>> > > > > > >> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
> > >>>> > > > > > >> > >> santosh@confluxtechnologies.com> 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 <
> > >>>> > > edcable@mifos.org>
> > >>>> > > > > > >> 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
> > >>>> > > > > > >> > >>>> edcable@mifos.org | 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
> > >>>> > > > > > >> > >> edcable@mifos.org | 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
> > >>>> > > > > > >> > edcable@mifos.org | 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
> > >>>> > > > > > > mifos-developer@lists.sourceforge.net
> > >>>> > > > > > > Unsubscribe or change settings at:
> > >>>> > > > > > > https://lists.sourceforge.net/
> > >>>> lists/listinfo/mifos-developer
> > >>>> > > > > > >
> > >>>> > > > > >
> > >>>> > > > >
> > >>>> > > >
> > >>>> > >
> > >>>> >
> > >>>>
> > >>>
> > >>>
> > >>
> > >
> >
>
Re: [Mifos-developer] Help in Configuring Bullet Loan in Mifos
Posted by Stephen Agyepong <st...@gmail.com>.
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 <
santosh@confluxtechnologies.com> 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 <
> stephenagyepong@gmail.com> 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 <
> > stephenagyepong@gmail.com> 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 <
> >>> santosh@confluxtechnologies.com> 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 <
> >>>> stephenagyepong@gmail.com>
> >>>> 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 <
> >>>> > santosh@confluxtechnologies.com> 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 <
> >>>> > > stephenagyepong@gmail.com>
> >>>> > > 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 <
> >>>> > > > santosh@confluxtechnologies.com> 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 <
> >>>> > > > > stephenagyepong@gmail.com>
> >>>> > > > > 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 <
> >>>> > > > > > santosh@confluxtechnologies.com> 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 <
> >>>> > > > > > > stephenagyepong@gmail.com> 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 <
> >>>> edcable@mifos.org>
> >>>> > > > 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 <
> >>>> > > > > > >> > santosh@confluxtechnologies.com> 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 <
> >>>> > edcable@mifos.org>
> >>>> > > > > > wrote:
> >>>> > > > > > >> > >
> >>>> > > > > > >> > >> Santosh,
> >>>> > > > > > >> > >>
> >>>> > > > > > >> > >> Could we document that as a solution in AnswerHub?
> >>>> > > > > > >> > >>
> >>>> > > > > > >> > >> Ed
> >>>> > > > > > >> > >>
> >>>> > > > > > >> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
> >>>> > > > > > >> > >> santosh@confluxtechnologies.com> 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 <
> >>>> > > edcable@mifos.org>
> >>>> > > > > > >> 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
> >>>> > > > > > >> > >>>> edcable@mifos.org | 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
> >>>> > > > > > >> > >> edcable@mifos.org | 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
> >>>> > > > > > >> > edcable@mifos.org | 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
> >>>> > > > > > > mifos-developer@lists.sourceforge.net
> >>>> > > > > > > Unsubscribe or change settings at:
> >>>> > > > > > > https://lists.sourceforge.net/
> >>>> lists/listinfo/mifos-developer
> >>>> > > > > > >
> >>>> > > > > >
> >>>> > > > >
> >>>> > > >
> >>>> > >
> >>>> >
> >>>>
> >>>
> >>>
> >>
> >
>
Re: [Mifos-developer] Help in Configuring Bullet Loan in Mifos
Posted by Santosh Math <sa...@confluxtechnologies.com>.
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 <
stephenagyepong@gmail.com> 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.retrieveRepaymentScheduleUpdationTyeOptions());
> }
>
> 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 <
> stephenagyepong@gmail.com> 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 <
>>> santosh@confluxtechnologies.com> 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 <
>>>> stephenagyepong@gmail.com>
>>>> 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 <
>>>> > santosh@confluxtechnologies.com> 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 <
>>>> > > stephenagyepong@gmail.com>
>>>> > > 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 <
>>>> > > > santosh@confluxtechnologies.com> 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 <
>>>> > > > > stephenagyepong@gmail.com>
>>>> > > > > 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 <
>>>> > > > > > santosh@confluxtechnologies.com> 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 <
>>>> > > > > > > stephenagyepong@gmail.com> 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 <
>>>> edcable@mifos.org>
>>>> > > > 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 <
>>>> > > > > > >> > santosh@confluxtechnologies.com> 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 <
>>>> > edcable@mifos.org>
>>>> > > > > > wrote:
>>>> > > > > > >> > >
>>>> > > > > > >> > >> Santosh,
>>>> > > > > > >> > >>
>>>> > > > > > >> > >> Could we document that as a solution in AnswerHub?
>>>> > > > > > >> > >>
>>>> > > > > > >> > >> Ed
>>>> > > > > > >> > >>
>>>> > > > > > >> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
>>>> > > > > > >> > >> santosh@confluxtechnologies.com> 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 <
>>>> > > edcable@mifos.org>
>>>> > > > > > >> 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
>>>> > > > > > >> > >>>> edcable@mifos.org | 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
>>>> > > > > > >> > >> edcable@mifos.org | 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
>>>> > > > > > >> > edcable@mifos.org | 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
>>>> > > > > > > mifos-developer@lists.sourceforge.net
>>>> > > > > > > Unsubscribe or change settings at:
>>>> > > > > > > https://lists.sourceforge.net/
>>>> lists/listinfo/mifos-developer
>>>> > > > > > >
>>>> > > > > >
>>>> > > > >
>>>> > > >
>>>> > >
>>>> >
>>>>
>>>
>>>
>>
>
Re: [Mifos-developer] Help in Configuring Bullet Loan in Mifos
Posted by Stephen Agyepong <st...@gmail.com>.
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.retrieveRepaymentScheduleUpdationTyeOptions());
}
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 <stephenagyepong@gmail.com
> 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 <
>> santosh@confluxtechnologies.com> 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 <
>>> stephenagyepong@gmail.com>
>>> 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 <
>>> > santosh@confluxtechnologies.com> 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 <
>>> > > stephenagyepong@gmail.com>
>>> > > 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 <
>>> > > > santosh@confluxtechnologies.com> 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 <
>>> > > > > stephenagyepong@gmail.com>
>>> > > > > 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 <
>>> > > > > > santosh@confluxtechnologies.com> 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 <
>>> > > > > > > stephenagyepong@gmail.com> 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 <
>>> edcable@mifos.org>
>>> > > > 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 <
>>> > > > > > >> > santosh@confluxtechnologies.com> 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 <
>>> > edcable@mifos.org>
>>> > > > > > wrote:
>>> > > > > > >> > >
>>> > > > > > >> > >> Santosh,
>>> > > > > > >> > >>
>>> > > > > > >> > >> Could we document that as a solution in AnswerHub?
>>> > > > > > >> > >>
>>> > > > > > >> > >> Ed
>>> > > > > > >> > >>
>>> > > > > > >> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
>>> > > > > > >> > >> santosh@confluxtechnologies.com> 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 <
>>> > > edcable@mifos.org>
>>> > > > > > >> 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
>>> > > > > > >> > >>>> edcable@mifos.org | 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
>>> > > > > > >> > >> edcable@mifos.org | 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
>>> > > > > > >> > edcable@mifos.org | 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
>>> > > > > > > mifos-developer@lists.sourceforge.net
>>> > > > > > > Unsubscribe or change settings at:
>>> > > > > > > https://lists.sourceforge.net/lists/listinfo/mifos-developer
>>> > > > > > >
>>> > > > > >
>>> > > > >
>>> > > >
>>> > >
>>> >
>>>
>>
>>
>
Re: [Mifos-developer] Help in Configuring Bullet Loan in Mifos
Posted by Stephen Agyepong <st...@gmail.com>.
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 <
> santosh@confluxtechnologies.com> 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 <
>> stephenagyepong@gmail.com>
>> 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 <
>> > santosh@confluxtechnologies.com> 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 <
>> > > stephenagyepong@gmail.com>
>> > > 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 <
>> > > > santosh@confluxtechnologies.com> 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 <
>> > > > > stephenagyepong@gmail.com>
>> > > > > 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 <
>> > > > > > santosh@confluxtechnologies.com> 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 <
>> > > > > > > stephenagyepong@gmail.com> 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/wiki/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 <
>> edcable@mifos.org>
>> > > > 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 <
>> > > > > > >> > santosh@confluxtechnologies.com> 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 <
>> > edcable@mifos.org>
>> > > > > > wrote:
>> > > > > > >> > >
>> > > > > > >> > >> Santosh,
>> > > > > > >> > >>
>> > > > > > >> > >> Could we document that as a solution in AnswerHub?
>> > > > > > >> > >>
>> > > > > > >> > >> Ed
>> > > > > > >> > >>
>> > > > > > >> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
>> > > > > > >> > >> santosh@confluxtechnologies.com> 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 <
>> > > edcable@mifos.org>
>> > > > > > >> 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
>> > > > > > >> > >>>> edcable@mifos.org | 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
>> > > > > > >> > >> edcable@mifos.org | 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
>> > > > > > >> > edcable@mifos.org | 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
>> > > > > > > mifos-developer@lists.sourceforge.net
>> > > > > > > Unsubscribe or change settings at:
>> > > > > > > https://lists.sourceforge.net/lists/listinfo/mifos-developer
>> > > > > > >
>> > > > > >
>> > > > >
>> > > >
>> > >
>> >
>>
>
>
Re: [Mifos-developer] Help in Configuring Bullet Loan in Mifos
Posted by Stephen Agyepong <st...@gmail.com>.
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
[image: Inline image 2]
[image: Inline image 1]
On Fri, Nov 10, 2017 at 12:07 AM, Santosh Math <
santosh@confluxtechnologies.com> 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 <
> stephenagyepong@gmail.com>
> 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 <
> > santosh@confluxtechnologies.com> 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 <
> > > stephenagyepong@gmail.com>
> > > 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 <
> > > > santosh@confluxtechnologies.com> 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 <
> > > > > stephenagyepong@gmail.com>
> > > > > 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 <
> > > > > > santosh@confluxtechnologies.com> 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 <
> > > > > > > stephenagyepong@gmail.com> 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/wiki/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 <edcable@mifos.org
> >
> > > > 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 <
> > > > > > >> > santosh@confluxtechnologies.com> wrote:
> > > > > > >> >
> > > > > > >> > > Hi Ed,
> > > > > > >> > >
> > > > > > >> > > I documented it here with little more and concise
> > description:
> > > > > > >> > >
> > > > > > >> > > http://mifos.cloud.answerhub.
> com/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 <
> > edcable@mifos.org>
> > > > > > wrote:
> > > > > > >> > >
> > > > > > >> > >> Santosh,
> > > > > > >> > >>
> > > > > > >> > >> Could we document that as a solution in AnswerHub?
> > > > > > >> > >>
> > > > > > >> > >> Ed
> > > > > > >> > >>
> > > > > > >> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
> > > > > > >> > >> santosh@confluxtechnologies.com> 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 <
> > > edcable@mifos.org>
> > > > > > >> 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
> > > > > > >> > >>>> edcable@mifos.org | 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
> > > > > > >> > >> edcable@mifos.org | 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
> > > > > > >> > edcable@mifos.org | 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
> > > > > > > mifos-developer@lists.sourceforge.net
> > > > > > > Unsubscribe or change settings at:
> > > > > > > https://lists.sourceforge.net/lists/listinfo/mifos-developer
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
Re: [Mifos-developer] Help in Configuring Bullet Loan in Mifos
Posted by Santosh Math <sa...@confluxtechnologies.com>.
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 <st...@gmail.com>
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 <
> santosh@confluxtechnologies.com> 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 <
> > stephenagyepong@gmail.com>
> > 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 <
> > > santosh@confluxtechnologies.com> 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 <
> > > > stephenagyepong@gmail.com>
> > > > 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 <
> > > > > santosh@confluxtechnologies.com> 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 <
> > > > > > stephenagyepong@gmail.com> 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/wiki/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 <ed...@mifos.org>
> > > 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 <
> > > > > >> > santosh@confluxtechnologies.com> wrote:
> > > > > >> >
> > > > > >> > > Hi Ed,
> > > > > >> > >
> > > > > >> > > I documented it here with little more and concise
> description:
> > > > > >> > >
> > > > > >> > > http://mifos.cloud.answerhub.com/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 <
> edcable@mifos.org>
> > > > > wrote:
> > > > > >> > >
> > > > > >> > >> Santosh,
> > > > > >> > >>
> > > > > >> > >> Could we document that as a solution in AnswerHub?
> > > > > >> > >>
> > > > > >> > >> Ed
> > > > > >> > >>
> > > > > >> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
> > > > > >> > >> santosh@confluxtechnologies.com> 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 <
> > edcable@mifos.org>
> > > > > >> 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
> > > > > >> > >>>> edcable@mifos.org | 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
> > > > > >> > >> edcable@mifos.org | 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
> > > > > >> > edcable@mifos.org | 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
> > > > > > mifos-developer@lists.sourceforge.net
> > > > > > Unsubscribe or change settings at:
> > > > > > https://lists.sourceforge.net/lists/listinfo/mifos-developer
> > > > > >
> > > > >
> > > >
> > >
> >
>
Re: [Mifos-developer] Help in Configuring Bullet Loan in Mifos
Posted by Stephen Agyepong <st...@gmail.com>.
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 <
santosh@confluxtechnologies.com> 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 <
> stephenagyepong@gmail.com>
> 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 <
> > santosh@confluxtechnologies.com> 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 <
> > > stephenagyepong@gmail.com>
> > > 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 <
> > > > santosh@confluxtechnologies.com> 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 <
> > > > > stephenagyepong@gmail.com> 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/wiki/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 <ed...@mifos.org>
> > 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 <
> > > > >> > santosh@confluxtechnologies.com> wrote:
> > > > >> >
> > > > >> > > Hi Ed,
> > > > >> > >
> > > > >> > > I documented it here with little more and concise description:
> > > > >> > >
> > > > >> > > http://mifos.cloud.answerhub.com/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 <ed...@mifos.org>
> > > > wrote:
> > > > >> > >
> > > > >> > >> Santosh,
> > > > >> > >>
> > > > >> > >> Could we document that as a solution in AnswerHub?
> > > > >> > >>
> > > > >> > >> Ed
> > > > >> > >>
> > > > >> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
> > > > >> > >> santosh@confluxtechnologies.com> 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 <
> edcable@mifos.org>
> > > > >> 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
> > > > >> > >>>> edcable@mifos.org | 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
> > > > >> > >> edcable@mifos.org | 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
> > > > >> > edcable@mifos.org | 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
> > > > > mifos-developer@lists.sourceforge.net
> > > > > Unsubscribe or change settings at:
> > > > > https://lists.sourceforge.net/lists/listinfo/mifos-developer
> > > > >
> > > >
> > >
> >
>
Re: [Mifos-developer] Help in Configuring Bullet Loan in Mifos
Posted by Santosh Math <sa...@confluxtechnologies.com>.
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 <st...@gmail.com>
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 <
> santosh@confluxtechnologies.com> 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 <
> > stephenagyepong@gmail.com>
> > 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 <
> > > santosh@confluxtechnologies.com> 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 <
> > > > stephenagyepong@gmail.com> 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/wiki/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 <ed...@mifos.org>
> 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 <
> > > >> > santosh@confluxtechnologies.com> wrote:
> > > >> >
> > > >> > > Hi Ed,
> > > >> > >
> > > >> > > I documented it here with little more and concise description:
> > > >> > >
> > > >> > > http://mifos.cloud.answerhub.com/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 <ed...@mifos.org>
> > > wrote:
> > > >> > >
> > > >> > >> Santosh,
> > > >> > >>
> > > >> > >> Could we document that as a solution in AnswerHub?
> > > >> > >>
> > > >> > >> Ed
> > > >> > >>
> > > >> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
> > > >> > >> santosh@confluxtechnologies.com> 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 <ed...@mifos.org>
> > > >> 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
> > > >> > >>>> edcable@mifos.org | 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
> > > >> > >> edcable@mifos.org | 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
> > > >> > edcable@mifos.org | 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
> > > > mifos-developer@lists.sourceforge.net
> > > > Unsubscribe or change settings at:
> > > > https://lists.sourceforge.net/lists/listinfo/mifos-developer
> > > >
> > >
> >
>
Re: [Mifos-developer] Help in Configuring Bullet Loan in Mifos
Posted by Stephen Agyepong <st...@gmail.com>.
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 <
santosh@confluxtechnologies.com> 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 <
> stephenagyepong@gmail.com>
> 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 <
> > santosh@confluxtechnologies.com> 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 <
> > > stephenagyepong@gmail.com> 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/wiki/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 <ed...@mifos.org> 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 <
> > >> > santosh@confluxtechnologies.com> wrote:
> > >> >
> > >> > > Hi Ed,
> > >> > >
> > >> > > I documented it here with little more and concise description:
> > >> > >
> > >> > > http://mifos.cloud.answerhub.com/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 <ed...@mifos.org>
> > wrote:
> > >> > >
> > >> > >> Santosh,
> > >> > >>
> > >> > >> Could we document that as a solution in AnswerHub?
> > >> > >>
> > >> > >> Ed
> > >> > >>
> > >> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
> > >> > >> santosh@confluxtechnologies.com> 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 <ed...@mifos.org>
> > >> 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
> > >> > >>>> edcable@mifos.org | 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
> > >> > >> edcable@mifos.org | 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
> > >> > edcable@mifos.org | 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
> > > mifos-developer@lists.sourceforge.net
> > > Unsubscribe or change settings at:
> > > https://lists.sourceforge.net/lists/listinfo/mifos-developer
> > >
> >
>
Re: [Mifos-developer] Help in Configuring Bullet Loan in Mifos
Posted by Santosh Math <sa...@confluxtechnologies.com>.
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 <st...@gmail.com>
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 <
> santosh@confluxtechnologies.com> 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 <
> > stephenagyepong@gmail.com> 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/wiki/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 <ed...@mifos.org> 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 <
> >> > santosh@confluxtechnologies.com> wrote:
> >> >
> >> > > Hi Ed,
> >> > >
> >> > > I documented it here with little more and concise description:
> >> > >
> >> > > http://mifos.cloud.answerhub.com/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 <ed...@mifos.org>
> wrote:
> >> > >
> >> > >> Santosh,
> >> > >>
> >> > >> Could we document that as a solution in AnswerHub?
> >> > >>
> >> > >> Ed
> >> > >>
> >> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
> >> > >> santosh@confluxtechnologies.com> 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 <ed...@mifos.org>
> >> 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
> >> > >>>> edcable@mifos.org | 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
> >> > >> edcable@mifos.org | 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
> >> > edcable@mifos.org | 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
> > mifos-developer@lists.sourceforge.net
> > Unsubscribe or change settings at:
> > https://lists.sourceforge.net/lists/listinfo/mifos-developer
> >
>
Re: [Mifos-developer] Help in Configuring Bullet Loan in Mifos
Posted by Stephen Agyepong <st...@gmail.com>.
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 <
santosh@confluxtechnologies.com> 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 <
> stephenagyepong@gmail.com> 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/wiki/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 <ed...@mifos.org> 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 <
>> > santosh@confluxtechnologies.com> wrote:
>> >
>> > > Hi Ed,
>> > >
>> > > I documented it here with little more and concise description:
>> > >
>> > > http://mifos.cloud.answerhub.com/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 <ed...@mifos.org> wrote:
>> > >
>> > >> Santosh,
>> > >>
>> > >> Could we document that as a solution in AnswerHub?
>> > >>
>> > >> Ed
>> > >>
>> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
>> > >> santosh@confluxtechnologies.com> 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 <ed...@mifos.org>
>> 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
>> > >>>> edcable@mifos.org | 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
>> > >> edcable@mifos.org | 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
>> > edcable@mifos.org | 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
> mifos-developer@lists.sourceforge.net
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>
Re: Help in Configuring Bullet Loan in Mifos
Posted by Santosh Math <sa...@confluxtechnologies.com>.
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 <st...@gmail.com>
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/wiki/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 <ed...@mifos.org> 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 <
> > santosh@confluxtechnologies.com> wrote:
> >
> > > Hi Ed,
> > >
> > > I documented it here with little more and concise description:
> > >
> > > http://mifos.cloud.answerhub.com/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 <ed...@mifos.org> wrote:
> > >
> > >> Santosh,
> > >>
> > >> Could we document that as a solution in AnswerHub?
> > >>
> > >> Ed
> > >>
> > >> On Tue, Oct 31, 2017 at 8:25 AM, Santosh Math <
> > >> santosh@confluxtechnologies.com> 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 <ed...@mifos.org> 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.max.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
> > >>>> edcable@mifos.org | 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>
> > >>>>
> > >>>>
> > >>>
> > >>
> > >>
> > >> --
> > >> *Ed Cable*
> > >> President/CEO, Mifos Initiative
> > >> edcable@mifos.org | 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>
> > >>
> > >>
> > >
> >
> >
> > --
> > *Ed Cable*
> > President/CEO, Mifos Initiative
> > edcable@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>
> >
>