CSV import for a DATE column results in "Something went wrong" displayed in firetable about rowy HOT 3 CLOSED

I stumbled upon same issue while trying to import dates.
Until the issue is solved you can use onCreate trigger to correct the date.

Eg.:

exports.onSlotCreate = functions
  .firestore.document('docs/{docId}')
  .onCreate(async (snapshot, context) => {
    const docData = snapshot.data();
    let update = false;

    if (typeof docData.date === "string") {
      docData.date = new Date(docData.date);
      update = true;
    }

    if (update) {
      db.collection('docs').doc(snapshot.id).update({date: docData.date});
    }
  });

from rowy.

@notsidney I think, all the fields are being imported as strings in the Firestore, and hence the Data Parser shows Something went wrong in the Date call.

I tried importing the following fields:

• name : string
• profilePictureUrl : string
• rating : number
• review : string
• reviewId : string
• timestamp : Date

with following csv:

name,profilePictureUrl,rating,review,reviewId,timestamp
Madhuri Salunkhe,,5,,temp_review,11/11/2020

Data Key Mapping Screen:

Firetable Post Import Screen

Actual Firestore Data Stored:

All the fields were directly added to Firestore as strings.

I think this could be the function which needs modification for type aware data importing.
https://github.com/AntlerVC/firetable/blob/fd036f59c7111b5105d69f94d183ccb1439eb0b7/www/src/components/Table/ImportCSV.tsx#L96-L105

from rowy.

Hi everyone, thanks for letting us know about this bug. I’m working on a new Import CSV wizard UI, which includes parsing date columns. We’ll be using date-fns’ parseJSON function, which supports a bunch of formats similar to the ISO date string format. Please note that it assumes your date is in UTC time, so if your CSV’s date is not in UTC and your browser/system’s timezone is not UTC, Firetable (and Firestore) will display a different date/time value (converted from UTC to your local timezone).

👉 So before using the Import CSV feature, you must convert dates to UTC time and a supported format.

When rows are added, it will store dates as Firestore Timestamps, similar to adding a new row & inputting a date through the picker.

The new Import CSV wizard will be available as part of the next PR from develop to master.

from rowy.