Bulk Upload Records

Bulk upload allows you to create and upload the following using CSV files:

Entity

Description

Employees Employee data including name, email address, user name, mobile number
Teams Team name and other details such as team lead, unavailable codes, and default team contact settings.
Team Assignment Team name and the usernames of the employees assigned to the team
Devices CXone Multi-ACD (CXone Open): Add communication devices to the third party telephony system.
Recording Accounts CXone Multi-ACD (CXone Open): A recording account associates an agent with a telephony system by extension number or agent ID.

Mobile Agents Mapping

CXone Multi-ACD (CXone Open): Device mapping is required for integrating Cisco telephony to support mobile and remote agents.

You can add or update multiple records at a time. For existing records, CXone updates data in the system with the data in the CSV file as long as the username/team name/team name/skill ID and username exactly matches that already in the system. For importing, first prepare the records list by downloading the CSV template. Fill in the details in the format provided in the CSV file and upload the file. The data that is imported must be in the format provided in the template.

Upload Records

  1. Click the app selector and select Admin.

  2. Click Bulk Upload Portal.

  3. To upload employees, teams, or team assignment records, click Admin and then depending on the type of record you want to upload, click Employees, Teams, or Team Assignment.

  4. Click Download Template and download the CSV template to your computer.

  5. Open the file, fill in the details of the records to upload, and save the file. You can upload employee, team, or team assignment records.

    You cannot update the employee Status when you bulk upload employee records. If you want to deactivate multiple employees at the same time, click Admin > Employees. Select the boxes beside each employee that you want to deactivate. Click Deactivate.

  6. Click Browse For File and select the file you just saved. Alternatively, you can drag and drop files to upload.

  7. Click Upload Files. When the upload is complete, you receive a notification in Notification Center (bell icon). Either the bulk upload is successful or there are errors. In either case, you can click the notification to display the Activity tab of the bulk upload portal, which lists the details of the various upload attempts.

  8. If there are errors in your upload, click Review Errors to display the uploaded data in editable fields. The fields with erroneous values are marked in red and instructions to help you correct the values appear below each of these fields. Correct the errors and click Submit.

    Optionally, on the Employees Upload Errors screen, click Download Errors to download a CSV file with only the erroneous records and the error details, correct the errors in the CSV file, and use the Upload Files option to retry uploading.

Download Existing Records

To examine the present data in the system, you can download a list of records for employees, teams, user-teams mapping, and user-skill mapping.

  1. Click the app selector and select Admin.

  2. Click Bulk Upload Portal.

  3. In Upload, click the appropriate heading, such as Admin or ACD and then select the type of record to download, such as employees or teams.

  4. Under the appropriate type of record, click Download Existing Records. The existing records in the system are downloaded to your computer in a CSV file. You will receive a notification when the download activity is complete.

  5. Click the Activity tab to view your upload and download history. You can download recent files for up to 48 hours after the initial download by clicking Download.

Download and Edit Inactive Employee Records

You can download and edit inactive employee records along with your active and pending records. Inactive employee records are listed as Inactive in the Status column of the CSV file.

  1. Click the app selector and select Admin.

  2. Click Bulk Upload Portal.

  3. On the Upload tab, click Employees.

  4. Click Download All Users. The existing records in the system are downloaded to your computer in a CSV file. You will receive a notification when the download activity is complete.

  5. Open the CSV file.

  6. To activate employee records in bulk, change the records to Active in the Status column.

  7. Upload the edited file in the Bulk Upload Portal.

Bulk Upload Employee Records

You can upload up to 1,000 employee records at a single time by using the Bulk Upload Portal UI or by using the Import Employees option.

  1. Click the app selector and select Admin.

  2. Click Bulk Upload Portal.

  3. Click Admin > Employees.

  4. Click Download Template.

  5. In the CSV template, enter the employee record details. Then save the file and return to the Bulk Upload Portal page in CXone.

  6. Click Browse For Files and select the file you just saved. Alternatively, you can drag and drop file to upload.

  7. Click Upload Files. The Bulk Upload Portal page displays file upload progress. You also receive a notification in Notification Center (bell icon) when the upload is complete.

  8. You can either go to the Activity tab to view the upload status or click the notification to display the Activity tab of the Bulk Upload Portal page. The Activity tab lists the details of the various upload attempts. If the file upload failed, try uploading the file again.

On the Bulk Upload Portal page, you can see the file upload progress on the Activity tab. You also receive a notification in Notification Center (bell icon) when the upload is complete, and you can click the notification to go to the Bulk Upload Portal if you've navigated away from it.

If the upload failed due to errors in the file records, click Review Errors to display the uploaded data in editable fields. Fields with erroneous values are marked in red and have instructions to help you correct the values. Once you do so, you can save the file and try to re-upload the pending records.

Another option is on the Employees Upload Errors page, where you can click Download Errors. The resulting CSV file contains only the incorrect records and error details. Correct the errors in the CSV file and use the Upload Files option to retry uploading.

Bulk Upload Team Records

  1. Click the app selector and select Admin.

  2. Click Bulk Upload Portal.

  3. Click Admin > Teams.

  4. Click Download Template.

  5. In the CSV template, enter the team record details. Then save the file and return to the Bulk Upload Portal page in CXone.

  6. Click Browse For Files and select the file you just saved. Alternatively, you can drag and drop file to upload.

  7. Click Upload Files. The Bulk Upload Portal page displays file upload progress. You also receive a notification in Notification Center (bell icon) when the upload is complete.

    You can either go to the Activity tab to view the upload status or click the notification to display the Activity tab of the Bulk Upload Portal page. The Activity tab lists the details of the various upload attempts. If the file upload failed, try uploading the file again.

  8. For the newly assigned skills, change user proficiency.

Bulk Upload Team Assignment Records

  1. Click the app selector and select Admin.

  2. Click Bulk Upload Portal.

  3. Click Admin > Team Assignments.

  4. Click Download Template.

  5. In the CSV template, enter the team names in the Team Name column and email IDs of the users to assign to the teams in the corresponding Assigned Users column cells. Use semicolons to separate multiple email IDs.

  6. Click Browse For Files and select the file you just saved. Alternatively, you can drag and drop file to upload.

  7. Click Upload Files. The Bulk Upload Portal page displays file upload progress. You also receive a notification in Notification Center (bell icon) when the upload is complete.

  8. You can either go to the Activity tab to view the upload status or click the notification to display the Activity tab of the Bulk Upload Portal page. The Activity tab lists the details of the various upload attempts. If the file upload failed, try uploading the file again.

On the Bulk Upload Portal page, you can see the file upload progress on the Activity tab. You also receive a notification in Notification Center (bell icon) when the upload is complete, and you can click the notification to go to the Bulk Upload Portal if you've navigated away from it.

If the upload failed due to errors in the file records, click Review Errors to display the uploaded data in editable fields. Fields with erroneous values are marked in red and have instructions to help you correct the values. Once you do so, you can save the file and try to re-upload the pending records.

Another option is on the Employees Upload Errors page, where you can click Download Errors. The resulting CSV file contains only the incorrect records and error details. Correct the errors in the CSV file and use the Upload Files option to retry uploading.

Bulk Upload Communication Devices

  1. Click the app selector and select Admin.

  2. Select Bulk Upload Portal.

  3. Click Third Party Telephony > Devices.

  4. Click Download Template.

  5. In the CSV template, enter details for each device. Save the file and return to the Bulk Upload Portal page in CXone.

  6. Click Browse For Files and select the file you just saved. Alternatively, drag and drop the file to upload.

  7. Click Upload Files. The Bulk Upload Portal page displays file upload progress.

  8. Go to the Activity tab to view the upload status. The Activity tab lists the details of the various upload attempts.

    • If the file upload succeeds, the devices appear in the Devices tab for the corresponding telephony system.

    • If the file upload fails, try uploading the file again.

For more information about configuring third party connectivity, see Configure Third Party Telephony for CXone Multi-ACD (CXone Open).

Bulk Upload Recording Accounts

  1. Click the app selector and select Admin.

  2. Select Bulk Upload Portal.

  3. Click Third Party Telephony > Recording Accounts.

  4. Click Download Template.

  5. In the CSV template, enter details for each device. Save the file and return to the Bulk Upload Portal page in CXone.

  6. Click Browse For Files and select the file you just saved. Alternatively, drag and drop the file to upload.

  7. Click Upload Files. The Bulk Upload Portal page displays file upload progress.

  8. Go to the Activity tab to view the upload status. The Activity tab lists the details of the various upload attempts.

    • If the file upload succeeds, the recording accounts appear in the Recording Accounts tab for the corresponding employees.

    • If the file upload fails, try uploading the file again.

For more information about configuring third party connectivity, see Configure Third Party Telephony for CXone Multi-ACD (CXone Open).

Bulk Upload Mobile Agents Mapping

Only available for CXone Multi-ACD Cisco configuration.

  1. Click the app selector and select Admin.

  2. Select Bulk Upload Portal.

  3. Click Third Party Telephony > Recording Accounts.

  4. Click Download Template.

  5. In the CSV template, enter details for each device. Save the file and return to the Bulk Upload Portal page in CXone.

  6. Click Browse For Files and select the file you just saved. Alternatively, drag and drop the file to upload.

  7. Click Upload Files. The Bulk Upload Portal page displays file upload progress.

  8. Go to the Activity tab to view the upload status. The Activity tab lists the details of the various upload attempts.

    • If the file upload succeeds, the recording accounts appear in the Recording Accounts tab for the corresponding employees.

    • If the file upload fails, try uploading the file again.