Student Sync: Student Card ID's and Leading 0's


Teena Blaydes -

Sometimes when handling data, especially in Excel, the leading 0's are not preserved. This can cause complications when uploading your student data. 

Help! Why is my user not able to check in to the kiosk? ("User not found") Their card ID is swiping a lot of 0's that aren't on their user profile!

This can be fixed by providing importer@joinhandshake.com with a corrected user file, that has the full card ID. If you have access to the Importer App, please upload it there, notating that the file is intended to change the card_id (this is a sensitive fields change).

 

How can I check that the original file has lost the leading 0's, since Excel removes them upon opening the file?

Using a text editor, or right-clicking the file and "open with" notepad or a comparable program, you can take a look at the raw text, to ensure that the card_id's have the leading 0's. 

 

Ways to avoid losing your leading 0's:

  • Try opening in a program other than Excel, if possible
  • If opening in Excel, remember to reformat the card_id column before saving
    • Right click column> Format Cells > Custom Format > Add the number of characters in 0's
      • E.g. if all card ID's are 16-digits, add 16 0's:
      • This will prefix any ID number that does not meet the 16-digit specification
        • If a card id reads: 123456789
          • Adding the above customization will cause it to read: 0000000123456789

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.