Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: malhelo on March 10, 2011, 08:14:31 AM

Title: Genesys outbound 7.6 OCM
Post by: malhelo on March 10, 2011, 08:14:31 AM

Dears,

Does the OCM support xls files ? in the other words I want to upload excel file using the Genesys OCM

Thanks

Title: Re: Genesys outbound 7.6 OCM
Post by: GenesysNewbie on March 12, 2011, 05:01:10 PM

Are you taling about ocm rigth?

Title: Re: Genesys outbound 7.6 OCM
Post by: cavagnaro on March 12, 2011, 05:17:17 PM

[quote author=malhelo link=topic=6239.msg27150#msg27150 date=1299744871]
Dears,

Does the OCM support xls files ? in the other words I want to upload excel file using the Genesys OCM

Thanks
[/quote]

If you export a list and open it with Excel you can see how it is elaborated and build the same with Excel. However the best way can be do it from customer DB to OCS DB directly.

Title: Re: Genesys outbound 7.6 OCM
Post by: malhelo on March 14, 2011, 10:36:34 AM

Thank you but can we customize an application using SDK ?

many thanks

Title: Re: Genesys outbound 7.6 OCM
Post by: GenesysNewbie on March 14, 2011, 02:40:04 PM

Hi mahelo,  Genesys in order to upload a list must follow a table structure. My believe is that if you follow the list structure you will  not find troubles when inserting data because you are only doing a INSERT COMMAND in a DB table. I would recommend to do some test on your lab.

Title: Re: Genesys outbound 7.6 OCM
Post by: Steve on March 15, 2011, 03:35:52 PM

To answer the original question - no OCM does not support .xls files. If you want to create a list in Excel, and there are good reasons why you would, there are a couple of steps to follow.

Create the list remember the keys (record_id=) as well as the values (1)
Save as a .csv
Use your favourite text editor to remove the commas after the equals signs (record_id=, becomes record_id=)
Replace all the other commas with pipe symbols (|)
Save the file as .lst
Import into OCM

Title: Re: Genesys outbound 7.6 OCM
Post by: Mat on March 18, 2011, 12:15:18 PM

You can stract the data and then write in excell using an ETL. Spoon is an OpenSource ETL very easy