Re: [Mifos-users] Is this possible with mifos?

[Bjarne Henriksen]

Hi Binny,

Thank you for your reply, it all looks very promissing from my point of 
view:) 

I was under the impression that savings was in beta (and of course I can't 
find the link now:) ). Anyway It's good to see everything's there. As susch 
we don't need savings, but I guess that account-type fits debit/giftcards 
best. We have no interest calcualtions on those 2 card-types, just deposits 
and withdrawals.

https://mifosforge.jira.com/wiki/display/MIFOSX/The+Basic+Design descripes 
you have designed Mifos as multi-tenanted which of course is good. I just 
need some clarification, is it possible to have multi-tenants in the same 
database shema or do they each need their own schema? At the moment we have 
25+ costumers/institutions running, and if they each need their own schema, 
I think it would require some more admin work:)

Regarding the database, are you using stored procedures / triggers or 
anything similar? Again I'm thinking of how difficult it would be to port 
from mysql

Thank you all for your kind and quick replies 

/Bjarne

Den mandag den 6. januar 2014 16.06.23 UTC+1 skrev Binny Gopinath Sreevas:
>
> Hi Bjarne,
>
>  
>
> You will need to port Mifos X for other databases – Oracle or any other 
> database – other than MySQL. I am not expecting Mifos to run without any 
> changes on Oracle, however, I do not expect the changes to be high either. 
> One of the technical guys can correct me if I am way off mark on this.
>
>  
>
> Card handling is not there in Mifos X.
>
>  
>
> Savings functionality is present in Mifos. Interest schemes, with periodic 
> interest posting, withdrawals, deposits, with fees and the related 
> accounting aspects have all been implemented in Mifos X. Is there any 
> specific feature that you are looking for beyond these?
>
>  
>
> Yes, accounting is separate from loans and savings. Products definitions 
> include a section whereby various ledger accounts are associated to product 
> transactions (like disbursements, repaymen rts, withdrawals, deposits, fees 
> etc.)
>
>  
>
> Hi Satriadi,
>
>  
>
> You are right if you are referring to Mifo 2.x. It tightly incorporates 
> the Grameen microfinance methodology. However, Mifos X can work well for a 
> financial institution which does not follow group lending methodologies. 
> The goal of Mifos X is to support financial institutions that may or may 
> not follow group lending methodologies. BTW, Mifos X has been rebuilt from 
> ground up so that ground lending/savings and general financial functions 
> are cleanly separated out.
>
>  
>
> Thanks and Regards
> Binny Gopinath Sreevas
>
> +91-98861 39498
> Skype: binny.gopinath
>
>  
>
>  
>
> *From:* Bjarne Henriksen [mailto:bjarne.h...@gmail.com ] 
> *Sent:* 06 January 2014 16:25
> *To:* mifos...@googlegroups.com 
> *Cc:* A good place to start for users or folks new to Mifos.
> *Subject:* Re: [Mifos-users] Is this possible with mifos?
>
>  
>
> Hi again:)
>
> After having looked a little bit more Mifos I have a few extra questions.
>
> I can see you are using Mysql. How tightly coupled are you to this? Would 
> it be possible to run on another db, for example Oracle, knowing it would 
> require a few datatype changes in DDL?
>
> I cannot find anything regarding card handling, so I assume that as 
> something we would have to implement?
>
> Savings accounts are in beta as I understand it. How far off is it from 
> being available?
>
> In your package structure, loan- and savings accounts/transactions are 
> separated. I'm thinking accounts/transactions are generic and then defined 
> by the products attached to them? 
>
> /
> Bjarne
>
>
> Den mandag den 6. januar 2014 03.42.23 UTC+1 skrev Satriadi:
>
> Dear bjarne,
>
> If I’m not mistaken, mifos is designed for grameen replicator.
>
> So as long as your company using grameen method as your business process, 
> you may only need a bit adjustment.
>
>  
>
>  
>
> *Best Regards,*
>
> *Satriadi*
>
> *IT BA Microfinance*
>
> BTPN Syariah
>
> ___
>
> [image: cid:4583C82F-A7B2-4E60-B31F-080DF89DAC2A]
>
> *BTPN Syariah*
>
> Menara Cyber 2, lt. 3
>
> Jl. HR Rasuna Said Block X-5, No. 13
>
> Kuningan, Jakarta 12950
>
>  
>
> t. +62 21 300 26 494 ext 2845
>
> f. +62 21 300 26 307
>
>
>
> w. *http://www.btpn.com *
>
>  
>
> *From:* Bjarne Henriksen [mailto:bjarne.h...@gmail.com] 
> *Sent:* Thursday, January 02, 2014 9:17 PM
> *To:* mifos...@googlegroups.com
> *Subject:* [Mifos-users] Is this possible with mifos?
>
>  
>
> Hi.
>
> We're a smaller company providing transaction-handling on 
> pre-paid/gift-cards as well as revolving credit-cards for chains and 
> shopping centers. At the moment we're running on a 3rd party banking 
> product, but we'd like to replace it with something where we have more 
> control over the development.
>
> Would it be possible to use Mifos for this:
>
> Is it possible to have multiple institutions in the same database-schema, 
> all using same cu

[Mifos-users] How do I unsubscribe Mifos mails

[Evans Opata]

Hi All

How do I  unsubscribe Mifos mails. The mails are becoming nuisance in my inbox.
Help me!




Kind Regards

Evans Opata

Cell: +233(0) 244027079
P. O. Box 205, Odumase Krobo, Ghana

Sent from Samsung tabletBjarne Henriksen  wrote:Hi 
Binny,

Thank you for your reply, it all looks very promissing from my point of view:) 

I was under the impression that savings was in beta (and of course I can't find 
the link now:) ). Anyway It's good to see everything's there. As susch we don't 
need savings, but I guess that account-type fits debit/giftcards best. We have 
no interest calcualtions on those 2 card-types, just deposits and withdrawals.

https://mifosforge.jira.com/wiki/display/MIFOSX/The+Basic+Design descripes you 
have designed Mifos as multi-tenanted which of course is good. I just need some 
clarification, is it possible to have multi-tenants in the same database shema 
or do they each need their own schema? At the moment we have 25+ 
costumers/institutions running, and if they each need their own schema, I think 
it would require some more admin work:)

Regarding the database, are you using stored procedures / triggers or anything 
similar? Again I'm thinking of how difficult it would be to port from mysql

Thank you all for your kind and quick replies 

/Bjarne

Den mandag den 6. januar 2014 16.06.23 UTC+1 skrev Binny Gopinath Sreevas:
Hi Bjarne,

 

You will need to port Mifos X for other databases – Oracle or any other 
database – other than MySQL. I am not expecting Mifos to run without any 
changes on Oracle, however, I do not expect the changes to be high either. One 
of the technical guys can correct me if I am way off mark on this.

 

Card handling is not there in Mifos X.

 

Savings functionality is present in Mifos. Interest schemes, with periodic 
interest posting, withdrawals, deposits, with fees and the related accounting 
aspects have all been implemented in Mifos X. Is there any specific feature 
that you are looking for beyond these?

 

Yes, accounting is separate from loans and savings. Products definitions 
include a section whereby various ledger accounts are associated to product 
transactions (like disbursements, repaymen rts, withdrawals, deposits, fees 
etc.)

 

Hi Satriadi,

 

You are right if you are referring to Mifo 2.x. It tightly incorporates the 
Grameen microfinance methodology. However, Mifos X can work well for a 
financial institution which does not follow group lending methodologies. The 
goal of Mifos X is to support financial institutions that may or may not follow 
group lending methodologies. BTW, Mifos X has been rebuilt from ground up so 
that ground lending/savings and general financial functions are cleanly 
separated out.

 

Thanks and Regards
Binny Gopinath Sreevas

+91-98861 39498
Skype: binny.gopinath

 

 

From: Bjarne Henriksen [mailto:bjarne.h...@gmail.com] 
Sent: 06 January 2014 16:25
To: mifos...@googlegroups.com
Cc: A good place to start for users or folks new to Mifos.
Subject: Re: [Mifos-users] Is this possible with mifos?

 

Hi again:)

After having looked a little bit more Mifos I have a few extra questions.

I can see you are using Mysql. How tightly coupled are you to this? Would it be 
possible to run on another db, for example Oracle, knowing it would require a 
few datatype changes in DDL?

I cannot find anything regarding card handling, so I assume that as something 
we would have to implement?

Savings accounts are in beta as I understand it. How far off is it from being 
available?

In your package structure, loan- and savings accounts/transactions are 
separated. I'm thinking accounts/transactions are generic and then defined by 
the products attached to them? 

/
Bjarne


Den mandag den 6. januar 2014 03.42.23 UTC+1 skrev Satriadi:

Dear bjarne,

If I’m not mistaken, mifos is designed for grameen replicator.

So as long as your company using grameen method as your business process, you 
may only need a bit adjustment.

 

 

Best Regards,

Satriadi

IT BA Microfinance

BTPN Syariah

___



BTPN Syariah

Menara Cyber 2, lt. 3

Jl. HR Rasuna Said Block X-5, No. 13

Kuningan, Jakarta 12950

 

t. +62 21 300 26 494 ext 2845

f. +62 21 300 26 307




w. http://www.btpn.com

 

From: Bjarne Henriksen [mailto:bjarne.h...@gmail.com] 
Sent: Thursday, January 02, 2014 9:17 PM
To: mifos...@googlegroups.com
Subject: [Mifos-users] Is this possible with mifos?

 

Hi.

We're a smaller company providing transaction-handling on pre-paid/gift-cards 
as well as revolving credit-cards for chains and shopping centers. At the 
moment we're running on a 3rd party banking product, but we'd like to replace 
it with something where we have more control over the development.

Would it be possible to use Mifos for this:

Is it possible to have multiple institutions in the same database-schema, all 
using same currency?
The bulk of our cards are anonymous gift-cards, is that a problem in terms of 
having a minimum of 

Re: [Mifos-users] How do I unsubscribe Mifos mails

[Ed Cable]

Evans,

You can unsubscribe from the following link:
https://lists.sourceforge.net/lists/listinfo/mifos-users If you would still
like to get periodic updates, you could also change your subscription to
the digest so you are not receiving each individual email.

Cheers,

Ed


On Tue, Jan 7, 2014 at 7:27 AM, Evans Opata  wrote:

> Hi All
>
> How do I  unsubscribe Mifos mails. The mails are becoming nuisance in my
> inbox.
> Help me!
>
>
>
>
> Kind Regards
>
> Evans Opata
>
> Cell: +233(0) 244027079
> P. O. Box 205, Odumase Krobo, Ghana
>
> Sent from Samsung tablet
>
> Bjarne Henriksen  wrote:
>
>> Hi Binny,
>>
>> Thank you for your reply, it all looks very promissing from my point of
>> view:)
>>
>> I was under the impression that savings was in beta (and of course I
>> can't find the link now:) ). Anyway It's good to see everything's there. As
>> susch we don't need savings, but I guess that account-type fits
>> debit/giftcards best. We have no interest calcualtions on those 2
>> card-types, just deposits and withdrawals.
>>
>> https://mifosforge.jira.com/wiki/display/MIFOSX/The+Basic+Designdescripes 
>> you have designed Mifos as multi-tenanted which of course is
>> good. I just need some clarification, is it possible to have multi-tenants
>> in the same database shema or do they each need their own schema? At the
>> moment we have 25+ costumers/institutions running, and if they each need
>> their own schema, I think it would require some more admin work:)
>>
>> Regarding the database, are you using stored procedures / triggers or
>> anything similar? Again I'm thinking of how difficult it would be to port
>> from mysql
>>
>> Thank you all for your kind and quick replies
>>
>> /Bjarne
>>
>> Den mandag den 6. januar 2014 16.06.23 UTC+1 skrev Binny Gopinath
>> Sreevas:
>>>
>>> Hi Bjarne,
>>>
>>>
>>>
>>> You will need to port Mifos X for other databases – Oracle or any other
>>> database – other than MySQL. I am not expecting Mifos to run without any
>>> changes on Oracle, however, I do not expect the changes to be high either.
>>> One of the technical guys can correct me if I am way off mark on this.
>>>
>>>
>>>
>>> Card handling is not there in Mifos X.
>>>
>>>
>>>
>>> Savings functionality is present in Mifos. Interest schemes, with
>>> periodic interest posting, withdrawals, deposits, with fees and the related
>>> accounting aspects have all been implemented in Mifos X. Is there any
>>> specific feature that you are looking for beyond these?
>>>
>>>
>>>
>>> Yes, accounting is separate from loans and savings. Products definitions
>>> include a section whereby various ledger accounts are associated to product
>>> transactions (like disbursements, repaymen rts, withdrawals, deposits, fees
>>> etc.)
>>>
>>>
>>>
>>> Hi Satriadi,
>>>
>>>
>>>
>>> You are right if you are referring to Mifo 2.x. It tightly incorporates
>>> the Grameen microfinance methodology. However, Mifos X can work well for a
>>> financial institution which does not follow group lending methodologies.
>>> The goal of Mifos X is to support financial institutions that may or may
>>> not follow group lending methodologies. BTW, Mifos X has been rebuilt from
>>> ground up so that ground lending/savings and general financial functions
>>> are cleanly separated out.
>>>
>>>
>>>
>>> Thanks and Regards
>>> Binny Gopinath Sreevas
>>>
>>> +91-98861 39498
>>> Skype: binny.gopinath
>>>
>>>
>>>
>>>
>>>
>>> *From:* Bjarne Henriksen [mailto:bjarne.h...@gmail.com]
>>> *Sent:* 06 January 2014 16:25
>>> *To:* mifos...@googlegroups.com
>>> *Cc:* A good place to start for users or folks new to Mifos.
>>> *Subject:* Re: [Mifos-users] Is this possible with mifos?
>>>
>>>
>>>
>>> Hi again:)
>>>
>>> After having looked a little bit more Mifos I have a few extra questions.
>>>
>>> I can see you are using Mysql. How tightly coupled are you to this?
>>> Would it be possible to run on another db, for example Oracle, knowing it
>>> would require a few datatype changes in DDL?
>>>
>>> I cannot find anything regarding card handling, so I assume that as
>>> something we would have to implement?
>>>
>>> Savings accounts are in beta as I understand it. How far off is it from
>>> being available?
>>>
>>> In your package structure, loan- and savings accounts/transactions are
>>> separated. I'm thinking accounts/transactions are generic and then defined
>>> by the products attached to them?
>>>
>>> /
>>> Bjarne
>>>
>>>
>>> Den mandag den 6. januar 2014 03.42.23 UTC+1 skrev Satriadi:
>>>
>>> Dear bjarne,
>>>
>>> If I’m not mistaken, mifos is designed for grameen replicator.
>>>
>>> So as long as your company using grameen method as your business
>>> process, you may only need a bit adjustment.
>>>
>>>
>>>
>>>
>>>
>>> *Best Regards,*
>>>
>>> *Satriadi*
>>>
>>> *IT BA Microfinance*
>>>
>>> BTPN Syariah
>>>
>>> ___
>>>
>>> [image: cid:4583C82F-A7B2-4E60-B31F-080DF89DAC2A]
>>>
>>> *BTPN Syariah*
>>>
>>> Menara Cyber 2, lt. 3
>>>
>>> Jl. HR Rasuna Said B

[Mifos-users] Fwd: Documentation Background from Nayan

[Ed Cable]

Dayna (and others)

Just wanted to give you a heads up on the documentation section that Nayan
created on the wiki in case you might want to start documenting the
Community App as you start to use it.

Ed
-- Forwarded message --
From: Nayan Ambali 
Date: Mon, Jan 6, 2014 at 9:19 PM
Subject: Re: News about your OpenHatch projects
To: Manohisoa Boulier 
Cc: Ed Cable , Michael Vorburger 


Hi Mano,

Thanks, and wish you a very happy new year.

I am stuck with some other work and did not get chance to follow up with
you on Mifos X user manual.

I am thinking in this direction.

   - For content, we can use *old* Mifos user manual as reference (
   http://mifcloud.com/manual/manual )
   - For content, External reference, we refer Mambu's manual (
   http://help.mambu.com/ )
   - For formatting, template and style we can refer Confluence Users Guide
   ( https://confluence.atlassian.com/display/DOC/Confluence+User%27s+Guide)

And at present I have created framework for user manual under this page
https://mifosforge.jira.com/wiki/display/docs/Community+App+-+A+user+interface+for+Mifos+X+APIs
Please go through it and let me know your opinion.

Can we take up  Manage
clientssection
as beginning and start working on?

And please feel free to schedule the Skype calls for any help and if you
want me to take you through the MIfos X application I can do that also.

Thanks
Nayan Ambali



Thanks and Regards,
Nayan Ambali
+91 9591996042
skype: nayangambali
--
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk___
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users

Re: [Mifos-users] Is this possible with mifos?

[Binny Gopinath Sreevas]

Hi Bjarne,



I am pretty certain that the savings accounts in Mifos X can be used as the 
account for your debit/gift/pre-paid cards. Do you have a one-to-one 
relationship between account and cards or do you see this relation being 
one-to-many? One-to-one may need lesser enhancements in Mifos X.



Each tenant will need it’s own schema (database). All the schemas can be on the 
same MySQL server. In my opinion, it is better to have different schemas for 
each of your customers/institutions. This would make your data physically 
separate (and protect you from any accidental sharing of data between 
customers/institutions that could lead to legal/customer protection/data 
privacy concerns). A lot of the admin work (like backups etc.) can be automated.



I just did “SHOW TRIGGERS” and “SHOW PROCEDURE STATUS” and “SHOW FUNCTION 
STATUS” on a local installation of Mifos X. And it comes back with an empty 
set. So, we can safely assume that there are no triggers/stored 
procedures/custom functions in Mifos X.



Off the top of my head I can think of the following (definitely, not a complete 
list, but just listing things that I can think of) as differences between MySQL 
and Oracle that is relevant for Mifos X:

-  DDLs are quite different especially data type differences – VARCHAR 
to VARCHAR2, SMALLINT or INT to NUMBER, DATE/TIMESTAMP etc. – I believe Oracle 
gives a migration tool for moving from MySQL to Oracle

-  Auto-increment columns are handled differently in Oracle using 
sequences

-  SQL differences in syntax – like using the LIMIT phrase in SQL 
selects, function names in SQL queries (SUBSTRING vs SUBSTR etc.)

-  Lower Case vs Upper Case for table names and column names – I don’t 
remember the exact difference, but I believe there is a setting in MySQL that 
controls whether to be case sensitive or not.

-  Etc.



Thanks and Regards
Binny Gopinath Sreevas

Skype: binny.gopinath





From: Bjarne Henriksen [mailto:bjarne.henrik...@gmail.com]
Sent: 07 January 2014 14:09
To: mifosus...@googlegroups.com
Cc: 'A good place to start for users or folks new to Mifos.'; A good place to 
start for users or folks new to Mifos.; binny.gopin...@gmail.com
Subject: Re: [Mifos-users] Is this possible with mifos?



Hi Binny,

Thank you for your reply, it all looks very promissing from my point of view:)

I was under the impression that savings was in beta (and of course I can't find 
the link now:) ). Anyway It's good to see everything's there. As susch we don't 
need savings, but I guess that account-type fits debit/giftcards best. We have 
no interest calcualtions on those 2 card-types, just deposits and withdrawals.

https://mifosforge.jira.com/wiki/display/MIFOSX/The+Basic+Design descripes you 
have designed Mifos as multi-tenanted which of course is good. I just need some 
clarification, is it possible to have multi-tenants in the same database shema 
or do they each need their own schema? At the moment we have 25+ 
costumers/institutions running, and if they each need their own schema, I think 
it would require some more admin work:)

Regarding the database, are you using stored procedures / triggers or anything 
similar? Again I'm thinking of how difficult it would be to port from mysql

Thank you all for your kind and quick replies

/Bjarne

Den mandag den 6. januar 2014 16.06.23 UTC+1 skrev Binny Gopinath Sreevas:

Hi Bjarne,



You will need to port Mifos X for other databases – Oracle or any other 
database – other than MySQL. I am not expecting Mifos to run without any 
changes on Oracle, however, I do not expect the changes to be high either. One 
of the technical guys can correct me if I am way off mark on this.



Card handling is not there in Mifos X.



Savings functionality is present in Mifos. Interest schemes, with periodic 
interest posting, withdrawals, deposits, with fees and the related accounting 
aspects have all been implemented in Mifos X. Is there any specific feature 
that you are looking for beyond these?



Yes, accounting is separate from loans and savings. Products definitions 
include a section whereby various ledger accounts are associated to product 
transactions (like disbursements, repaymen rts, withdrawals, deposits, fees 
etc.)



Hi Satriadi,



You are right if you are referring to Mifo 2.x. It tightly incorporates the 
Grameen microfinance methodology. However, Mifos X can work well for a 
financial institution which does not follow group lending methodologies. The 
goal of Mifos X is to support financial institutions that may or may not follow 
group lending methodologies. BTW, Mifos X has been rebuilt from ground up so 
that ground lending/savings and general financial functions are cleanly 
separated out.



Thanks and Regards
Binny Gopinath Sreevas

+91-98861 39498
Skype: binny.gopinath





From: Bjarne Henriksen [mailto:bjarne.h...@gmail.com  ]
Sent: 06 January 2014 16:25
To: mifos...@googlegroups.com 
Cc: A good place to