AVAnnotate / admin-client

Application for building AVAnnotate websites
0 stars 0 forks source link

Auto-select fields for spreadsheet imports #76

Closed absempere closed 1 month ago

absempere commented 2 months ago

AVAnnotate users will be using the spreadsheet templates we came up with together, so Tanya requested that the spreadsheet import validation have default values that match the template. Users can modify the selections via the drop downs, but it's somewhat tedious to have to select each field in a dropdown, especially when the values should already match.

This is for Event, Annotation, and Tag imports.

Screenshot 2024-09-11 at 8 53 54 AM

For example, this Event spreadsheet import would look like this:

Screenshot 2024-09-11 at 8 55 07 AM

The attached spreadsheets have the correct column orders to align the import and the template. AVAnnotate_Event_Annotation_Template.csv AVAnnotate_Tag_Template.csv AVAnnotate_Event_Template.csv

camdendotlol commented 1 month ago

Done in #90

absempere commented 1 month ago

@camdendotlol Tag Import should be pre-selected on Project creation:

Screenshot 2024-09-17 at 10 23 29 AM

Also, I think this is a required field on Event Import, so should also be pre-selected:

Screenshot 2024-09-17 at 9 08 05 AM
camdendotlol commented 1 month ago

@absempere See the note in #90 about the column header typo ("AVFile" => "AV File"). The AV File Label column will match for event CSVs exported after that PR was merged. (You can also manually change the column name in your CSV from "AVFile Label" to "AV File Label")

I'll look into the project creation tag import component once Lorin's PR is merged since that touches some of the same stuff. The matching is done by comparing the field labels with the CSV column headers, so getting them to match will be as simple as updating the field labels to match our CSV format.