Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Kevin S on April 21, 2011, 12:41:21 PM

Title: Lab CME Refresh
Post by: Kevin S on April 21, 2011, 12:41:21 PM

I would like to do a refresh load of certain objects from our Production environment into our Lab environment. Specifically, I would like to copy Person and Skill objects (and related dependencies), and certain DN objects (virtual queues). However, I do not want to blow away the existing Lab configuration of DNs, Applications, Hosts, etc, so I do not want to do an export/import from Production to Lab.

Does anyone have any suggestions outside of building these objects fresh in Lab or editing a Production export file to remove all the objects I do not want to touch?

Thanks in advance for your time.

Title: Re: Lab CME Refresh
Post by: fnunezsa on April 21, 2011, 06:37:31 PM

Ummm...

Maybe you can use CWI to generate the SQL scripts to import those object into your lab environment and then tune up those scripts to keep just the objects you care about befor running the scripts to import those objects into your lab environment.

HTH...

Title: Re: Lab CME Refresh
Post by: creading001 on April 27, 2011, 08:55:29 AM

Hi,

Have a look here :

http://eemaan.com/audit-trail-for-genesys

There are some tools for bulk export and import of CME objects between environments.

Craig

Title: Re: Lab CME Refresh - Method Found!
Post by: Kevin S on April 28, 2011, 08:52:03 PM

For those who are interested...

Genesys Administrator 8.1 (newly released) has bulk import capabilities for Agents, DNs, Place Groups, etc etc.  It looks like you need to start with a CSV file, but this looks a lot easier than the paths I was examining...

Title: Re: Lab CME Refresh
Post by: GG on May 09, 2011, 02:52:57 PM

I have had great success using CIW (configuration import wizard) to import large ranges of non-contiguous objects (DNs/Places, Agent IDs/Persons, Queues, etc.) associating these objects, etc.  Using the raw XML feature you can import anything you like and retain critical fields without concern for violating the CME database schema. Granted knowledge of the XML schema itself is a must. I have been doing this since 6.5 and have likely exceeded the million mark on object provisioning without ever having to touch CME. If you have any interest I can give you a run down of the process...

Title: Re: Lab CME Refresh
Post by: Kevin S on May 10, 2011, 12:25:15 PM

GG -
Thanks for the infomation. I didn't think to try XML.

My main concern was encountering conflicting dbids, since I was exporting from one environment and importing into another established environment. I also only wanted to export/import certain items, such as Persons, Virtual Queues, Agent Groups, etc.

I was able to do what I needed to by performing a SQL query to export the values I wanted, then using the Genesys Administrator bulk import functions on those lists to import the data into my Lab environment.