Author Topic: Lab CME Refresh  (Read 3917 times)

Offline Kevin S

  • Full Member
  • ***
  • Posts: 145
  • Karma: 4
Lab CME Refresh
« 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.

Offline fnunezsa

  • Full Member
  • ***
  • Posts: 213
  • Karma: 5
Re: Lab CME Refresh
« Reply #1 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...

Offline creading001

  • Newbie
  • *
  • Posts: 10
  • Karma: 0
Re: Lab CME Refresh
« Reply #2 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

Offline Kevin S

  • Full Member
  • ***
  • Posts: 145
  • Karma: 4
Re: Lab CME Refresh - Method Found!
« Reply #3 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...

Offline GG

  • Newbie
  • *
  • Posts: 3
  • Karma: 0
Re: Lab CME Refresh
« Reply #4 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...

Offline Kevin S

  • Full Member
  • ***
  • Posts: 145
  • Karma: 4
Re: Lab CME Refresh
« Reply #5 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.