Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error encountered when importing record with Unique ID #439

Open
adriancris opened this issue Jun 7, 2024 · 2 comments
Open

Error encountered when importing record with Unique ID #439

adriancris opened this issue Jun 7, 2024 · 2 comments
Assignees

Comments

@adriancris
Copy link

Description:
Error encountered when importing record with Unique ID in CSV for Individuals and Groups.

Instance:
ACF-DEV

Steps to reproduce:

  1. Navigate to Registry > Individuals or Registry > Groups.
  2. Click Actions (gear icon) then click Import records.
  3. Click Upload File then choose CSV file attached. TSOS-18 for Individual. TSOS-26 for Group.

TSOS-18.csv
TSOS-26.csv

  1. Click Test.
  2. Check error in Registrant ID field.

Actual Behavior:
Error in Registrant ID field.

Expected Behavior:
No error in Registrant ID field.

Screenshot:
Image
Image

@reichie020212
Copy link
Member

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
Image

Image

@reichie020212 reichie020212 self-assigned this Jul 16, 2024
@anthonymarkQA
Copy link

anthonymarkQA commented Jul 16, 2024

Findings: QA Passed

Able to upload CSV in Groups page - PASS

Able to block upload of duplicate unique ID in Group page - PASS
Image

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.

Image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants