Instructor Import
An Instructor Import is available for PrismCore in the WPConsole Import/Export Interface.
With the interface, instructor records can be added or updated.
The ‘Instructor Import’ section within the WPConsole's Import/Export Interface must be checked, and the properties must be set. The instructors are imported utilizing the ‘OldInstructorEmail’ field. If the ‘OldInstructorEmail’ does not exist, then a record is added. If the ‘OldInstructorEmail’ does exist, then all other fields in the import line are updated in the instructor record.
Imports header information into ‘Instructors’.
| Column | Data Type | Length |
|---|---|---|
| InstructorName | varchar | 100 |
| InstructorPhone | varchar | 16 |
| InstructorFax | varchar | 16 |
| OldInstructorEmail | varchar | 80 |
| NewInstructorEmail | varchar | 80 |
| fInactiveFlag | bit | 1 (1=Inactive, 0=Active) |
Example:
VELUTUS VONCUSTOMER,106-019-2017,206-019-2017,SICVONCUSTOMER@MAILINATOR.COM,,0
Notes:
• The ‘NewInstructorEmail’ field can be left blank unless attempting to overwrite existing information.
• If either the ‘InstructorPhone’ or ‘InstructorFax’ fields are left blank, but the ‘OldInstructorEmail’ is populated with an existing instructor email, the ‘InstructorPhone’ and ‘InstructorFax’ fields will be blanked in ‘Instructors’.