Jira CSV export | Discrepancy in the date and time when exporting issues with CSV export.
プラットフォームについて: Cloud のみ - この記事は クラウド プラットフォームのアトラシアン製品に適用されます。
要約
When exporting issues using the Export tool with options like Export CSV or Export Excel CSV, it is important to know the date, time, and timezone settings. This article helps explain why two users would notice discrepancies in date and time values when exporting the same Jira issue using the export CSV tools.
環境
Jira Cloud
診断
Steps to validate both user account preference timezone -
1. Navigate to Atlassian account settings:
2. Go to Account Preference:
原因
Both the users' personal Atlassian account settings have different timezone sets up.
ソリューション
Exported data should follow the date and time timezone as per the user's personal preference on the Atlassian account setting. With native CSV export, the date and time honour the respective user Profile's time and date rather than the general setting of the Jira settings.