ZEVA - Flagging Duplicate VINs in BCeID Spreadsheet Uploads to Prevent Error 31 (duplicate VINs)

[shayjeff]

Describe the task
Implement a feature in the ZEVA system that flags duplicate VINs in the spreadsheet uploads for BCeID users. The feature will prevent uploads containing duplicate VINs from being processed until the duplicates are removed.

Purpose
This task will improve efficiency and user experience by preventing duplicate VINs from being submitted in the first place. It eliminates the need for IDIR users returning the duplicate VINs and for suppliers to resubmit them in new credit applications.

Acceptance Criteria

• Add functionality to flag duplicate VINs during the spreadsheet upload process for BCeID users.
• Halt the upload if duplicate VINs are detected and display a clear error message to the user.
• Include an error message instructing users to remove duplicate VINs before resubmitting the spreadsheet.
• Confirm the flagging feature works smoothly within the existing spreadsheet upload process for BCeID users.

Additional context

• Error code 31 occurs when a supplier submits the same VIN twice, and both are flagged as duplicates.
• Currently, there is no way to validate one of these VINs within the system; IDIR users must return the VINs, requiring BCeID users to
  resubmit them in a new credit application.

[tim738745]

Can look at frontend/src/salesforecast/components/RecordsUpload.js to see how we can parse spreadsheets in the user's browser using the xlsx library.

[shayjeff]

Tested and approved. All criteria met with no issues found.