.csv export now has timezone info in date columns

[Ronald Vallenduuk]

Starting today the Date Started column in the timesheet report includes timezone info when exported to csv. This breaks our processes as Excel does no longer recognise this column as a date. csv export last Friday: 2017-08-01 08:58:00 csv export today: 2017-08-01 08:58:00 +01:00

[Andriy Zhdanov]

Hi Ronald,

This is by intention, due to issue#1131.

There is timezone offset included, because time is in worked user timezone, which may be different than currently logged in user, so it may be not accurate unless offset is included.

Please adjust your processing, and sorry for inconveniences caused.

Thank you.

[Ronald Vallenduuk]

Genius. Fix an edge case for one customer and break Excel import for everyone else. By adding the timezone offset you have reduced the Date Started field from a date field to a text field. Well done.

[Andriy Zhdanov]

Please let me know if there is better way to include timezone offset.

I've thought of removing space before offset, but I don't think it will be valid format then.

Do you thinkk it should be 2017-08-01T08:58:00+01:00?

[Andriy Zhdanov]

Issue #1157 was marked as a duplicate of this issue.

[Andriy Zhdanov]

Hi Ronald,

As you might have noticed, I have removed timezone offset in export files, and restored original behaviour, i.e. converting time to current user time zone. Note, I've just added Preserve Started Time add-on configuration option for issue#1131.

Thank you.

[Ronald Vallenduuk]

Thank you, much appreciated!