[Mifos-users] [Mifos-developer] Family Details issue!

Hey All, I have deployed Mifos 1.5 . This version is suppose to support family details screen of client. I have done the following change in the "applicationConfiguration.default.properties" file ClientInformation.AreFamilyDetailsRequired=true The family screen is coming in ap

Re: [Mifos-users] [Mifos-developer] Family Details issue!

Thanks Jeff! It worked. Thanks & Regards, Ramya Toshniwal * SunGard Technology Services * Embassy Icon,Infantry Road, Bangalore,India Tel +91-80--0501 Extn - 3092 www.sungard.com From: Jeff Brewster [mailto:jbrews...@grameenfoundation.org] Sent: Tuesday, Ju

Re: [Mifos-users] Spouse Birth Date Entry

Hi Trilok, You can add spouse date of birth from the mifos UI on client creation screen. This functionality is available from mifos 1.4 onwards I guess. On client creation screen, once you click submit, automatically the screen for capturing family info will open. It will ask for the spouse d

Re: [Mifos-users] [Mifos-developer] Spouse Birth Date Entry

Trilok, You will find out the one in customer_family_detail table Thanks & Regards, Ramya Toshniwal * SunGard Technology Services * Embassy Icon,Infantry Road, Bangalore,India Tel +91-80--0501 Extn - 3092 www.sungard.com From: Trilok J. Pandya [mailto:tr

Re: [Mifos-users] [Mifos-developer] loan type details

Hi Trilok, If you are asking about the table where you can see the loan product details then it is Prd_offering in Mifos database. Thanks & Regards, Ramya Toshniwal * SunGard Technology Services * Embassy Icon,Infantry Road, Bangalore,India Tel +91-80--0501 Extn - 3240 www.sungar

Re: [Mifos-users] [Mifos-developer] loan type details

One more table. Loan_offering Thanks & Regards, Ramya Toshniwal * SunGard Technology Services * Embassy Icon,Infantry Road, Bangalore,India Tel +91-80--0501 Extn - 3240 www.sungard.com From: ramya.toshni...@sungard.com [mailto:ramya.toshni...@sungard.co

Re: [Mifos-users] Best Web Browser for Pentaho

Hi All, Since I have worked on Pentaho, both IE and Firefox browsers are supported, but Pentaho recommends Firefox to use for its higher flexibility and advantages. It is my experience, certain things may fail due to IE browser but runs fine on Firefox. So it's better to use Firefox. Thanks

Re: [Mifos-users] [Mifos-developer] Want A List Of All Loans Which is not Disbursed

Hi Trilok, Below is the query fetching up all loan accounts details with their customer names. The field ACCOUNT_STATE with value as APPLICATION APPROVED is the one whose loan needs to be disbursed.(already approved but pending for disbursal) select office.display_name as BRANCH, center.d

[Mifos-users] Mifos Support Manual version 1.1!

Dear all, Over the last couple of years, the team at SunGard has been actively involved in providing production and deployment support MIFOS deployments at multiple client locations. In our experience, we have found that supporting the MIFOS deployments is not limited to just resolving the typ

Re: [Mifos-users] Where Is Loan Purpose Stored ?

Hi Trilok, Loan purpose is actually the business_activities_id in loan_account table. So you can find the corresponding purposes in lookup_value table Select loan_account.account_id,lookup_value.lookup_name >From loan_account Left outer join lookup_value on loan_account.business_ac

Re: [Mifos-users] Where Is Loan Purpose Stored ?

Hi Trilok, Loan purpose is actually the business_activities_id in loan_account table. So you can find the corresponding purposes in lookup_value table Select loan_account.account_id,lookup_value.lookup_name >From loan_account Left outer join lookup_value on loan_account.business_ac

Re: [Mifos-users] Fwd: raw_amount_total field on loan_summary table

Hi Milan, I am not very sure, but this field is the sum of the orig_interest and orig_fees fields. But this amount is slightly higher or lower than what we expect due to conversion of the result in the associated currency. Thanks, Ramya From: Milan Patel [mailto:milan.pa...@prosperitas

Re: [Mifos-users] [Mifos-developer] Help On Creating reports

Hi Trilok, Can you please explain the first two reports.. What do you mean by VAR? And please explain a little more what is expected in Loan return report.. Thanks, Ramya From: Trilok J. Pandya [mailto:trilok.pan...@lightmicrofinance.com] Sent: Friday, March 25, 2011 3:52 PM To: Mif

Re: [Mifos-users] [Mifos-developer] Help On Creating reports

Trilok, So, you are saying to view the list of all members whose loan accounts are cancelled for some reason and no new loan account for these opened so far. Right? Thanks, Ramya From: Trilok J. Pandya [mailto:trilok.pan...@lightmicrofinance.com] Sent: Friday, March 25, 2011 5:57 PM T

Re: [Mifos-users] Want A Sql Statement

Hi Trilok, This query will help you in finding out the prepayments happened in the selected range for the given center and group: select center.display_name as CENTER_NAME, grp.display_name as GROUP_NAME, client.display_name as CLIENT_NAME, account_trxn.account_id as ACCOUNTID, account_

Re: [Mifos-users] Reports - seeking SQL statements

Hi Jessica, I think the following might help in your case: I am posting the solutions for first three cases for now a) List future disbursement on a given future time: By this you mean, on a selected future date, what are the disbursements expected. select center.display_name as

Re: [Mifos-users] [Mifos-developer] Jasper reports in Pentaho

Hi Adam, I tried to run a Jasper report in Pentaho Bi server few days back. I followed the same link, but I think there seems to be some plugin problems due to which reports are failing to run. Some properties are missed to be set in the Jaspercomponent of Bi server. With setting of some default p

Re: [Mifos-users] questions about multiple loans

Hi Jessica, This option is given at disbursement not at approval level, since there might be a scenario A center has meeting dates on every Tuesday. A customer has first loan’s installment date as coming Tuesday(next week) and he applies for second loan on this week’s, say Friday. So,

Re: [Mifos-users] sql query challenge

Hi Tajudeen, I think this may help select client.display_name as CLIENT_NAME, account.global_account_num as ACCOUNT_NUM, lookup_value.lookup_name as SAVINGS_TYPE, grp.display_name as GROUP_NAME, savings_account.SAVINGS_BALANCE from customer center inner join customer grp on grp.pare

Re: [Mifos-users] sql query challenge

Hi, Center name was missing select client.display_name as CLIENT_NAME, account.global_account_num as ACCOUNT_NUM, lookup_value.lookup_name as SAVINGS_TYPE, grp.display_name as GROUP_NAME, center.display_name as CENTER_NAME, savings_account.SAVINGS_BALANCE from customer center inner

Re: [Mifos-users] loan arrears aging table

Hi Jessica, Yes the data in this table is injected through the scheduled batch jobs in Mifos. Thanks, Ramya From: Jessica Cheng [mailto:jessica.chen...@gmail.com] Sent: Monday, April 11, 2011 11:22 AM To: A good place to start for users or folks new to Mifos. Subject: [Mifos-users] l

[Mifos-users] Fees!

Hi All, I have an issue in attaching fees to various entities. Let's take a scenario, I have a fees named " fees-five " which is a periodic fees defined at center level whose recurrence is 5 weeks and amount to be collected at every recurrence is Rs. 12. I define a new center "Center-fi

Re: [Mifos-users] Window mifos BI (pentaho) installation

Hi Teejay, If your Mifos and BI server are two separate tomcat applications, make sure that the ports of the two are different, when you try to run both simultaneously. For Mifos, if it is 8080, define 8086 for BI server in web.xml and server.xml files. Thanks, Ramya -Original Message- F

Re: [Mifos-users] Get Data from Question Groups Associated with aSpecific Loan.

Hi Natu, The way Mifos schema has been designed, we divide it into various entities like center, group, client, loan, savings etc. But to capture custom fields against each of these entities, the database tables are same. So, in order to find out the custom field against a specific entity instanc

Re: [Mifos-users] Need Help running Mifos and Pentaho BI Suite Concurently

Hi Thomas, I have installed both Mifos and Bi server on my machine and they run simultaneously. Following are the steps you need to replicate: a) Install Mifos war in your default tomcat which runs on port 8080. Don't change anything in it. Just check whether Mifos runs fine on 8080

[Mifos-users] Repayment Schedule!

Hi All, I have faced a weird situation while generating the loan schedule of an account in Mifos 2.1 when the feature LSIM is disabled. I created one center with meeting recurrence bi-weekly every Friday. When I created one loan account for a client under the same center today, I got the di

Re: [Mifos-users] [Mifos-developer] Repayment Schedule!

Hi Keith, Yeah, I was earlier testing on 2.1.1. But as suggested to try with 2.1.3, everything works perfectly now. Below scenario is not replicating. But I was just going through the Mifos product bugs, I found an issue http://mifosforge.jira.com/browse/MIFOS-5031 Looking at the comments in t

Re: [Mifos-users] Configuring Pentaho database settings and installingETL

Hi Dennis, The SourceDB is your mifos production database, on top of it you want to create the warehouse. So it should be set accordingly. The destinationDB is the name of the warehouse database which will store the processed data warehouse data. It hardly matters what name it has, but the

Re: [Mifos-users] BI

Hi Dennis, The hibernate and quartz are the default databases that comes with Pentaho suite. Apart from that you are suppose to create two DB's SourceDB and DestinationDB which is your mifos and datawarehouse instance respectively. Excecute "D:\mifos_bi-1.2.0\ETL\MifosDataWarehouseETL\load_mi

Re: [Mifos-users] loan cycle count

Hi Jessica, Loan counter is just used to know the loan number of a client against a particular product. There is no direct dependency in database if you update the value in the table, since there are no references to it. Thanks, Ramya From: Jessica Cheng [mailto:jessica.chen...@gmail.com] Sent

Re: [Mifos-users] question about loan disbursement -

Hi Jessica, Receipt ID is an optional field whenever you perform any transaction. Ideally your receipt id should be the receipt number when the mode of payment is cheque. It is stored in your account_payment table. Thanks, Ramya From: Jessica Cheng [mailto:jessica.chen...@gmail.com] Sent: Frida

Re: [Mifos-users] Changing interest mid-way during the loan tenure

Hi Binny, I think the solutions that are assuming for the two scenarios are mismatched. Based on my understanding on reverse and redo, closed-reschedule feature present in Mifos, I think the solutions needs to be interchanged. Reverse and Redo : Whenever you reverse a loan and try to redo it. O