Skip to main content

How do I export barcode numbers to CSV?

You may want to export barcode numbers for custom-made identification cards for students or employees. In SchoolInsight, barcodes can be scanned when entering food orders in the Lunch module or when using the attendance terminal in the Attendance module. While SchoolInsight has the ability to print ID cards with the barcodes, some schools prefer custom-made ID cards by third-party printing companies and would like to export barcode numbers to CSV.

The default option for barcodes uses the student and employee internal numbers. This number is generated on the backend for each user. Admins cannot configure the internal number options. Student barcodes using internal numbers will be prefaced by an “S” and employee barcodes using internal numbers will be prefaced by an “E”.

If your school utilizes unique student and employee numbers, then you have the option of using the unique number. This option uses the number displayed in the “Student Number” or “Employee Number” fields. Unique numbers are managed from the district level and you may click here to read more about them.

To set the barcode number option:

  1. Go to Admin Main > Lunch > Options
  2. Select Edit
  3. Under Barcode Scanning, select either:
    • Use internal student/employee ID
    • Use unique student/employee numbers
  4. Save

To export student barcodes to CSV:

  1. Go to (District) Admin Main > Tools > Reports > Classic Custom Reports > Create a New Report - Query Builder
  2. In the Data tab
    • Remove the fields Student Full Name and Mailing Address All Fields
    • Add the following fields
      1. Student First Name
      2. Student Last Name
      3. Barcode Number
      4. Add any other fields as needed
  3. In the Output tab
    • Select Comma Delimited (CSV)
  4. (Optional) Click Save As…, enter a title, and select Save to save a copy of this report
  5. Generate

To export employee barcode to CSV:

  1. Go to (District) Admin Main > Tools > Reports > Employee Details
  2. Under Filter Employees
    • Set Active to True to export active staff only
  3. Under Fields to Show
    • Add the following fields:
      1. First Name
      2. Last Name
    • Add the barcode:
      1. If using the barcode option for internal ID, choose Internal Employee ID
      2. If using the barcode option for unique number, Add Employee Number
    • Add any other fields as needed
  4. Under Where Shown?
    • Select Comma Delimited (CSV)
  5. (Optional) Select Save Report, enter a description, and select OK to save a copy of this report
  6. Generate

Please note that if you are using the barcode option for internal ID, then you will need to preface the internal ID with the letter “E”, as the export only includes the numeric portion.