Generating CSV files for Agent by Account and Routing Service reports

Last Updated : Aug 29, 2022 |
Prolog information
Metadata
Keywords:
To share historical reporting data with Avaya Experience Platform™ (Public Cloud Workforce Engagement) and non-Avaya Experience Platform™ (Public Cloud Workforce Engagement) solutions, you can configure Avaya Analytics™ to generate CSV files for the Agent By Account and Routing Service historical reports. Perform the following procedure to enable CSV file generation.
Other:
Complete this procedure only if your solution includes Avaya Experience Platform™ (Public Cloud Workforce Engagement). If you enable CSV file generation when Avaya Experience Platform™ (Public Cloud Workforce Engagement) is not part of your solution, this can impact Avaya Analytics™ performance.
After you complete this procedure, Avaya Analytics™ generates the CSV files at the following locations:
  • Routing Service
    • The location you configured on the dedicated external host server
  • Agent By Account
    • The location you configured on the dedicated external host server
For Agent by Account, you can enable daily OR interval CSV producer. For the Routing Service processor, you can enable only interval CSV producer. Interval Producer puts the data into the CSV file at an interval of 15 minutes. The daily producer generates a new CSV file with a unique name once daily.
Before you begin
Ensure that the location to store the CSV files already exists on the host server and the specified user has write permissions to the directory.
  1. Log in to the Cluster Control Manager (CCM) console as the customer user.
  2. Switch to being the root user by entering the command su.
  3. To run the Analytics Administration script, use the following command:
    ADDITIONAL INFORMATION:
    ccm release orca analytics
  4. Select Deployment by pressing the corresponding number.
  5. To select the CSV Producer option, enter the corresponding number.
  6. To view the current CSV producer configuration, select the Show CSV Producer settings option, enter the corresponding number.
    STEP RESULT:
    Depending on the CSV producer configuration status, the CCM console displays the following:
    • If both the CSV producers are disabled:
      CSV producer for Agent by Account processor is currently disabled.
      CSV producer for Routing Service processor is currently disabled.
    • If one or both of the CSV producers are enabled, the CCM console displays settings that were configured for this producer. For example:
      oceanalytics.csv-producer.external-storage.host=[host]
      oceanalytics.csv-producer.external-storage.port=[port]
      oceanalytics.csv-producer.external-storage.username=[username]
      oceanalytics.csv-producer.external-storage.password=[password]
      oceanalytics.csv-producer.external-storage.path=[path]
  7. Return to the previous page by entering b.
  8. Quit the current page by entering q.
  9. Return to the main menu by entering m.
  10. To configure daily or interval CSV producer for Agent by Account processor, select the Configure CSV producer for Agent by Account processor option, enter the corresponding number.
  11. Select one of the following:
    ADDITIONAL INFORMATION:
    • To configure interval CSV producer for Agent by Account processor, select Configure interval CSV producer for Agent by Account processor option, enter the corresponding number.
    • To configure daily CSV producer for Agent by Account processor, select Configure daily CSV producer for Agent by Account processor option, enter the corresponding number.
    Note:
    You can enable the interval or the daily CSV producer at a time. When you enable one, the other producer gets disabled if it is currently enabled. After you successfully enable the CSV Producer, the configuration maps are updated without restart of the agentbyaccount pods.
  12. In the Enter the host IP address field, type the IP address of the dedicated host server where the scripts write the CSV files and press Enter.
  13. In the Enter the port number used for connecting to the host field, type the port number used for connecting to the host and press Enter.
  14. In the Enter the username for connecting to the host field, type the name of the specified user with the write permissions to the directory and press Enter.
  15. In the Enter the users password field, type the password of the specified user and press Enter.
  16. In the Enter the path field, enter the path to store the CSV files.
    ADDITIONAL INFORMATION:
    Note:
    Ensure that the path you enter to store the files must already exist on the host server, and the specified user must have the write permissions to the directory.
    STEP RESULT:
    After you successfully enable the CSV Producer, the configuration maps are updated without restarting the agentbyaccount pods.
  17. Return to the previous page by entering b.
  18. Quit the current page by entering q.
  19. Return to the main menu by entering m.
  20. To verify the CSV Producer settings status after enabling it, select the Show CSV Producer settings option, enter the corresponding number.
  21. To disable CSV producer for Agent by Account processor, select the Disable CSV producer for Agent by Account processor option, enter the corresponding number after step 10. The configuration maps are updated without restart of the agentbyaccount pods.
  22. To configure interval CSV producer for Routing Service processor, select the Configure CSV producer for Routing Service processor option, enter the corresponding number.
  23. To enable interval CSV producer for Routing Service processor or to change CSV producer settings for Routing Service processor, select the Configure interval CSV producer for Routing Service processor option, enter the corresponding number. Then, complete steps 12 through 16.
  24. To disable interval CSV producer for Routing Service processor, select the Disable CSV producer for Routing Service processor option, enter the corresponding number.
    STEP RESULT:
    The configuration maps are updated without restart of the routingservice pods.
  25. Return to the previous page by entering b.
  26. Quit the current page by entering q.
  27. Return to the main menu by entering m.