You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Mukundhan Murugesan <mu...@zucisystems.com> on 2021/01/07 10:51:33 UTC
Unable to change timezone from UTC to IST
Hi,
I am experiencing trouble changing the timezone from GMT/UTC to IST(Asia/Kolkata). Fineract uses my local timezone IST(Asia/Kolkata) to store in the database. But while retrieving, it shows in UTC timezone.
I can see this issue in Scheduler jobs. Is there anything I need to do while running or so?
I been struggling with this issue for a week. I would like to get some help.
Fineract Database:
[cid:e67ab327-92a7-400f-a76d-b92d6ef5cd94]
Fineract Scheduler Jobs:
[cid:a7f327dd-b2e6-4650-a4fd-621ad6e944a6]
Thanks,
Mukundhan
Disclaimer: "The contents of this e-mail and any attachments enclosed therein are intended solely for the addressee(s) and may contain confidential and/or privileged information. It may also be the sole intellectual and proprietary resource of Zuci Systems and therefore may be legally protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you by inadvertence, kindly alert the sender by email and then follow with its deletion. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited and shall make you liable for consequences under applicable laws."
Re: Unable to change timezone from UTC to IST
Posted by Mukundhan Murugesan <mu...@zucisystems.com>.
Hi Bharath,
Sure. Thanks for the information.
________________________________
From: Bharath Gowda <bg...@mifos.org>
Sent: Monday, January 11, 2021 6:42 PM
To: Dev <de...@fineract.apache.org>
Subject: Re: Unable to change timezone from UTC to IST
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Hi Mukundan,
The suggestion is you could raise an enhancement ticket here<https://issues.apache.org/jira/projects/FINERACT/issues> to reflect the date and time as per the tenant's specified time zone.
you could make the necessary code change and send a PR to the upstream codebase. or request other community developers for the same.
Regards,
Bharath
Lead Implementation Analyst | Mifos Initiative
Skype: live:cbharath4| Mobile: +91.7019635592
http://mifos.org<http://mifos.org/> [https://secure.plimus.com/developers/817570/Template/icon-tiny-facebook.png] <http://facebook.com/mifos> [http://organizationsandmarkets.files.wordpress.com/2010/04/icon-tiny-twitter.png] <http://www.twitter.com/mifos>
On Fri, Jan 8, 2021 at 5:03 PM Mukundhan Murugesan <mu...@zucisystems.com>> wrote:
Hi Bharat,
I tried running the fineract locally on my laptop (timezone - IST) and with the server (timezone configured to IST), Fineract and database hosted on the same system. My default timezone_id set to Asia/Kolkata in DB. But it's not working. I tried debugging the issue and then figured out it changing the timezone to UTC while returning the data. Any suggestions pls.
________________________________
From: Bharath Gowda <bg...@mifos.org>>
Sent: Friday, January 8, 2021 2:18 PM
To: Dev <de...@fineract.apache.org>>
Subject: Re: Unable to change timezone from UTC to IST
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Hi Mukundhan,
The Issue could be because of the timezone set at your tenant_identifier level (timezone_id column under tenants table) but I am not sure.
You could test by changing the timezone and restart the server to get the new setting reflected.
[image.png]
Or, It could also be because of your server time where the instance is hosted
if you have DB and Server in a different system, check if both instance timzones are the same.
Let me know if you have any questions.
Regards,
Bharath
Lead Implementation Analyst | Mifos Initiative
Skype: live:cbharath4| Mobile: +91.7019635592
http://mifos.org<http://mifos.org/> [https://secure.plimus.com/developers/817570/Template/icon-tiny-facebook.png] <http://facebook.com/mifos> [http://organizationsandmarkets.files.wordpress.com/2010/04/icon-tiny-twitter.png] <http://www.twitter.com/mifos>
On Thu, Jan 7, 2021 at 4:21 PM Mukundhan Murugesan <mu...@zucisystems.com>> wrote:
Hi,
I am experiencing trouble changing the timezone from GMT/UTC to IST(Asia/Kolkata). Fineract uses my local timezone IST(Asia/Kolkata) to store in the database. But while retrieving, it shows in UTC timezone.
I can see this issue in Scheduler jobs. Is there anything I need to do while running or so?
I been struggling with this issue for a week. I would like to get some help.
Fineract Database:
[cid:176f173e6f7cd93ecbb1]
Fineract Scheduler Jobs:
[cid:176f173e6f7499234352]
Thanks,
Mukundhan
Disclaimer: "The contents of this e-mail and any attachments enclosed therein are intended solely for the addressee(s) and may contain confidential and/or privileged information. It may also be the sole intellectual and proprietary resource of Zuci Systems and therefore may be legally protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you by inadvertence, kindly alert the sender by email and then follow with its deletion. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited and shall make you liable for consequences under applicable laws."
Disclaimer: "The contents of this e-mail and any attachments enclosed therein are intended solely for the addressee(s) and may contain confidential and/or privileged information. It may also be the sole intellectual and proprietary resource of Zuci Systems and therefore may be legally protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you by inadvertence, kindly alert the sender by email and then follow with its deletion. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited and shall make you liable for consequences under applicable laws."
Disclaimer: "The contents of this e-mail and any attachments enclosed therein are intended solely for the addressee(s) and may contain confidential and/or privileged information. It may also be the sole intellectual and proprietary resource of Zuci Systems and therefore may be legally protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you by inadvertence, kindly alert the sender by email and then follow with its deletion. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited and shall make you liable for consequences under applicable laws."
Re: Unable to change timezone from UTC to IST
Posted by Bharath Gowda <bg...@mifos.org>.
Hi Mukundan,
The suggestion is you could raise an enhancement ticket here
<https://issues.apache.org/jira/projects/FINERACT/issues> to reflect the
date and time as per the tenant's specified time zone.
you could make the necessary code change and send a PR to the upstream
codebase. or request other community developers for the same.
Regards,
Bharath
Lead Implementation Analyst | Mifos Initiative
Skype: live:cbharath4| Mobile: +91.7019635592
http://mifos.org <http://facebook.com/mifos>
<http://www.twitter.com/mifos>
On Fri, Jan 8, 2021 at 5:03 PM Mukundhan Murugesan <
mukundhan.m@zucisystems.com> wrote:
> Hi Bharat,
> I tried running the fineract locally on my laptop (timezone - IST)
> and with the server (timezone configured to IST), Fineract and database
> hosted on the same system. My default timezone_id set to Asia/Kolkata in
> DB. But it's not working. I tried debugging the issue and then figured out
> it changing the timezone to UTC while returning the data. Any suggestions
> pls.
>
> ------------------------------
> *From:* Bharath Gowda <bg...@mifos.org>
> *Sent:* Friday, January 8, 2021 2:18 PM
> *To:* Dev <de...@fineract.apache.org>
> *Subject:* Re: Unable to change timezone from UTC to IST
>
>
> CAUTION: This email originated from outside of the organization. Do not
> click links or open attachments unless you recognize the sender and know
> the content is safe.
>
> Hi Mukundhan,
>
> The Issue could be because of the timezone set at your tenant_identifier
> level (timezone_id column under tenants table) but I am not sure.
>
> You could test by changing the timezone and restart the server to get the
> new setting reflected.
>
> [image: image.png]
>
> Or, It could also be because of your server time where the instance is
> hosted
> if you have DB and Server in a different system, check if both instance
> timzones are the same.
>
> Let me know if you have any questions.
>
>
> Regards,
> Bharath
> Lead Implementation Analyst | Mifos Initiative
> Skype: live:cbharath4| Mobile: +91.7019635592
> http://mifos.org <http://facebook.com/mifos>
> <http://www.twitter.com/mifos>
>
>
> On Thu, Jan 7, 2021 at 4:21 PM Mukundhan Murugesan <
> mukundhan.m@zucisystems.com> wrote:
>
> Hi,
> I am experiencing trouble changing the timezone from GMT/UTC to
> IST(Asia/Kolkata). Fineract uses my local timezone IST(Asia/Kolkata) to
> store in the database. But while retrieving, it shows in UTC timezone.
>
> I can see this issue in Scheduler jobs. Is there anything I need to do
> while running or so?
> I been struggling with this issue for a week. I would like to get some
> help.
>
> Fineract Database:
>
>
> Fineract Scheduler Jobs:
>
>
> Thanks,
> Mukundhan
> Disclaimer: "The contents of this e-mail and any attachments enclosed
> therein are intended solely for the addressee(s) and may contain
> confidential and/or privileged information. It may also be the sole
> intellectual and proprietary resource of Zuci Systems and therefore may be
> legally protected from disclosure. If you are not the intended recipient of
> this message, or if this message has been addressed to you by inadvertence,
> kindly alert the sender by email and then follow with its deletion. If you
> are not the intended recipient, you are hereby notified that any use,
> dissemination, copying, or storage of this message or its attachments is
> strictly prohibited and shall make you liable for consequences under
> applicable laws."
>
> Disclaimer: "The contents of this e-mail and any attachments enclosed
> therein are intended solely for the addressee(s) and may contain
> confidential and/or privileged information. It may also be the sole
> intellectual and proprietary resource of Zuci Systems and therefore may be
> legally protected from disclosure. If you are not the intended recipient of
> this message, or if this message has been addressed to you by inadvertence,
> kindly alert the sender by email and then follow with its deletion. If you
> are not the intended recipient, you are hereby notified that any use,
> dissemination, copying, or storage of this message or its attachments is
> strictly prohibited and shall make you liable for consequences under
> applicable laws."
>
Re: Unable to change timezone from UTC to IST
Posted by Mukundhan Murugesan <mu...@zucisystems.com>.
Hi Bharat,
I tried running the fineract locally on my laptop (timezone - IST) and with the server (timezone configured to IST), Fineract and database hosted on the same system. My default timezone_id set to Asia/Kolkata in DB. But it's not working. I tried debugging the issue and then figured out it changing the timezone to UTC while returning the data. Any suggestions pls.
________________________________
From: Bharath Gowda <bg...@mifos.org>
Sent: Friday, January 8, 2021 2:18 PM
To: Dev <de...@fineract.apache.org>
Subject: Re: Unable to change timezone from UTC to IST
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Hi Mukundhan,
The Issue could be because of the timezone set at your tenant_identifier level (timezone_id column under tenants table) but I am not sure.
You could test by changing the timezone and restart the server to get the new setting reflected.
[image.png]
Or, It could also be because of your server time where the instance is hosted
if you have DB and Server in a different system, check if both instance timzones are the same.
Let me know if you have any questions.
Regards,
Bharath
Lead Implementation Analyst | Mifos Initiative
Skype: live:cbharath4| Mobile: +91.7019635592
http://mifos.org<http://mifos.org/> [https://secure.plimus.com/developers/817570/Template/icon-tiny-facebook.png] <http://facebook.com/mifos> [http://organizationsandmarkets.files.wordpress.com/2010/04/icon-tiny-twitter.png] <http://www.twitter.com/mifos>
On Thu, Jan 7, 2021 at 4:21 PM Mukundhan Murugesan <mu...@zucisystems.com>> wrote:
Hi,
I am experiencing trouble changing the timezone from GMT/UTC to IST(Asia/Kolkata). Fineract uses my local timezone IST(Asia/Kolkata) to store in the database. But while retrieving, it shows in UTC timezone.
I can see this issue in Scheduler jobs. Is there anything I need to do while running or so?
I been struggling with this issue for a week. I would like to get some help.
Fineract Database:
[cid:176e12a133acd93ecbb1]
Fineract Scheduler Jobs:
[cid:176e12a133a499234352]
Thanks,
Mukundhan
Disclaimer: "The contents of this e-mail and any attachments enclosed therein are intended solely for the addressee(s) and may contain confidential and/or privileged information. It may also be the sole intellectual and proprietary resource of Zuci Systems and therefore may be legally protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you by inadvertence, kindly alert the sender by email and then follow with its deletion. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited and shall make you liable for consequences under applicable laws."
Disclaimer: "The contents of this e-mail and any attachments enclosed therein are intended solely for the addressee(s) and may contain confidential and/or privileged information. It may also be the sole intellectual and proprietary resource of Zuci Systems and therefore may be legally protected from disclosure. If you are not the intended recipient of this message, or if this message has been addressed to you by inadvertence, kindly alert the sender by email and then follow with its deletion. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited and shall make you liable for consequences under applicable laws."
Re: Unable to change timezone from UTC to IST
Posted by Bharath Gowda <bg...@mifos.org>.
Hi Mukundhan,
The Issue could be because of the timezone set at your tenant_identifier
level (timezone_id column under tenants table) but I am not sure.
You could test by changing the timezone and restart the server to get the
new setting reflected.
[image: image.png]
Or, It could also be because of your server time where the instance is
hosted
if you have DB and Server in a different system, check if both instance
timzones are the same.
Let me know if you have any questions.
Regards,
Bharath
Lead Implementation Analyst | Mifos Initiative
Skype: live:cbharath4| Mobile: +91.7019635592
http://mifos.org <http://facebook.com/mifos>
<http://www.twitter.com/mifos>
On Thu, Jan 7, 2021 at 4:21 PM Mukundhan Murugesan <
mukundhan.m@zucisystems.com> wrote:
> Hi,
> I am experiencing trouble changing the timezone from GMT/UTC to
> IST(Asia/Kolkata). Fineract uses my local timezone IST(Asia/Kolkata) to
> store in the database. But while retrieving, it shows in UTC timezone.
>
> I can see this issue in Scheduler jobs. Is there anything I need to do
> while running or so?
> I been struggling with this issue for a week. I would like to get some
> help.
>
> Fineract Database:
>
>
> Fineract Scheduler Jobs:
>
>
> Thanks,
> Mukundhan
> Disclaimer: "The contents of this e-mail and any attachments enclosed
> therein are intended solely for the addressee(s) and may contain
> confidential and/or privileged information. It may also be the sole
> intellectual and proprietary resource of Zuci Systems and therefore may be
> legally protected from disclosure. If you are not the intended recipient of
> this message, or if this message has been addressed to you by inadvertence,
> kindly alert the sender by email and then follow with its deletion. If you
> are not the intended recipient, you are hereby notified that any use,
> dissemination, copying, or storage of this message or its attachments is
> strictly prohibited and shall make you liable for consequences under
> applicable laws."
>