Skip to content

Dates aren't displayed in their original format in the Import Wizard #320

@lmatayoshi

Description

@lmatayoshi

When uploading the following Lab Record Import CSV file:

ID,LabID,TestID,Result,Date
1243,1l23jkh45,43,positive,15Dec19
123,hj3245,43,positive,16May19
124,oi8324,43,negative,17Apr19
5123541,138jh53,43,negative,08Jun19
51,091324j,23,positive,19Aug19

And choosing the proper format DDMMMYY in the Protected Health Information Step:

protected_health_information_step

I would expect to see the dates in their original format. However, the following Review Step screen shows:

review_step

Which is confusing, because it makes me think that I misselected the date format in the previous step.

The problem is that the xlsxManager.js module is parsing those fields as Dates and formatting them its way. A possible solution would be forcing the manager to read those fields as plain text.

It's just an UI problem though. Dates are being sent with its original format to the server

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions