Cloud Import Service

Cloud Import Service allows you to retrieve data from a cloud based installation of WFO.

Since WFO 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
  • On WFO
  • On CloudImportService


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.



  1. On OneBackoffice > System Administration > Configuration edit Timezone, setting timezone and local.
    Note: Make sure that OneContact, WFO and Cloud Import Service have the same time.
  2. Create the folders that will receive and store the WFO files.
  3. On web.config, on the tag <applicationSettings> set the WFO 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 WFO 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 WFO database is.
    Value: Connection String.
  5. The OneWorkForceProvisioningDBCommandTimeout sets the maximum time that a connection to the WFO database tries befores timeout.
  6. On the tag <authentication> set the WFO authentication procedure:
    • None - Doesn't require authentication.
    • Forms - Require authentication to access WFO.
    • 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 WFO database:
    UPDATE [Administrator]
    SET SystemAdministrator = 1
    WHERE UserID = <userID> (1, 2 ou 3)



  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 WFO's BaseWebService URL.
      e.g.:  <value></value>
    • On the tag <appSettings> insert the path to the new WFO 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 WFO 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.