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.
Multiexcerpt include | ||||||
---|---|---|---|---|---|---|
|
Person Field Codes
Note |
---|
A backslash (\) in any field is converted into a carriage return. Repeat two (\\) to make new a paragraph. |
Supports two Address lines for import; breaks apart the address at the \ into two different address fields.
Names of people who are authorized to check a student out of school.
Yes=Yes, No=No, Blank=No
Yes=Yes, No=No, Blank=No
MM/DD/YYYY for person start date.
MM/DD/YYYY for person end date.
When repeating the 1027 tag in the import header, facility IDs in the record must be <tab> delimited
(e.g. StudentID#<tab>FacilityID01<tab>FacilityID02<tab>FacilityID03...). Additionally, the %%%All command can be utilized for the purpose of assigning the imported person to ALL facilities in the account.
Male=1(or M), Female=2 (or F).
Blank=No, Yes=Yes, No=No, Staff=Yes
Blank=No, Yes=Yes, No=No, Student=Yes
Blank=No, Yes=Yes, No=No, Vendor=Yes
Blank=No, Yes=Yes, No=No, Volunteer=Yes
Blank=Blank, No Match=Blank, Exact Match=Type
Appends to the First Name data fields with a <space>.
The Person ID must be between 4 and 15 characters in length, alpha-numeric only.
MM/DD/YYYY for staff hire date.
1=Active, 2=Inactive, 3=Pending, 4=Access Denied
Determines that file is being imported into correct account.