Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add wizard helper to upload CSV/xlsx file uploads #293

Closed
12 of 15 tasks
tnrich opened this issue Oct 31, 2022 · 1 comment
Closed
12 of 15 tasks

Add wizard helper to upload CSV/xlsx file uploads #293

tnrich opened this issue Oct 31, 2022 · 1 comment

Comments

@tnrich
Copy link
Contributor

tnrich commented Oct 31, 2022

  • Relies on cell editable table being implemented Add Cell Editing to TRC #289

  • should have an option to manually insert data

  • excel parser needs to be passed optionally from lims!

  • include the file name being fixed up in the Dialog Title

  • should detect if there are mismatched headers in the uploaded file and open the Upload Helper Dialog with a message that the headers do not match

  • The first page of the Upload Helper Dialog should give the option to remap those headers

  • if headers match, we should still detect if there is invalid data in the uploaded file and still show the 1st page of the Upload Helper Dialog dialog with a message saying that "Some of the data doesn't look quite right. Do these header mappings look correct?"

  • in either case (manual insert or mismatched upload) we should present a table view that allows the user to preview and edit their data including validation

  • the headers metadata should be shown on hover of column headers in the header matching page

  • going back and forth between pages of the Upload Helper Dialog should NOT reset changes made to the table UNLESS the table mappings changed (even then maybe we can be smart about it?)

  • after manual upload or mismatched upload, a new file should be added to the file list

  • boolean field doesn't have select all button in column header sometimes? (fixed this)

  • make sure that hitting cancel on the Upload Helper or Manual Entry dialog is ONLY closing the newly spawned dialog!

Stretch goals:

  • support multi-file upload
  • (MAYBE DO THIS?) if headers and data are both valid, then the file should just be added to the file list successfully with toastr messages saying "Validating File..." --> "Validation Successful" as the upload completes
@tnrich
Copy link
Contributor Author

tnrich commented Dec 1, 2022

Closing this as finished

@tnrich tnrich closed this as completed Dec 1, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant