Solved Import local contacts via csv - the sequel

Discussion in 'Clients' started by Mark Coutinho, Apr 9, 2018.

Thread Status:
Not open for further replies.
  1. Mark Coutinho

    Joined:
    Mar 8, 2018
    Messages:
    2
    Likes Received:
    0
    I found abovementioned problem in this forum and I executed what was being proposed as a solution, being:
    - export a contact from within the admin console
    - use that csv-file as a default template (so the right columns (and names) are on the right places)
    - fill the rows in that csv-file with the contacts I want to import

    Couldn't go wrong, you'd say. However, when importing that newly edited csv-file 3CX says "Wrong CSV file, required columns are not found: Mobile".
    This test csv-file has all its columns filled. I upload that file with this post (renamed it to .txt as I wasn't allowed to upload a .csv-file)

    Where did I go wrong?
     

    Attached Files:

  2. YiannisH_3CX

    YiannisH_3CX Support Team
    Staff Member 3CX Support

    Joined:
    May 10, 2016
    Messages:
    3,520
    Likes Received:
    240
    Hello @Mark Coutinho

    I renamed your file back to csv and used Notepad++ to open it. From what i can see the problem is that instead of commas (,) there are semicolons ";" used. When i replaced ";" with "," the contacts were correctly imported.
     
    craigreilly and jed like this.
  3. Mark Coutinho

    Joined:
    Mar 8, 2018
    Messages:
    2
    Likes Received:
    0
    Thanks Yiannis! That did do the trick for me too.
     
  4. YiannisH_3CX

    YiannisH_3CX Support Team
    Staff Member 3CX Support

    Joined:
    May 10, 2016
    Messages:
    3,520
    Likes Received:
    240
    Glad i could help
     
Thread Status:
Not open for further replies.