terencemo/mifos-import

To import data into Mifos

Mifos Import

Mifos Import is a set of Perl scripts to import data into Mifos. Currenty, the following data can be imported:

• Offices (all levels) - Regional, Divisional, Area, Branch Offices
• Centers
• Groups

Usage Instructions

Download the source scripts, and run the following command:

perl Makefile.PL

This may require you to install the recent version of Test::WWW::Mechanize and Test::WWW::Selenium from CPAN if you don't already have them. Next, create a file settings.conf with your mifos login configuration, like:

mifos_url   http://mifos-domain.com
username    mifos
password    testmifos

Importing Offices

To import offices, create a CSV with the office details having the following columns:

1. Office Name
2. Short Name
3. Parent Office
4. Address Line1
5. Address Line2
6. Address Line3
7. Office City
8. Office State
9. Office Country
10. Office Zip
11. Office Phone Number

Then run the following command:

perl create-offices.pl officelevel(1-5) offices.csv

Importing Centers

This requires the Selenium standalone server running. Download it from http://seleniumhq.org/download/ and run it as follows:

$ java -jar selenium-server-standalone-<version>.jar

Then, create a CSV with the office details having the following columns:

1. Branch
2. Center Name
3. Loan Officer
4. Meeting Schedule (e.g Weekly:DayOfWeek:Location)
5. MFI Joining Date (dd/mm/YYYY)
6. Address 1
7. Address 2
8. Address 3
9. District
10. State
11. Country
12. Postal Code (PIN/ZIP)
13. Telephone
14. Fee 1 Type
15. Fee 1 Amount
16. Fee 2 Type
17. Fee 2 Amount
18. Fee 3 Type
19. Fee 3 Amount

Import the centers by running the script:

perl create-centers.pl centers.csv

Importing Groups

As with centers, this requires the Selenium standalone server running. Create a CSV with the group details having the following columns:

1. Center
2. Group Name
3. Recruited by (loan officer name)
4. Training Date (dd/mm/YYYY)
5. Address 1
6. Address 2
7. Address 3
8. District/City
9. State
10. Country
11. Postal Code (PIN/ZIP)
12. Telephone
13. Fee 1 Type
14. Fee 1 Amount
15. Fee 2 Type
16. Fee 2 Amount
17. Fee 3 Type
18. Fee 3 Amount

Import the groups by running the script:

perl create-groups.pl groups.csv

mifos-import's Issues

Training Date in create-groups

create-groups.pl does not set the training date