gmane.comp.finance.mifos.devel

JDBC data set not working in BIRT reports

Hi,
JDBC data sets are not working at all, for BIRT reports uploaded to Mifos. I want to know
if anyone else is seeing the same issue. Can someone try the attached report on your Mifos install and
tell me if it works? This probably broke *just* before we shipped 1.1. I'm trying to figure out when.

I created a barebones JDBC report with JDBC data set and datasource. The DataSet preview from within
Eclipse shows the results of the query quite fine, but I only see blanks when report file is viewed through Mifos.
I looked at MySQL query logs and it shows the query is actually running.

I've uploaded this report on http://test.mifos.org:8085/mifos/. (Look for Reports -> Misc -> "Pramod Jdbc Sample")
The report contains this one query to show Branch Name: select display_name from office where office_id = 5

I hope my connection string, username and password are correct for the test server (jdbc:mysql://localhost:3306/mifos?useUnicode=true&characterEncoding=UTF-8, root, mysql)

I have also attached that report file to this mail if you want to test it yourself.

Pramod Biligiri,
ThoughtWorks

Attachment (JdbcBCC.rptdesign): application/octet-stream, 6019 bytes

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

headers

Ryan Whitney | 27 Aug 10:23

2 Questions about Admin Docs and BIRT

How do we have the system automatically pass in a loan account id to the Admin Doc? (Desire is to pull a report up about the loan in question when its getting approved)
Any ideas on how to convert a numerical value in the database (say like 107.45) to an alphabetical (?) representation (ie, one hundred and seven and forty five cents). The developer here created a library in java, but is not sure how to bring that into Birt. Can he use his java code within the report? Does he need to do it somewhere else?

Thanks,
Ryan
Ryan Whitney
Mifos Technical Program Manager
rwhitney-DnEsXXvMQJxj/JC5u5XAOISLwOllVvif@public.gmane.org
Mifos - Technology that Empowers Microfinance (www.mifos.org)

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

headers

Adam Monsen | 26 Aug 21:21

Re: FW: Acces to source code

Hello there!

I am not familiar with Synchro SVN. I recommend git-svn or svk for
offline Mifos development. Both are truly distributed version control
systems which support local branches.

Please feel welcome to stop by our IRC channel and subscribe to our
mailing lists.

Cheers,
-Adam

On Tue, 2008-08-26 at 12:08 -0400, mtarimo@... wrote:
> From: mifos general alias
> Sent: Tuesday, August 26, 2008 3:40:25 AM 
> To: mifos 
> Subject: Acces to source code 
> 
> I am trying to get mifos code, i would wish to work on it offline as
> connectivity can sometimes be an issue here. I am using Synchro SVN
> Client, could you giv me the steps? 
> I have tried to import but it asks me for username and password, guest
> no password doesnt work! please advise.

--

-- 
Adam Monsen

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

headers

Van Mittal-Henkle | 22 Aug 20:14

Yesterday's community meeting link

Hi all,

It was great to talk to everyone at our community meeting yesterday (the
21st).  There were lots of good questions, comments, ideas and
suggestions.  Thanks for the input!  We'll look forward to talking to
everyone again as work progresses on the Rhino and Cheetah releases.

In the mean time here is the URL to the meeting info including a link to
the presentation (a short version of the same URL follows):

http://www.mifos.org/developers/listserv/meetings

http://tiny.cc/5OTLc

--Van

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

headers

Ryan Whitney | 22 Aug 14:58

Data Migration - MySQL Optimization

Hi all,

We’re working steadily on the data migrations and I’ve been doing some early looking into optimizing MySQL. As we get closer to completing our first set of scripts for customer data, be interested to revisit some of these. I believe some of them, while they didn’t have much impact for this research, may have more once we start working with more tables or the size of inserts (and possibly adding in selects), gets bigger.

For now, the most dramatic improvement was setting innodb_buffer_pool_size to 50% of the available RAM (recommendations online say 50-80%, so I shot low) and set innodb_log_file_size to 25% of the buffer pool size.

Anyways, tests results below

Performed on:
MacBook Pro
    - 2.33 GHz Intel Core 2 Duo
    - 3 GB 667 MHz DDR2 SDRAM

Test sets:
10k Dummy Customer inserts (Names are real, rest of data are placeholders)
110k (approx) Dummy Customer Inserts

Initial Tests:
    - Baseline, No optimizations made:
10k - 10 seconds
110k - 120 seconds

Second Set of Tests:
    - innodb_buffer_pool_size=1610612736   # Set to 50% of the Ram
    - innodb_log_file_size=402653184   # Set to 25% of innodb_buffer_pool_size
10k - 6 seconds (166% improvement)
110k - 87 seconds (138% improvement)

Iteration 3

- Ran
"SET AUTOCOMMIT=0;"
Run queries
"COMMIT;"

10k - 7 seconds (86% of previous iteration)
110k - 90 seconds (97% of previous iteration)

Iteration 4

- Removing the changes in iteration 3
- Ran
SET UNIQUE_CHECKS=0;
run queries
SET UNIQUE_CHECKS=1;

10k - 7 seconds (86% of iteration 2)
110k - 88 seconds (99% of iteration 2)

Iteration 5
- Removed changes in iteration 4
- Try setting innodb_flush_log_at_trx_commit=0 in the config
10k - 7 seconds (86% of iteration 2)
110k - 92 seconds (95% of iteration 2)

Ryan Whitney
Mifos Technical Program Manager
rwhitney-DnEsXXvMQJxj/JC5u5XAOISLwOllVvif@public.gmane.org
Mifos - Technology that Empowers Microfinance (www.mifos.org)

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

headers

j dailey | 22 Aug 08:47

Community of Mifos

Hi all -

So, it is good to see the effort by GF to engage the community of developers with the new strategy - the meeting
earlier tonight was good for that I think. More is needed, and not just for the developers who know what
Spring MVC is, but also for the constituency that is the eventual market. As an innovative open source
model, much still needs to be done to improve the community transparency - who is getting mifos working,
what are their challenges, how are they overcoming them, what is the future role of the GF/Mifos team?

When we dreamed up the Mifos concept with our friends at MFIs around the world, there seemed to be an appetite
to shoulder some of the effort themselves. That dream, where the end users are also the developers - at
least in the broad sense, should still be kept going. Those who have a vested interest make the best
participants long term and meeting their needs (developers within MFIs, external vendors, etc) is
paramount. They need to see a software solution constantly improve, and are best positioned to inform the
effort at GF or its successors.

Since I missed some of the early slides in the meeting this evening, and have no idea if these questions were
answered, I would like to ask:
* what makes the Mifos Chetah approach fundamentally different from the technology-strategy approach of
before? Beyond Spring and reworking the architecture, what does it say about the Mifos value
proposition?
* have you decided to reach 80% of the market with Software as a Service and what does that say about your
target customers? Small MFIs? Larger MFIs?
* what assumptions are you going to make about connectivity? and, how about those lightweight front ends
(Air, GoogleGears, etc) ?
* do you have accounting and transactional models at the core? or is the philosophy to leverage an existing
open source or other accounting system?
* will you enable (allow and encourage) a set of external and PRIVATE plugins to the framework to extend
functionality in a modular way?
* will you make data migration a part of your value proposition or at least make it easy to do?

Configurability, Approachability, Deployability, Extensibility - and since we love acronyms CADE -
this was the message that came out of our analysis of the original effort in 2006, we needed much much more of
CADE.

But, I would add something more - until Mifos has a solid core that the vendors around the world can make a
profit on, we won't get to a critical mass of participants/customers. Seeding that eco-system has been a
long and arduous task, but more frustrating perhaps for some supporters out there, is knowing when
certain elements of CADE will be available. I see the meeting tonight as a great step in that process and I
hope those supporters out there on the fence take note.

Before I sign off, Congrats on Version 1.1./Rhino - I can hear the thunder of hooves.

- James Dailey

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

headers

Adam Monsen | 22 Aug 07:47

trunk build broken: revision 13589

The trunk build is broken; I'm looking at it now. I got a bit careless
with cleanup of translations in localizedResources for issue 2144. I'll
report back when the build is fixed.

--

-- 
Adam Monsen

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

headers

Jeff Blue | 22 Aug 04:05

French char. set conversion functions missing in V1.1?

During testing V1.1.x Rev. #13431 in French, I'm getting a "FnCheckNumberOnPass_fr_FR(event) is not defined" error when entering the interest rate on a new loan. After a search for the function drew a blank, a search for "FnCheckNumberOnPass_en_GB" led to the discovery of the following source files:

/v1.1.x/mifos/src/org/mifos/doc-root/framework/js/con_en_GB.js
/v1.1.x/mifos/src/org/mifos/doc-root/framework/js/func_en_GB.js

These appear to be character set conversion functions used in key press validation with names tied to language and locale. There are similar files for Arabic, Hindi, Spanish and others, but no French. Are French versions of these files available? Are there other validation files specific to language and locale that may be missing?

Thanks,
Jeff Blue
working with SEM (sem-fund.org)

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

headers

kdurodoye | 22 Aug 02:44

Comparison of MIFOS and Loan Performer

Hi there,

Just wondering if someone has a document where MIFOS has been compared with major MIS for MFBs especially Loan Performer?

If someone has this sort of document, I will be glad to have it

Regards

Kazeem

Get the MapQuest Toolbar. Directions, Traffic, Gas Prices & More!

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

headers

Gbolahan Oshonubi | 21 Aug 21:58

Re: [Mifos-functional] Help on Mifos Design/Structure

Hi All,

Greetings! Kindly let's know if there is any response to this mail. As it were, MIFOS requires some modifications and we need to have a good understanding of the architecture. We will appreciate your response.

Thank you,
Gbolahan Oshonubi
Intelligent Network Services Ltd
oshonubi-VxdBXZNqTusyY3YROqfsYA@public.gmane.org
Mobile
Remain blessed

Disclaimer This e-mail (and any attachment) is intended only for the attention of the addressee(s). Its unauthorised use, disclosure, storage or copying is not permitted. If you are not the intended recipient, please destroy all copies and inform the sender by return e-mail. Internet e-mail is not a secure medium. Any reply to this message could be intercepted and read by someone else. Please bear that in mind when deciding whether to send material in response to this message by e-mail.

From: "Abdul-Quadri Dauda" <quadri-VxdBXZNqTusyY3YROqfsYA@public.gmane.org>
Sent: Saturday, August 16, 2008 7:26 PM
To: mifos-developer <at> lists.sourceforge.net
Subject: [Mifos-functional] Help on Mifos Design/Structure

Hello,
Please we are having a serious challenge on how to include a little function to this application called Mifos inorder to suite our society.
We having been using this application for a very long time and we need to adjust or include some syntax in the code for a better use to us urgently, but we have not understand the coding structure better.

Please we need to understand the basic structure of this Application like :
1: How the files are being connected/accessed by each order.
2: How data is being retrivied from the database,I mean the structure on how the file is accessing the database (Hibernate).

I think these are just the things we need to understand better for us to work more effectively on this application.
Please we need your assistance greatly,we are trying our best over here but this is not enough.

Please we will be very greatfull if you can help with this also as you have been assisting us since.
We will be expecting your reply,thanks and God bless.

Dauda Abdulquadri unbehalf of others programmers in the Company kindly request for the above help, and we will be expecting your reply.

Thanks,
Bye.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

headers

Ryan Whitney | 21 Aug 17:35

Questions about Customer Data

Forwarding from ThoughtWorks. Anyone have any feedback?

Ryan

------ Forwarded Message
From: Nandini Yadalam <nyadalam-IFekc9qy6S0WhyVFc8JwjA@public.gmane.org>
Date: Thu, 21 Aug 2008 17:41:52 +0530
To: Ryan Whitney <rwhitney-DnEsXXvMQJxj/JC5u5XAOISLwOllVvif@public.gmane.org>
Subject: Customer Migration Questions

Hi Ryan,

We have a few simple questions about fields in the CUSTOMER table.

Are these fields used anywhere significant in Mifos
1. Version_no.
2.Global_cust_num
3.Search_id

Nandini & Pramod

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

Mon	Tue	Wed	Thu	Fri	Sat	Sun

				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31