SFTP: Format Records and Images

Modified on Tue, 10 Dec at 9:22 AM

Clients can automatically import a large set of data (collection of records and images) into Badge via SFTP.

 

Guide


Record Format

Before uploading a new file, please review the following: 


  • Column fields must be the following data type:

 

  • Number: Integer or Decimal value

 

  • Text: Combination of letters, numbers, spaces, or supported special characters

 

  • Date/Time: must be in one of the following formats:

 

  • yyyy-mm-dd (e.g., 2023-05-12)
  • yyyy-mm-dd hh:mm:ss (e.g., 2023-05-12 05:45:07)
  • mm/dd/yyyy (e.g., 2023/05/12)
  • mm/dd/yyyy hh:mm:ss (e.g., 2023/05/12 05:45:07)

 

  • Files must be saved as a CSV file and less than 5MB

 

  • Required Column Fields: ID and Campus


The ID column will be the student/staff ID.

The Campus column will be the student/staff's location (e.g., School, Office, Store). 


Column names are case sensitive and should exactly match the column name in Badge.  

(i.e., A column name "Sampleton District" in the CSV file will not import to the column name "sampleton district" in Badge.)


  • Do not import any fields that do not require sorting, filtering, printing, or identification purposes


Image Format


Do not type the .jpg/.jpeg or .png extension when renaming the image files. Save the images as a JPG/JPEG or PNG. 


Before uploading a new image, please review the following:


  • Image files must be saved as .JPG/JPEG or .PNG

 

  • Image files must be less than 100 KB

 

  • The total size of the image files uploaded at once must be less than 1 GB

 

  • The name of the image file must match the record's ID. (e.g., Student ID is 512, image file should be "512")




Contact us for proper sizing and cropping instructions if you have any questions.



ZIP Files


When performing a bulk import of images, clients must follow the guidelines below to ensure compatibility with the import process and prevent errors during the upload.


  • File Format: All images must be stored within a single .zip file


  • Folder Structure: The .zip file should not contain any additional nested folders; it must contain only the image files directly


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article