Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 20 Next »

Exporting Current Relationships

To export the current relationship configuration to an Excel file:

  1. Use the Export button

    1. This will download an Excel Workbook of the current relationship configuration to a folder based on your browser settings. e.g.

  2. The file format is suitable for having changes made and then Imported as required

The file may include Mentor relationships. These are established as part of the Mentor/Mentee processes, and should not be changed in preparation for Importing EXCEPT to remove them if that was specifically requested.

New Mentor Relationships should NOT be added in preparation for Importing. Doing so will circumvent aspects of the Mentor/Mentee processes with unpredictable results.


Importing Relationships

Please note that when using the Import functionality, Processing an upload workbook will delete and replace ALL existing relationships

  1. Use the Import button

  2. This will open the Import dialogue pop-up


Downloading an upload template

  1. Use the Download Bulk Template button in the Import Pop-Up

    1. This will produce and save the template file in a download folder as specified in your Browser configuration e.g.

  2. This Template can then be edited and populated with the Relationship information you require for Importing


Importing an Upload file

  1. Use the Select Files button to kick-off the dialogue to select your prepared Upload file from your device

  2. Select and Open the Upload file

  3. Once the file/s have appeared in the Files to upload block use the Process Upload button to replace the current Relationships configuration with the one specified in your Upload file

  4. You will need to acknowledge the Warning Pop-Up (Press OK) to continue with the Import

  5. You should get a brief prompt in the Top Right of the browser window acknowledging the success or failure of the Import e.g.

Errors that could prevent the successful Import of an Upload Workbook are usually:

  • Email Addresses that do not exist in the lists

    • Either the Leadership or Employee email columns

  • An invalid Relationship Type specified

  • A Relationship specified for more than once for the same Leader/Employee combination. Or if it does not actually fail, the outcomes could be dubious. (e.g. The last one of the duplicate relationships processed may be the only one configured)

On this page:


Upload Template format

Column Name

Options

Description

Leadership email

A valid email address of valid User

The email address of the Leader of the relationship. (i.e. The person that is either the Line Manager, Team Leader or Endorser)

Employee Email

A valid email address of valid User

The email address of the Employee that is being Managed, a member of the Team or to be Endorsed

Relationship Type:
Line Manager
Team Leader

  • Line Manager

  • Team Leader

The Type of relationship being configured for this row

NOTE: ALL existing relationships will be replaced with this data.
If existing relationships are NOT included in this template they WILL BE DELETED

None

This column is not utilized for the Import, it is merely to document the warning.

Please take note of the warning

  • Each row of the Upload file is used to define a single relationship

  • There can only be a single instance of a Leader/Employee relationship specified. i.e. A Leader cannot be more than 1 Leadership Type for the same Employee.

The following extract of prepared Upload Workbook shows an example of the configuration of Team Leaders and Line Managers with various employees:

  • No labels