Genesys outbound 7.6 OCM

[malhelo]

Dears,

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

Thanks

[GenesysNewbie]

Are you taling about ocm rigth?

[cavagnaro]

[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.

[malhelo]

Thank you but can we customize an application using SDK ?

many thanks

[GenesysNewbie]

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.

[Steve]

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

[Mat]

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