Example csv file that really work

Discussion in 'General' started by pnaves, Jul 17, 2009.

  1. pnaves

    Joined:
    May 27, 2009
    Messages:
    66
    Likes Received:
    0
    Someone could avaiable a csv file example to charge campaigns. I tried to find but all examples fail even I saving using unicode encoding.

    tks
     
  2. dicko

    Joined:
    Oct 24, 2008
    Messages:
    4,099
    Likes Received:
    0
    They are in unix newline format?
     
  3. javapaul

    Joined:
    Jul 1, 2009
    Messages:
    99
    Likes Received:
    0
    are you using excel to edit the file?, cause after i create the file in excel and save it as .csv, i still have to change the ; for , and add " when i edited with notepad and it didn't give me any upload problems.
     
  4. pnaves

    Joined:
    May 27, 2009
    Messages:
    66
    Likes Received:
    0
    My problem was in header file format that doesn't match with the body data.

    Tks all for help
     
  5. jgutierrez

    Joined:
    Feb 28, 2008
    Messages:
    5,737
    Likes Received:
    0
    Hi,
    A way to make sure that you are uploading a correct csv file, is to open it with notepad, you should have the following format:

    18773527849,"Elastix"
    18773527850,"Elastix2"
    18773527851,"Elastix3"

    A common mistake is to use a delimiter different from ',' and to not quote the words.
    If you have a csv with lines on that format, you wont have any problem. By the way you may add more fields, of course following the same rules on delimiters and quoted words.
     
  6. faraqsa

    Joined:
    Jul 5, 2010
    Messages:
    9
    Likes Received:
    0
    once we upload the CSV where it is getting saved in the server ?
     
  7. jgutierrez

    Joined:
    Feb 28, 2008
    Messages:
    5,737
    Likes Received:
    0
    It is stored on the mysql database called call_center, there are a couple tables that you need to look, and understand how they are related.
     
  8. faraqsa

    Joined:
    Jul 5, 2010
    Messages:
    9
    Likes Received:
    0
    how does elastix connects to the call_center mysql database ? where is the database configuration file located in elastix ?

    I have developed a file in PHP to add a record to the call_center DB but the thing is I need to get the db configuration !?
     
  9. franklin

    Joined:
    Oct 22, 2010
    Messages:
    254
    Likes Received:
    0
    pnaves, Can you tell me how you got the csv to work? I have tried every combination I can think of. Open Office. Txt saved as a .csv. Excel. I always get no data found when I open the csv from the Campaign List. I've tried a simple list of numbers in one column.
    xxxxxxxxxx
    xxxxxxxxxx

    I've tried putting a 1 in front
    1xxxxxxxxxx
    I've tried
    xxxxxxxxxx,"name"

    And I've saved those in multiple formats. Never any data.
     
  10. dicko

    Joined:
    Oct 24, 2008
    Messages:
    4,099
    Likes Received:
    0
    Be aware that 'End of Lines' in Windows are not the same as Linux ( or Apple OS)

    perhaps run the file through dos2unix (you might well need to you install that in the standard Elastix distros)
     
  11. jgutierrez

    Joined:
    Feb 28, 2008
    Messages:
    5,737
    Likes Received:
    0
    franklin,
    Just to make things clearer, when you click on the csv from the Campaign List, you will only see the results of calls being done, wich is not the same as the entire number list that you have uploaded.
    If you are not getting data on that file is due to the reason that you havent configured correctly the call center module, check:

    1. If elastixdialer service is on
    2. If the phone numbers have a correct format (place them as you would dial them through a sip extension, choose the dial plan trunk NOT another trunk)
    3. Make sure that you have used agents on your queue NOT extensions
    4. Make sure that you have placed valid phone numbers

    For more information on callcenter configuration, you may follow this link:
    http://www.elastix.org/en/component/kun ... 0&start=20
     
  12. nielsen

    Joined:
    Feb 26, 2011
    Messages:
    6
    Likes Received:
    0
    What you mean by "And I've saved those in multiple formats. Never any data." ???

    After you upload file csv click at show data and it empty ?

    If YES, realy never u see data on this file, first u need finish a campain and will see data generated by de csv+forms OK ?
     

Share This Page