150 likes | 297 Views
Importing Course Headers. Course Requests. How Can Importing Course Headers Help Me?. More Efficient More Accurate More Complete. How Does It Work?. Acquire an Excel based list of courses from your school Copy the data to the Import Template Email the list to PRISM support
E N D
Importing Course Headers Course Requests
How Can Importing Course Headers Help Me? • More Efficient • More Accurate • More Complete
How Does It Work? • Acquire an Excel based list of courses from your school • Copy the data to the Import Template • Email the list to PRISM support • Review your course to insure they were imported correctly
Preparing The List • A typical list given by the school
Preparing The List • To sort the list, we will go to Data>Sort • Sort the list by the three columns in ascending order
Preparing The List • The list is now sorted and all the junk has been removed.
Preparing The List • The Template
Preparing The List • Column A
Preparing The List • Columns B-I
Preparing The List • The list is almost ready to upload. • Convert list into a PRISM readable file type
Importing The List • Wait for confirmation from support • Jump 561 (Utilities>Data Import\Export > Import Course Requests)
Other Issues • No Department Code = No Course Upload • Updating\Overwriting course headers • Importing will not update existing book QTP • What happens if the import does not import correctly?