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 javascript:] *Sent:* 06 January 2014 16:25 *To:* mifos...@googlegroups.com 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 ___ [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 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 registration for
Re: [Mifos-users] How do I unsubscribe Mifos mails
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 eop...@yahoo.com 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 bjarne.henrik...@gmail.com 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 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: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
[Mifos-users] Fwd: Documentation Background from Nayan
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 nayan.amb...@gmail.com Date: Mon, Jan 6, 2014 at 9:19 PM Subject: Re: News about your OpenHatch projects To: Manohisoa Boulier manohisoa_rajos...@hotmail.de Cc: Ed Cable edca...@gmail.com, Michael Vorburger m...@vorburger.ch 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 clientshttps://mifosforge.jira.com/wiki/display/docs/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=84349831iu=/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?
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 javascript: ] Sent: 06 January 2014 16:25 To: mifos...@googlegroups.com