Users Import Guide

CSV Order Friendly Name Description Required for new record? Required for update? Other Requirements Sample CSV Data
1 User ID This field is the unique ID that corresponds with the school’s student and staff identification numbers. YES YES No spaces or special characters allowed. 18F98L1
2 First Name The user’s given name YES NO Mary-Anne
3 Last Name The user’s family name YES NO Smith
4 Username The user’s network (domain) login. This also becomes the OrchestrateIT username if this user is assigned OrchestrateIT access. NO NO fred.smith
5 CRN Reference The user’s CRN reference. NO NO 1009837439
6 Year Level The current grade that the student is in. This field is left blank if the user is not a student. NO NO Between 0 and 12 (inclusive). Use 0 for staff or other user types. 11
7 Class The current class that the student is in. This field is left blank if the user is not a student. NO NO No spaces or special characters allowed. 11M3
8 Phone Number The user’s mobile phone number starting with the country code (e.g. ’61’ instead of ‘0’ if Australia). NO NO No spaces or special characters allowed. 61412345678
9 Email Address The user’s email address. NO NO No spaces or special characters allowed. test@email.com
10 Type The category of the user. The user can be a staff member, student or a guest/other user. YES NO Accepted values: ’Student’, ’Staff’, ’Other’ Other
11 Status Specifies whether the user is current or whether they have left or graduated. YES NO Accepted values: ‘Active’ or ‘A’, ‘Inactive’ or ‘L’, ‘Future’ or ‘F’ Active
12 Eligibility Specifies whether the user is eligible to be assigned a computer. YES NO Accepted values: ‘Yes’, ‘No’ No
13 Internet Filtering Level Specifies the level of internet filtering this user should have applied to their account. NO NO Accepted values: ‘High’, ‘Medium’, ‘NA’ Medium
14 Campus Identifies the user’s home (base) campus YES NO Ensure exact match with the actual name of the campus in OrchestrateIT (case sensitive) Gold Coast
15 OrchestrateIT Access Specifies whether the user can login to the OrchestrateIT software, and the level of access they have YES NO Accepted values: ‘NA’, ‘Read Only’, ‘Finance Officer’, ‘IT Technician’, ‘Campus Admin’, ‘Site Admin’ Campus Admin
16 OrchestrateIT Passcode If the user has OrchestrateIT access, this field stores the 4-digit passcode. NO NO Must be 4 numeric digits. Required if OrchestrateIT Access (11) is anything other than ‘NA’. 1234
17 ICT Program The name of the ICT Program that the user is assigned to. NO NO Must match the name of an existing ICT Program that has been configured in Campus Settings. Non-Participant