Gayl, Natu,

congrats on getting it working Natu!

there is a version of the data migration templates I worked on in the
Mifos source control repository:

/documents/deployment/AlMajmoua/migrator

these are very specific to one MFI (because of configuration, custom
fields, business rules, etc.) so I think it is better to record &
write your own selenium scripts for other MFIs.


Sam



On Jul 10, 1:24 pm, Natu Lauchande <[email protected]> wrote:
> Hi Sam,
>
> Your approach with sellenium works really very well at least for clients and
> groups, thank you very much, is actually safer and more easy than playing
> around with sql inserts.
>
> Regards,
> Natu
>
>
>
> On Fri, Jul 9, 2010 at 9:41 AM, Sam Birney <[email protected]> wrote:
>
> > Hi Natu,
>
> > (sharing with the mifos-users list in case it helps others or anyone else
> > has suggestions)
>
> > >Did you do the open balances automatically  automatically ? If yes what
> > was your approach.
>
> > We exported the principal remaining on the loan and the interest remaining
> > on the loan as two separate values.  Then the script entered the remaining
> > principal as the loan amount in mifos and used a formula to calculate the
> > effective interest rate for the remaining loan.  The formula, for flat
> > interest for monthly loans, was:
>
> > (((remaining interest) / (remaining principal)) * 12 * 100) / (installments
> > left)
>
> > So, for example, let's say there was a 12 month loan of $1200 with 10% flat
> > yearly interest.  So each payment should be $100 principal + $10 interest.
> >  Let's say the client has already made 3 repayments.
>
> > So the script would enter a 9-month loan in Mifos with an amount of $900
> > and use this formula to enter a calculated interest rate of 13.3333333333%.
> >  This should result in a schedule that correctly has 9 payments left each
> > with $100 principal and $10 interest.
>
> > This is the basic idea.  We enhanced it to handle clients who were overdue
> > by using the formula above on the scheduled amounts remaining, and then
> > adding fees for any interest and principal that was already overdue.
>
> > So, in the example above, let's say the client had only made 2 payments out
> > of the 3 that were due.  We would still calculate the migrated loan as if 3
> > payments had been made, so that the schedule matches the old schedule, then
> > we would add a $100 "overdue principal" fee and a $10 "overdue interest" fee
> > as the script enters the loan.
>
> > Similarly, some clients were already ahead on their future payments.  We
> > still calculated the migrated loan in the same way, based on scheduled
> > amounts, but then the script applied a payment to the loan, after approving
> > it and disbursing it, to reflect what had already been paid in advance.  So
> > if the client above had made 4 payments even though only 3 were due, the
> > loan was the same, but then the script applied a payment of $110.
>
> > So, to do this approach you need to export these fields from the existing
> > data:
>
> > * scheduled principal remaining
> > * scheduled interest remaining
> > * total principal remaining
> > * total interest remaining
> > * number of installments remaining
>
> > And if you have any clients with outstanding fee or penalty amounts, you
> > can also export these fields and have your script apply them to the migrated
> > loan.
>
> > Sam
>
> > On Thu, Jul 8, 2010 at 6:02 PM, Natu Lauchande <[email protected]>wrote:
>
> >> Hi Sam,
>
> >> Thank you very much for your answers. I still have some questions on the
> >> answers that you gave.
>
> >> On Thu, Jul 8, 2010 at 10:01 AM, Sam Birney <[email protected]> wrote:
>
> >>> Hi Natu,
>
> >>> it was successful using selenium for data migration.  For your questions-
>
> >>> * backdate payments -- the approach we chose was to only migrate opening
> >>> balances (no historical payments).  So, if the loan was $1000 and $300 was
> >>> already paid, then we created a migrated loan for $700, and we marked in 
> >>> the
> >>> "historical data" page that the original loan was actually $1000.
>
> >>> Did you do the open balances automatically  automatically ? If yes what
> >> was your approach.
>
> >>> * meeting schedules -- we used "Loan Schedule Independent of Meeting
> >>> Schedule" (LSIM) configuration
>
> >>> * mandatory fields -- when we did not have data to migrate for some
> >>> fields, we tried to make them non-mandatory for migration (and then set 
> >>> them
> >>> back to mandatory for data entry of new loans where desired).  Where that
> >>> was not possible, we just had the selenium script enter "N/A" or "X".
>
> >>> hope this helps,
> >>> Sam
>
> >>> Regards,
> >> Natu
>
>
>
> --------------------------------------------------------------------------- 
> ---
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first --http://p.sf.net/sfu/sprint-com-first
>
> _______________________________________________
> Mifos-users mailing list
> [email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users

Reply via email to