[Libreoffice-bugs] [Bug 119675] New: Migration Assistant: User dialog to set treatment of date and time values during migration

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119675

            Bug ID: 119675
           Summary: Migration Assistant: User dialog to set treatment of
                    date and time values during migration
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: drewjensen.inbox at gmail.com

The migration of date and time values from an HSQLdb data source to a Firebird
data source requires a decision with regards to how to handle the difference
between the two data engines interpretation of these values.

The HSQL RDBMS (servers and client tools) work with an awareness of the users
timezone and use to transform data sent from the client to the server and again
from the server to the client. Transforming the data from client_TZ -> UTC(0)
when sent and from UTC(0) -> Client_TZ when retrieved.

The Firebird RDBMS (servers and client tools) have no such awareness of time
zones, writing whatever the client gives to the server.

Since the migration assistant in LibreOffie is reading directly from the disc
image for the the HSQL data store, with no use of HSQL tools, the value
retrieved is always the value relative to the UTC(0) timezone.

If that value is written as is into the new Firebird data source the users will
see a difference in their data with displayed dates and times adjusting. This
change currently happens automatically.

The RFE is to add during the migration assistant function a dialog which gives
the users the option to move the date as stored or to have the assistant
transform the values from the UTC(0)_TZ value to the users Timezone equivalent
and therefore maintaining the same values presented to the user on screen and
in reports. 

For reference see this issue: Firebird: Migration: Time values are being
changed during migration process (data type TIME and DATETIME)
https://bugs.documentfoundation.org/show_bug.cgi?id=117732

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180903/0d23e0b4/attachment.html>