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
