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