Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: DaveJ on November 15, 2007, 02:32:44 PM

Title: Importing Excel files into DNC list
Post by: DaveJ on November 15, 2007, 02:32:44 PM

I've been handed a list of 4000 telephone numbers in Excel format.  Can anyone assist with how i would transfer these records into a suitable format for Genesys?  I've been advised to use a .dat file?

Thanks in advance

Title: Re: Importing Excel files into DNC list
Post by: cavagnaro on November 15, 2007, 04:18:45 PM

I'd recoomend to input a record by hand, export it as you will see how you need to format your data

Title: Re: Importing Excel files into DNC list
Post by: René on November 15, 2007, 04:25:37 PM

You can use Outbound Contact Manager (OCM) to upload list of DNC numbers. It supports "csv" file format. Unfortunately, I don't have access to OCM now so I can't provide you with more details but there is detailed step-by-step description how to do it in "Outbound Contact Deployment Guide".

René

Title: Re: Importing Excel files into DNC list
Post by: cavagnaro on November 15, 2007, 04:33:13 PM

Well just to mention that my procedure is also with OCM. If you only have one record you will import it and when ready OCM will ask you what field is that, it can be the number or the customer_id (read OCS deplyment guide on how to use this special column).

Title: Re: Importing Excel files into DNC list
Post by: DaveJ on November 15, 2007, 05:45:43 PM

I am using OCM as well, so if i was to change the excel file to a csv file would i be able to import the list, or is there any other formatting i would need to consider?

Thanks again.

Title: Re: Importing Excel files into DNC list
Post by: cavagnaro on November 15, 2007, 05:54:32 PM

csv, txt, no matter, just consider the right format, for you to get a better idea export a record and see how it is used.

Title: Re: Importing Excel files into DNC list
Post by: jbobinsk on November 16, 2007, 10:31:53 AM

You have to only know what format is accepted from Genesys site for DNC List.
You have it described in Deployment Guide for Outbound solution.
Exporting from Excel may be done with macro behinde which you will program it's quite easy for example:

Sub Export()
  Dim hndl as Integer
  Dim var_FileName as String 'you have to assign it with file path and name
  Dim Bufor as string
  Dim var_row as integer
  Dim var_column as integer

hndl=FreeFile
Open var_FileName For Output As #hndl
For var_row=1 to ActiveSheet.UsedRange.Rows.Count
  For var_column to ActiveSheet.UsedRange.Columns.Count
      Bufor=Bufor & "," & ActiveSheet.Cells(var_row,var_column)
  Next
  Bufor=Mid(Bufor,2)
  Print #hndl,bufor
Next
Close
end Sub

You have to test it because I have written it write now without testing. The name of File should be with *.csv.

Regards

Jacek Bobinski