Bulk Import Schedule Exceptions

You can bulk import exceptions to agent schedules from the Master Schedule. Exceptions can be additional Activities that need to be inserted into agent schedules for specific dates and times, such as unscheduled breaks, meetings, and coaching sessions. These exceptions will appear as published changes in both the Master Schedule and the relevant Schedule Scenario.

Follow these steps to bulk import schedule exceptions:

1. Navigate to the Master Schedule from the Left Pane.

   

2. Click the More Actions (⋯) button at the top-right and select Import Exceptions to open the Import Exceptions Data window.

   

3. Upload the file with details of the schedule exceptions. Refer to the Important Considerations While Importing Schedule Exceptions section below for details on the headers of the data import file.

4. The following fields will appear after the file is successfully uploaded:

   1. Timezone: Select the time zone of the date and time provided in the import file. (Required)

   2. Date Pattern: Select the date and time format for the exceptions being imported, such as DD-MM-YYYY HH:mm:ss, MM-DD-YYYY HH:mm:ss, MM/DD/YYYY HH:mm:ss, or DD/MM/YYYY HH:mm:ss. (Required)

   3. Unique ID: Choose the unique identifier to identify the agent. Available options are User ID, Email ID, Federation ID, and Workday User ID. (Required)

5. Click the Import button to import the schedule exceptions for the specified agents.

You will receive a toast notification confirming your import request.

Once the request is processed, a platform notification will inform you of the status and include an attached file listing any errors encountered during the import. If there are rows with invalid or missing data, their data will be skipped without stopping the entire import process.

This completes the process of importing schedule exceptions.

Important Considerations While Importing Schedule Exceptions

• XLS and XLSX are the approved file formats.

• The Activity must already exist in the environment with the Activity Code specified in the import file.

The following headers are mandatory in the file (Do not modify the headers, including their case):

Bulk Import Agent Status

You can bulk import external agent status data for multiple agents. This allows Sprinklr Workforce Management to calculate Adherence based on the imported data, even when agent statuses are not tracked directly within Sprinklr.

Follow these steps to bulk import agent statuses:

1. Navigate to the Master Schedule from the Left Pane.

   ​

   ​

   ​

2. Click the More Actions (⋯) button at the top-right and select Import Agent Status to open the Import Agent Status Data window.

   ​

   ​

   ​

3. Upload the file with details of the agent statuses. Refer to the Important Considerations While Importing Agent Statuses section below for details on the headers of the import file.

4. The following fields will appear after the file is successfully uploaded:

   1. Timezone: Select the time zone of the date and time provided in the import file. (Required)

   2. Date Pattern: Select the date and time format for the agent statuses being imported, such as DD-MM-YYYY HH:mm:ss, MM-DD-YYYY HH:mm:ss, MM/DD/YYYY HH:mm:ss, or DD/MM/YYYY HH:mm:ss. (Required)

   3. Unique ID: Choose the unique identifier to identify the agent. Available options are User ID, Email ID, Federation ID, and Workday User ID. (Required)

5. Click the Import button to import statuses for the specified agents.

This completes the process of importing agent statuses.

After successful import, the system matches the external agent statuses with the agent’s latest published schedule to calculate Adherence. The Adherence timeline in Master Schedule will also reflect the updated Adherence values.

Important Considerations While Importing Agent Statuses

• XLS and XLSX are the approved file formats.

​

The following headers are mandatory in the file (Do not modify the headers, including their case):