Genesys CTI User Forum

Hi,
I was wondering if someone has already developed an application to import agent information from Excel into CME.

Do we need to use Genesys Adapter? If we write it directly into DB, would confserv need to be restarted?

I would appreciate any info on this matter!

Hi Vic,

I think somewhere on interent exist an applcation which is able to read data from excel and simulate mouse and keyboard inputs. So you can then program steps to import data like you would do it manualy. I know nothing genial but it works and you do not have to develop some interface.

This is true. While you can update the tables in the config layer, Genesys fully recommends not trying this. They recommend using their Config SDK, which of course is not free!

Suggestion:
Set your configuration server logging to "all", then make the appropriate changes. Look in the logs. The logs give you the sequence of all the insert statements, including the appropriate "begin transaction" and "commit transaction" statements.
If you mirrored those actions, you should be able to create a "home grown" utility.

One thing to consider: I toyed with making changes directly to the database in my nonproduction environment. The changes were not recognized by CME until I reinitialized the environment.
In other words, while you may be able to add agents via direct database queries, they may not be recognized until you restart your configuration environment which I'm sure most people do not want to do on a regular basis.

www.kratronic.com/tools/recorder
I have used this with great success to import Genesys CME objects from Excel. It needs a bit of practice, it works most reliably if you can use keystrokes to do the navigation. As Genesys sees it as a (fast) human there is no danger of invalidating the database.
Free trial version works ok, you just need to copy & store the macros yourself in a text file. Easy to understand the macro code and write directly if you need to tinker with recorded code. It has saved many hours of boring keyboard input, not to mention 100% accuracy. Email me if you need more info.

Also, similar to what someone else suggested, to see the queries needed create a new agent phone login, then create a new user and assign this new login to the agent. Open the config DBserver log and look at the SQL scripts passed to the database. This will help you understand what needs to be done. It's not supported by Genesys, but it is quite simple to do.

Config Import Wizard remains an optional component, even under 7.1. It is not included with CME.

Dave

If you install Config Manager 7.1.100.06 (and probably other versions too), Config Import Wizard is on the menu under "Tools".

If it is grayed out then install the CIW from the media, it will then be available. The requirement for a Licence has been removed.

At first I thought that this was fault with the software, but in the documentation (71fr_refdataimport.pdf v7.1.101.00), the first paragraph in section 3 states "....CIW no longer requires a licence".

Steve