Hi Marina, great to hear of another Mifos deployment in the works. As Ryan alluded to in another message, I have recently done some data migration at Al Majmoua.
first of all, watch this two-minute intro at the top of this web-page: http://seleniumhq.org/ The basic idea is pretty simple: 0. do you base mifos configuration and export a clean database. 1. export data from the legacy MIS into an excel spreadsheet. save the spreadsheet as a tab-delimited unicode text file in our case, but there are many different ways to kill this rat (thanks for the colorful expression). 2. use Selenium IDE to record the Selenese code for creating a new client, approving him/her, creating a loan, approving the loan, disbursing the loan. 3. export this Selenese into the programming language of your choice, whatever is easiest for you to work with... i chose python because it is very good at parsing text files and manipulating strings and lists and because i am reasonably practiced at it. 4. edit the exported code to basically do a for loop that reads each line of your exported data file and then performs the actions you recorded in the UI, passing in variables from the fields you read from the file. 5. run the script, test, make changes, revert to your exported database, run again, etc., repeat as needed, voila, finito! to answer your questions, 1. we exported everything we could from the old MIS and put it into either Mifos standard fields or custom fields: i.e. client name, birthdate, loan officer, gender, etc. 2. no major issues came up as problems, but there have been tons of little details... things like fields we don't want to be mandatory that are, not being able to disburse loans for a future date, meeting schedules, etc, but we found a solution for all of them, one by one. 3. it only took me a couple days to get the basic client data migration automated. a few more days for individual loans and a few more days for group loans (which were a little trickier, but by then I had a good feel for Selenium). In fact the basic idea was working within a few hours of starting, all those days were just for the various details of this or that field or Mifos quirks. I'm happy to share some of the scripts with you as a reference, but it might be better to just try writing your own than reading mine. I can also give a little advice along the way if you like. Unfortunately it is not a generally reusable tool at this point because it depends a lot on the specific configuration, for example we are using Group Lending with Individual Monitoring, Loan Schedule Independent of Meeting Schedule, no Centers, etc., which all affect the UI and therefore the scripts. hope this helps, Sam On Nov 9, 2:37 pm, "Maina Wachira" <[email protected]> wrote: > Hi Everyone, > > It is my hope that this finds you well wherever you are. I had a couple of > questions on the data migration. > > I wanted to find out if there is anyone who has been able to migrate data > into Mifos (excel spread sheets) and the problems they may have encountered > and how they went about it. > > I have divided the questions as below, > > 1. What data migration templates did you use? (What information was > being captured in the templates?) > 2. What are the issues you may have encountered? > 3. How long did it take? > > I got some information from this page but I wanted to find out from the user > list who has been able to go about it and the challenges they may have > faced. > > If I come up with other questions I will share them ASAP. I need to deploy > Mifos at a client's by the end of March and they have about 16,000 clients. > > Thanks for any and every assistance. > > Kind Regards, > > Maina Wachira. > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > > _______________________________________________ > Mifos-users mailing list > [email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
