INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Just one tip for anyone who wants to import Excel file into IPOCC Campaign using Dialer
2

Just one tip for anyone who wants to import Excel file into IPOCC Campaign using Dialer

Just one tip for anyone who wants to import Excel file into IPOCC Campaign using Dialer

(OP)
thread1831-1765238: Creating a Campaign Job for Auto Call Dialer
http://www.tek-tips.com/viewthread.cfm?qid=1765238
Hey Guys,
Just reference to the above closed thread. I've tried to post the answer there but the topic was closed already.
My solution to importing the Excel file into the Dialer in IPOCC is need to use Microsoft Access, since Access is more powerful in generating the output file in .CSV.
If you tried to export the content from Excel itself into CSV file, then you are not able to import this .CSV file into the IPOCC, because Excel already adjust the .CSV format itself (actually it adds double quote "" wrongly thus IPOCC does not understand the imported file) then it is not suited for IPOCC. The best is to use MS Access, with the correct .CSV file format.

Just my 2cents.

Thanks everyone.
Nam

RE: Just one tip for anyone who wants to import Excel file into IPOCC Campaign using Dialer

I actually made a macro enabled excel sheet that specifically outputs in the correct format. I gave this to the customer and they don't seem to have any issues. Please see the attached file. If you are nervous opening a macro excel sheet from a stranger below is the macro I used in text form so you can implement it yourself.

CODE -->

Sub CSVFile()
'updateby
    Dim xRg As Range
    Dim xRg2 As Range
    Dim xRow As Range
    Dim xCell As Range
    Dim xStr As String
    Dim xSep As String
    Dim xTxt As String
    Dim xName As Variant
    Dim xName2 As Variant
    On Error Resume Next
    ThisWorkbook.Sheets("dialer_import.csv").Activate
    If ActiveWindow.RangeSelection.Count > 1 Then
      xTxt = ActiveWindow.RangeSelection.AddressLocal
    Else
      xTxt = ActiveSheet.UsedRange.AddressLocal
    End If
    Set xRg = ActiveSheet.UsedRange
    If xRg Is Nothing Then Exit Sub
    xName = CurDir & Application.PathSeparator & "dialer_import.csv"
    xName2 = CurDir & Application.PathSeparator & "dialer_import.txt"
    xSep = Application.International(xlListSeparator)
    Open xName For Output As #1
    For Each xRow In xRg.Rows
        xStr = ""
        For Each xCell In xRow.Cells
            xStr = xStr & """" & xCell.Value & """" & xSep
        Next
        While Right(xStr, 1) = xSep
            xStr = Left(xStr, Len(xStr) - 1)
        Wend
        Print #1, xStr
    Next
    Close #1
    ThisWorkbook.Sheets("dialer_import.txt").Activate
    Set xRg2 = ActiveSheet.Range("A1:A8")
    Open xName2 For Output As #2
    For Each xRow In xRg2.Rows
        xStr = ""
        For Each xCell In xRow.Cells
            xStr = xStr & xCell.Value & xSep
        Next
        While Right(xStr, 1) = xSep
            xStr = Left(xStr, Len(xStr) - 1)
        Wend
        Print #2, xStr
    Next
    Close #2
    ThisWorkbook.Sheets("Start").Activate
    If Err = 0 Then MsgBox "The file has saved to: " & xName & " & " & xName2, vbInformation, "Dialer Import"
End Sub 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close