Error parsing time strings with unsupported offset format

[ggalmazor]

Software versions

Briefcase v1.16.0

Problem description

Reported by @aurdipas on the forums

Briefcase fails to export submissions with time fields encoded as HH:mm:ss.sss±HH. Briefcase expects time zone offsets to be expressed as ±HH:mm.

Steps to reproduce the problem

• Unzip this form and submissions to Briefcase's storage directory under forms: Test form.zip
• Reload forms in the Settings tab
• Export the "Test form" form

You'll see that 100% of submission are exported, but after inspecting the output file, you won't find the submission. You'll find an exception stacktrace in the logs as well.

Expected behavior

It should complete the export without failing, and the output file should have a row with the submission's data.

Other information

N/A