Why do I have duplicate records for a member?


There are several possible reasons why duplicate member records could exist:

  • When importing members it is possible that Excel may remove the leading zeroes.
    • For example, "0ABC" may be converted to "ABC" by Excel if the file is edited and not formatted correctly.
    • Member imports should always be reviewed in a text editor.
  • Member imports are created using either member pin or employee number as the identifier.
    • When importing members, ensure that the same identifier is always used.
    • If a member account is created via API, the member employee number or username is their identifier.
      • If this info were to change, a duplicate member will be created.

Note:

  • A member pin unique and will always reference the same member per partner.
  • An employee number is unique per program.
  • When importing member records, the member pin and employee number are not case sensitive.