Inline file mapping and editing (Flatfile)

[znatty22]

Feature Justification

Users often do not want to or don't have the means to programmatically transform their data into the study's required templates. Right now there is no user friendly way or UI to help them do this. Instead most users undergo a very error prone process of copying and pasting rows or columns of data from one spreadsheet into another.

Additionally, if a user wants to make corrections or changes to a file in Data Tracker, they must download their file, make corrections locally and then re-upload their file as a new version.

Proposed Change or Addition

It would be really nice if a user had a UI to help them do both of those things during the upload flow. We have found a product, Flatfile Portal, that can be integrated into Data Tracker as an import button to provide this functionality. Details are below:

Flatfile Portal

Flatfile Portal is a button that when clicked opens up a UI for users to
upload a file, map their columns to template columns, make corrections to
the data, and review their file before completing the upload.

https://flatfile.com/product/portal/

Demo + Code

Shane has already created a basic demo with just the Flatfile Portal button
using a couple of the NCI and Kids First templates

https://dewrangle-qf1f0gh3h-peykio.vercel.app/

Shane's code for the demo is:
https://github.com/kids-first/dewrangle/tree/main/src/components/Flatfile

New Upload Flow

We need to provide a way for the user to "Try New Upload" via a toggle or
something on the UI. Then if the user decides to try the new upload experience
the flow would be something like this:

1. User clicks Upload Document (this would actually be the Flatfile button)
2. User is presented with Flatfile upload modal
3. User maps their file, fixes errors, and completes the upload in the modal
4. API creates new version
5. Resume same flows

Backend

The Flatfile Portal button needs some configuration in order to work. The
configuration is essentially a list of template field definitions but
in the Flatfile format.

We may need to write a mutation that can convert our template into
their format. Or we may do this conversion on the frontend. Not sure yet.