Upload Skill Map - allow upload if some records dont have submitted_date value

nerubia / kh360-react

KH360 Frontend

0 stars 0 forks source link

Upload Skill Map - allow upload if some records dont have submitted_date value #1343

Open gborgonia-ir opened 2 months ago

gborgonia-ir commented 2 months ago

When admin tries to upload skill map with records that doesnt have submitted date, it currently throws this error

Data uploaded is as follows or refer here under sheet named Jan-Dec 2021

Expected Behavior:

Admin should be able to proceed with uploading skill map, but those records without submitted date should be skipped. And skipped records should show on the notification msg after upload under data with errors (refer to screenshot below)

jatnerubia commented 2 months ago

BE: https://github.com/nerubia/kh360-nodejs/pull/701

Acey06 commented 2 months ago

Issue on uploading with empty email.

I tried to upload csv with data that has no email address and invalid data error message occurred.

https://docs.google.com/spreadsheets/d/1PLmXMhwRsV62zf-ItwzeNBsqRRfUG3U3oH4r5mMMlA8/edit?gid=0#gid=0

I duplicated the sheet "Jan-Dec 2021" to another excel file and I removed the data that has no email address

Expected: I think it should be acceptable since I uploaded a csv file only and this error should be occurred if the file uploaded is non csv

rrosel commented 2 months ago

OK in Beta

Screenshare - 2024-07-18 10_35_12 AM.webm

rrosel commented 2 months ago

OK in Beta

Screenshare - 2024-07-18 10_35_12 AM.webm