OpenSPP
Error encountered when importing record with Unique ID
Description: Error encountered when importing record with Unique ID in CSV for Individuals and Groups.
Instance: ACF-DEV
Steps to reproduce:
- Navigate to Registry > Individuals or Registry > Groups.
- Click Actions (gear icon) then click Import records.
- Click Upload File then choose CSV file attached. TSOS-18 for Individual. TSOS-26 for Group.
- Click Test.
- Check error in Registrant ID field.
Actual Behavior: Error in Registrant ID field.
Expected Behavior: No error in Registrant ID field.
Screenshot:
Upon checking, the cause of error is due to using the wrong column name in the header of the csv.
The header should be Unique ID and not Registrant ID.
To fix this, just change the Registrant ID to Unique ID.
Also, make sure that spp_registrant_import module is installed before uploading.
No code change/improvement needed.
sample screenshots after uploading the csv with the changed column name
Findings: QA Passed
Able to upload CSV in Groups page - PASS
Able to block upload of duplicate unique ID in Group page - PASS
Able to upload csv in Individuals page - PASS Able to block upload of duplicate unique ID in Individuals page - PASS
PLEASE NOTE : For UNIQUE ID, Values "0", "O", "1", "I" are not accepted. adding any of these values in the unique ID will trigger an error.
