Re: [Mifos-users] Branch progress report and GL report problems

2011-05-20 Thread Ed Cable
Udai (or any others), Any ideas to help Kevin troubleshoot these BIRT errors. -- What Every C/C++ and Fortran developer Should Know! Read this article and learn how Intel has extended the reach of its next-generation tool

Re: [Mifos-users] Branch progress report and GL report problems

2011-04-21 Thread Kevin Kimani
Udai, I managed to open the modified GL report (http://mifosforge.jira.com/browse/MIFOS-3598 ), the branch drop down on the report parameter is populated with the relevant details; in Birt the following are the errors shown. The following items have errors: Data (id = 333): + Column bindin

Re: [Mifos-users] Branch progress report and GL report problems

2011-04-19 Thread Udai Gupta
Kevin, If you are using modified Branch progress and GL reports of 1.5 with 2.1 then you should first see what is the difference in reports and try to update it for 2.1. If you are using 2.1 default reports then check if you have the correct reports which gets bundled with 2.1. You should enable

Re: [Mifos-users] Branch progress report and GL report problems

2011-04-19 Thread Kevin Kimani
hi UDAI, Thanks a lot for the references supplied in the attached email. I have been experiencing similar problems mentioned on this thread (Branch progress report and GL report problems), particularly with the progress report and the GL report for mifos 2.1. I am doing a follow up on the same to

Re: [Mifos-users] branch progress report not showing details of group loans (only client loans)

2010-10-05 Thread Gayl Kennedy
hi, i logged this as a bug this morning. Key: MIFOS-3851 URL: http://mifosforge.jira.com/browse/MIFOS-3851 Regards Gayl On 04/10/2010, Gayl Kennedy wrote: > hi > most of our clients are set up with individual loans under their group. > for > some really delinquent groups (months in arrears and sh

[Mifos-users] branch progress report not showing details of group loans (only client loans)

2010-10-04 Thread Gayl Kennedy
hi most of our clients are set up with individual loans under their group. for some really delinquent groups (months in arrears and should be completed) I added a group loan as we don't want to track at individual level. the loan has been disbursed but is not showing in the branch report under "D

Re: [Mifos-users] Branch progress report "instructions"

2010-09-30 Thread Gayl Kennedy
m] >> Sent: Wednesday, September 29, 2010 1:31 AM >> To: A good place to start for users or folks new to Mifos. >> Subject: Re: [Mifos-users] Branch progress report "instructions" >> >> Thanks for the excel file with the comments Kay, very helpful. >> A cosm

Re: [Mifos-users] Branch progress report "instructions"

2010-09-29 Thread Kay Chau
Original Message- > From: Gayl Kennedy [mailto:gaylkenn...@gmail.com] > Sent: Wednesday, September 29, 2010 1:31 AM > To: A good place to start for users or folks new to Mifos. > Subject: Re: [Mifos-users] Branch progress report "instructions" > > Thanks for the excel fil

Re: [Mifos-users] Branch progress report "instructions"

2010-09-29 Thread Gayl Kennedy
Thanks for the excel file with the comments Kay, very helpful. A cosmetic point - is there a way of changing the default header MFI name to the actual MFI name? Ryan, in an ideal world the fees issue will reduce as they make payments but it could take several months to get them cleared out of the

Re: [Mifos-users] Branch progress report "instructions"

2010-09-28 Thread Ryan Whitney
Gayl, Unfortunately that does fall a bit out of scope for the report. It doesn't make much sense to have fee amounts show up under the arrears portion. The workaround I proposed for migrating data does not work well with our current reports. That said, once the client pays off the initial fee p

Re: [Mifos-users] Branch progress report "instructions"

2010-09-28 Thread Kay Chau
od place to start for users or folks new to Mifos. > Subject: [Mifos-users] Branch progress report "instructions" > > hi > has anybody put together a document outlining how to interpret the > branch progress report? if so I would appreciate getting a copy. > If not I wi

[Mifos-users] Branch progress report "instructions"

2010-09-28 Thread Gayl Kennedy
hi has anybody put together a document outlining how to interpret the branch progress report? if so I would appreciate getting a copy. If not I will put one together. I have a question about something which I was not expecting to find on it. We had a cycle loan repaid early by a group who have si

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-27 Thread Gayl Kennedy
Thank you so much Jeff, we have loan data! I have validated it for the "test branch" data and all appears to be in order. On the live branch data it is showing a centre in arrears but I think it is just that I changed their meeting date but that won't take effect till after the next meeting date.

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-23 Thread Jeff Brewster
Gayl and Kelechi, I have reviewed your custom properties file and understand now why your BranchReport task producing this error: " Unable to find currency with id: 2. You may be missing an entry for the currency with this id in applicationConfiguration.custom.properties. " Since you have the Acc

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-23 Thread kelechi Micheals
hi Jeff, find attached copy of properties file. Thanks. On 09/22/2010 04:57 PM, Jeff Brewster wrote: Hi Jeff I just want to ensure we are the same page here but we still have no loan information showing in the Branch progress report. we have data in the panel to the left - # of clients, loans,

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-22 Thread Jeff Brewster
>Hi Jeff >I just want to ensure we are the same page here but we still have no >loan information showing in the Branch progress report. we have data >in the panel to the left - # of clients, loans, savers, staff etc but >no data yet in the loans disbursed section or aging section. >Please advise >

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-22 Thread Gayl Kennedy
Hi Jeff I just want to ensure we are the same page here but we still have no loan information showing in the Branch progress report. we have data in the panel to the left - # of clients, loans, savers, staff etc but no data yet in the loans disbursed section or aging section. Please advise Thanks

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-21 Thread Jeff Brewster
>I have verified that the Branch Progress report works on all days when the batch successfully completed. Ok, thanks I'll update the jira issue with your findings. >And on the days when the batch did not complete successfully, I see the report comes back to the Report parameter screen and if yo

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-21 Thread Jeff Brewster
> hi Jeff, >Branch ReportTask ran ok, however, I also noticed the following task >returned error, so I commented them out in the task.xml file. > >ApplyCustomerFeeTask >RegenerateScheduleTask >CollectionSheetReportParameterCachingTask > Hi Kelechi, This is expected as these tasks were removed in

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-21 Thread kelechi Micheals
hi Jeff, Branch ReportTask ran ok, however, I also noticed the following task returned error, so I commented them out in the task.xml file. ApplyCustomerFeeTask RegenerateScheduleTask CollectionSheetReportParameterCachingTask so far the properties file seems ok. On 09/20/2010 10:13 PM, Jeff

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-20 Thread Jeff Brewster
Binny and Kelechi, In talking with Udai further, the Progress Report should not require edits, instead we think it is an issue of not having completed batch jobs for that report to run correctly. Can you please confirm your batch jobs have completed for that BranchReportTask? Kelechi, when you la

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-16 Thread Jeff Brewster
>The workaround for this issue is that we should have two versions of >BIRT reports. >1) pre 1.5 users (upper case column names in mifos database) >2) post 1.5 users (lower case column names in mifos database) > >We can not have one report which will work for both user just by >changing the case in

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-16 Thread Udai Gupta
Hi, I think we know one issue with BIRT reports here, i.e column binding (name) is case sensitive in BIRT. http://dev.eclipse.org/newslists/news.eclipse.birt/msg15093.html http://www.informit.com/articles/article.aspx?p=686166&seqNum=3 search "BIRT ROM Data Spec" (google) see column section in th

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-16 Thread kelechi Micheals
: [Mifos-users] Branch progress report and GL report problems Hi Jeff and Binny I can see that the Branch batch job ran on the 10th of Sept so when I use that date I can see some information in the report, mainly # of clients but no loan information. See attached example. I can also see that the

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-15 Thread Jeff Brewster
;) Regards, Jeff >-Original Message- >From: Gayl Kennedy [mailto:gaylkenn...@gmail.com] >Sent: Wednesday, September 15, 2010 8:32 AM >To: A good place to start for users or folks new to Mifos. >Subject: Re: [Mifos-users] Branch progress report and GL report problems > >

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-14 Thread Jeff Brewster
> >If I click submit on this page again without changing the date, I see >the error message 'The parameter "branchReportDate" is required'. I see >this behavior on my laptop where the daily batch job does not get >initiated everyday. Binny, So are you saying you don't have an issue with Branch Pro

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-09 Thread Ryan Whitney
ate for which you are sure the batch job ran > successfully. > > Thanks > Binny > > - Original Message - > From: Gayl Kennedy > To: A good place to start for users or folks new to Mifos. > > Sent: Mon, 6 Sep 2010 17:38:34 +0530 (IST) > Subject: Re: [Mifos-users] Bran

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-08 Thread binnygopinath
r which you are sure the batch job ran successfully. Thanks Binny - Original Message - From: Gayl Kennedy To: A good place to start for users or folks new to Mifos. Sent: Mon, 6 Sep 2010 17:38:34 +0530 (IST) Subject: Re: [Mifos-users] Branch progress report and GL report problems Hi Jef

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-07 Thread Jeff Brewster
org] Sent: Tuesday, September 07, 2010 12:27 AM To: A good place to start for users or folks new to Mifos. Subject: Re: [Mifos-users] Branch progress report and GL report problems thanks Ryan, I have Eclipse Galilio with Birt 2.5.1. (2009 ) version. This should do I guess, I will download 2.5

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-07 Thread Ryan Whitney
This should do I > guess, I will download 2.5.2 all the same and try it out. > > > Ryan Whitney wrote: >> Re: [Mifos-users] Branch progress report and GL report problems Gayl, no ­ >> it doesn¹t matter what area the GL report is uploaded under. Categories are >> ju

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-07 Thread kelechi Micheals
thanks Ryan, I have Eclipse Galilio with Birt 2.5.1. (2009 ) version. This should do I guess, I will download 2.5.2 all the same and try it out. Ryan Whitney wrote: Gayl, no -- it doesn't matter what area the GL report is uploaded under. Categories are just for sorting reports and setting pe

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-06 Thread Ryan Whitney
Gayl, no ­ it doesn¹t matter what area the GL report is uploaded under. Categories are just for sorting reports and setting permissions. Kelechi, ok, that helps in narrowing down the issue. Next area I would look at is trying to run it in the BIRT Report Designer, and see if you can see any error

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-06 Thread kelechi Micheals
hi Ryan, I ran the query against the database and it came up with results. however, with the report it gives blank. Gayl Kennedy wrote: Hi Ryan does it matter what area of reports the new version of the GL report was added to in mifos as we added it under performance and it was originally unde

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-06 Thread Gayl Kennedy
Hi Ryan does it matter what area of reports the new version of the GL report was added to in mifos as we added it under performance and it was originally under analysis. Would it be something simple like that? We definitely have transactions in that date period in my test branch and we entered the

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-06 Thread Ryan Whitney
Gayl, The GL report does not depend on the batch jobs. That shouldn't be the issue. Double check that you have entered transactions for the branch in question between your selected dates, and that you are entering the dates in correctly. Also, you can try running the query directly against your

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-06 Thread Gayl Kennedy
Hi Jeff thanks for the new version. The fix to the GL report is now allowing us to select branch and date but no data is showing so need to check batch jobs etc. We still have the issue with the branch progress report originally referenced on this thread. Regards Gayl On 06/09/2010, Jeff Brews

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-05 Thread Jeff Brewster
>Hi Jeff, > >If I use your modified GL report, it works !! :-) > Good to know Binny. Are you having any issues with the other reports at this point? Jeff -- This SF.net Dev2Dev email is sponsored by: Show off your pa

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-05 Thread binnygopinath
2010 02:51:15 +0530 (IST) Subject: Re: [Mifos-users] Branch progress report and GL report problems Hi Binny, I've attached a modified GL report to the issue noted below. Will you download that report and test it on your laptop? I've lower-cased all of the column names as I noticed the &q

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-03 Thread Jeff Brewster
2 AM >To: A good place to start for users or folks new to Mifos. >Subject: Re: [Mifos-users] Branch progress report and GL report problems > >Gayl, > >Here's the direct link to the issue: > >http://mifosforge.jira.com/browse/MIFOS-3598 > >Ed > ---

Re: [Mifos-users] Branch progress report and GL report problems

2010-08-30 Thread Edward Cable
rds, > > Jeff > > > > > > > > From: Jessica Cheng [mailto:jessica.chen...@gmail.com] > Sent: Wednesday, August 25, 2010 8:48 PM > To: A good place to start for users or folks new to Mifos. > Subject: Re: [Mifos-users] Branch progress report and GL report prob

Re: [Mifos-users] Branch progress report and GL report problems

2010-08-30 Thread Gayl Kennedy
t; > > From: Jessica Cheng [mailto:jessica.chen...@gmail.com] > Sent: Wednesday, August 25, 2010 8:48 PM > To: A good place to start for users or folks new to Mifos. > Subject: Re: [Mifos-users] Branch progress report and GL report problems > > > > Hi Gayle, > > I cre

Re: [Mifos-users] Branch progress report and GL report problems

2010-08-27 Thread Jeff Brewster
tart for users or folks new to Mifos. Subject: Re: [Mifos-users] Branch progress report and GL report problems Hi Gayle, I created a jira issue for this recently, it is Mifos-3598. Regards, Jessica On Wed, Aug 25, 2010 at 10:42 PM, Gayl Kennedy wrote: Hi when I try to run the branch progress

Re: [Mifos-users] Branch progress report and GL report problems

2010-08-26 Thread Ryan Whitney
Gayl, Our standard default login/passwd for mysql is usually mifos/mifos. I¹m going to guess your database login/password might be different. I¹m wondering if the GL and Branch Progress Report are not pulling the connection details correctly and trying mifos/mifos. I¹m hazarding that is what ma

Re: [Mifos-users] Branch progress report and GL report problems

2010-08-26 Thread Gayl Kennedy
Hi Ryan the portfolio at risk report appears to be working (at least can select expected items from drop down) but there is no data in it. Should the current loans be showing even if not overdue? I have a test branch for which loans have been disbursed but nothing is overdue so may be an issue.

Re: [Mifos-users] Branch progress report and GL report problems

2010-08-25 Thread Jessica Cheng
Hi Gayle, I created a jira issue for this recently, it is Mifos-3598. Regards, Jessica On Wed, Aug 25, 2010 at 10:42 PM, Gayl Kennedy wrote: > Hi > when I try to run the branch progress report I get an error message: > the Parameter "BranchReportDate" is required > I have entered in todays date

Re: [Mifos-users] Branch progress report and GL report problems

2010-08-25 Thread Ryan Whitney
Gayl, Are the other standard reports working? Ryan On 8/25/10 22:42, "Gayl Kennedy" wrote: > Hi > when I try to run the branch progress report I get an error message: > the Parameter "BranchReportDate" is required > I have entered in todays date and yesterdays date to no avail. > > When I t

[Mifos-users] Branch progress report and GL report problems

2010-08-25 Thread Gayl Kennedy
Hi when I try to run the branch progress report I get an error message: the Parameter "BranchReportDate" is required I have entered in todays date and yesterdays date to no avail. When I try the General Ledger report the drop down filters have no values (although they do in the branch progress rep

Re: [Mifos-users] branch progress report data queries

2010-07-23 Thread Kay Chau
Hi Gayl, We are looking to release by the end of the month for 1.6. Kay > -Original Message- > From: Gayl Kennedy [mailto:gaylkenn...@gmail.com] > Sent: Friday, July 23, 2010 3:21 PM > To: A good place to start for users or folks new to Mifos. > Subject: Re: [Mifo

Re: [Mifos-users] branch progress report data queries

2010-07-23 Thread Gayl Kennedy
great news, thanks Ryan. Can you set an expectation re 1.6, when you say soon do you mean a matter of days, weeks or a few months? we are planning to start configuring our version in the next week or so as I have done as much as I can on your test demo server so need to include time to upgrade to

Re: [Mifos-users] branch progress report data queries

2010-07-22 Thread Ryan Whitney
Gayl, We discovered a lot of issues with the Branch Progress Report in Mifos 1.5. This is being fixed in Mifos 1.6, which is due to be released soon. Ryan On 7/22/10 20:22, "Gayl Kennedy" wrote: > Hello > I believe the branch progress report is a supported report so I ran it > today on the d

[Mifos-users] Branch Progress Report

2009-09-21 Thread Parthasarathy.Thanda
Hi, We are noticing the Branch Progress Report giving 0 values for some of the report fields - for eg., total active borrowers. Is this an issue faced by others as well? The query the report has for execution returns the correct value when run directly on the db (with parameters substituted) SE