Contributors

Odoo e2e testing with Cypress.

Sales terms

A module to add methods to convert datetime between UTC and user's timezone

I think I've seen somewhere under OCA a module to add generic methods to convert datetime between UTC and user's timezone, but I somehow can't find it now. A pointer would be appreciated.

Yoshi Tashiro

by Yoshi Tashiro. - 04:40 - 6 Jan 2021

Follow-Ups

Re: A module to add methods to convert datetime between UTC and user's timezone

Yes, that's it. Thank you, Lorenzo!

--
Yoshi Tashiro

On Wed, Jan 6, 2021 at 5:02 PM Lorenzo Battistini <elbaddy@gmail.com> wrote:
Was it this
https://github.com/OCA/partner-contact/tree/13.0/partner_tz
?

On Wed, 6 Jan 2021 at 04:42, Yoshi Tashiro <tashiro@quartile.co> wrote:
I think I've seen somewhere under OCA a module to add generic methods to convert datetime between UTC and user's timezone, but I somehow can't find it now. A pointer would be appreciated.

--
Yoshi Tashiro

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

--
Lorenzo Battistini
https://github.com/eLBati
takobi.online | Facebook | Linkedin | Youtube

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

by Yoshi Tashiro. - 09:21 - 6 Jan 2021
Re: A module to add methods to convert datetime between UTC and user's timezone

Was it this
https://github.com/OCA/partner-contact/tree/13.0/partner_tz
?

On Wed, 6 Jan 2021 at 04:42, Yoshi Tashiro <tashiro@quartile.co> wrote:
I think I've seen somewhere under OCA a module to add generic methods to convert datetime between UTC and user's timezone, but I somehow can't find it now. A pointer would be appreciated.

--
Yoshi Tashiro

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

--
Lorenzo Battistini
https://github.com/eLBati
takobi.online | Facebook | Linkedin | Youtube

by Lorenzo Battistini. - 09:01 - 6 Jan 2021
Re: A module to add methods to convert datetime between UTC and user's timezone

OK, I'd better look into odoo.tools, although there might be cases where we do not want to apply the formats by the language. Thanks a lot, Graeme!

--
Yoshi Tashiro

On Wed, Jan 6, 2021 at 4:12 PM Graeme Gellatly <gdgellatly@gmail.com> wrote:
Hi

The first 2 cases are already done better in odoo.tools and also exposed to mail.template, maybe reports too, well except it also formats the string for the users language too I think. Easily importable.

The 3rd case isn't worth it IMO, it seems quite specific and written in a very long way. Something like datetime.now(pytz.timezone('tz')).utcoffset() will do it in a 1 liner with maybe a bit of math and its a ton easier using python main datetime and pytz modules

I used to maintain a report date helper module but never use it anymore.

On Wed, 6 Jan 2021, 7:27 pm Yoshi Tashiro, <tashiro@quartile.co> wrote:
Thanks Graeme and Dominique. What I'm looking for is a collection of methods that are not covered in Date and Datetime classes of vanilla Odoo. For example:
    # Convert datetime object to date string
    def _convert_to_user_date_string(self, datetime, hours):
        user_datetime = datetime + relativedelta(hours=hours)
        return fields.Date.to_string(fields.Date.to_date(user_datetime))

    # Convert date string with timestamp to datetime object
    def _convert_to_user_datetime_string(self, date, timestamp, hours):
        datetime_value = fields.Datetime.from_string("{} {}".format(date, timestamp))
        return fields.Datetime.to_string(datetime_value - relativedelta(hours=hours))

    # Return the time difference (in hours), e.g. if user's timezone is in
    # GMT+9 this method will return 9.0
    def _get_tz_hours_diff(self):
        tz = timezone(self.env.user.tz or "UTC")
        current_time = fields.Datetime.now()
        user_time = pytz.utc.localize(current_time).astimezone(tz)
        utc_time = timezone("UTC").localize(current_time)
        hours_diff = (
            (user_time.utcoffset() - utc_time.utcoffset()) / timedelta(minutes=1) / 60
        )
        return hours_diff

I vaguely remember seeing somewhere someone extending Date and Datetime in a somewhat similar manner. If there is nothing under OCA we may create a module and make a PR.

--
Yoshi Tashiro

On Wed, Jan 6, 2021 at 2:12 PM Dominique k <dominique.k@elico-corp.com.sg> wrote:
oh... will check that. thanks a lot

On Wed, 6 Jan 2021 at 12:42 PM, Graeme Gellatly <gdgellatly@gmail.com> wrote:
It is built in to odoo and sometimes uses babel under hood.

For today jobs fields.Date.context_today(record with tz context, optional timestamp) is my general go to available in views as context_today.

odoo.tools.format_datetime or something like that does it too for datetime plus locale specific representation as string.

There is some more. Check fields.Date* and odoo.tools

In record rules it is tons harder but if you have the patience you can handroll a very ugly rule using time module.

Regards from UTC+13.

On Wed, 6 Jan 2021, 5:22 pm Dominique k, <dominique.k@elico-corp.com.sg> wrote:
i would be curious if there is one, or contribute for developing one

UTC --> user timezone is a real real pain to develop. particularly when trying to get "today" jobs

Regards,
Dominique

On Wed, 6 Jan 2021 at 11:42, Yoshi Tashiro <tashiro@quartile.co> wrote:
I think I've seen somewhere under OCA a module to add generic methods to convert datetime between UTC and user's timezone, but I somehow can't find it now. A pointer would be appreciated.

--
Yoshi Tashiro

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

--
Dominique KON-SUN-TACK  [Project Manager]
Elico Solutions (Singapore/Shanghai/Shenzhen)
Odoo Gold Partner, best Odoo Partner 2014 for APAC

Mobile: + 65 8502 2399
Skype: dominique_elico
Email: dominique.k@elico-corp.com.sg
Website: www.elico-corp.com

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

by Yoshi Tashiro. - 08:26 - 6 Jan 2021
Re: A module to add methods to convert datetime between UTC and user's timezone

Hi

The first 2 cases are already done better in odoo.tools and also exposed to mail.template, maybe reports too, well except it also formats the string for the users language too I think. Easily importable.

The 3rd case isn't worth it IMO, it seems quite specific and written in a very long way. Something like datetime.now(pytz.timezone('tz')).utcoffset() will do it in a 1 liner with maybe a bit of math and its a ton easier using python main datetime and pytz modules

I used to maintain a report date helper module but never use it anymore.

On Wed, 6 Jan 2021, 7:27 pm Yoshi Tashiro, <tashiro@quartile.co> wrote:
Thanks Graeme and Dominique. What I'm looking for is a collection of methods that are not covered in Date and Datetime classes of vanilla Odoo. For example:
    # Convert datetime object to date string
    def _convert_to_user_date_string(self, datetime, hours):
        user_datetime = datetime + relativedelta(hours=hours)
        return fields.Date.to_string(fields.Date.to_date(user_datetime))

    # Convert date string with timestamp to datetime object
    def _convert_to_user_datetime_string(self, date, timestamp, hours):
        datetime_value = fields.Datetime.from_string("{} {}".format(date, timestamp))
        return fields.Datetime.to_string(datetime_value - relativedelta(hours=hours))

    # Return the time difference (in hours), e.g. if user's timezone is in
    # GMT+9 this method will return 9.0
    def _get_tz_hours_diff(self):
        tz = timezone(self.env.user.tz or "UTC")
        current_time = fields.Datetime.now()
        user_time = pytz.utc.localize(current_time).astimezone(tz)
        utc_time = timezone("UTC").localize(current_time)
        hours_diff = (
            (user_time.utcoffset() - utc_time.utcoffset()) / timedelta(minutes=1) / 60
        )
        return hours_diff

I vaguely remember seeing somewhere someone extending Date and Datetime in a somewhat similar manner. If there is nothing under OCA we may create a module and make a PR.

--
Yoshi Tashiro

On Wed, Jan 6, 2021 at 2:12 PM Dominique k <dominique.k@elico-corp.com.sg> wrote:
oh... will check that. thanks a lot

On Wed, 6 Jan 2021 at 12:42 PM, Graeme Gellatly <gdgellatly@gmail.com> wrote:
It is built in to odoo and sometimes uses babel under hood.

For today jobs fields.Date.context_today(record with tz context, optional timestamp) is my general go to available in views as context_today.

odoo.tools.format_datetime or something like that does it too for datetime plus locale specific representation as string.

There is some more. Check fields.Date* and odoo.tools

In record rules it is tons harder but if you have the patience you can handroll a very ugly rule using time module.

Regards from UTC+13.

On Wed, 6 Jan 2021, 5:22 pm Dominique k, <dominique.k@elico-corp.com.sg> wrote:
i would be curious if there is one, or contribute for developing one

UTC --> user timezone is a real real pain to develop. particularly when trying to get "today" jobs

Regards,
Dominique

On Wed, 6 Jan 2021 at 11:42, Yoshi Tashiro <tashiro@quartile.co> wrote:
I think I've seen somewhere under OCA a module to add generic methods to convert datetime between UTC and user's timezone, but I somehow can't find it now. A pointer would be appreciated.

--
Yoshi Tashiro

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

--
Dominique KON-SUN-TACK  [Project Manager]
Elico Solutions (Singapore/Shanghai/Shenzhen)
Odoo Gold Partner, best Odoo Partner 2014 for APAC

Mobile: + 65 8502 2399
Skype: dominique_elico
Email: dominique.k@elico-corp.com.sg
Website: www.elico-corp.com

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

by Graeme Gellatly - 08:11 - 6 Jan 2021
Re: A module to add methods to convert datetime between UTC and user's timezone

Thanks Graeme and Dominique. What I'm looking for is a collection of methods that are not covered in Date and Datetime classes of vanilla Odoo. For example:
    # Convert datetime object to date string
    def _convert_to_user_date_string(self, datetime, hours):
        user_datetime = datetime + relativedelta(hours=hours)
        return fields.Date.to_string(fields.Date.to_date(user_datetime))

    # Convert date string with timestamp to datetime object
    def _convert_to_user_datetime_string(self, date, timestamp, hours):
        datetime_value = fields.Datetime.from_string("{} {}".format(date, timestamp))
        return fields.Datetime.to_string(datetime_value - relativedelta(hours=hours))

    # Return the time difference (in hours), e.g. if user's timezone is in
    # GMT+9 this method will return 9.0
    def _get_tz_hours_diff(self):
        tz = timezone(self.env.user.tz or "UTC")
        current_time = fields.Datetime.now()
        user_time = pytz.utc.localize(current_time).astimezone(tz)
        utc_time = timezone("UTC").localize(current_time)
        hours_diff = (
            (user_time.utcoffset() - utc_time.utcoffset()) / timedelta(minutes=1) / 60
        )
        return hours_diff

I vaguely remember seeing somewhere someone extending Date and Datetime in a somewhat similar manner. If there is nothing under OCA we may create a module and make a PR.

--
Yoshi Tashiro

On Wed, Jan 6, 2021 at 2:12 PM Dominique k <dominique.k@elico-corp.com.sg> wrote:
oh... will check that. thanks a lot

On Wed, 6 Jan 2021 at 12:42 PM, Graeme Gellatly <gdgellatly@gmail.com> wrote:
It is built in to odoo and sometimes uses babel under hood.

For today jobs fields.Date.context_today(record with tz context, optional timestamp) is my general go to available in views as context_today.

odoo.tools.format_datetime or something like that does it too for datetime plus locale specific representation as string.

There is some more. Check fields.Date* and odoo.tools

In record rules it is tons harder but if you have the patience you can handroll a very ugly rule using time module.

Regards from UTC+13.

On Wed, 6 Jan 2021, 5:22 pm Dominique k, <dominique.k@elico-corp.com.sg> wrote:
i would be curious if there is one, or contribute for developing one

UTC --> user timezone is a real real pain to develop. particularly when trying to get "today" jobs

Regards,
Dominique

On Wed, 6 Jan 2021 at 11:42, Yoshi Tashiro <tashiro@quartile.co> wrote:
I think I've seen somewhere under OCA a module to add generic methods to convert datetime between UTC and user's timezone, but I somehow can't find it now. A pointer would be appreciated.

--
Yoshi Tashiro

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

--
Dominique KON-SUN-TACK  [Project Manager]
Elico Solutions (Singapore/Shanghai/Shenzhen)
Odoo Gold Partner, best Odoo Partner 2014 for APAC

Mobile: + 65 8502 2399
Skype: dominique_elico
Email: dominique.k@elico-corp.com.sg
Website: www.elico-corp.com

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

by Yoshi Tashiro. - 07:26 - 6 Jan 2021

Archives

Contributors

Odoo e2e testing with Cypress.

Sales terms

A module to add methods to convert datetime between UTC and user's timezone

Follow-Ups

Re: A module to add methods to convert datetime between UTC and user's timezone

Re: A module to add methods to convert datetime between UTC and user's timezone

Re: A module to add methods to convert datetime between UTC and user's timezone

Re: A module to add methods to convert datetime between UTC and user's timezone

Re: A module to add methods to convert datetime between UTC and user's timezone

Follow us