Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

Solved Import local contacts via csv - the sequel

Discussion in '3CX 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:
    7,380
    Likes Received:
    535
    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:
    7,380
    Likes Received:
    535
    Glad i could help
     
Thread Status:
Not open for further replies.