Importing Excel files into DNC list

[DaveJ]

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

[cavagnaro]

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

[René]

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é

[cavagnaro]

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

[DaveJ]

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.

[cavagnaro]

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.

[jbobinsk]

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