Configure Surveys to SQL
(SharePoint Online Only) Pre-requisite
Note This step is required if you are using the preferred method of application credentials and when not already executed on the site collection during template installation.
-
Enable APP permissions
-
This was already executed during the installation of the UCCUCC stands for Unified Contact Center and consists of a queue that can be handled by Agents Each Contact Center has its own settings, interactive voice response questions and Agent with specific skills. Agents can be member of, or sign up to, one or more Contact Centers. Creator. If not completed, Learn More
-
Configure the Surveys to SQL application as scheduled task
Note These steps are for both SharePoint On-premise and SharePoint Online.
Warning Find your site collection URL and Client Secret code. If you lost your Client Secret code, you can generate one by following guide below.
-
Grab the site URL (parent site of your ucc) and client secret
Example: http://workstreampeople.sharepoint.com/sites/ucc/ucc_support/uccconfigtemplate (only use bold part)
Note This is also the site for the UCC Creator.
-
Copy the contents of the Survey script to <drive>\program files\anywhere365\scripts\SPO_Survey on the UCC server (may also be another Windows server, make sure the above pre-regs are met).
Note The survey scrips can be requested at the support-desk.
-
In the config file (Surveys.config), fill in the Targets:
Same Site = For all sites on the root level:
<Target enabled="true" type="SameLevel">https://contoso.sharepointonline.com/sites/ucc</Target>
Site Collection = For all sites in this site collection:
<Target enabled="true" type="SiteCollection">https://contoso.sharepointonline.com/sites/ucc</Target>
Site = Only for this site:
<Target enabled="true" type="Site">https://contoso.sharepointonline.com/sites/ucc</Target>
Version 6.0.6.0 or lower
<add key="TargetUrl" value="https://contoso.sharepointonline.com/sites/ucc" />
-
Next step is to configure user authentication.
-
(SharePoint OnPremise) Fill in the Username and Encrypted Password.
Note Use the Password Tool in the install directory to encrypt the password.
<Username></Username>
<Password></Password>
-
(SharePoint Online) Fill in the ClientID and ClientSecret, between the quotes.
<ClientID></ClientID>
<ClientSecret></ClientSecret>
-
-
Create a Windows Scheduled Task that runs indefinitely every 5 minutes (starting from rounded minutes e.g. 12.00, 12.05, 12.10, 12.15) and starts the executable (WSP.A365.SharePoint.WebJob.Survey.exe).
Or use the example XML below to import it into Task Scheduler:
<?xml version="1.0" encoding="UTF-16"?>
<Task version="1.2" xmlns="http://schemas.microsoft.com/windows/2004/02/mit/task">
<RegistrationInfo>
<Date>2019-04-16T15:24:40.1269215</Date>
<Author>Workstreampeople B.V.</Author>
</RegistrationInfo>
<Triggers>
<TimeTrigger>
<Repetition>
<Interval>PT5M</Interval>
<StopAtDurationEnd>false</StopAtDurationEnd>
</Repetition>
<StartBoundary>2019-04-16T15:20:00</StartBoundary>
<Enabled>true</Enabled>
</TimeTrigger>
</Triggers>
<Principals>
<Principal id="Author">
<UserId>S-1-5-21-3347327956-105208351-3318644539-10774</UserId>
<LogonType>Password</LogonType>
<RunLevel>LeastPrivilege</RunLevel>
</Principal>
</Principals>
<Settings>
<MultipleInstancesPolicy>Parallel</MultipleInstancesPolicy>
<DisallowStartIfOnBatteries>false</DisallowStartIfOnBatteries>
<StopIfGoingOnBatteries>false</StopIfGoingOnBatteries>
<AllowHardTerminate>true</AllowHardTerminate>
<StartWhenAvailable>false</StartWhenAvailable>
<RunOnlyIfNetworkAvailable>false</RunOnlyIfNetworkAvailable>
<IdleSettings>
<StopOnIdleEnd>true</StopOnIdleEnd>
<RestartOnIdle>false</RestartOnIdle>
</IdleSettings>
<AllowStartOnDemand>true</AllowStartOnDemand>
<Enabled>true</Enabled>
<Hidden>false</Hidden>
<RunOnlyIfIdle>false</RunOnlyIfIdle>
<WakeToRun>false</WakeToRun>
<ExecutionTimeLimit>P3D</ExecutionTimeLimit>
<Priority>7</Priority>
</Settings>
<Actions Context="Author">
<Exec>
<Command>"C:\Program Files\Anywhere365\Scripts\SPO_Survey\WSP.A365.SharePoint.WebJob.Survey.exe"</Command>
</Exec>
</Actions>
</Task>
-
Make sure that the account that performs the task has sufficient permissions to run the job, even if it is not logged in. Run with highest privileges.

Pre-requisites
Make sure the following pre-requisites are met
-
Install SharePoint Online Management Shell
https://www.microsoft.com/en-us/download/details.aspx?id=35588
-
Install Microsoft Online Services Sign-In Assistant
https://www.microsoft.com/en-us/download/details.aspx?id=41950
-
Install PowerShell PowerShellGet
-
Open PowerShell as administrator
-
Run:
Install-Module –Name PowerShellGet –Force
Update-Module -Name PowerShellGet
-
-
Install "Microsoft Online Services"
-
Open PowerShell as administrator
-
Run:
Install-Module -Name MSOnline
-
-
User is SharePoint Online global administrators and tenant administrator for the Office 365 tenant
Generate
-
Run Powershell as administrator
-
Run the following cmdlets: (Change the client id value to your client id)
Connect-MsolService
$clientId = 'clientid'
$bytes = New-Object Byte[] 32
$rand = [System.Security.Cryptography.RandomNumberGenerator]::Create()
$rand.GetBytes($bytes)
$rand.Dispose()
$newClientSecret = [System.Convert]::ToBase64String($bytes)
New-MsolServicePrincipalCredential -AppPrincipalId $clientId -Type Symmetric -Usage Sign -Value $newClientSecret
New-MsolServicePrincipalCredential -AppPrincipalId $clientId -Type Symmetric -Usage Verify -Value $newClientSecret
New-MsolServicePrincipalCredential -AppPrincipalId $clientId -Type Password -Usage Verify -Value $newClientSecret
$newClientSecret
-
Copy outcome and save it
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.