Data360 Analyze

 View Only

  • 1.  Seemingly Unable to Change Timezone Metadata of D360's datetimes

    Posted 10-03-2024 13:07

    Good Afternoon all!

    We have a peculiar observation that we're wondering if other folks in the userbase have encountered and if they've solutioned it. Whenever we successfully change the timezone information attached to a datetime away from the normal server TZ that is applied by default (via the methods available in pytz and datetime modules in python) it appears that D360 Analyze is immediately reapplying the server timezone metadata. Example, in the below screenshot, "Metric Date"'s TZ component has already been converted to UTC in python in a transform.. yet looking at the output pin we still see the -0500 indicating that the TZ information is somehow still remaining as US Eastern. This causes issues when using the Analyze Native Output tableau node, the resultant hyper file that it creates sees the TZ is US Eastern and converts it to the equivalent UTC time which corrupts the true time.. Since the Analyze output tableau node seemingly has not parameters to control this behavior, the fix is to update the TZ metadata to UTC before data goes into the output tableau node, however as outlined when we do this in python in a transform node, analyze seemingly ignores it and continues to treat the datetime as having a US/Eastern TZ component. Thoughts?



    ------------------------------
    Edward Bodie
    Lead Developer
    Consolidated Communications Enterprise Services, Inc.
    ------------------------------


  • 2.  RE: Seemingly Unable to Change Timezone Metadata of D360's datetimes

    Employee
    Posted 10-09-2024 07:04
    Edited by Adrian Williams 10-09-2024 07:08

    The datetime values displayed in the Data360 Analyze Data Viewer are always displayed in the timezone of the server hosting the Data360 Analyze application. 

    In the example below:

    All the datetime values use the same 'base' value 2024-10-27 12:00:00

    The Server hosting the Data360 Application is hosted in the US/Pacific timezone which is currently observing PDT (i.e. UTC-7).

    The 1st column in the Data Viewer displays a unicode string type field that contains a string which represents a test datetime (12:00 on Oct 27, 2024)

    The 2nd column shows a datetime field. The datetime object was created as a naiive datetime with no time zone info. The value shown in the field indicates the datetime value is being displayed in the current server time (-0700) and, as the value has no time zone info, the time element is 12:00 (it is assumed to be local time).

    The 3rd column displays a datetime value that was constructed with a timezone of UTC. The time element of the actual datetime object (12:00) is displayed relative to the server's time zone - as "05:00" with the timezone information showing it is relative to PDT (-0700). 

    The 4th column displays a datetime value that has been localized using pytz to 'US/Eastern' which is currently observing EDT (UTC-4). The value in the column is displayed relative to the server timezone. So the value is also "05:00" relative to the server's timezone of PDT (-0700). There is no indication in the Data Viewer that the underlying datetime value was created relative to the US/Eastern timezone. 

    The 5th column displays the UTC-localized datetime value as a formatted string and shows the timezone is indeed UTC (+0000)

    The 6th column displays the US/Eastern-datetime value as a formatted string and shows the time element is "08:00" and the timezone is EDT(-0400).



    ------------------------------
    Adrian Williams
    Precisely Software Inc.
    ------------------------------



  • 3.  RE: Seemingly Unable to Change Timezone Metadata of D360's datetimes

    Posted 04-21-2025 13:19

    Hi Adrian,

    could you explain how to install the pytz package, please? in your image I can see there is another Transform node with this

    Thanks

    Rafa



    ------------------------------
    Rafael Lucía
    Director
    NTASYS SOLUTIONS SL
    ------------------------------

    Original Message


  • 4.  RE: Seemingly Unable to Change Timezone Metadata of D360's datetimes

    Employee
    Posted 04-22-2025 08:56
    Edited by Adrian Williams 04-22-2025 08:56
      |   view attached

    Details on how to install a 'pure-Python' module for use with the Jython-based nodes is available within the product Help documentation, see here:

    https://help.precisely.com/r/t/1010707659/2024-05-08/Data360-Analyze/analyze-server/Latest/en-US/Data360-Analyze-Server-Help/Installing-pure-Python-modules

    The Script in the Transform node implements the same logic but uses the 'subprocess' command from within Analyze itself to automate the task, rather than manually executing the commands within a command window.

    I have attached a zip file that contains an example data flow with the relevant Transform node. Data360 Analyze 3.12 or higher is required to import the data flow.



    ------------------------------
    Adrian Williams
    Precisely Software Inc.
    ------------------------------

    Attachment(s)

    zip
    Install_pytz_Package_3.12.4 - 22 Apr 2025.zip   4 KB 1 version
    Original Message