You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Rahul Goel <ra...@gmail.com> on 2018/02/10 18:41:53 UTC
[SOLUTION] | ISSUE : FINERACT-547
Hi community,
I was looking into this iss*u*e :
https://github.com/openMF/community-app/issues/2440
*https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983
<https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983>*
I found that this is a bug of FINERACT project due to incorrect data in
database.
I tried fetching currency details using below API endpoint and found that
backend is giving incorrect symbol. (screenshot attached)
https://demo.openmf.org/fineract-provider/api/v1/
currencies?tenantIdentifier=default&pretty=true
I then replicated this on my local machine using staging database dump
shared with me by Sampath. Because staging database had correct symbol,
correct result was received from API(screenshot attached).
I request community members who has access to the database to kindly run
these queries.
1.
*UPDATE `m_currency` SET display_symbol = '₹' where code = 'INR' *
2. *UPDATE `m_organisation_currency` SET display_symbol = '₹' where code
= 'INR'*
After running these queries ISSUE : FINERACT-547 should be resolved.
--
RAHUL GOEL
Re: [SOLUTION] | ISSUE : FINERACT-547
Posted by Chirag Gupta <gu...@gmail.com>.
Hi Rahul,
The solution you came up with looks like a temporary one. Can't we do
something that will update the current database and then at the release we
are with the updated database of not only Indian Currency Symbol but all
the currency symbols.
Thanks,
Chirag Gupa
On Sun, Feb 11, 2018 at 12:11 AM, Rahul Goel <ra...@gmail.com> wrote:
> Hi community,
>
> I was looking into this iss*u*e :
> https://github.com/openMF/community-app/issues/2440
> *https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983
> <https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983>*
>
> I found that this is a bug of FINERACT project due to incorrect data in
> database.
> I tried fetching currency details using below API endpoint and found that
> backend is giving incorrect symbol. (screenshot attached)
> https://demo.openmf.org/fineract-provider/api/v1/currencies?
> tenantIdentifier=default&pretty=true
>
> I then replicated this on my local machine using staging database dump
> shared with me by Sampath. Because staging database had correct symbol,
> correct result was received from API(screenshot attached).
>
> I request community members who has access to the database to kindly run
> these queries.
>
> 1.
> *UPDATE `m_currency` SET display_symbol = '₹' where code = 'INR' *
> 2. *UPDATE `m_organisation_currency` SET display_symbol = '₹' where
> code = 'INR'*
>
>
> After running these queries ISSUE : FINERACT-547 should be resolved.
> --
> RAHUL GOEL
>
>
Re: [SOLUTION] | ISSUE : FINERACT-547
Posted by Rahul Goel <ra...@gmail.com>.
Hi Vishwas,
Thank you for doing the needful.
On Mon, Feb 12, 2018 at 10:37 AM, Vishwas Babu <
vishwas@confluxtechnologies.com> wrote:
> Hi Rahul,
>
> I have updated the demo server.
>
> A fresh installation of Fineract should not have this issue.
>
> It looks like tenants created on the demo server are having a sample
> database that consists of a few loan products and Chart of accounts
> configured, this sample database is restored from
> incubator-fineract/fineract-provider/src/main/resources/
> sql/migrations/sample_data/load_sample_data.sql.
> I had a quick look at this file and it has incorrect symbols for INR and
> other currencies.
>
> Fixing this file would ensure that
> *https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983
> <https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983>* does
> not occur in new tenants created with sample data on the demo server.
>
>
> Regards,
>
> Vishwas
>
> Regards,
> Vishwas
> +1 (202) 716 6675
>
> On Sat, Feb 10, 2018 at 10:41 AM, Rahul Goel <ra...@gmail.com>
> wrote:
>
> > Hi community,
> >
> > I was looking into this iss*u*e :
> > https://github.com/openMF/community-app/issues/2440
> > *https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983
> > <https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983>*
> >
> > I found that this is a bug of FINERACT project due to incorrect data in
> > database.
> > I tried fetching currency details using below API endpoint and found that
> > backend is giving incorrect symbol. (screenshot attached)
> > https://demo.openmf.org/fineract-provider/api/v1/currencies?
> > tenantIdentifier=default&pretty=true
> >
> > I then replicated this on my local machine using staging database dump
> > shared with me by Sampath. Because staging database had correct symbol,
> > correct result was received from API(screenshot attached).
> >
> > I request community members who has access to the database to kindly run
> > these queries.
> >
> > 1.
> > *UPDATE `m_currency` SET display_symbol = '₹' where code = 'INR' *
> > 2. *UPDATE `m_organisation_currency` SET display_symbol = '₹' where
> > code = 'INR'*
> >
> >
> > After running these queries ISSUE : FINERACT-547 should be resolved.
> > --
> > RAHUL GOEL
> >
> >
>
--
RAHUL GOEL
+91-9873124753
Re: [SOLUTION] | ISSUE : FINERACT-547
Posted by Vishwas Babu <vi...@confluxtechnologies.com>.
Hi Rahul,
I have updated the demo server.
A fresh installation of Fineract should not have this issue.
It looks like tenants created on the demo server are having a sample
database that consists of a few loan products and Chart of accounts
configured, this sample database is restored from
incubator-fineract/fineract-provider/src/main/resources/sql/migrations/sample_data/load_sample_data.sql.
I had a quick look at this file and it has incorrect symbols for INR and
other currencies.
Fixing this file would ensure that
*https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983
<https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983>* does
not occur in new tenants created with sample data on the demo server.
Regards,
Vishwas
Regards,
Vishwas
+1 (202) 716 6675
On Sat, Feb 10, 2018 at 10:41 AM, Rahul Goel <ra...@gmail.com> wrote:
> Hi community,
>
> I was looking into this iss*u*e :
> https://github.com/openMF/community-app/issues/2440
> *https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983
> <https://issues.apache.org/jira/browse/FINERACT-547?filter=12342983>*
>
> I found that this is a bug of FINERACT project due to incorrect data in
> database.
> I tried fetching currency details using below API endpoint and found that
> backend is giving incorrect symbol. (screenshot attached)
> https://demo.openmf.org/fineract-provider/api/v1/currencies?
> tenantIdentifier=default&pretty=true
>
> I then replicated this on my local machine using staging database dump
> shared with me by Sampath. Because staging database had correct symbol,
> correct result was received from API(screenshot attached).
>
> I request community members who has access to the database to kindly run
> these queries.
>
> 1.
> *UPDATE `m_currency` SET display_symbol = '₹' where code = 'INR' *
> 2. *UPDATE `m_organisation_currency` SET display_symbol = '₹' where
> code = 'INR'*
>
>
> After running these queries ISSUE : FINERACT-547 should be resolved.
> --
> RAHUL GOEL
>
>