Welcome to our Knowledge Base
-
System Settings
-
- Upload User Accounts
- User Accounts
- Upload Students
- Upload Students (Video)
- Upload Student Pictures
- User Permissions
- Manage Family and Guests
- Mass Updates
- Manage Students
- Microsoft Single Sign-On (SSO)
- Preparing for Next School Year
- Printer Setup - 3" Thermal (Windows)
- Printer Setup - 3" Thermal (Mac) **Advanced Setup**
- Printer Setup - 3" Thermal Network (Mac) **Advanced Setup**
- Google Single Sign-On (SSO)
- Classlink
- Show all articles (1) Collapse Articles
-
Store
-
- Changing Payment Type After Transaction has Completed
- Creating a Transaction
- E-mail Receipts
- Exporting Ticket Sales from Store to Ticketing for Checkin
- Modify Transaction - Post Sale
- Payment Type
- PAX Credit Card Reader Setup
- Portal Purchased Product Pickup and Reports
- Product Buttons
- Printing Receipts
- ProPay: How to Process Credit Cards
- ProPay: How to Void a Transaction
- Scanning a Student ID
- Returns
- Reprint Receipt and Resend Receipt by E-mail
- Student Credit
- Student Credit - Credit Refunds
- Discount Options
- Convenience Fee
- Show all articles (4) Collapse Articles
-
- Family and Guest Management
- Manage Spirit Points
- Manage Students
- Manage Family and Guests
- Mass Updates
- Student Credit
- Student Credit - Credit Refunds
- Discount Options
- Student Type
- Managing Student Credit
- Student Spirit Points
- Upload Students
- Upload Student Credit
- Upload Student Pictures
- Upload Students (Video)
- Add Students
- Student Negative Account Balance
- Show all articles (2) Collapse Articles
-
- Accessing the Student Only Store Portal
- Accessing the Open Store Portal
- Configure your Portal and Products
- Family and Guest Management
- Google Single Sign-On (SSO)
- Family Portal
- ProPay (Heartland) Merchant Account
- Manage Family and Guests
- Microsoft Single Sign-On (SSO)
- Portal Purchased Product Pickup and Reports
- Convenience Fee
-
- Accessing the Student Only Store Portal
- Accessing the Open Store Portal
- Configure your Portal and Products
- Cash Drawer (Connected to Thermal Printer)
- Cash Drawer (USB) Windows 10
- ProPay (Heartland) Merchant Account
- My Account
- PAX Credit Card Reader Setup
- Portal Purchased Product Pickup and Reports
- Product History (Link on Current Transaction)
- Product Agreement
- SFTP Automated Student Rosters
- School Logo
- Taxes
- User Accounts
- User Permissions
- Upload User Accounts
- Whitelist URL's
- Pay Open Invoice by Credit Card
- Show all articles (4) Collapse Articles
-
- System Settings Getting Started (Video)
- Mass Updates
- ProPay (Heartland) Merchant Account
- PAX Credit Card Reader Setup
- Google Single Sign-On (SSO)
- Microsoft Single Sign-On (SSO)
- School Logo
- User Accounts
- Preparing for Next School Year
- Remote Support
- Upload Student Pictures
- User Permissions
- Upload User Accounts
- Convenience Fee
- Classlink
-
Voting
-
- Adding an Election
- Adding Candidates
- Adding Officer Positions
- Adding Pictures and Biographies
- Archive and Retrieve Old Elections
- Create a Survey (Video)
- Election Layout Options
- Duplicate an Election
- Election Preflight
- Preview an Election
- Removing Candidates
- Using Video Biographies
- Write-in Candidates
- Rank Choice Voting
-
- Configure the Student Login Page
- Hobbies and Biography
- My Account
- Notifications for Unsuccessful Student Login Attempts
- Require Student E-mail
- Require Change Passwords
- SFTP Automated Student Rosters
- School Logo
- User Accounts
- User Permissions
- Upload User Accounts
- Whitelist URL's
- Pay Open Invoice by Credit Card
-
Ticketing
-
Interventions
-
- Bell Schedules
- Interventions
- Mass Updates
- My Account
- Printer Setup - 3" Thermal (Windows)
- Printer Setup - 3" Thermal (Mac) **Advanced Setup**
- Printer Setup - 3" Thermal Network (Mac) **Advanced Setup**
- SFTP Automated Student Rosters
- School Logo
- User Accounts
- User Permissions
- Upload User Accounts
- Whitelist URL's
- Pay Open Invoice by Credit Card
-
Announcements
-
Student / Family Portal
-
Digital ID
SFTP Automated Student Rosters
In this article, you will learn about configuring your automated student roster file. This is an addon option if you choose to automate your list of students into our platform nightly.
We do not have knowledge of your student information system, your district IT team will be responsible for exporting out the data below.
SFTP Credentials
Once we have Setup your SFTP (Secure File Transfer Protocol) account you will receive and SFTP URL, Username and Password. Your SFTP location will only house your districts data and no other districts will have access to your files. Your SFTP account will have a folder titled Upload. You will Automate your file / files in.
Student CSV File
The file name needs to be students.csv. You need to include a header row with the following fields in the order. Column titles need to be in all CAPS and have an underscore between each words as seen below. If you are unable to format it this way, please be sure to note that in your communication back to us.
Items below that have a Check are required. Items below with a Circle is optional based on product and configuration.
- STUDENT_ID - varchar (100) Student ID must be unique.
- FIRST_NAME - varchar (50)
- LAST_NAME - varchar (50)
- GRADE_LEVEL - varchar (50) if grade level is other then numeric (1,2,3) you will need to add those into system values
- SCHOOL_ID - varchar (50) we prefer NCES school ID if not then a local site ID will work.
- EMAIL - varchar (100)
- PASSWORD - varchar (50) passwords are encrypted on upload, not required if using Google for SSO
- VOTING_GROUP - varchar (150) - if using Voting many schools upload grade level as voting group
- TICKETING_GROUP - varchar (150) if using Ticketing you can upload a custom group for reporting
- LAST_PERIOD_LOCATION - varchar (50) if using Interventions you can upload last period room number or teacher name
Parent CSV File
If automating parent file, you will add a second .csv file titled parents.csv. This file will also have a header row Column titles need to be in all CAPS and have an underscore between each words as seen below. I
Items below that have a Check are required.
- STUDENT_ID - varchar (100) Student ID must be unique.
- PARENT_FIRST - varchar (50)
- PARENT_ LAST - varchar (50)
- PARENT_EMAIL - varchar (100)
Upload Options
We will also need answers to the following questions when setting up your account.
- Do your students have Google Email accounts? (password is not required if using Google for SSO)
- Do you want to wipe and reload students nightly? (typically the only time you would not want to do this is if you have additional users in your student table such as staff. Some schools will do this when using Ticketing and or Store)
- Do you want to overwrite emails with your nightly upload? (Student email can be modified by students and staff in our system. If you choose to overwrite emails this will set it back to the district uploaded email each night. This can be changed after initial setup)
- Do you want to overwrite passwords with your nightly upload? (Student passwords can be modified by students and staff in our system. If you choose to overwrite passwords, this will set the password back to the default each night.)
- Are your passwords dates? (Districts sometimes use a student birthday at their initial password. If so we can format the date on import to m/d/yyyy)
- We will also need a site ID map. Provide a Excel or Google Sheet with Site ID’s and school labels so we can map them on the backend.