AccuTrack/AccuSQL
Import "Staff Table"

12 September 2013
USED TO IMPORT TUTORS/ADVISORS/STAFF MEMBERS. THEY WILL BE AVAILABLE TO ASSIST FOR THE ACTIVITIES TO WHICH THEY ARE ASSIGNED

CSV Mapped Columns:

# Field Name Type (Char Limit)
1 (Staff/Tutor/Advisor) User ID
varchar(40)
2 (Staff/Tutor/Advisor) First Name varchar(15)
3 (Staff/Tutor/Advisor) Last Name varchar(20)
4 Email varchar(100)
5 Phone varchar(13)
6 CellPhone varchar(13)
7 Address varchar(35)
8 City varchar(15)
9 State varchar(2)
10 ZIP varchar(10)
11 Card ID varchar(40)

*Fields highlighted in yellow are required to import.

Explanation:

The User ID is the ID for the tutor, advisor or staff member in the Tutors screen (names based on terminology, but data always in tutors table).

The First Name and Last Name are required.

The Email is optional, but required if you intend to send emails such as appointment confirmations or use messaging center for tutors.

The Phone is optional tutors phone number.

The Cell Phone is optional, but required if you plan to send text messages to tutors.

The Address is tutor address.

The City is tutor city.

The State is tutor state.

The ZIP is tutor zip.

The Card ID is optional and used to store a secondary ID tutors can use to sign into the system as an alternate credential to their user ID .

Example:

Download/View the example file (.CSV)

Import Behaviors for this Import

When you run this particular import there are not any import behaviors. Import behaviors typically allow you to modify the way the import is ran for different results that normal. If you have any ideas for adding an import behavior please submit them to AccuTrack/AccuSQL's User Voice.

BACK to List of Imports