Fixes for the ff:

#1 I just talked to Pete who will finalize / update the template spreadsheet so that we can make sure that we understand required and optional fields per cert. I should have this by tomorrow.

#2 Error message for "Header row not found in row 1”. For this error yo udon’t need to list the individual columns as they don’t relate to the error. You just need to say “Missing header in row 1”.

#3 I notice the filename is now displaying when I hit OK after the error in #2 and go back to the main screen (good job!). However, when I hit import it says please hit the spreadsheet file to import. Expected behavior is that I don’t have to re-browse for the file again.

#4 I went ahead and reselected the file having fixed it by taking out the invalid row 1 so that the header row was in row 1, and attempted another reimport. I got a error on row 1 stating header column names missing in row 1: First Name. Please rename the error to be “Row 1: Column First Name not found”. I am assuming the column names are case insensitive.

#5 Select the certificate type should default to Introductory, then list Stage 1, then Stage 2

#6 In summary section change “Total Rows” to “Number of trainee rows found”

#7 Because there typically will be only a single trainer per spreadsheet, you should just list the trainer one time, not for each row. I’m talking about the error where the trainer doesn’t exist. I suppose they could concatenate spreadsheets (I doubt it), so you would display a row for each trainer not found. This isn’t row dependent so you could list use a dash “-“ for the row number. Please ping me if this doesn’t make sense.

#8 There is a chance the course location may move to the initial page as a drop down, but for now, the same goes for course location as for #7.