Thank you all for your kind and detailed replys:)
At the moment we are just looking around to see what is available for us to
use, and I think your product is very exciting with a few obstacles for us
to solve.
If the decision makers find this interesting I'm sure we will get back with
more in-depth questions:)
Kind regards
Bjarne
Den torsdag den 9. januar 2014 14.13.25 UTC+1 skrev Vishwas Babu:
>
> Bjarne,
>
> We use mysql as our default database, all create/update are done using JPA
> standards so should work on any database. However, for all read operations,
> we using native SQL queries (which bring in the mysql tie-in). Changing the
> database would involve removing any mysql specific syntax used in these sql
> queries.
>
> >>Regarding the database, are you using stored procedures / triggers or
> anything similar?
> No we do not.
>
> >>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:)
> We maintain around 35 pilot users on the demo server
> and administering them isn't too difficult (since you never actually have
> to manually run any sql patch on each database etc, upgrading to a newer
> version of MifosX is as simple as dropping in a new war and restarting the
> server)
>
> If you do want to maintain all clients on a single database schema, you
> could do the same by creating a branch and users for each client etc ( All
> accounting happens at branch level). The only minor change required would
> be to enable branch level savings products (on the product roadmap, but not
> scheduled for the next couple of quarters unless it becomes a blocker for
> potential implementations)
>
> Regards,
> Vishwas
>
>
>
> On 7 January 2014 14:09, Bjarne Henriksen <bjarne.h...@gmail.com<javascript:>
> > 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 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/>
>>>
>>> This email is free from viruses and malware because avast!
>>> Antivirus<http://www.avast.com/>protection is active.
>>>
>>>
>>
>> ------------------------------------------------------------------------------
>> 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...@lists.sourceforge.net <javascript:>
>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>
>>
>
------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users