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
- Show all articles (3) 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
-
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
-
Announcements
-
Student / Family Portal
-
Digital ID
Uploading Multiple Voting Groups
![](https://software4schools.com/wp-content/uploads/2023/05/media_1612801618797-1.png)
-
The first step in creating multiple voting groups is to get a file that has all the data points that you want to use to separate out your voters. In this example, we are going to combine Gender and Grade so we can have 11th grade females in one group and 11th grade males in another.
In this article, you will learn how to upload multiple voting groups.
![](https://software4schools.com/wp-content/uploads/2021/09/Create-New-Columns-1.png)
-
Create a new column (for example “combined”) and then put your curser in the first row of data and click the Function (fx) Icon.
-
Search for Concatenate and click enter.
![](https://software4schools.com/wp-content/uploads/2021/09/Concatenate-1.png)
-
For Text1 click the first cell (in my example D2 under grade) and for Text2 click the next cell (in my example E2 under gender) and click done.
![](https://software4schools.com/wp-content/uploads/2021/09/Fill-down-1.png)
-
You should now see the combined data in one cell in the new column. Next click the small square box in the bottom right corner and drag down the entire file so it copies the formula.
![](https://software4schools.com/wp-content/uploads/2021/09/Copy-cells-1.png)
-
Highlight the entire column (F in my example), right click and select Copy.
![](https://software4schools.com/wp-content/uploads/2021/09/Paste-Cells-1.png)
-
Very important – We are now taking the formula and turning into raw data that can be imported. Fine a new blank column, click the header and select Paste Special and select Values and that will duplicate the data in a new column. The difference is that when you click on the data it will show in the formula cell and if you click on the original column (F) it shows the formula.
![](https://software4schools.com/wp-content/uploads/2021/09/Delete-old-cells-1.png)
-
You can now delete the original columns (in my example Grade, Gender and Combined) and this will now leave me with just the new column that has the raw data. Be sure to keep the new combined data (in my example column I )
![](https://software4schools.com/wp-content/uploads/2021/09/Save-as-1.png)
-
The best way to upload your file is to use a CSV file. So go Save As and choose the option CSV.
![](https://software4schools.com/wp-content/uploads/2021/09/upload-voting-1-1024x641.png)
-
Next you go log into your voting account System Settings / Users / Students and Upload your file. Be sure to line up the columns by selecting the correct column in the drop down to match the fields. Learn more about uploading students