Cloud Import Service

Cloud Import Service allows you to retrieve data from OneContactCC into OneContactWFO when OneContactWFO is installed in the cloud.

Since OneContactWFO is on the cloud and both the Contact Center and the Cloud Import Service are on premises, in order to work the import service requires installations and configurations on several locations:


On Azure

  1. Create a database on Azure/Nubitalk.
    Note: for more information on how to create a database on Azure, click here.
  2. Run the script 1_OneWorkForceProvisioningCreateScript_Azure.sql.
  3. Run the script 2_OneWorkForceProvisioningInsertScript_Azure.sql.
  4. Run the WFO 2.1 release scripts.


On OneContactWFO

  1. On OneBackoffice > System Administration > Configuration edit Timezone, setting timezone and local.
    Note: Make sure that OneContactCC, OneContactWFO and Cloud Import Service are in the same TimeZone.
  2. Create the folders that will receive and store the OneContactWFO files.
  3. On web.config, on the tag <applicationSettings> set the OneContactWFO BaseWebService's path.
    e.g.: <value>http://localhost/OneWorkForceWebServicesHost/BaseWebService.asmx</value>
  4. On the tag <appSettings> there's a key OneWorkForceProvisioningDBConnection. Set the connection string to access the OneContactWFO database.
    e.g.: <add key="OneWorkForceProvisioningDBConnection" value="data,1433;initial catalog=OneWorkForceProvisioning_EAPDec;user id=sa;password=Collab2017;Connection Timeout=60"/>
    Key: Machine where the OneContactWFO database is.
    Value: Connection String.
  5. The OneWorkForceProvisioningDBCommandTimeout sets the maximum time that a connection to the OneContactWFO database tries befores timeout.
  6. On the tag <authentication> set the OneContactWFO authentication procedure:
    • None - Doesn't require authentication.
    • Forms - Require authentication to access OneContactWFO.
    • Windows - Windows credentials are used to log user.
  7. Three type of users (administrators) are created with the instance creation:
    • Admin
    • Sysadmin
    • Collabadmin
  8. To give permission as System Administrator, run the SQL command on the OneContactWFO database:
    UPDATE [Administrator]
    SET SystemAdministrator = 1
    WHERE UserID = <userID> (1, 2 ou 3)


On client's server

  1. On the cloudservice folder there's a CloudImportService.exe
  2. Run the following command line, in cmd.exe or Windows Power Shell, as administrator:

    sc create <servicename> binpath="<pathtobinaryexecutable>

  3. On the same folder there's a App.config. Configure the following parameters:
    • On the tag <applicationSettings> insert the OneContactWFO's BaseWebService URL.
      e.g.:  <value></value>
    • On the tag <appSettings> insert the path to the new OneContactWFO WebService (APiOneWorkForce.asmx).
      e.g.: <add key="WFOCloudAPI" value=""/>
    • If the Contact Center is an Oracle solution, set the ConnectionString: <add key="OracleDBConnection" value="Dsn=XXXXXXXX; Pwd=XXXXXXXX"/>
    • If the connection OnPrem -> Cloud goes through a proxy, configure the proxy:
      <add key="ProxyURL" value=""/> <!-- Example: -->
          <add key="ProxyUsername" value=""/> <!-- Example: UserName -->
          <add key="ProxyPassword" value=""/> <!-- Example: UserPass -->
      <add key="ProxyDomain" value=""/> <!-- Example: Novabase -->

    • On the tag <client> set the new OneContactWFO Webservice's path.
      e.g.: <endpoint address= binding="basicHttpBinding" bindingConfiguration="ApiOneWorkForceSoap"contract="APIOneWorkForce.ApiOneWorkForceSoap" name="ApiOneWorkForceSoap" />
  4. Go to Task Manager > Services.
  5. Select Cloud Import Service and right-click on the service.
  6. Select Start.
    Note: Whenever the CloudService.exe.config is edited, after saving it, the service must be restarted.