|Tutorial - Excel import not working when Timezone CEST||nicolas fenwick||2019-02-28 01:42|
Hi LabKey team,
I am going through the tutorials and noticed that the import of the Excel dataset is not working in my local instance of Labkey (which I find really amazing by the way, congratulations).
I live in France (CEST timezone).
The error message is attached.
As I was debugging I noticed that CEST was not correctly handled in DateUtil.java
resolveDatePartEnum(s) (line 297) returns null as CEST is not in the TimeZone list (line 252):
Now if you did add it, TimeZone.java translates it automatically to "CET" which causes another issue in DateUtil.java (line 292):
this returns null and another process starts to try and recognise CEST thanks to TimeZone.getTimeZone(s).
Unfortunately TimeZone.getTimeZone(s) does not recognise CEST and translates it to GST.
That issue was raised by Christine Rousseau:
I am not sure whether it has been fixed but I thought I would let you know about my investigations before it gets lost. I hope that helps.