If the tab-delimited file you choose to import doesn’t have a recognizable header, it will require manual field mapping. Selecting Next from the Selected Import Pane section will open the Field Mapping dialog, allowing you to match KeepnTrack data fields to information in your tab-delimited import files.
The data from the import file is shown on the left-hand side of the dialog. KeepnTrack field names are contained in the drop-down menus on the right-hand side. Use these menus to match the contents of the import file. If you want to skip or ignore some of the information in the import file, you can change the drop-down menu to None.
If you find that there are blank or unmatched sections in the principle record of the import file, you may select None to ignore that entry throughout all remaining file records; be aware, however, that sometimes one person record will lack information that others contain.
Ignore First Record
If the first record in your tab-delimited import file contains an invalid header or a list of column headings rather than importable data, make sure that this box is checked—that way, this column will not be interpreted as legitimate person data.
Cancel
Closes the Field Mapping dialog and returns you to the People import interface.
Import
Once the proper fields have been aligned, click the Import button to send the import to the Operations Management queue.
Person Field Codes
| Note |
|---|
A backslash (\) in any field is converted into a carriage return. Repeat two (\\) to make new a paragraph. |
| Field | Code | Notes |
|---|---|---|
| Address Line 1 | 1011 | Supports two Address lines for import; breaks apart the address at the \ into two different address fields. |
| Authorized to Checkout | 1154 | Names of people who are authorized to check a student out of school. |
| Background Check Date | ||
| Birthdate | 1045 | |
| Block Sign Out | 1153 | Yes=Yes, No=No, Blank=No |
| Bus 1 | 1151 | |
| Bus 2 | 1155 | |
| City | 1012 | |
| Criminal Conviction | 1172 | Yes=Yes, No=No, Blank=No |
| Driver License Number | 1140 | |
| Driver License State | 1141 | |
| Effective Date | 4501 | MM/DD/YYYY for person start date. |
| Email Address | 1019 | |
| Emergency Contact | 1133 | |
| Employer | 1170 | |
| Ethnicity | 1132 | |
| Expiration Date | 4502 | MM/DD/YYYY for person end date. |
| Facility | 1027 | When repeating the 1027 tag in the import header, facility IDs in the record must be <tab> delimited |
| Family ID | 1152 | |
| Fax Number | ||
| First Name | 1007 |
| Sex | 1032 | Male=1(or M), Female=2 (or F). |
| Government ID | ||
| Grade | 1010 | |
| Home Phone | 1017 | |
| Homeroom | 1004 | |
| Is Staff | 1112 | Blank=No, Yes=Yes, No=No, Staff=Yes |
| Is Student | 1111 | Blank=No, Yes=Yes, No=No, Student=Yes |
| Is Vendor | 1113 | Blank=No, Yes=Yes, No=No, Vendor=Yes |
| Is Volunteer | 1110 | Blank=No, Yes=Yes, No=No, Volunteer=Yes |
| Is Volunteer Type | 1120 | Blank=Blank, No Match=Blank, Exact Match=Type |
| Last Background Check Date | 1173 | |
| Last Name | 1006 | |
| License Plate Number | 1142 | |
| Login ID | 1052 | |
| Medical Notes | 1134 | |
| Middle Name | 1008 | Appends to the First Name data fields with a <space>. |
| Mobile Phone | 1131 | |
| None | ||
| Notes | 1020 | |
| On Staff Date | ||
| Operator Alert | ||
| Organization | 1102 | |
| Password | 1003 | |
| Person ID | 1000 | The Person ID must be between 4 and 15 characters in length, alpha-numeric only. |
| Personal Message | 1174 | |
| Postal Code | 1014 | |
| Preferred Activity | ||
| Prefix | ||
| Print Badge | ||
| Sign-In Message | ||
| Social Security Number | 1002 | |
| Staff Effective Date | 1161 | MM/DD/YYYY for staff hire date. |
| Staff Expiration Date | ||
| Staff ID | 1162 | |
| Staff Type | 1160 | |
| State | 1013 | |
| Status | 4500 | 1=Active, 2=Inactive, 3=Pending, 4=Access Denied |
| Student Effective Date | ||
| Student Expiration Date | ||
| Student ID | 1001 | |
| Suffix | 1101 | |
| Teacher | 1150 | |
| URL Code | 1999 | Determines that file is being imported into correct account. |
| Username | ||
| Vehicle Description | 1144 | |
| Vehicle Registration Date | ||
| Vehicle Registration State | 1143 | |
| Vendor Effective Date | ||
| Vendor Expiration Date | ||
| Volunteer Effective Date | ||
| Volunteer Expiration Date | ||
| Volunteer Type | ||
| Work Phone | 1130 |
