Reporting and Analytics

Separate Timezone from Date field in csv report exports

Since the upgrade to OTRS6 timezone settings have been given increased importance. This is generally good however we have found that when we create reports and export them as .csv files the date fields such as create date now contain the timezone too. This is annoying as previously it was just a numerical field. When we generated the reports we could use excel formula to sort and analyse the results. Now that the timezone is included in the same column it is more annoying to do this. I spoke to OTRS and they just said use a formual to remove the timezone from the cells, which we'd started to do already however from our point of view it's not good DB practice to include two different types of data in the same column. The timezone should be a separate column in the table.

Tags

Attachments

- [ Show all ]

Voting

3 votes
Idea No. 1553