Config PowerMass
Mass Config
When you need to configure a lot of UCCs it would be very helpful if you don’t have to do this manually. With the Mass script configure tens or hundreds of UCCs.
The Mass Config script focuses on functional configuration on SharePoint only, for creating the SharePoint sites and Skype applications + endpoints, please check UCC Creator, Learn More
Generate input files
For the Mass Config script to complete your SharePoint configuration, it requires one or more of the following input files:
-
00. AudioFiles (= directory)
-
01. Agents.csv
-
02. Skills.csv
-
03. SkillsPerAgent.csv
-
04. BusinessHours.csv
-
05. IVRQuestions.csv
-
06. Holidays.csv
-
07. Playlists.csv
-
08. Settings.csv
-
09. TimerJobs.csv
-
10. QualityMonitorConfig.csv
-
11. Supervisors.csv
-
12. Endpoints.csv
Every directory/CSV-file corresponds with a list within the UCC SharePoint Configuration Site. The following sections explain how to complete the different directories/CSV-files.
Each of the directories/CSV-files refers to a UCC. This reference should match the final section of the hyperlink to the UCC SharePoint configuration site.
If the hyperlink to the UCC SharePoint Configuration Site is: https://sitecollection.domain.com/sites/a365/ucc_example the UCC reference is: ucc_example
00. AudioFiles
If audio files should be uploaded to one or more UCCs, a subfolder inside the 00. AudioFiles directory should be created for each of these UCCs. The name of the subfolder should match the UCC reference (as explained earlier). The audio files that should be uploaded to the UCC SharePoint Configuration Site can be placed within this subfolder.
01. Agents
If Agents should be added to one or more UCCs, these can be configured in the file “01. Agents.csv”. This CSV-file contains four columns:
-
UCC: this is the UCC reference (as explained earlier)
-
Agent
-
Order
-
Formal
For more information regarding these columns, please check: Agents
02. Skills
If Skills should be added to one or more UCCs, these can be configured in the file “02. Skills.csv”. This CSV-file contains ten columns:
-
UCC: this is the UCC reference (as explained earlier)
-
Title
-
ShowOnWallboard
-
ForwardToSip
Only used for Forward Skills and Chat Forward Skills
-
ForwardWithDTMF
Only used for Forward Skills
-
StartCountDownSeconds
Only used for CountDown Skills and CountDown Availability Skills
-
EndCountDownSeconds
Only used for CountDown Skills and CountDown Availability Skills
-
Availability
Only used for Availability Skills
-
Escape Skill
Only used for Availability Skills, CountDown Skills and CountDown Availability Skills
-
Content Type; possible values are:
-
Skill (if no Content Type is defined it will default to Skill)
-
CountdownSkill
-
AvailabilitySkill
-
CountdownAvailabilitySkill
-
ForwardSkill
-
ChatSkill
-
ChatForwardSkill
-
For more information regarding these columns, please check: Skills
03. SkillsPerAgent
If Skills should be assigned to Agents for one or more UCCs, these can be configured in the file “03. SkillsPerAgent.csv”. This CSV-file contains four columns:
-
UCC: this is the UCC reference (as explained earlier)
-
Skill: this column should match the title of a Skill
-
Score
-
Agent: this column should match the SIP address of an Agent
For more information regarding these columns, please check: Skills per Agent
04. BusinessHours
If Business Hours should be added to one or more UCCs, these can be configured in the file “04. BusinessHours.csv”. This CSV-file contains four columns:
-
UCC: this is the UCC reference (as explained earlier)
-
Day
-
Start
-
End
For more information regarding these columns, please check: Business Hours
05. IVRQuestions
If an IVRInteractive Voice Response (IVR) is a telephone application to take orders via telephone keypad or voice through a computer. By choosing menu options the caller receives information, without the intervention of a human operator, or will be forwarded to the appropriate Agent. should be setup for one or more UCCs, these can be configured in the file “05. IVRQuestions.csv”. This CSV-file contains fifteen columns:
-
UCC: this is the UCC reference (as explained earlier)
-
Title: this column has the following defaults:
-
Welcome Message
-
Welcome Recording
-
Message Closed
-
Message Overflow
-
Voicemail Message
-
Queue 1
-
Queue 2_1
-
Queue 2_2
-
Queue 2_3
-
Queue 2_4
-
Queue 2_5
-
Queue 2_more_5
-
Queue 3
-
Message Busy
-
CallbackThe CallBack feature enables the customer to leave his / her number to be called back by an available agent during business hours. init pre number
-
Callback init post number
-
Callback init anonymous
-
Callback enter number
-
Callback verify pre number
-
Callback verify post number
-
Callback bye
Additionally, multiple questions can be added, these items should start with prefix “Question” followed by any text.
-
-
Action: this column has the following defaults:
-
<empty>
-
Callback
-
Disconnect
-
Previous
-
Skill
-
Voicemail
-
-
Parent
-
Question
-
AudioQuestion: this column can be empty or should match the file name (without extension) of an Audio File
-
Choice; this column has the following defaults:
-
0
-
1
-
2
-
3
-
4
-
5
-
6
-
7
-
8
-
9
-
*
-
#
-
-
Choice Timeout
-
Answer
-
AudioAnswer: this column can be empty or should match the file name (without extension) of an Audio File
-
Skill: this column should match the title of a Skill when the action is set to either Callback or Skill
-
Order: only used for IVRCallbackItem; the following items should get the following order:
-
Callback init pre number 401
-
Callback init post number 402
-
Callback init anonymous 403
-
Callback enter number 404
-
Callback verify pre number 405
-
Callback verify post number 406
-
Callback bye 407
-
-
Queue: only used for IVRCallbackItem; for each IVRCallbackItem the value should be “3 - Callback Queue”
-
Workflow: only used for IVRCallbackItem; for each IVRCallbackItem the value should be “Callback”
-
Content Type: only used for IVRCallbackItem; for each IVRCallbackItem the value should be “IVRCallbackItem”
For more information regarding these columns, please check: IVR Questions
06. Holidays
If Holidays should be added to one or more UCCs, these can be configured in the file “06. Holidays.csv”. This CSV-file contains three columns:
-
UCC: this is the UCC reference (as explained earlier)
-
Title
-
Date
For more information regarding these columns, please check: Holidays
07. Playlists
If Playlists should be added to one or more UCCs, these can be configured in the file “05. Playlists.csv”. This CSV-file contains three columns:
-
UCC: this is the UCC reference (as explained earlier)
-
Playlist
-
Audio File
-
Order
-
Active
For more information regarding these columns, please check: Playlists
08. Settings
If Settings should be added to one or more UCCs, these can be configured in the file “08. Settings.csv”. This CSV-file contains three columns:
-
UCC: this is the UCC reference (as explained earlier)
-
Key
-
Value
For more information regarding these columns, please check: Settings
09. TimerJobs
If TimerJobs should be added to one or more UCCs, these can be configured in the file “09. TimerJobs.csv”. This CSV-file contains twelve columns:
-
UCC: this is the UCC reference (as explained earlier)
-
Title
-
Day
-
Specific days
-
Start time
-
Specific start time
-
List
-
Item
-
Column
-
Value
-
Active
-
Run now once
For more information regarding these columns, please check: Timerjobs
10. QualityMonitorConfig
If Quality Monitors should be added to one or more UCCs, these can be configured in the file “10. QualityMonitorConfig.csv”. This CSV-file contains nine columns:
-
UCC: this is the UCC reference (as explained earlier)
-
Welcome
-
ValueStart
-
ValueEnd
-
Goodbye
-
WelcomeAudio
-
GoodbyeAudio
-
Modality
-
Order
For more information regarding these columns, please check: Quality Monitoring
11. Supervisors
If Supervisors should be added to one or more UCCs, these can be configured in the file “11. Supervisors.csv”. This CSV-file contains two columns:
-
UCC: this is the UCC reference (as explained earlier)
-
Supervisor
For more information regarding these columns, please check: Supervisor
12. Endpoints
If Endpoints should be added to one or more UCCs, these can be configured in the file “12. Endpoints.csv”. This CSV-file contains nine columns:
-
UCC: this is the UCC reference (as explained earlier)
-
Title
-
Modality
Only used for ModalityEndpoint
-
Skill
Only used for ModalityEndpoint
-
ParentQuestion
Only used for ModalityEndpoint
-
Priority
Only used for ModalityEndpoint
-
EnableRouting
Only used for ModalityEndpoint
-
AlwaysOn
Only used for ModalityEndpoint
-
Content Type; possible values are:
-
ModalityEndpoint (if no Content Type is defined it will default to ModalityEndpoint)
-
SystemEndpoint
-
MainEndpoint
-
DefaultRoutingEndpoint
-
A UCC needs a minimum of three system endpoints and one main endpoint. For more information regarding these columns, please check: Endpoints
Start the Mass Config
If one or more input files are generated the Mass Config can be started. I.e. if you don’t want to add Agents to the UCC, remove the file “01. Agents.csv” from the Mass Config root-directory.
-
Start Powershell as Administrator and run “mass.ps1”
-
First, the script will prompt for the delimiter used in the CSV files.
-
Next, the script will prompt for the SharePoint Parent Site:
-
Please enter the SharePoint Parent Site of the UCCs that will be imported now:
This is the web address to the UCC SharePoint Site that hosts the underlying UCC SharePoint Configuration Sites.
E.g. if the UCC SharePoint Configuration Site is https://sitecollection.domain.com/sites/a365/ucc_mass_import fill in the site without the UCC reference: https://sitecollection.domain.com/sites/a365
-
Based on the web address of the SharePoint Parent Site the mass script detects whether the UCC SharePoint Configuration sites are hosted on SharePoint On-premises our SharePoint Online. The prompts that follow are tailored to the detected version of SharePoint.
SharePoint On-premises
If the UCC SharePoint Configuration Sites are hosted by SharePoint On-premises the following prompts should be completed:
-
Do you want to use “domain\user” to connect to SharePoint:
If you are logged in with a domain account, you can use this account to connect to SharePoint.
If you do not want to use your current account, more prompts will follow:
-
Please enter the domain-part of the account to connect to SharePoint (<domain>\<user>):
Enter the domain of your user account
-
Please enter the user-part of the account to connect to SharePoint (<domain>\<user>):
Enter the username of your user account
-
Do you want to use “domain\user” to connect to SharePoint?
If you miss typed the domain- and or user-part of your user account you can select No. If the user account is correct, select Yes.
-
Please enter the password for “domain\user”:
Enter the password in order to be let the script sign-in to SharePoint successfully.
Regardless of connecting to SharePoint with your current account, or with another account, a final prompt should be completed:
-
Do you want to delete existing items from the SharePoint lists?
If you select Yes, existing items will be deleted from the lists that will be imported. This might be useful, take the Business Hours as an example: the default items in the list are Monday till Sunday from 00:00 till 23:59. If you want to override the Business Hours with your own set of Business Hours, existing items should be deleted from the list first.
If you select No, existing items will remain, and new items will be added to the lists.
SharePoint Online
If the UCC SharePoint Configuration Sites are hosted by SharePoint Online the following prompts should be completed:
-
Please enter the account to connect to SharePoint (<user>@<domain>):
Enter the sign-in address of the user account
-
Do you want to use “user@domain.com” to connect to SharePoint?
If you miss typed the sign-in address of your user account you can select No. If the user account is correct, select Yes.
-
Please enter the password for “user@domain.com”:
Enter the password in order to be let the script sign-in to SharePoint successfully.
-
Do you want to delete existing items from the SharePoint lists?
If you select Yes, existing items will be deleted from the lists that will be imported. This might be useful, take the Business Hours as an example: the default items in the list are Monday till Sunday from 00:00 till 23:59. If you want to override the Business Hours with your own set of Business Hours, existing items should be deleted from the list first.
If you select No, existing items will remain, and new items will be added to the lists.
After all prompts are completed the Mass Config will setup a connection to the first UCC SharePoint Configuration Site. If this connection is unsuccessful an error will be thrown.
If this connection is successful the items from the generated input files will be imported in the corresponding UCCs.
When one of the items contains malformed data, an error will be thrown that indicates why the item cannot be imported. In this case, correct the input file, and re-run Mass Config.
Advanced Mass Config
When a lot of UCCs with an identical configuration should be created (or part of the configuration is identical for these UCCs), there is an advanced way to import this data into these UCCs.
If, for example, 10 settings should be added to 10 different UCCs, and these 10 UCCs do have the same 10 Holidays as well as the same 10 Business Hours, you must create 3 Input Files (04. BusinessHours.csv, 05. Holidays.csv, and 07. Settings.csv) each of them containing 100 lines (10 lines per UCC).
Instead of creating the 3 Input Files with 100 lines each (as described above), you can also create 4 Input Files with 10 lines each.
-
04. BusinessHours.csv containing the 10 Business Hours
-
06. Holidays.csv containing the 10 Holidays
-
08. Settings.csv containing the 10 Settings
-
99. UCC.csv containing the 10 UCCs
Every Input File contains a column UCC, but if the Input File “99. UCC.csv” exists, this column will be ignored. Instead all items from all Input Files will be imported in all UCCs that are defined in the Input File “99. UCC.csv”.
99. UCC
If all items from all specified Input Files should be added to multiple UCCs, these UCCs can be configured in the file “99. UCC.csv”. This CSV-file contains two columns:
-
UccName: this is the UCC reference (as explained earlier)
-
Site: the complete hyperlink to the UCC SharePoint Configuration Site.
Start the Mass Config
The process for running the advanced Mass Config is identical to running the regular Mass Config. The only difference is that when the Input File “99. UCC.csv” is present, the UCC column in all other Input Files will be ignored and all items from all other Input Files will be added to all UCCs that are defined in the Input File “99. UCC.csv” (if the Mass Config is able to successfully sign-in to the specific UCC SharePoint Configuration File).
Final Remark
Be aware that the regular Mass Config and the advanced Mass Config cannot be used together in a single run of the Mass Config. In case you have some lists that should have identical items across multiple UCCS, use the advanced Mass Config first with only these Input Files that hold the generic items. Next, remove all Input Files (including 99. UCC.csv) and replace them with the Input Files holding UCC specific items, and run the Mass Config again.
.
Did you find this page helpful?
Yes No
Sorry about that
Why wasn't this helpful? (check all that apply)
Thank you for your feedback.
Want to tell us more?
Email your feedback to our documentation team.
Great!
Thanks for taking the time to give us some feedback.