Hi all, I was able to get the report to display after making the changes as per Pramod's email. Thanks. The report looks good. However I have some queries around this: 1. <quote>First you need to create 2 loan products and 2 savings products. Then enter the ids of these product offerings in this file (you can get the ids by a "select prd_offering_id from prd_offering") </quote> Why is this required? If I add more products do i have to update this file? Or is 2 the minimum?.. basically i want to understand the logic behind this. It seems counterintuitive to set a "dynamic" id that is generated when a product is created into a resource file. Or is this a limitation of BIRT report? 2. I tested the report with 4 meeting dates being passed and saw the correspoding reports. However the older ones that i have printed and also collected from the enter collection sheet data interface still show up. This means that as we move forward, the select date field will display a lot of dates? Or is there a cutoff i can set somewhere. In other words once a collection sheet is generated how can i make it not show up in the list. 3. There is a setting MFI can set through applicationConfiguration.custom.properties , the property being CollectionSheet.DaysInAdvance=1. Is this property being used when generating collection sheets, and if yes what is the maximum number of days that can be set? The testing i have done are not complete but mostly to see how things would work.. We will be testing with some real data next few weeks and I will send more feedback...and suggestions (which could very well fall out of scope for this release ;-) Regards Soham
_____ From: Beth Mazur [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2008 1:22 AM To: [EMAIL PROTECTED]; Pramod Biligiri; Amiruddin Nagri; Nandini Yadalam Subject: RE: [Mifos-developer] Collection sheet report: Is itpart ofthebaseRev? Hi Soham- It will be great to hear how this works for you. We have recently developed this report, and finding out how this works for a range of MFIs will be very helpful for our upcoming release. I have copied the team working on the report also. Thanks, Beth Technical Program Manager on Mifos From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pramod Biligiri Sent: Wednesday, March 05, 2008 4:03 AM To: Developer Cc: [EMAIL PROTECTED]; 'Developer' Subject: Re: [Mifos-developer] Collection sheet report: Is itpart ofthebaseRev? Hi Soham, The Collection Sheet report has a configuration file called reportproducts.properties (present in WEB-INF\classes\org\mifos\application\reports\resources). First you need to create 2 loan products and 2 savings products. Then enter the ids of these product offerings in this file (you can get the ids by a "select prd_offering_id from prd_offering") After setting these values, you can submit the report parameters again using the parameters form page and you should be able to view the report. The output of the CollectionSheetTask batch job is stored in the following tables: coll_sheet, coll_sheet_customer, coll_sheet_loan_details and coll_sheet_savings_details Pramod Biligiri, ThoughtWorks [EMAIL PROTECTED] wrote on 03/05/2008 02:29:30 PM: > Hi Amir > I tried to test this with a basic data set. Just one client who has a > mandatory saving account. I changed the time to 11:59 pm , started the > server which triggered the collection sheet task..i saw logs which are > logging collection sheet related data. But when i view the report its > empty. It is logging an exception, which i have attached with this email. > > Where can I look to see if the data was generated? or better yet how I > troubleshoot this (tables, logs etc). When i go to "enter" the > collection sheet data i do see the proper listing, i.e. the amount to > be deposited for the savings account. > > Thanks > Soham > > From: [EMAIL PROTECTED] [mailto:mifos- > [EMAIL PROTECTED] On Behalf Of Amir Nagri > Sent: Thursday, February 28, 2008 3:35 PM > To: Developer > Subject: Re: [Mifos-developer] Collection sheet report: Is it part ofthebaseRev? > Hi Soham, > > The CollectionSheetTask is configured to run after every 24hrs and is > run automatically around mid night. > > You dont have to run the batch job manually, probably leave the server > running for a night, you should have sufficient data to try and test > Collection Sheet Report. > > Hope this help. > > Regards, > > Amiruddin Nagri, > Bangalore, 560008, KA > India > > Y! IM : [EMAIL PROTECTED] > GTalk : [EMAIL PROTECTED] > > On Thu, Feb 28, 2008 at 1:57 PM, Soham Dhakal <[EMAIL PROTECTED]> wrote: > Hi Beth, > Do i need to do anything special for the collectionSheetTask or is it > automatically set up? > > Thanks > Soham > > > From: [EMAIL PROTECTED] [mailto:mifos- > [EMAIL PROTECTED] On Behalf Of Beth Mazur > Sent: Wednesday, February 27, 2008 1:07 PM > > To: Developer; [EMAIL PROTECTED] > Subject: Re: [Mifos-developer] Collection sheet report: Is it part of > thebaseRev? > Hi Soham- > This patch has been checked in. You can upload the report to Mifos- > the report template is called "LayoutRpt.RptDesign." It can be found > in the code tree under BirtReportDesign. The report will be called > CollectionSheetReport in later revisions. > > Please let me know if you have any feedback and/or questions when > testing this report ,as we have not yet done thorough testing of the > report. The performance is a little slow for the parameter screen > with large data sets. Also, the report is dependent on the > CollectionSheetTask which doesn't currently work in all situations. I > am looking into the issue with the task now. > > Thanks, > Beth > > From: [EMAIL PROTECTED] [mailto:mifos- > [EMAIL PROTECTED] On Behalf Of Soham Dhakal > Sent: Tuesday, February 26, 2008 9:00 PM > To: 'Developer'; [EMAIL PROTECTED] > Subject: [Mifos-developer] Collection sheet report: Is it part of the baseRev? > > Hi All, > I remember a while back Pramod submitted a patch for collection sheet > report. Is this already checked into the code base? If it is, are > there any instructions (special) in setting this up? For e.g. there is > a "days in advance" property in the properties file which is intuitive > but are there any other such requirements? > > > If not where can i get the patch from, I dont see it in the patch queue. > > > Thanks > Soham > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > [attachment "collection sheet_error.txt" deleted by Pramod > Biligiri/India/ThoughtWorks] > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
