What is the general goal of the feature?
As a data manager, I would like to process dates and times that use standard formats.
What are some example use cases for this feature?
As described at Date format on export different on different machines (with identical setups), depending on the locale and version of Java you have, Briefcase will output date times in a different format. This makes it hard to write and manage downstream tools that work with the data.
What can you contribute to making this feature a reality?
Spec and implementation guidance. Also docs.
- This will break a lot of downstream scripts so we need to have a longer beta and clear release notes.
- Newer versions of Java change the date formats we're using, meaning that doing nothing will also get us into trouble.
- Might not be possible to easily change formats with Aggregate or Central's publishers. That is, perhaps FusionTables or Tableau, might not love the new date formats. In that case, we can start with just CSV exports.
Here are the steps that we'll need to take to complete this.
Understand the potential date/time data types the XForms supports
Understand what formats Briefcase and Aggregate can parse
Understand what formats Central can parse
Understand what date/time formats Briefcase exports
Understand what date/time formats Aggregate exports and publishes
Understand what date/time formats Central exports and publishes
Update Briefcase to export ISO8601
Update Aggregate to export/publish ISO8601
Update Central to export/publish ISO8601
Release betas with deprecation warnings