Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Ton Koenders on January 01, 1970, 12:00:00 AM

Title: import callinglist
Post by: Ton Koenders on January 01, 1970, 12:00:00 AM

Is there a simple way to import let's say an Excel file with only Contact names and phonenumbers, into the calling list of Genesys Outbound 6.5 (with all its mandatory fields) ?

Title: import callinglist
Post by: Superglide on January 01, 1970, 12:00:00 AM

You could save the spreadsheet as an ascii file and then import it.

Title: import callinglist
Post by: Paulo on January 01, 1970, 12:00:00 AM

Hi folks,
does anybody know a way to automate the callinglist importing?

I have campaigns that I have to import more than 12 callinglists daily. It's realy a boring and mechanic task.

Thank you all for the great help and tips.

Title: import callinglist
Post by: ecki on January 01, 1970, 12:00:00 AM

Hi,
Yes, there is realy one way to solve it.
You have to write database script for importing your data directly to calling list tables. If you adhere the mandatory fields, you will be successful. I have made such script and it works.

bye.

Title: import callinglist
Post by: mark newcomb on January 01, 1970, 12:00:00 AM

Scripts is an easy way of automating the loading, alternatively a tool such as DataStage can be used we've found this to be our first choice as we can don't have to worry too much about the format the list is supplied to our system in. Datastage then converts it to the correct list format.

Title: import callinglist
Post by: Paulo on January 01, 1970, 12:00:00 AM

Hei Ecki,
would you mind if I asked you to send me some examples of the scripts you wrote?
I'd like to try them at my site.
Thanks