Naganand, I suspect that the account_id != global_account_num. Have you tried setting it to the account.account_id instead?
Ryan On 2/5/10 13:18, "Naganand" <nag.mifosu...@gmail.com> wrote: > > > Hi all, > > We are facing a issue in using the admin document feature in mifos version > 1.3. [system properties attached below] > > We have designed a loan passbook template using the birt version 2.1.2 to be > used to be printed for all disbursed loan accounts in mifos and handed over to > the clients. > > We are able to run the template as a normal report in Mifos by using the > global account number of the loan [global_account_num in accounts table] as a > parameter. And the report runs well. > > But when we are trying to upload the report as a admin document using the > standard instructions given in mifos documents [which I have attached below], > it is not running and timing out. > > We are not able to find out the issue. Please help us resolve the same. > > I am also attaching the report for checking. > > The credentials are as follows: > > Dbname = mifos > User = root > Password = mifos > Host=localhost > > Creating a Receipt Template (Administrative Documents) > <http://www.mifos.org/knowledge/reporting/reporting-in-mifos#id11> > The Administrative Documents feature in Mifos allows you to generate a receipt > for an account -- without having to use the Reports tab. You can also use this > feature to generate other administrative documents specific to an account, > such as vouchers and passbooks. > > To create a receipt template: > 1. In BIRT, open a new template. You do not need to specify a data source -- > the Mifos database will be automatically used. > 2. Use the following parameters, in the following order: > * userId > * account_id > * reportName > 1. In Mifos, upload the template using the Upload new Admin document link on > the Admin tab. A receipt link will automatically appear on client loan account > pages. Note the template must be a BIRT report design document which has an > extension of '.rptdesign'. > When you click an account's receipt link, the system automatically passes in > the account ID of the loan account and generates a receipt, based on the BIRT > template design you uploaded. > > > > System Information: > > > Operating System / Arch / Version Windows 2003 / x86 / 5.2 > Java Vendor / Version Sun Microsystems Inc. / 1.6.0_07 > Database Vendor / Version MySQL / 5.0.51a-3ubuntu5.4-log > Database Driver / Version MySQL-AB JDBC Driver / > mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} ) > Application Server Apache Tomcat/6.0.14 > Mifos Database Version 213 > Subversion Revision Number branches/v1.3.x/applicat...@15807 > Custom Reports Directory D:\MifosApp\Mifos1.1Tomcat\webapps\mifos\report > Database Parameter Source > [D:\MifosApp\Mifos1.1Tomcat\webapps\mifos\WEB-INF\classes\org\mifos\config\res > ources\mainDatabase.properties, D:\MifosApp\config\local.properties] > Database Server 172.16.0.2 > Database Port 3306 > Database Name mifos > Database User appu...@172.16.0.1 > Date and Time 05/02/10 12:34 > Date and Time in ISO8601 format 2010-02-05T12:34:21.519+05:30 > > > > Regards, > > > > Nagananda Kumar. K.N > Deputy General Manager [Information Technology] > Grameen Financial Services Pvt. Ltd > Avalahalli, Anjanapura Post, > Bangalore > Karnataka > India > PinCode: 560062 > Ph: 080-28436237, Fax: 080 28436577 > Mob: 9845104252 > Email:nagan...@grameenkoota.org > Website: www.grameenkoota.org <http://www.grameenkoota.org> > > > > > ------------------------------------------------------------------------------ > The Planet: dedicated and managed hosting, cloud storage, colocation > Stay online with enterprise data centers and the best network in the business > Choose flexible plans and management services without long-term contracts > Personal 24x7 support from experience hosting pros just a phone call away. > http://p.sf.net/sfu/theplanet-com > > _______________________________________________ > Mifos-users mailing list > Mifos-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users -- Ryan Whitney Mifos Technical Program Manager rwhit...@grameenfoundation.org Mifos - Technology that Empowers Microfinance (www.mifos.org) Our mission is to enable the poor, especially the poorest, to create a world without poverty. <http://grameenfoundation.org/take-action/ingenuity-fund-challenge/> P please consider the environment before printing this e-mail.
<<image.gif>>
------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
