Jul 18, 2017 - 10:28 AM
We often receive questions regarding some of the fields or data that is used in the CSV. Here is some information that may answer your questions.
The CSV should contain ALL of your users -
When you upload your CSV, it will need to contain all of the users that you want in Wixie. So, you can’t upload a CSV with all of your first graders and then upload a new CSV with only your second graders. This will mark all of your first graders as deleted.
I have outlined how to add new users if you’ve already uploaded a CSV containing some users and want to add more users here.
If you do upload a new CSV that does not contain all of your users, the previous users will be marked as deleted. You can fix this by undeleting the users manually (as outlined here) or you can upload a new CSV with all users.
The Wixie CSV will contain several values, including the Reference ID (RefID) for some items. The RefID is a unique value that does not change for an item such as a School, Teacher or Student. As long as the RefID stays the same, work that a user did last year will move forward with them when the accounts are updated.
I usually recommend using the Student ID number from your Student Information System (SIS) for the RefID.
For some items, you may not have an entry in your SIS such as a school. In that case, you may want to use the school name for the RefID (more on this below). For example, the first two columns of CSV may look like this:
#School RefID, School Name,
Washington Elementary School, Washington Elementary School,
Remember, the RefID should not change at all since even a small change will create a new user or school. Using the example from earlier:
#School RefID, School Name,
Washington Elem. School, Washington Elementary School,
This would be a considered a new school since the RefID value has changed.
If your students and staff have already been assigned Usernames for your network or Learning Management System (LMS), then I generally recommend using the same usernames.
I usually DO NOT recommend using a combination of name and initials for the Username as the chance of running into duplicate users is high with this method. For example, if you make the username for Barbara Miller = bmiller, you will have the same username for Ben Miller or Brittany Miller.
If your students have Google accounts, you can also use their Google username for their Wixie username. You can then leave the password field blank if you want to use Google to authenticate.
The same is true if you want to use your LDAP server to obtain passwords. You can find out more about creating a CSV for your Google accounts here.
I STRONGLY recommend that each user have a unique password. If the password is the same for all students, it is easy for students to get into another user's account which can create serious problems.
If you are using Google or your LDAP server, you can leave the password field empty. Remember, your usernames will need to be the same as your authentication provider.
What if some fields are not in my SIS, or if I don't have access to export my data?
While I generally do not recommend "making up" the data, you may be able to use the same data in multiple fields.
For example, if you don't have a Class ID in your system, you can usually use the Class Name in the RefID field as long as it is unique. So, if your class names look like this, you will probably not have a problem:
Homeroom - Mrs. Smith
Homeroom - Mr. Davis
Often, teachers may not have an ID in the Student Information System. In that case, you can usually use the teacher's username as the RefID value. For example (the last 5 columns of your CSV may look like this):
Teacher RefID, Teacher First Name, Teacher Last Name, Teacher Username, Teacher Password
mmiller, Monica, Miller, mmiller, password
blin, Bruce, Lin, blin, password
Short URL for this article –
A couple of other articles that may be helpful:
How to add a teacher to more than one class in your CSV - https://goo.gl/195X6i
I uploaded a CSV in my district, but no changes were made - http://goo.gl/o8zU5T