Thanks for the info
@Paul Simpson. It's not so much the import/export process that's problematic but the actual updates to the tables before hand, due to the unwieldiness of the interface, the heftiness of the data volume and the persnicketiness of the data formats.
Unfortunately we're over-leveraging IP Table with our current set up and while we are looking to move away from that it's an enormous admin overhead at this time with 12 servers needing to be kept in sync. Regardless of what we move to in the future, it'd be a big project and we could really use something in the mean time as a shim to free up resources from what is basically specialized data entry.
AFAIK both ICElib and ICWS only offer read functionality for IP tables, unfortunately.
Thanks for the heads up on the potential support issue, I'll be sure to bring that up if we do look at a possible solution.
------------------------------
Tyler Style
Interactive Intelligence Engineer, WellCare Health Plans
------------------------------
Original Message:
Sent: 01-15-2020 14:31
From: Paul Simpson
Subject: Writing to IP Tables
Tyler,
IPTables are intended to be small, lean "lookup" style tables and so are, by design, Read Only (from Handlers).
How often does the data change? It may well be easier to add to your process for changing them, steps to manually export from the "Master" copy and then re-import on all the other servers.
I understand that a DB is out of the question, but how about @Aaron Lael's other suggestion of using Structured Parameters?
Another approach MIGHT be to use ICELib or ICWS to write an application to update the tables. I'm not sure if the tables are exposed via either of those APIs, but if they are....
I am fairly certain that any method you come up with to directly modify the files would result in your system not being supportable (by Genesys) if you have issues with the system later on.
------------------------------
Paul Simpson
Senior Technical Instructor
Original Message:
Sent: 01-15-2020 13:23
From: Tyler Style
Subject: Writing to IP Tables
Thanks @Aaron Lael, that's helpful.
Unfortunately IP tables are what I have to work with, so DB options are not on the table.
------------------------------
Tyler Style
Interactive Intelligence Engineer, WellCare Health Plans
Original Message:
Sent: 01-15-2020 13:09
From: Aaron Lael
Subject: Writing to IP Tables
Pointers to IP tables are are stored in directory services, but they tables themselves are files in the server directory "I3Tables" on your IC server.
I would not recommend attempting to write to IP tables, as it could be fairly simple to corrupt them.
You are likely much better off just creating a new table in your database instance that corresponds with whatever you are doing and read and write from their, or if it is a simple enough data structure, use a structured parameter, which is intended to be read from and written to.
------------------------------
Aaron Lael
State of Utah
Original Message:
Sent: 01-15-2020 13:05
From: Tyler Style
Subject: Writing to IP Tables
I'm wanting to write data *to* an IP Table from a handler in order to replicate data across server instances. I know there is a tool for fetching data but I don't see one for writes. I'm assuming that if that's the case, then one would instead write to the registry instead to manipulate those values. Is that the case, and if so does anyone have any pointers on that?
#Handlers
------------------------------
Tyler Style
Interactive Intelligence Engineer, WellCare Health Plans
------------------------------