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:[email protected]]
Sent: 07 January 2014 14:09
To: [email protected]
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.; [email protected]
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:[email protected] <javascript:> ]
Sent: 06 January 2014 16:25
To: [email protected] <javascript:>
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 <http://www.btpn.com/>
From: Bjarne Henriksen [mailto:[email protected]]
Sent: Thursday, January 02, 2014 9:17 PM
To: [email protected]
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 registration for each card?
The system should be able to handle both single- and dual message transactions.
I know it will require some adjustments for us, but if the basics are ok, we've
come a long way:)
Do you think it's possible or am I stretching it a bit?
Best regards
Bjarne
_____
"E-Mail ini dan dokumen lampirannya ditujukan untuk digunakan oleh penerima
e-mail. Bila anda bukan orang yang tepat untuk menerima e-mail ini segera hapus
e-mail ini. Isi e-mail ini mungkin tidak mewakili pandangan dan/atau pendapat
PT Bank Tabungan Pensiunan Nasional TBK (Bank), kecuali bila dinyatakan dengan
jelas demikian. Informasi yang terdapat dalam e-mail ini dapat bersifat
rahasia. Dilarang memperbanyak, menyebarkan dan menyalin informasi rahasia
kepada pihak lain tanpa persetujuan Bank. Bank tidak bertanggungjawab atas
kerusakan yang diakibatkan oleh e-mail ini jika terkena virus atau gangguan
komunikasi."
“This e-mail and it’s attachment is intended for the use of the email receiver
only. If you are not the intended recipient you should delete this e-mail
immediately. The e-mail’s contain might be not represent vision and/or opinion
of PT Bank Tabungan Pensiunan Nasional TBK (Bank), except if it is clearly
declared as it is. The information of this e-mail may contain confidential
information. Strictly prohibited to duplicate, propagate and make a copy or to
other party without Bank’s approval. Bank will not responsible on any harmless
or disaster caused of this e-mail’s virus or communication error”
_____
<http://www.avast.com/>
<http://www.avast.com/> This email is free from viruses and malware because
avast! Antivirus protection is active.
<http://www.avast.com/>
---
This email is free from viruses and malware because avast! Antivirus protection
is active.
http://www.avast.com
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users