Placement Processes

Step 1:    Create the Student List spreadsheet

Action

Details

Warning:  The spreadsheet must not contain a header row; and the list of students must be entered in Column A of the spreadsheet.

The list of students can be extracted from a Program, Course or Class list.

The spreadsheet must be created as follows:

-          The spreadsheet must not contain a header row

-          Column A must list the Student IDs of the students to be uploaded into the Student Pool

Save the spreadsheet (as a CSV (Comma Delimited - .csv) file) ready to be uploaded.

Take note of the file location and name for use later in the process.

Step 2:    Select and save the Placement Block and Student List spreadsheet in Medici

Application:   Medici

Navigation:    Student Placements®Placement Processes®Student Pool File Load

Run Control ID:             Type your [Run Control ID].

Select the Search button (or press Enter).

Note:    If you do not have a Run Control ID, select the Add a New Value tab or link.  In the Run Control ID field in the Add a New Value page, type your Medici user ID, then select the Add button (or press Enter).

Result:  The Student Pool Import page is displayed.

Process Parameters

If your Run Control ID has previously been used to upload students:

Select the Delete icon () to delete previous load details (there is no need to select the delete icon if your Run Control ID has not previously been used to upload students into a Student Pool).

Load into Placement Block:  Select the [Placement Block the Student Pool is to be loaded to].

Select the Upload File button.

Result:  The Upload File page is displayed.

Result:  The Choose File dialogue box is displayed.

Look In:                  Select the [file path to the CSV file to be uploaded].

Select the [CSV File to be Uploaded] (double-click the file, or select the file then select the Open button).

Result:  The Choose File dialogue box is closed, and the Upload File page now displays the file-path to the file to be uploaded.

Result:  The Student Pool Import page is displayed again.  The name of the file to be uploaded is displayed in the Attached File field, and the list of Student IDs to be loaded is displayed.

Result 1:   Assuming a Student ID is not duplicated in the list of students, the Student Pool Import page is saved, and the Student Pool Import process can be run.

Result 2:   If the file contains an invalid Student ID, the Student Pool Import page will save (provided there are no duplicate Student IDs) however a name will not be displayed adjacent to the invalid Student ID.  At this stage of the process it is possible to either overtype the invalid Student ID with the correct Student ID, or delete the invalid Student ID record; however correcting/deleting this data is not mandatory prior to running the Student Pool Import process (the process can be run without correcting the invalid Student ID(s), and the invalid records will fail to load and will be listed in the Process Output report).

Result 3:   If a Student ID is duplicated in the list of students, an error message will be displayed and the duplicate record will be highlighted in red.  The duplicate record(s) must be deleted from the Student List prior to running the Student Pool Import process (the process cannot be run when the list of students to be loaded contains duplicate Student IDs).

Result 1 (No Errors):

Result 2 (Invalid Student ID):

Result 3 (Duplicate Student ID):

Question 1:  Are there duplicate Student IDs in the list of students to be loaded?

Question

Yes

No

Are there duplicate Student IDs in the list of students to be loaded to the Student Pool?

Go to step 3.

Go to step 4.

Explanation:

If the Student List contains duplicate Student IDs, the duplicate Student IDs must be deleted (deleting duplicate records is mandatory prior to running the Student Pool Import process).  If the Student List contains invalid Student IDs, it is recommended the invalid Student IDs be corrected or deleted, however correcting/deleting invalid Student IDs is optional (step 3).

If the Student List does not contain duplicate Student IDs, the Student Pool Import process can be run in Medici (step 4).

Step 3:    Delete the duplicate Student IDs, and correct or delete the invalid Student IDs if applicable

Application:   Medici

Navigation:    An error message will already be displayed over the Student Pool Import page as a result of performing step 2

Result:  The Student Pool Import page is displayed, and the duplicate Student ID is highlighted in red.

To correct an invalid Student ID (optional):

[Relevant EmplID field(s)]:   Type or select the [correct Student ID(s)].

To delete a row that contains a duplicate Student ID (mandatory when the Student List contains duplicate records):

Select the Delete Row button () adjacent to the student record to be deleted (the duplicate record).

Result:  A message is displayed requesting confirmation the selected row is to be deleted, and advises the deletion will occur when the transaction is saved.

Result:  The selected duplicate student record is deleted from the list of students to be loaded to the Student Pool.

Continue to repeat this step until all duplicate records have been deleted.

Once all duplicate records have been corrected, (and invalid records corrected or deleted if applicable), select the Save button.

Result:  Assuming there are no further duplicate Student IDs, the Student Pool Import page is saved.  If there are further duplicate records, an error message will be displayed and this step must be repeated to delete the remaining duplicate(s).

Step 4:    Run the Student Pool Import process

Application:   Medici

Navigation:    The Student Pool Import page will already be displayed as a result of performing step 2 or 3

Result:  The Process Scheduler Request page is displayed.

Result:  The selected file commences loading, and the Student Pool Import page is displayed again.  The Process Instance is displayed at the top of the page (below the Run button).

[Note the Process Instance Number] (this detail is used later in the process).

Select the Process Monitor link.

Result:  The Process List page is displayed.

If the Run Status for the Process Instance is ‘Queued’ or ‘Processing’:

Continue to select the Refresh button until the Run Status field for the noted Process Instance displays ‘Success’.

Note:    If the Run Status field displays ‘No Success’, the process has failed (process failures will be rare or non-existent).  Should the process fail, repeat the run process.  If the process fails a second time, refer to the SPS Support Matrix for instructions on how to seek further assistance (the source of the error can be investigated in the .sdtout file).  Once the issue has been resolved, the Student Pool Import process can be resubmitted.

Select the Details link adjacent to the loaded file (the correct file can be identified by the Process Instance number displayed in the Instance Sequence field).

Result:  The Process Detail page is displayed.

Select the View Log/Trace link.

Result:  The View Log/Trace page is displayed.

Select the Log Report link (the name of the file will end in .log).

Result:  The Log Report for the selected File Upload process is displayed.

All records were loaded successfully:

In the File Load Summary section of the report:

            Records Read:             Will be the same as the number displayed in Records Inserted.

            Records Inserted:        Will be the same as the number displayed in Records Read.

            Record Failed:             Will be zero (0).

Record(s) failed to load:

In the File Load Summary section of the report:

        Records Read:             Will be greater than the number displayed in Records Inserted.

        Records Inserted:        Will be less than the number displayed in Records Read.

        Record Failed:             Will be a number other than zero.

In the Loading Students into Placement Block section of the report:

            Failed to Insert:           Will be [Placement Block ID] [Student ID] – Duplicate Entry.

In the Loading Students into Placement Block section of the report:

            Failed to Insert:           Will be [Placement Block ID] [Student ID] – The EmplID could not be found.

Question 2: Does the Log Report indicate one or more records failed to load?

Question

Yes

No

Does the Log Report indicate one or more records failed to load?

Go to question 3.

Go to step 6.

Explanation:

If the Log Report indicates one or more records failed to load, the next step of the process depends on the reason why the record(s) failed to load (question 3).

If the Log Report indicates all records loaded successfully, select random students from the load file and confirm the students are displayed in the Student Pool (step 6).

Question 3: Did a record fail to load due to invalid Student ID?

Question

Yes

No

Did a record fail to load due to invalid Student ID?

Go to step 5.

Go to step 6.

Explanation:

If the Log Report indicates a record failed to load due to an invalid Student ID, manually add the student record(s) to the Student Pool (if required) (step 5).

If the Log Report indicates a record failed to load as it duplicates an existing record in the Student Pool (ie. the student is already loaded in the Student Pool), the error does not need to be resolved and the process can continue by confirming the students are displayed in the Student Pool (step 6).

Step 5:    Manually load the student record(s) to the Student Pool

Application:   Medici

Navigation:    Student Placements®Placement Administration®Student Pool

           Placement Block:              Type the [Placement Block ID].

           Placement Block Name:       Type the [name of the Placement Block].

           Start Date:                       Type or select the [Start Date of the Placement Block].

           End Date:                         Type or select the [End Date of the Placement Block].

        Associated Study Period:   Type or select the [Study Period the Placement Block is associated with].

Select the Search button (or press Enter).

Result:  The Student Pool page is displayed for the selected Placement Block.

Select an Add a New Row button ().

           Student ID:                         Type or select the [Student ID of the student to be added to the Student Pool].

Continue to repeat this step to manually add all required student records to the Student Pool.

Result:  Medici is updated and the student record(s) are added to the Student Pool.

Step 6:    Confirm the students are displayed in the Student Pool

Application:   Medici

Navigation:    Student Placements®Placement Administration®Student Pool (this page may already be displayed as a result of performing step 5)

Populate one or more of the following search fields:

            Placement Block:                 Type the [Placement Block ID].

            Placement Block Name:        Type the [name of the Placement Block].

            Start Date:                         Type or select the [Start Date of the Placement Block].

            End Date:                           Type or select the [End Date of the Placement Block].

Select the Search button (or press Enter).

Result:  The Student Pool page is displayed for the selected Placement Block.

If the Process Output file for the Student Pool Import process indicates a student failed to load due to a duplication, confirm the duplicate student is displayed in the Student Pool.