cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Parth Jagirdar <Parth.Jagir...@citrix.com>
Subject [DISCUSS] UI time conversion for Events and Alerts.
Date Tue, 02 Apr 2013 22:35:21 GMT
All,

CS – 1898 ::  UI : incorrect time conversion on UI under Events

https://issues.apache.org/jira/browse/CLOUDSTACK-1898


I am proposing to change/redesign the way CS handles times and dates currently.


We have time conversion issue on UI due to Time Zones.

Time Zones is not a mandatory field and if left blank CS will use its default time zone and
Users will see time on their UI's off. (Refer to bug and attached screen for clarification)
(Unless of course they are in default time zone that CS would use, when no time zone is supplied)


Once upon a time…there was a table in a database , named Event…..


mysql> select * from event;
+-----+--------------------------------------+---------------------------+-----------+-------------------------------------------------------------------------------------------+---------+------------+-----------+---------------------+-------+----------+------------+----------+
| id  | uuid                                 | type                      | state     | description
                                                                              | user_id |
account_id | domain_id | created             | level | start_id | parameters | archived |
+-----+--------------------------------------+---------------------------+-----------+-------------------------------------------------------------------------------------------+---------+------------+-----------+---------------------+-------+----------+------------+----------+
|   1 | 746273bb-a6ed-453a-8e45-a9873d06c58e | USER.LOGIN                | Completed | user
has logged in from IP Address 10.216.132.50                                          |   
   2 |          2 |         1 | 2013-04-01 22:26:12 | INFO  |        0 | NULL       |    
   0 |
|   2 | f8323212-fe8f-4d3c-a1c8-40d26b217895 | USER.CREATE               | Completed | Successfully
completed creating User. Account Name: test, Domain Id:1                     |       2 | 
        1 |         1 | 2013-04-01 22:49:50 | INFO  |        0 | NULL       |        0 |


Now assume 2 users;

1.Admin  and
2.User

with User created by Admin using "Pacific time Zone".

When these 2 Users log in on UI, they both will see Event 1 (From Table above) with different
times. (Of course Admin)

Admin will see it as 2013-04-01 22:26:12  +/- Time Zone specified when this user was created.
Similarly user will see this same event with time +/- "Time Zone specified when this user
was created". (Pacific Time , in our example)

As per existing implementation, a Traveling "User", Either logs in from London Or Tokyo; "if
this User was created using PST", then he will have time off all the time during his travel.



DISCUSS:: To Prevent CS – 1898

- Should we actually store time/date in DB in some standard format. And then display it by
converting based on User's (Client Browser's) time/zone.
- Or should we instead make Time Zone field mandatory? (In this case we still have traveling
user problem).



Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message