2022-02-17

Exporting data from Interaction Administrator (Genesys PureConnect)

 Sometimes you need to export configuration data from Genesys PureConnect.

There are multiple ways to do that. Here are some of them:

1) use DSEditU utility (or directly use Regedit) on CIC server.

Most of the configuration items are stored in Windows Registry and can be viewed/exported using DSEditU.

After you export it you can parse it using scripts.

2) Using custom handlers.

There are several system tools available in Interaction Designer that allows you to export data

https://help.genesys.com/pureconnect/mergedProjects/wh_id/desktop/hid_system.htm

  • Get DS Attr
  • Get DS Attrs
  • Get DS Keys
  • Get DS Parameter
Directory Services (DS) is exactly the same Windows Registry where PureConnect CIC server keeps most of the configuration.

3) Use ICWS or ICE Lib API
https://help.genesys.com/developer/cic/docs/icws/webhelp/conceptualcontent/welcome.htm
https://help.genesys.com/developer/cic/docs/icelib/webhelp/index.html

Limitation: Both ICWS and ICE Lib API do not allow you to export Stations/Managed IP Phones information.

4) Custom tools/custom scripts

In the past, I created an article about 2 tools that were created by Genesys employees.
Both are using ICWS API and can help you with data export/bulk updates etc...
  • https://github.com/GenesysPureConnect/cli - Command line tool that allows interacting with CIC
  • https://github.com/gildas/posh-ic - Collection of PowerShell scripts to interact with CIC
Limitation: Both ICWS and ICE Lib API do not allow you to export Stations/Managed IP Phones information.

5) IA_Export script 

I developed my own PowerShell script that allows to export data from Interaction Administrator.
It uses WinAPI to grab data from SysListViews of Interaction Administrator.

You can download it from my GitHub:


How to use it:
1. Download PowerShell script IA_Export.ps1
2. Download ManagedWinapi.dll from http://mwinapi.sourceforge.net/
3. Place ManagedWinapi.dll and the script in the same directory
4. Open PowerShell (x86)
5. Open Interaction Administrator and select one of the views that you want to export.
For example "Managed IP Phones"
6. Run the script 
.\IA_Export.ps1 "Managed IP Phones"
7. It will start exporting data to CSV file in the same directory where your PowerShell script is located.



  • This script exports data exactly as you see it in Interaction Administrator. For example, if you applied a filter or sorted it - it will export only data that you see, exactly as you see it.
  • Make sure that you run it in PowerShell (x86)
  • Make sure that your Interaction Administrator is open and you selected the view that you want to export. Otherwise, it will not work.
  • Full list of commands that you can use:
      • .\IA_Export.ps1 "Managed IP Phones"
      • .\IA_Export.ps1 "Stations"
      • .\IA_Export.ps1 "Users"
      • .\IA_Export.ps1 "Structured Parameters"
      • .\IA_Export.ps1 "Roles"
      • .\IA_Export.ps1 "Workgroups"
      • .\IA_Export.ps1 "Schedules"
      • .\IA_Export.ps1 "Queue Columns"
      • .\IA_Export.ps1 "Client Buttons"
      • .\IA_Export.ps1 "Tables"
      • .\IA_Export.ps1 "Status Messages"
      • .\IA_Export.ps1 "Web Services Parameters"
      • .\IA_Export.ps1 "Licenses Allocation"





 

No comments:

Post a Comment