Skip to content

CSV import for a DATE column results in "Something went wrong" displayed in firetable #219

@mellissatort

Description

@mellissatort

Describe the bug
A column in firetable is configured with the DATE type. When importing a CSV file with date data into this field, the result is "Something went wrong" is displayed. Several different date formats have been tried.

To Reproduce
Steps to reproduce the behavior:

  1. Create a firetable with a column of type DATE
  2. Import a csv file with a column having data in a date format into this DATE column. The following formats have been attempted:
  • m/d/yy
  • mm/dd/yy
  • mm/dd/yyyy
  • month day, yyyy
  • yyyy-mm-ddT00:00:00.000Z
  • yyyy-mm-ddT00:00:00Z
  1. The import will be successful but the firetable will display "Something went wrong" for this date value.

After manually entering a record into the firetable, we reviewed the data being stored via firebase and the date value is being stored as a timestamp instead of just a date. Exported the table data to confirm the format from an export and it is yyyy-mm-ddT00:00:00.000Z which is one of the formats listed above that was tried for importing.

Expected behavior
Firetable import will accept any date format, or a defined date format that is supported for import needs to be identified.

Desktop (please complete the following information):

  • OS: macOS 10.14.6
  • Browser: Safari
  • Version: 13.1

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions